The following commit has been merged in the master branch:
commit 895f18fa172655114fafa1951287ccba2f1c5622
Author: Andreas Tille <[email protected]>
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
[email protected]
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/blends-commit
