From 9760c10454f57c04a24bbaf2efeebcb191315734 Mon Sep 17 00:00:00 2001 From: Helmut Grohne Date: Wed, 20 Feb 2013 16:52:17 +0100 Subject: store hard dependencies --- test.py | 5 +++++ 1 file changed, 5 insertions(+) (limited to 'test.py') diff --git a/test.py b/test.py index 4277d57..a9761a9 100755 --- a/test.py +++ b/test.py @@ -2,6 +2,7 @@ """ CREATE TABLE package (package TEXT PRIMARY KEY, version TEXT, architecture TEXT); CREATE TABLE content (package TEXT, filename TEXT, size INTEGER, function TEXT, hash TEXT, FOREIGN KEY (package) REFERENCES package(package)); +CREATE TABLE dependency (package TEXT, required TEXT, FOREIGN KEY (package) REFERENCES package(package), FOREIGN KEY (required) REFERENCES package(package)); CREATE INDEX content_package_index ON content (package); CREATE INDEX content_hash_index ON content (hash); """ @@ -286,6 +287,10 @@ def process_package(db, filelike): depends = control.relations.get("depends", []) depends = set(dep[0]["name"].encode("ascii") for dep in depends if len(dep) == 1) + cur.execute("DELETE FROM dependency WHERE package = ?;", + (package,)) + cur.executemany("INSERT INTO dependency (package, required) VALUES (?, ?);", + ((package, dep) for dep in depends)) break continue elif name == "data.tar.gz": -- cgit v1.2.3