Mercurial > public > sg101
view gpp/forums/management/commands/sync_forums.py @ 552:9e42e6618168
For bitbucket issue #2, tweak the admin settings for the Post model to
reduce slow queries. Define our own queryset() method so we can control the
select_related(), and not have it cascade from post to topics to forums to
categories. Removed 'topic' from list_display because MySQL still sucked with
2 inner joins. Now it seems to be tolerable with only one join to User.
author | Brian Neal <bgneal@gmail.com> |
---|---|
date | Wed, 25 Jan 2012 20:07:03 -0600 |
parents | 254db4cb6a86 |
children |
line wrap: on
line source
""" sync_forums.py - A management command to synchronize the forums by recomputing the de-normalized fields in the forum and topic objects. """ import optparse from django.core.management.base import NoArgsCommand, CommandError from forums.models import Forum from forums.models import Topic class Command(NoArgsCommand): help = """\ This command synchronizes the forum application's forums and topic objects by updating their de-normalized fields. """ option_list = NoArgsCommand.option_list + ( optparse.make_option("-p", "--progress", action="store_true", help="Output a . after every 50 topics to show progress"), ) def handle_noargs(self, **opts): show_progress = opts.get('progress', False) or False n = 0 for topic in Topic.objects.iterator(): topic.post_count_update() topic.save() n += 1 if n % 50 == 0: self.stdout.write('.') self.stdout.flush() for forum in Forum.objects.all(): forum.sync() forum.save() self.stdout.write('\n')