diff options
Diffstat (limited to 'autoimport.py')
-rwxr-xr-x | autoimport.py | 10 |
1 files changed, 2 insertions, 8 deletions
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__": |