db = sqlite3.connect("db", detect_types=sqlite3.PARSE_DECLTYPES)
with contextlib.closing(db.cursor()) as cur:
cur.execute("""
- SELECT d.source, d.version, d.architecture, r.rowid
+ SELECT d.source, d.version, d.architecture, r.id
FROM depstate AS d
JOIN buildrequests AS r
ON d.architecture = ifnull(r.architecture, d.architecture)
(source, version, architecture, success, timestamp,
filename))
if requestid is not None:
- cur.execute("DELETE FROM buildrequests WHERE rowid = ?;",
+ cur.execute("DELETE FROM buildrequests WHERE id = ?;",
(requestid,))
if giveback:
cur.execute("UPDATE depcheck SET giveback = 1 WHERE architecture = ?;",
filename TEXT NOT NULL);
CREATE TABLE buildrequests (
+ id INTEGER PRIMARY KEY,
source TEXT NOT NULL,
architecture TEXT,
requesttime TIMESTAMP NOT NULL,