"""""
rows = query_without_source(suite_id, session)
message = '[auto-cruft] no longer built from source, no reverse dependencies'
- arch_all_id_tuple = tuple([get_architecture('all', session=session)])
+ arch = get_architecture('all', session=session)
+ arch_all_id_tuple = tuple([arch.arch_id])
arch_all_list = ["all"]
for row in rows:
package = row[0]
params = {"suite_id": suite_id, "sources": tuple(source_list)}
q = session.execute("""
SELECT s.source, s.version, 'source', s.id
- FROM source s,
+ FROM source s
JOIN src_associations sa ON sa.source = s.id
- JOIN suite su ON sa.suite = su.id
- WHERE su.id = :suite_id AND s.source IN :sources""", params)
+ WHERE sa.suite = :suite_id AND s.source IN :sources""", params)
to_remove.extend(q)
q = session.execute("""
SELECT b.package, b.version, a.arch_string, b.id
FROM binaries b
JOIN bin_associations ba ON b.id = ba.bin
JOIN architecture a ON b.architecture = a.id
- JOIN suite su ON ba.suite = su.id
JOIN source s ON b.source = s.id
- JOIN src_associations sa ON s.id = sa.source AND sa.suite = su.id
- WHERE su.id = :suite_id AND s.source IN :sources""", params)
+ WHERE ba.suite = :suite_id AND s.source IN :sources""", params)
to_remove.extend(q)
return to_remove
('n',"dry-run","Auto-Decruft::Options::Dry-Run"),
('d',"debug","Auto-Decruft::Options::Debug"),
('s',"suite","Auto-Decruft::Options::Suite","HasArg"),
- ('z','if-newer-version-in',"Auto-Decruft::Options::OtherSuite", "HasArg"),
- ('Z','if-newer-version-in-rm-msg',"Auto-Decruft::Options::OtherSuiteRMMsg", "HasArg")]
+ # The "\0" seems to be the only way to disable short options.
+ ("\0",'if-newer-version-in',"Auto-Decruft::Options::OtherSuite", "HasArg"),
+ ("\0",'if-newer-version-in-rm-msg',"Auto-Decruft::Options::OtherSuiteRMMsg", "HasArg")]
for i in ["help", "Dry-Run", "Debug", "OtherSuite", "OtherSuiteRMMsg"]:
if not cnf.has_key("Auto-Decruft::Options::%s" % (i)):
cnf["Auto-Decruft::Options::%s" % (i)] = ""
osuite = get_suite(Options["OtherSuite"].lower(), session).suite_name
decruft_newer_version_in(osuite, suite_name, suite_id, Options["OtherSuiteRMMsg"], session, dryrun)
+ if not dryrun:
+ session.commit()
+
################################################################################
if __name__ == '__main__':