Building up bugzilla query support
diff --git a/includes/BugzillaConnection.class.php b/includes/BugzillaConnection.class.php
index d1e3009..3a88d08 100644
--- a/includes/BugzillaConnection.class.php
+++ b/includes/BugzillaConnection.class.php
@@ -3,7 +3,7 @@
require_once "/home/data/httpd/eclipse-php-classes/system/dbconnection_bugs_ro.class.php";
require_once "bug.class.php";
-print "$Id: BugzillaConnection.class.php,v 1.34 2008/04/08 17:43:09 edillon Exp $";
+print "$Id: BugzillaConnection.class.php,v 1.35 2008/04/08 17:45:22 edillon Exp $";
# A convenience class for Bugzilla a set of bugzilla queries
class BugzillaConnection {
@@ -59,11 +59,15 @@
public function getAllFixedBugsUntil( $timestamp ) {
+ echo $timestamp;
+
#MySql expects seconds in the timestamp...
if ( strlen($timestamp) == 12 ) {
$timestamp = $timestamp . "59";
}
+ echo $timestamp;
+
$result = array();
$sql_info = "SELECT bugs.bug_id, bugs.short_desc, bugs_activity.bug_when FROM bugs, bugs_activity WHERE
@@ -73,6 +77,7 @@
$rs = $this->runQuery($sql_info);
if ( isset($rs) ) {
while($myrow = mysql_fetch_assoc($rs)) {
+ echo $myrow['bug_id'];
$result[] = new Bug( $myrow['bug_id'], $myrow['short_desc']);
}
diff --git a/includes/bug.class.php b/includes/bug.class.php
index 19e25d0..5a6ff8a 100644
--- a/includes/bug.class.php
+++ b/includes/bug.class.php
@@ -15,5 +15,9 @@
public function getShortDesc() {
return $this->shortDesc;
}
+
+ public function render() {
+ $result = "<a href='http://bugs.eclipse.org/bugs/show_bug.cgi?id=" . $this.getId() . "'>Bug " . $this.getId() . "</a>: " . $this->getShortDesc();
+ }
}
?>
\ No newline at end of file
diff --git a/includes/testBugsFunctions.php b/includes/testBugsFunctions.php
index e3af68f..891dd77 100644
--- a/includes/testBugsFunctions.php
+++ b/includes/testBugsFunctions.php
@@ -7,5 +7,9 @@
print $productId . "</br>";
-$conn->getAllFixedBugsUntil($_TIMESTAMP);
+echo "<ul>";
+foreach( $conn->getAllFixedBugsUntil($_TIMESTAMP) as $bug) {
+ echo "<li>" . $bug->render() . "</li>";
+}
+echo "</ul>";
?>
\ No newline at end of file
