Your message dated Sun, 25 Jul 2004 15:53:49 +0200
with message-id <[EMAIL PROTECTED]>
and subject line Upstream version is now available in developer.php
has caused the attached Bug report to be marked as done.
This means that you claim that the problem has been dealt with.
If this is not the case it is now your responsibility to reopen the
Bug report if necessary, and/or fix the problem forthwith.
(NB: If you are a system administrator and have no idea what I am
talking about this indicates a serious mail system misconfiguration
somewhere. Please contact me immediately.)
Debian bug tracking system administrator
(administrator, Debian Bugs database)
--------------------------------------
Received: (at submit) by bugs.debian.org; 23 Jul 2004 17:47:27 +0000
>From [EMAIL PROTECTED] Fri Jul 23 10:47:27 2004
Return-path: <[EMAIL PROTECTED]>
Received: from smtp20.libero.it [193.70.192.147]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1Bo48l-0002iZ-00; Fri, 23 Jul 2004 10:47:27 -0700
Received: from localhost (172.16.1.82) by smtp20.libero.it (7.0.027-DD01)
id 40E3F8E700406DDC for [EMAIL PROTECTED]; Fri, 23 Jul 2004 19:46:56
+0200
Received: from ppp-144-135.24-151.libero.it (151.24.135.144) by smtp1.libero.it
(7.0.027-DD01)
id 40CB29090239B718 for [EMAIL PROTECTED]; Fri, 23 Jul 2004 19:47:02
+0200
Subject: qa.debian.org: Dehs data integration in developer.wml
From: Bluefuture <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Content-Type: multipart/mixed; boundary="=-J/HrbHT0GQ2eD2hmtxfl"
Message-Id: <[EMAIL PROTECTED]>
Mime-Version: 1.0
X-Mailer: Ximian Evolution 1.4.6
Date: Fri, 23 Jul 2004 21:47:01 +0200
X-Virus-Scanned: by amavisd-new at libero.it
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2004_03_25
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-3.1 required=4.0 tests=BAYES_10,HAS_PACKAGE,
HTML_20_30,HTML_FONTCOLOR_BLUE,HTML_FONTCOLOR_UNKNOWN,
HTML_FONTCOLOR_UNSAFE,HTML_MESSAGE autolearn=no
version=2.60-bugs.debian.org_2004_03_25
X-Spam-Level:
--=-J/HrbHT0GQ2eD2hmtxfl
Content-Type: text/plain
Content-Transfer-Encoding: 7bit
Followup-For: Bug #206363
Package: qa.debian.org
Tags: Patch
This patch close this bug and introduces some dehs[1] data in
developer.wml.
Databases needed and daily updated are here:
http://alioth.debian.org/debian_qa_unstable.db
http://alioth.debian.org/debian_qa_experimental.db
and must to go in /org/qa.debian.org/data/dehs (wget this files in a
cronjob?).
Cheers,
Stefano Fabri
[1] http://dehs.alioth.debian.org
--=-J/HrbHT0GQ2eD2hmtxfl
Content-Disposition: attachment; filename=dehs_patch.diff
Content-Type: text/x-patch; name=dehs_patch.diff; charset=ANSI_X3.4-1968
Content-Transfer-Encoding: 7bit
--- developer.wml 2004-07-21 17:14:30.000000000 +0200
+++ developer_dehs.wml 2004-07-23 21:08:10.000000000 +0200
@@ -30,7 +30,6 @@
text-decoration: none;
}
</style>
-
<?
error_reporting(0);
$time = microtime();
@@ -137,7 +136,14 @@
<small>
<b>Packages in <font color="blue">blue</font> are packages that are
co-maintained by developer (reference to Uploaders: field)</b><br>
<b>Packages version in <font color="red">red</font> are NMUed</b><br>
-<b>Packages where testing version in <font color="#ff00ff">magenta</font> are
those where the unstable version differs from the version in testing</b><br><br>
+<b>Packages where testing version in <font color="#ff00ff">magenta</font> are
those where the unstable version differs from the version in testing</b><br>
+<b>Packages where Upstream/Wwiz version in <font color="green">green</font>
are those where the upstream finded version is in sync with version
unstable/experimental</b><br>
+<b>Packages where Upstream/Wwiz version in <font
color="#ff00ff">magenta</font> are those where the upstream finded version is
greater than version in unstable</b><br>
+<b>Packages where Upstream/Wwiz version in <font color="#2222AA">navy
blue</font> are those where the upstream finded version is lower than version
in unstable (a bug in the Watch file)</b><br>
+<b>Packages where Upstream/Wwiz is <font color="red">error</font> are those
where the uscan had problems following the Watch file</b><br>
+<b>Packages where Upstream is N/A are those that doesn't had a Watch
file</b><br>
+<b>Packages where Wwiz is N/A are those that doesn't had a Copyright file for
trying to automatically generate a Watch file</b><br>
+<b>Packages where Wwiz is <font color="red">notmatch</font> are those that had
a Copyright file but no useful url download link was found for trying to
automatically generate a Watch file</b><br><br>
<b><u>The real number of bugs is displayed in each bugs column.
If there are any merged bugs, the total is displayed within
parenthesis.</u></b>
</small>
@@ -310,7 +316,86 @@
return substr($package_name, 0, 1);
}
}
-
+# Begin of Dehs functions
+function dehsdb_conn ($dbname,$mode) {
+ $id = dba_open($dbname, $mode, "db2");
+ if (!$id) {
+ echo "dba_open failed\n";
+ exit;
+ }
+return $id;
+}
+function dehsdb_xml($xml) {
+ $p = xml_parser_create();
+ xml_parse_into_struct($p, $xml, $vals, $index);
+ xml_parser_free($p);
+
$values=array("id"=>$vals[1][value],"up_version"=>$vals[2][value],"wwiz"=>$vals[3][value]);
+ return $values;
+}
+function dehs_value($pkg_name,$dist) {
+ $id = dehsdb_conn("/org/qa.debian.org/data/dehs/dehs_qa_" . $dist .
".db","r");
+ if (!dba_exists($pkg_name,$id)) return
array("id"=>"-","up_version"=>"-","wwiz"=>"-");
+ $xml=dba_fetch($pkg_name,$id);
+ dba_close($id);
+ return dehsdb_xml($xml);
+}
+function vers_conv($debvers) {
+ preg_match("/(.+:)?(.+)(ds-|-)/",$debvers,$matches);
+ return $matches[2];
+}
+function ver_comp($a,$b) {
+ exec("dpkg --compare-versions '$a' gt '" . vers_conv($b) .
"'",$output,$res);
+ if ($res==0) return 1;
+ exec("dpkg --compare-versions '$a' lt '" . vers_conv($b) .
"'",$output,$res);
+ if ($res==0) return 2;
+ else return 3;
+}
+function print_dehs($package,$version,$dist,$type) {
+ $dehs_values=dehs_value($package,$dist);
+ if ($type=="up_version") {
+ $dehs_link='<small><a
href="http://dehs.alioth.debian.org/maintainer.php?name=' .
rawurlencode($package) . '"> Details</a></small>';
+ if($dehs_values[up_version]=="-") {
+ $dehs_values[up_version] = '<small>-</small>';
+ $dehs_link='';
+ }
+ elseif ($dehs_values[up_version]=='N/A') {
+ $color="black";
+ }
+ elseif ($dehs_values[up_version]=='Error') $color="red";
+ elseif(ver_comp($dehs_values[up_version],$version)==1)
$color="magenta";
+ elseif(ver_comp($dehs_values[up_version],$version)==2)
$color="#2222AA";
+ else {
+ $color="green";
+ $dehs_link='';
+ }
+ $upstream_print = '<td rowspan="1" colspan="1"><small><font
color="' . $color . '">' . $dehs_values[up_version] . '</font>' . $dehs_link .
'</small></td>';
+ return $upstream_print;
+ }
+ else {
+ $wwiz_link_desc="Details";
+ if($dehs_values[wwiz]=='-' or !$dehs_values[wwiz]) {
+ $dehs_values[wwiz] = '<small>-</small>';
+ $dehs_link='';
+ }
+ elseif ($dehs_values[wwiz]=='N/A') $color="black";
+ elseif ($dehs_values[wwiz]=='error' OR
$dehs_values[wwiz]=='notmatch') $color="red";
+ elseif(ver_comp($dehs_values[wwiz],$version)==1) {
+ $color="magenta";
+ $wwiz_link_desc="Watch";
+ }
+ elseif(ver_comp($dehs_values[wwiz],$version)==2) {
+ $color="#2222AA";
+ $wwiz_link_desc="Watch";
+ }
+ else {
+ $color="green";
+ $wwiz_link_desc="Watch";
+ }
+ if(!isset($dehs_link)) {$dehs_link='<small><a
href="http://dehs.alioth.debian.org/wwiz_detail.php?id=' . $dehs_values[id] .
'&type=watch"> ' . $wwiz_link_desc . '</small></a>';}
+ $wwiz_print= '<td rowspan="1" colspan="1"><small><font color="'
. $color . '">' . $dehs_values[wwiz] . '</font>' . $dehs_link . '</small></td>';
+ return $wwiz_print;
+ }
+}
# Check whether there is a debcheck entry for that package
function debcheckavailable($branch, $package_name) {
$package = ereg_replace ("\.", "_", $package_name);
@@ -359,7 +444,7 @@
<tr align="center">
<th rowspan="2"><small><font color="green">Source Name</font></small></th>
<th rowspan="1" colspan="5"><small><font color="green">Bugs(see
above)</font></small></th>
-<th rowspan="1" colspan="5"><small><font
color="green">Version</font></small></th>
+<th rowspan="1" colspan="9"><small><font
color="green">Version</font></small></th>
<th rowspan="1" colspan="2"><small><font
color="green">Security</font></small></th>
<th rowspan="2"><small><font color="green">Binary<br> Package
Page</font></small></th>
<th rowspan="2"><small><font color="green">Buildd</font></small></th>
@@ -379,8 +464,12 @@
<th><small><font color="green">Stable</font></small></th>
<th><small><font color="green">Testing</font></small></th>
<th><small><font color="green">Unstable</font></small></th>
+<th><small><font color="green">Upstream Uns.</font></small></th>
+<th><small><font color="green">WWiz Up. Uns.</font></small></th>
<th><small><u><font color="green"><span title="Stable Proposed updates">Prop.
Up.</span></font></u></small></th>
<th><small><font color="green">Exp.</font></small></th>
+<th><small><font color="green">Upstream Exp.</font></small></th>
+<th><small><font color="green">WWiz Up. Exp.</font></small></th>
<th><small><font color="green">Stable</font></small></th>
<th><small><font color="green">Testing</font></small></th>
<th><small><font color="green">Stable</font></small></th>
@@ -421,6 +510,7 @@
$version_unstable = $versions[2];
$version_prop = $versions[3];
$version_experimental = $versions[4];
+ $version_experimental_backup= $versions[4];
$security_stable = $versions[5];
$security_testing = $versions[6];
$uninstalable_stable = preg_replace("/,/", " ", $results[3]);
@@ -469,7 +559,7 @@
$excuse .= "<a
href=\"http://bjorn.haxx.se/debian/testing.pl?package=$package\";>More</a>";
}else{
$excuse = "-";
- }
+ }
if(strcmp($version_prop, "-")) {
$version_prop = '<font color="#2222AA"><b>' . $version_prop .
'</b></font>';
}
@@ -483,9 +573,9 @@
if((strcmp ($version_stable, $version_testing) == 0) &&
(strcmp ($version_stable, "/") != 0)) {
if((strcmp ($version_unstable, $version_testing) == 0)) {
- $version_print = '<td rowspan="1" colspan="3"><small>' . $version_stable .
'</small></td>' .$prop .$experimental;
+ $version_print = '<td rowspan="1" colspan="3"><small>' . $version_stable .
'</small></td>' .print_dehs($package,$version_unstable,"unstable","up_version")
.print_dehs($package,$version_unstable,"unstable","wwiz") . $prop .
$experimental .
print_dehs($package,$version_experimental_backup,"experimental","up_version")
.print_dehs($package,$version_experimental_backup,"experimental","wwiz");
}else{
- $version_print = '<td rowspan="1" colspan="2"><small><font
color="#ff00ff">' . $version_stable . '</font></small></td><td rowspan="1"
colspan="1"><small>' . $version_unstable . '</small></td>' . $prop
.$experimental;
+ $version_print = '<td rowspan="1" colspan="2"><small><font
color="#ff00ff">' . $version_stable . '</font></small></td><td rowspan="1"
colspan="1"><small>' . $version_unstable . '</small></td>'
.print_dehs($package,$version_unstable,"unstable","up_version")
.print_dehs($package,$version_unstable,"unstable","wwiz") . $prop .
$experimental .
print_dehs($package,$version_experimental_backup,"experimental","up_version")
.print_dehs($package,$version_experimental_backup,"experimental","wwiz");
}
$ver = explode("-", $version_unstable);
if((preg_match("/(.+\..+?)$/", $ver[count($ver) - 1], $toto)) &&
(count($ver) != 1))
@@ -496,7 +586,7 @@
if(strcmp($version_stable, "/") != 0) {
$version_stable = '<font color="#00AADD">'.$version_stable.'</font>';
}
- $version_print = '<td><small>'.$version_stable.'</small></td><td
rowspan="1" colspan="2"><small>' . $version_testing .'</small></td>' .$prop .
$experimental;
+ $version_print = '<td><small>'.$version_stable.'</small></td><td
rowspan="1" colspan="2"><small>' . $version_testing .'</small></td>' .
print_dehs($package,$version_unstable,"unstable","up_version") .
print_dehs($package,$version_unstable,"unstable","wwiz") . $prop .
$experimental .
print_dehs($package,$version_experimental_backup,"experimental","up_version")
.print_dehs($package,$version_experimental_backup,"experimental","wwiz");
$ver = explode("-", $version_unstable);
if((preg_match("/(.+\..+?)$/", $ver[count($ver) - 1], $toto)) &&
(count($ver) != 1))
{
@@ -508,7 +598,7 @@
}else{
$version_stable = '<small>'.$version_stable.'</small>';
}
- $version_print = '<td>' . $version_stable . '</td><td><small><font
color="#ff00ff">'.$version_testing .
'</font></small></td><td><small>'.$version_unstable.'</small></td>' . $prop
.$experimental;
+ $version_print = '<td>' . $version_stable . '</td><td><small><font
color="#ff00ff">'.$version_testing .
'</font></small></td><td><small>'.$version_unstable.'</small></td>' .
print_dehs($package,$version_unstable,"unstable","up_version")
.print_dehs($package,$version_unstable,"unstable","wwiz") . $prop .
$experimental .
print_dehs($package,$version_experimental_backup,"experimental","up_version") .
print_dehs($package,$version_experimental_backup,"experimental","wwiz");
$ver = explode("-", $version_unstable);
if((preg_match("/(.+\..+?)$/", $ver[count($ver) - 1], $toto)) &&
(count($ver) != 1))
{
--=-J/HrbHT0GQ2eD2hmtxfl--
---------------------------------------
Received: (at 261111-done) by bugs.debian.org; 25 Jul 2004 13:54:03 +0000
>From [EMAIL PROTECTED] Sun Jul 25 06:54:03 2004
Return-path: <[EMAIL PROTECTED]>
Received: from home.genibel.org (genibel.org) [81.56.84.10]
by spohr.debian.org with esmtp (Exim 3.35 1 (Debian))
id 1BojRy-0002Oh-00; Sun, 25 Jul 2004 06:54:03 -0700
Received: by genibel.org
via sendmail from stdin
id <[EMAIL PROTECTED]> (Debian Smail3.2.0.115)
Sun, 25 Jul 2004 15:53:59 +0200 (CEST)
From: Igor Genibel <[EMAIL PROTECTED]>
Organization: Debian GNU/Linux
To: [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Upstream version is now available in developer.php
Date: Sun, 25 Jul 2004 15:53:49 +0200
User-Agent: KMail/1.6.2
MIME-Version: 1.0
Content-Type: multipart/signed;
protocol="application/pgp-signature";
micalg=pgp-sha1;
boundary="Boundary-02=_1t7ABemisbH7iOl";
charset="iso-8859-15"
Content-Transfer-Encoding: 7bit
Message-Id: <[EMAIL PROTECTED]>
Delivered-To: [EMAIL PROTECTED]
X-Spam-Checker-Version: SpamAssassin 2.60-bugs.debian.org_2004_03_25
(1.212-2003-09-23-exp) on spohr.debian.org
X-Spam-Status: No, hits=-3.0 required=4.0 tests=BAYES_00 autolearn=no
version=2.60-bugs.debian.org_2004_03_25
X-Spam-Level:
X-CrossAssassin-Score: 2
--Boundary-02=_1t7ABemisbH7iOl
Content-Type: text/plain;
charset="iso-8859-15"
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Hi,
Stefano Fabri provided a patch I applied in order to have this=20
fonctionnality. Many thanks to him.
Cheers
=2D-=20
Igor Genibel=20
http://www.answare.fr/ [EMAIL PROTECTED]
http://www.tuxfamily.org/ [EMAIL PROTECTED]
http://people.debian.org/~igenibel/ [EMAIL PROTECTED]
GPG: 1024D/1648F6C8
--Boundary-02=_1t7ABemisbH7iOl
Content-Type: application/pgp-signature
Content-Description: signature
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (GNU/Linux)
iD8DBQBBA7t1+xgdMBZI9sgRAjgCAJ0UBj/2PdSnTRHViUh5KqHXk+m9lACfRshQ
gFt2Nu/SXpU6mWuEAzDNQYU=
=XTgv
-----END PGP SIGNATURE-----
--Boundary-02=_1t7ABemisbH7iOl--
