From 7cd66ced9ea502a4179fcf6a2c9d1ce7e2b314e1 Mon Sep 17 00:00:00 2001 From: Helmut Grohne Date: Sat, 2 Mar 2019 13:55:43 +0100 Subject: depcheck.py: move the filter into sql --- depcheck.py | 15 +++++++++------ 1 file changed, 9 insertions(+), 6 deletions(-) diff --git a/depcheck.py b/depcheck.py index 046b559..cb2e7e4 100755 --- a/depcheck.py +++ b/depcheck.py @@ -440,14 +440,17 @@ def main(): args = argp.parse_args() mirror = DebianMirror(args.mirror) mirror.update_release() - db = sqlite3.connect("db", detect_types=sqlite3.PARSE_DECLTYPES) + db = sqlite3.connect("db") cur = db.cursor() - cur.execute("SELECT architecture, releasetime, updatetime, giveback FROM depcheck;") lastupdate = datetime.datetime.utcnow() - datetime.timedelta(hours=6) - for architecture, releasetime, updatetime, giveback in list(cur.fetchall()): - if giveback or updatetime < lastupdate or releasetime < mirror.releasetime: - print("update %s" % architecture) - update_depcheck(mirror, db, architecture) + cur.execute(""" + SELECT architecture FROM depcheck + WHERE giveback = 1 OR updatetime < ? OR releasetime < ?;""", + (datetime.datetime.utcnow() - datetime.timedelta(hours=6), + mirror.releasetime)) + for architecture, in list(cur.fetchall()): + print("update %s" % architecture) + update_depcheck(mirror, db, architecture) if __name__ == "__main__": main() -- cgit v1.2.3