From: Sarah Hoffmann <lonvia@denofr.de>
Date: Sat, 26 Jan 2013 20:06:21 +0000 (+0100)
Subject: flush bulk list once a day
X-Git-Tag: deploy~643
X-Git-Url: https://git.openstreetmap.org./nominatim.git/commitdiff_plain/54995a86ab7274ccf4fb2e73ecb443426ed462f4?hp=--cc

flush bulk list once a day
---

54995a86ab7274ccf4fb2e73ecb443426ed462f4
diff --git a/utils/cron_banip.py b/utils/cron_banip.py
index d716affb..af443444 100755
--- a/utils/cron_banip.py
+++ b/utils/cron_banip.py
@@ -182,6 +182,7 @@ if debulkcandidates:
     cur.execute("""
         SELECT DISTINCT ipaddress FROM new_query_log
         WHERE ipaddress IN ('%s') AND starttime > now() - interval '%s'
+        AND starttime > date_trunc('day', now())
         """ % ("','".join(debulkcandidates), BULKCOOLOFF_PERIOD))
 
     for c in cur: