summaryrefslogtreecommitdiff
path: root/autoimport.py
diff options
context:
space:
mode:
Diffstat (limited to 'autoimport.py')
-rwxr-xr-xautoimport.py10
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__":