From e0dd701f41a874c1c06702d849fe4b860a450e3e Mon Sep 17 00:00:00 2001 From: Helmut Grohne Date: Thu, 7 Mar 2013 09:05:48 +0100 Subject: use "ON DELETE CASCADE" clauses --- autoimport.py | 10 ++-------- 1 file changed, 2 insertions(+), 8 deletions(-) (limited to 'autoimport.py') diff --git a/autoimport.py b/autoimport.py index bc2c6aa..453a839 100755 --- a/autoimport.py +++ b/autoimport.py @@ -38,16 +38,10 @@ def main(): delpkgs = set(knownpkgs) - distpkgs print("clearing packages %s" % " ".join(delpkgs)) - cur.executemany("DELETE FROM sharing WHERE package1 = ?", - ((pkg,) for pkg in delpkgs)) - cur.executemany("DELETE FROM sharing WHERE package2 = ?", - ((pkg,) for pkg in delpkgs)) - cur.executemany("DELETE FROM content WHERE package = ?;", - ((pkg,) for pkg in delpkgs)) - cur.executemany("DELETE FROM dependency WHERE package = ?;", - ((pkg,) for pkg in delpkgs)) cur.executemany("DELETE FROM package WHERE package = ?;", ((pkg,) for pkg in delpkgs)) + # Tables content, dependency and sharing will also be pruned + # due to ON DELETE CASCADE clauses. db.commit() if __name__ == "__main__": -- cgit v1.2.3