lib/hashserv/sqlite.py

84     where = {}
87             where[c] = condition[c]
89     return where, " AND ".join("%s=:%s" % (k, k) for k in where.keys())
159 …SELECT name FROM {_schema_table_name(sqlite_version)} WHERE type = 'table' AND name = 'unihashes_v…
204             ((SELECT id FROM config WHERE name=:name), :name, :value)
214             "SELECT value FROM config WHERE name=:name",
233                 WHERE outhashes_v2.method=:method AND outhashes_v2.taskhash=:taskhash
250                 WHERE outhashes_v2.method=:method AND outhashes_v2.outhash=:outhash
265                 SELECT * FROM unihashes_v3 WHERE unihash=:unihash
279                 WHERE outhashes_v2.method=:method AND outhashes_v2.outhash=:outhash
297 …WHERE outhashes_v2.method=:method AND outhashes_v2.outhash=:outhash AND outhashes_v2.taskhash!=:ta…
313 …  "SELECT taskhash, method, unihash FROM unihashes_v3 WHERE method=:method AND taskhash=:taskhash",
323             where, clause = _make_condition_statement(columns, condition)
324             if where:
325                 query = f"DELETE FROM {table_name} WHERE {clause}"
326                 cursor.execute(query, where)
347                 SELECT COUNT() FROM unihashes_v3 WHERE
348                     gc_mark=COALESCE((SELECT value FROM config WHERE name='gc-mark'), '')
355                 SELECT COUNT() FROM unihashes_v3 WHERE
356                     gc_mark!=COALESCE((SELECT value FROM config WHERE name='gc-mark'), '')
369             where, clause = _make_condition_statement(UNIHASH_TABLE_COLUMNS, condition)
372             if where:
376                         gc_mark=COALESCE((SELECT value FROM config WHERE name='gc-mark'), '')
377                     WHERE {clause}
379                     where,
392                 DELETE FROM unihashes_v3 WHERE
393                     gc_mark!=(SELECT value FROM config WHERE name='gc-mark')
406                 DELETE FROM outhashes_v2 WHERE created<:oldest AND NOT EXISTS (
407 …SELECT unihashes_v3.id FROM unihashes_v3 WHERE unihashes_v3.method=outhashes_v2.method AND unihash…
427                     COALESCE((SELECT value FROM config WHERE name='gc-mark'), '')
456                 SELECT username, permissions, token FROM users WHERE username=:username
477                 UPDATE users SET token=:token WHERE username=:username
491                 UPDATE users SET permissions=:permissions WHERE username=:username
528                 DELETE FROM users WHERE username=:username
542 …SELECT name FROM {_schema_table_name(self.sqlite_version)} WHERE type = 'table' AND name NOT LIKE …