The following commit has been merged in the master branch:
commit f990063eb0f8602e5043a8ee1524ebf189a0fc1a
Author: Andreas Tille <[email protected]>
Date: Fri May 31 13:19:22 2013 +0200
We are interested in source packages
diff --git a/misc/sql/gis-thermometer.sh b/misc/sql/gis-thermometer.sh
index 140342a..5783056 100755
--- a/misc/sql/gis-thermometer.sh
+++ b/misc/sql/gis-thermometer.sh
@@ -6,29 +6,29 @@ if [ $# -lt 1 ] ; then
fi
psql udd >$1.stable <<EOT
-SELECT DISTINCT p.package, strip_binary_upload(version) AS stableversion,
p.distribution
+SELECT DISTINCT p.source, strip_binary_upload(version) AS stableversion,
p.distribution
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'
- ORDER BY p.package;
+ ORDER BY p.source;
EOT
psql udd >$1.testing <<EOT
-SELECT DISTINCT p.package, strip_binary_upload(version) AS testingversion,
p.distribution
+SELECT DISTINCT p.source, strip_binary_upload(version) AS testingversion,
p.distribution
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'
- ORDER BY p.package;
+ ORDER BY p.source;
EOT
psql udd >$1.unstable <<EOT
-SELECT DISTINCT p.source, p.package, strip_binary_upload(version) AS
unstableversion, p.distribution
+SELECT DISTINCT p.source, strip_binary_upload(version) AS unstableversion,
p.distribution
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'
- ORDER BY p.package;
+ ORDER BY p.source;
EOT
--
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
