"""
these 2 operations are to cleanup sessions and cache table (if it exists)
"""
__revision__ = "$Rev: 227 $" 
__date__ = "$Date: 2006-07-22 21:42:10 +1000 (Sat, 22 Jul 2006) $" 

from django.dispatch import dispatcher
from zilbo.common.utils import signals
from django.db import backend, connection, transaction

def counter_cleanup():
    cursor = connection.cursor()
    cursor.execute("DELETE FROM %s WHERE %s < DATE_SUB( now(), interval 72 HOUR) " % \
        (backend.quote_name('counter_objecthourcounter'), backend.quote_name('effective_date')))

    cursor.execute("DELETE FROM %s WHERE %s < DATE_SUB(now(), interval 60 day)" % \
        (backend.quote_name('counter_objectdatecounter'), backend.quote_name('effective_date') ))

    cursor.execute("DELETE FROM %s WHERE %s < DATE_SUB( now(), interval 30 day)" % \
        (backend.quote_name('counter_objectdateusercounter'), backend.quote_name('effective_date') ))

    cursor.execute("DELETE FROM %s WHERE %s < DATE_SUB( now(), interval 48 hour)" % \
        (backend.quote_name('counter_objecthourusercounter'), backend.quote_name('effective_date') ))

    cursor.execute("DELETE FROM %s WHERE %s < DATE_SUB( now(), interval 60 day)" % \
        (backend.quote_name('counter_objectcounter'), backend.quote_name('last_change')))

    transaction.commit_unless_managed()


dispatcher.connect(counter_cleanup, signal=signals.run_daily_jobs)