X-Git-Url: https://git.decadent.org.uk/gitweb/?a=blobdiff_plain;f=dak%2Fdominate.py;h=600d1127d927f0011cab4e4939213080bdf7818e;hb=5b520e89c57dfc268c2e32a88b4e5b4b7ec4333c;hp=7bb74c6728ff12a448bd4fadd418da48dfb7dbf5;hpb=2c55c2809f7a76f9b50e2c7cb7e12e10f29eacc5;p=dak.git diff --git a/dak/dominate.py b/dak/dominate.py index 7bb74c67..600d1127 100755 --- a/dak/dominate.py +++ b/dak/dominate.py @@ -87,9 +87,12 @@ def deleteAssociations(table, idList, session): query = """ DELETE FROM %s - WHERE id = :id + WHERE id IN :idList """ % table - session.execute(query, [{'id': id} for id in idList]) + if not idList: + return + params = {'idList': tuple(idList)} + session.execute(query, params) def doDaDoDa(suite, session): # keep this part disabled because it is too dangerous @@ -125,27 +128,37 @@ def main(): ('s', "suite", "Obsolete::Options::Suite", "HasArg"), ('n', "no-action", "Obsolete::Options::No-Action"), ('f', "force", "Obsolete::Options::Force")] - query_suites = DBConn().session().query(Suite) - suites = [suite.suite_name for suite in query_suites.all()] - if not cnf.has_key('Obsolete::Options::Suite'): - cnf['Obsolete::Options::Suite'] = ','.join(suites) cnf['Obsolete::Options::Help'] = '' cnf['Obsolete::Options::No-Action'] = '' cnf['Obsolete::Options::Force'] = '' - apt_pkg.ParseCommandLine(cnf.Cnf, Arguments, sys.argv) - Options = cnf.SubTree("Obsolete::Options") + apt_pkg.parse_commandline(cnf.Cnf, Arguments, sys.argv) + Options = cnf.subtree("Obsolete::Options") if Options['Help']: usage() - Logger = daklog.Logger(cnf.Cnf, "dominate") + if 'Suite' not in Options: + query_suites = DBConn().session().query(Suite) + suites = [suite.suite_name for suite in query_suites] + cnf['Obsolete::Options::Suite'] = str(','.join(suites)) + + if not Options['No-Action']: + Logger = daklog.Logger("dominate") session = DBConn().session() for suite_name in utils.split_args(Options['Suite']): suite = session.query(Suite).filter_by(suite_name = suite_name).one() + + # Skip policy queues. We don't want to remove obsolete packages from those. + policy_queue = session.query(PolicyQueue).filter_by(suite=suite).first() + if policy_queue is not None: + continue + if not suite.untouchable or Options['Force']: doDaDoDa(suite.suite_id, session) if Options['No-Action']: session.rollback() else: session.commit() + if Logger: + Logger.close() if __name__ == '__main__': main()