[sqlite] SELECT and UPDATE in single query

[Richard Baron Penman]

Hello,

I have a table like this:

CREATE TABLE queue (
    key TEXT NOT NULL PRIMARY KEY UNIQUE,
    status INTEGER
);
CREATE INDEX IF NOT EXISTS keys ON queue (key);


And then I process it like this, N keys at a time:

SELECT key FROM queue WHERE status=0 LIMIT N;
BEGIN TRANSACTION;
for key in keys:
    UPDATE queue SET status=1 WHERE key=key;
END TRANSACTION;


How can this SELECT and UPDATE be combined more efficiently?

Richard
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users