flush bulk list once a day

[nominatim.git] / utils / cron_banip.py

diff --git a/utils/cron_banip.py b/utils/cron_banip.py
index d716affbe8e153b99d3fc8810c36ee61dbde9b19..af443444e756eddb979ee48d0e1162a74c6bba6d 100755 (executable)
--- 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'
     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:
         """ % ("','".join(debulkcandidates), BULKCOOLOFF_PERIOD))
 
     for c in cur: