The following commit has been merged in the master branch:
commit 7a9b1cd1cc5922361e37afc7a27f8b5788fe15a4
Author: Andreas Tille <[email protected]>
Date: Sat May 25 21:39:17 2013 +0200
Add some simple shell script example containing an SQL query to get the
upgradable packages per Blend
diff --git a/misc/sql/upgradable.sh b/misc/sql/upgradable.sh
new file mode 100755
index 0000000..f1e67e7
--- /dev/null
+++ b/misc/sql/upgradable.sh
@@ -0,0 +1,11 @@
+#!/bin/sh
+
+psql udd <<EOT
+SELECT distinct u.source, unstable_version, unstable_upstream
+ FROM blends_dependencies b
+ JOIN packages p ON p.package = b.package
+ JOIN dehs u ON u.source = p.source
+ WHERE blend = '$1' AND b.distribution = 'debian' AND unstable_status =
'outdated'
+ ORDER BY 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
