The following commit has been merged in the master branch:
commit f0e0ce0cd45c914372e357cd7cb8fa2980a099a5
Author: Andreas Tille <[email protected]>
Date: Fri May 31 13:09:41 2013 +0200
Add some test SQL script to enable implementing pkg-grass package status
thermometer
diff --git a/misc/sql/gis-thermometer.sh b/misc/sql/gis-thermometer.sh
new file mode 100755
index 0000000..140342a
--- /dev/null
+++ b/misc/sql/gis-thermometer.sh
@@ -0,0 +1,34 @@
+#!/bin/sh
+
+if [ $# -lt 1 ] ; then
+ echo "$0: Argument for Blend is missing"
+ exit
+fi
+
+psql udd >$1.stable <<EOT
+SELECT DISTINCT p.package, 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;
+EOT
+
+psql udd >$1.testing <<EOT
+SELECT DISTINCT p.package, 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;
+EOT
+
+psql udd >$1.unstable <<EOT
+SELECT DISTINCT p.source, p.package, 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;
+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
