The following commit has been merged in the master branch: commit 9b807c8c1497b978499fbc1aa3b6f58dc0c76f92 Author: Andreas Tille <ti...@debian.org> Date: Fri May 31 14:36:26 2013 +0200
Drop distribution from results to enable grouping over source name, make sure we get the latest *source* version that might be different from binary package version (see ncbi-tools6 - blast2) diff --git a/misc/sql/gis-thermometer.sh b/misc/sql/gis-thermometer.sh index 5783056..6e41d65 100755 --- a/misc/sql/gis-thermometer.sh +++ b/misc/sql/gis-thermometer.sh @@ -6,29 +6,38 @@ if [ $# -lt 1 ] ; then fi psql udd >$1.stable <<EOT -SELECT DISTINCT p.source, strip_binary_upload(version) AS stableversion, p.distribution +SELECT DISTINCT p.source, strip_binary_upload(MAX(s.version)) AS stableversion FROM packages p JOIN releases r ON p.release = r.release JOIN blends_dependencies b ON b.package = p.package - WHERE b.blend = '$1' AND r.role = 'stable' + -- 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 r.role = 'stable' AND p.distribution = 'debian' + GROUP BY p.source ORDER BY p.source; EOT psql udd >$1.testing <<EOT -SELECT DISTINCT p.source, strip_binary_upload(version) AS testingversion, p.distribution +SELECT DISTINCT p.source, strip_binary_upload(MAX(s.version)) AS testingversion FROM packages p JOIN releases r ON p.release = r.release JOIN blends_dependencies b ON b.package = p.package - WHERE b.blend = '$1' AND r.role = 'testing' + -- 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 r.role = 'testing' AND p.distribution = 'debian' + GROUP BY p.source ORDER BY p.source; EOT psql udd >$1.unstable <<EOT -SELECT DISTINCT p.source, strip_binary_upload(version) AS unstableversion, p.distribution +SELECT DISTINCT p.source, strip_binary_upload(MAX(s.version)) AS unstableversion FROM packages p JOIN releases r ON p.release = r.release JOIN blends_dependencies b ON b.package = p.package - WHERE b.blend = '$1' AND r.role = 'unstable' + -- 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 r.role = 'unstable' AND p.distribution = 'debian' + GROUP BY p.source ORDER BY p.source; EOT -- 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