The following commit has been merged in the master branch:
commit cd4efcfd4424672390a43ef47f887e5ee1e2fcac
Author: Andreas Tille <[email protected]>
Date: Fri May 31 15:10:56 2013 +0200
Add DEHS table to get upstream version and status flag
diff --git a/misc/sql/gis-thermometer.sh b/misc/sql/gis-thermometer.sh
index b329334..778a486 100755
--- a/misc/sql/gis-thermometer.sh
+++ b/misc/sql/gis-thermometer.sh
@@ -9,7 +9,13 @@ fi
# name in stable or testing that is different from the name in unstable
psql udd >$1.out <<EOT
-SELECT unstable.source, stable.version AS stable, testing.version AS testing,
unstable.version AS unstable FROM (
+SELECT unstable.source,
+ stable.version AS stable,
+ testing.version AS testing,
+ unstable.version AS unstable,
+ d.unstable_upstream,
+ d.unstable_status
+ FROM (
SELECT DISTINCT p.source, strip_binary_upload(MAX(s.version)) AS version
FROM packages p
JOIN releases r ON p.release = r.release
@@ -42,6 +48,7 @@ SELECT unstable.source, stable.version AS stable,
testing.version AS testing, un
GROUP BY p.source
ORDER BY p.source
) stable ON unstable.source = stable.source
+ LEFT OUTER JOIN dehs d ON unstable.source = d.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
