The following commit has been merged in the master branch:
commit 5389c1a38166b54a568621f852ccea6e169a81d5
Author: Andreas Tille <[email protected]>
Date: Mon Jun 3 16:00:28 2013 +0200
Add stable-backports column
diff --git a/misc/sql/gis-thermometer.sh b/misc/sql/gis-thermometer.sh
index 6dcb9f8..1c080b3 100755
--- a/misc/sql/gis-thermometer.sh
+++ b/misc/sql/gis-thermometer.sh
@@ -16,6 +16,7 @@ SELECT b.source,
stable.version AS stable,
testing.version AS testing,
unstable.version AS unstable,
+ stable_bpo.version AS "stable-bpo",
experimental.version AS experimental,
ubuntu.version AS ubuntu,
d.unstable_upstream AS upstream,
@@ -72,6 +73,17 @@ SELECT b.source,
ORDER BY p.source
) experimental ON b.source = experimental.source
LEFT OUTER JOIN (
+ SELECT DISTINCT p.source, strip_binary_upload(MAX(s.version)) AS version
+ FROM packages p
+ JOIN releases r ON p.release = r.release
+ JOIN blends_dependencies b ON b.package = p.package
+ -- make sure we get the right source version that does not necessarily
match binary version
+ JOIN sources s ON p.source = s.source AND p.release = s.release
+ WHERE b.blend = '$1' AND p.release = (SELECT release FROM releases WHERE
role='stable') || '-backports' AND p.distribution = 'debian'
+ GROUP BY p.source
+ ORDER BY p.source
+ ) stable_bpo ON b.source = stable_bpo.source
+ LEFT OUTER JOIN (
SELECT DISTINCT u.source, strip_binary_upload(MAX(s.version)) AS version
FROM ubuntu_packages u
JOIN blends_dependencies b ON b.package = u.package
--
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
