diff gpp/forums/management/commands/forum_cleanup.py @ 307:7e19180b128d

Fixing #97; adding a management command to remove old forum and topic last visit records.
author Brian Neal <bgneal@gmail.com>
date Sun, 16 Jan 2011 20:18:26 +0000
parents
children
line wrap: on
line diff
--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/gpp/forums/management/commands/forum_cleanup.py	Sun Jan 16 20:18:26 2011 +0000
@@ -0,0 +1,26 @@
+"""
+forum_cleanup.py - A management command to cleanup forum model objects. Right
+now this entails deleting old forum and topic last visit records.
+
+"""
+import datetime
+
+from django.core.management.base import NoArgsCommand, CommandError
+
+from forums.models import ForumLastVisit, TopicLastVisit
+import forums.unread
+
+
+class Command(NoArgsCommand):
+    help = "This command deletes old forum and topic last visit records."
+
+    def handle_noargs(self, **opts):
+
+        now = datetime.datetime.now()
+        threshold = now - forums.unread.THRESHOLD * 2
+
+        # delete old topic last visit records
+        TopicLastVisit.objects.filter(last_visit__lt=threshold).delete()
+
+        # delete old forum visit records
+        ForumLastVisit.objects.filter(end_date__lt=threshold).delete()