From 94711787487f3f3dae26979bcbdbeeb77ed883ae Mon Sep 17 00:00:00 2001 From: Helmut Grohne Date: Mon, 25 Feb 2013 08:55:53 +0100 Subject: autoimport: this is not how foreign key constraints work --- autoimport.py | 4 ++++ 1 file changed, 4 insertions(+) (limited to 'autoimport.py') diff --git a/autoimport.py b/autoimport.py index 02ac58e..a7ea5ff 100755 --- a/autoimport.py +++ b/autoimport.py @@ -38,6 +38,10 @@ def main(): delpkgs = set(knownpkgs) - distpkgs print("clearing packages %s" % " ".join(delpkgs)) cur.execute("PRAGMA foreign_keys=1;") + 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)) db.commit() -- cgit v1.2.3