The following commit has been merged in the master branch:
commit 695f87b7471f21baede9155b28531ff67732101c
Author: Andreas Tille <[email protected]>
Date: Fri Sep 6 19:15:17 2013 +0200
Find packages not touched for a very long time
diff --git a/misc/sql/0-aging.sh b/misc/sql/0-aging.sh
new file mode 100755
index 0000000..3a09b05
--- /dev/null
+++ b/misc/sql/0-aging.sh
@@ -0,0 +1,20 @@
+#!/bin/sh
+# seek for packages uploaded a very long time ago
+# join MAX(version)
+
+SERVICE="service=udd"
+#if there is a local UDD clone just use this
+if psql -l 2>/dev/null | grep -qw udd ; then
+ SERVICE=udd
+fi
+
+psql $SERVICE >$1.out <<EOT
+ SELECT u.source, u.version, u.date, u.distribution FROM (
+ SELECT source, MAX(version) AS version FROM blends_dependencies b
+ JOIN packages p ON p.package = b.package
+ WHERE blend = 'debian-med' GROUP BY source
+ ) s
+ JOIN upload_history u ON s.source = u.source AND s.version = u.version
+ ORDER BY date
+ ;
+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
