#!/usr/local/bin/python
"Daily cleanup file"
import sys
import os
os.environ['DJANGO_SETTINGS_MODULE'] = "zilbo.settings" 
sys.path = ['/usr/local/src/magik' ] + sys.path
from django.db import backend, connection, transaction

#DOCUMENTATION_DIRECTORY = '/home/html/documentation/'

def clean_up():
    # Clean up old database records
    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()

if __name__ == "__main__":
    clean_up()