From 54995a86ab7274ccf4fb2e73ecb443426ed462f4 Mon Sep 17 00:00:00 2001 From: Sarah Hoffmann Date: Sat, 26 Jan 2013 21:06:21 +0100 Subject: [PATCH] flush bulk list once a day --- utils/cron_banip.py | 1 + 1 file changed, 1 insertion(+) 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: -- 2.39.5