view gpp/forums/management/commands/forum_cleanup.py @ 463:452835f4429f

Fixing #225; for some reason MySQL finds the user 'John' when searching for 'John ' (note trailing space). This doesn't happen on SQLite. This causes a NoReverseMatch when searching for 'John ' in the member search. The solution is to call strip() on the form field contents in the clean_username() method of the search form.
author Brian Neal <bgneal@gmail.com>
date Sat, 09 Jul 2011 02:00:48 +0000
parents 7e19180b128d
children
line wrap: on
line source
"""
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()