diff options
Diffstat (limited to 'scripts')
| -rw-r--r-- | scripts/daily_cleanup.py | 14 | ||||
| -rwxr-xr-x | scripts/djangoshell.sh | 6 |
2 files changed, 20 insertions, 0 deletions
diff --git a/scripts/daily_cleanup.py b/scripts/daily_cleanup.py new file mode 100644 index 0000000..98f997b --- /dev/null +++ b/scripts/daily_cleanup.py @@ -0,0 +1,14 @@ +from django.db import backend, connection, transaction +""" Daily cleanup file + This purges the session data that is old from the session table. +""" +def clean_up(): + # Clean up old database records + cursor = connection.cursor() + cursor.execute("DELETE FROM %s WHERE %s < NOW()" % \ + (backend.quote_name('django_session'), backend.quote_name('expire_date'))) + cursor.execute("OPTIMIZE TABLE %s" % backend.quote_name('django_session')) + transaction.commit_unless_managed() + +if __name__ == "__main__": + clean_up() diff --git a/scripts/djangoshell.sh b/scripts/djangoshell.sh new file mode 100755 index 0000000..457c882 --- /dev/null +++ b/scripts/djangoshell.sh @@ -0,0 +1,6 @@ +#!/bin/bash +cd /home/sites/archlinux/archlinux +export PYTHONPATH=/usr/local/django:/home/sites/archlinux:${PYTHONPATH} +export DJANGO_SETTINGS_MODULE=archlinux.settings +python manage.py $* + |