diff options
| author | Helmut Grohne <helmut@subdivi.de> | 2013-02-25 08:55:53 +0100 |
|---|---|---|
| committer | Helmut Grohne <helmut@subdivi.de> | 2013-02-25 08:55:53 +0100 |
| commit | 94711787487f3f3dae26979bcbdbeeb77ed883ae (patch) | |
| tree | 068b3b7abef506ad6f9d73157ab02bbd1eba6ad0 | |
| parent | f09f59b271a1e23eda162fd357814ca560f72a34 (diff) | |
| download | debian-dedup-94711787487f3f3dae26979bcbdbeeb77ed883ae.tar.gz | |
autoimport: this is not how foreign key constraints work
| -rwxr-xr-x | autoimport.py | 4 |
1 files changed, 4 insertions, 0 deletions
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() |