use "ON DELETE CASCADE" clauses

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__":