Author: nthykier
Date: 2012-10-30 10:25:17 +0000 (Tue, 30 Oct 2012)
New Revision: 2536
Modified:
rc-buggy-leaf-packages/rt-source-rcbugs.sql
Log:
Skip packages with open unblock bugs (based on title)
Modified: rc-buggy-leaf-packages/rt-source-rcbugs.sql
===================================================================
--- rc-buggy-leaf-packages/rt-source-rcbugs.sql 2012-10-30 04:01:38 UTC (rev
2535)
+++ rc-buggy-leaf-packages/rt-source-rcbugs.sql 2012-10-30 10:25:17 UTC (rev
2536)
@@ -45,6 +45,12 @@
OR ut.tag = 'wheezy-no-auto-remove'
)
)
+ AND b.id NOT IN ( -- No open unblock bugs
+ SELECT b2.id FROM bugs b2
+ WHERE b2.source = 'release.debian.org'
+ AND b2.done != 'done'
+ AND b2.title LIKE 'unblock: ' || b.source || '/%'
+ )
AND b.last_modified < CURRENT_TIMESTAMP - INTERVAL '14 days'
GROUP BY b.source, b.id
_______________________________________________
Collab-qa-commits mailing list
Collab-qa-commits@lists.alioth.debian.org
http://lists.alioth.debian.org/cgi-bin/mailman/listinfo/collab-qa-commits
