From e455f9428f8730aa6685382b86a5db7c6429ab5c Mon Sep 17 00:00:00 2001 From: "martin@piware.de" <> Date: Sat, 13 Jun 2009 09:49:09 +0200 Subject: [PATCH] workitems: Overwrite data from same day --- workitems.py | 3 +++ 1 file changed, 3 insertions(+) diff --git a/workitems.py b/workitems.py index b9ee195..8572a75 100755 --- a/workitems.py +++ b/workitems.py @@ -135,6 +135,9 @@ def import_lp(db, name_pattern, release): blueprints = get_blueprints('%s//ubuntu/%s/+specs' % (blueprints_base_url, opts.release), name_pattern) + cur = db.cursor() + cur.execute('DELETE FROM work_items WHERE date = date(CURRENT_TIMESTAMP)') + for bp in blueprints: #print 'Checking', bp bpname = bp.split('/')[-1] -- 2.39.2