The following commit has been merged in the master branch: commit 895f18fa172655114fafa1951287ccba2f1c5622 Author: Andreas Tille <ti...@debian.org> Date: Mon Jun 3 16:39:59 2013 +0200
Add WNPP bug number for prospective packages diff --git a/misc/sql/gis-thermometer.sh b/misc/sql/gis-thermometer.sh index ae9cc90..05927a8 100755 --- a/misc/sql/gis-thermometer.sh +++ b/misc/sql/gis-thermometer.sh @@ -23,19 +23,20 @@ SELECT b.source, raring.version AS raring, d.unstable_upstream AS upstream, d.unstable_status AS status, - homepage + homepage, + wnpp FROM ( - SELECT DISTINCT p.source, p.homepage FROM packages p + SELECT DISTINCT p.source, p.homepage, '' AS wnpp FROM packages p JOIN blends_dependencies bd ON bd.package = p.package JOIN releases r ON p.release = r.release WHERE bd.blend = '$1' AND (r.sort >= (SELECT sort FROM releases WHERE role = 'stable') OR r.sort = 0) -- forget older releases than stable but allow experimental UNION - SELECT DISTINCT u.source, u.homepage FROM ubuntu_packages u + SELECT DISTINCT u.source, u.homepage, '' AS wnpp FROM ubuntu_packages u JOIN blends_dependencies bd ON bd.package = u.package WHERE bd.blend = '$1' AND bd.distribution = 'ubuntu' UNION - SELECT DISTINCT pr.source, pr.homepage FROM blends_prospectivepackages pr + SELECT DISTINCT pr.source, pr.homepage, CASE WHEN wnpp!=0 THEN CAST(pr.wnpp AS text) ELSE '' END AS wnpp FROM blends_prospectivepackages pr JOIN blends_dependencies bd ON bd.package = pr.package WHERE bd.blend = '$1' AND bd.distribution = 'prospective' ) b -- Static and dynamic websites for Debian Pure Blends _______________________________________________ Blends-commit mailing list Blends-commit@lists.alioth.debian.org http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/blends-commit