The following commit has been merged in the master branch:
commit 414c40cc392b6a62fb36d05df52bf2a2dc85c7e8
Author: Andreas Tille <[email protected]>
Date: Sat Jun 8 21:21:10 2013 +0200
Obtain information from PET to check whether there are UNRELEASED versions
in VCS
diff --git a/misc/sql/gis-thermometer.sh b/misc/sql/gis-thermometer.sh
index 80aff36..6a32411 100755
--- a/misc/sql/gis-thermometer.sh
+++ b/misc/sql/gis-thermometer.sh
@@ -18,6 +18,7 @@ SELECT b.source,
unstable.version AS unstable,
stable_bpo.version AS "stable-bpo",
experimental.version AS experimental,
+ unreleased.version AS "UNRELEASED",
precise.version AS precise,
quantal.version AS quantal,
raring.version AS raring,
@@ -116,6 +117,16 @@ SELECT b.source,
ORDER BY p.source
) stable_bpo ON b.source = stable_bpo.source
LEFT OUTER JOIN (
+ SELECT DISTINCT p.source, strip_binary_upload(MAX(v.version)) AS version
+ FROM packages p
+ 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
+ JOIN vcs v ON s.source = v.source
+ WHERE b.blend = '$1' AND v.distribution = 'UNRELEASED'
+ GROUP BY p.source
+ ) unreleased ON b.source = unreleased.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
