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.5