+ # Check for packages in experimental obsoleted by versions in unstable
+ #
+ # [If melanie was callable from python, we could auto-remove these
+ # packages...]
+
+ suite_id = db_access.get_suite_id("unstable");
+ q = projectB.query("""
+SELECT s.source, s.version AS experimental, s2.version AS unstable
+ FROM src_associations sa, source s, source s2, src_associations sa2
+ WHERE sa.suite = 1 AND sa2.suite = %d AND sa.source = s.id
+ AND sa2.source = s2.id AND s.source = s2.source
+ AND versioncmp(s.version, s2.version) < 0""" % (suite_id));
+ ql = q.getresult();
+ if ql != []:
+ print
+ print q