Bug#261111: marked as done (qa.debian.org: Dehs data integration in developer.wml)
Your message dated Sun, 25 Jul 2004 15:53:49 +0200
with message-id <200407251553.57931.igenibel@debian.org>
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 bluefuture@email.it Fri Jul 23 10:47:27 2004
Return-path: <bluefuture@email.it>
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 submit@bugs.debian.org; 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 submit@bugs.debian.org; Fri, 23 Jul 2004 19:47:02 +0200
Subject: qa.debian.org: Dehs data integration in developer.wml
From: Bluefuture <bluefuture@email.it>
Reply-To: bluefuture@email.it
To: submit@bugs.debian.org
Content-Type: multipart/mixed; boundary="=-J/HrbHT0GQ2eD2hmtxfl"
Message-Id: <[🔎] 1090612021.20959.24.camel@atlantide>
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: submit@bugs.debian.org
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 igor@genibel.org Sun Jul 25 06:54:03 2004
Return-path: <igor@genibel.org>
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 <m1BojRv-00O03jC@genibel.org> (Debian Smail3.2.0.115)
Sun, 25 Jul 2004 15:53:59 +0200 (CEST)
From: Igor Genibel <igenibel@debian.org>
Organization: Debian GNU/Linux
To: 261111-done@bugs.debian.org,
228394-done@bugs.debian.org
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: <200407251553.57931.igenibel@debian.org>
Delivered-To: 261111-done@bugs.debian.org
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/ igor.genibel@eds.com
http://www.tuxfamily.org/ igor@tuxfamily.net
http://people.debian.org/~igenibel/ igenibel@debian.org
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--
Reply to: