Mercurial > public > sg101
view gpp/legacy/management/commands/fix_potd_smiles.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 | 97593a955291 |
children |
line wrap: on
line source
""" This command fixes the old 1.0 smiley system to match the new scheme. """ from django.core.management.base import NoArgsCommand from comments.models import Comment SMILEY_MAP = { ':confused:': ':?', ':upset:': ':argh:', ':eek:': ':shock:', ':rolleyes:': ':whatever:', ':mad:': 'X-(', ':shy:': ':oops:', ':laugh:': ':lol:', ':dead:': 'x_x', ':cry:': ':-(', ';)': ':wink:', ':|': ':-|', ';-)': ':wink:', ':D': ':-D', ':P': ':-P', 'B)': '8)', ':(': ':-(', ':)': ':-)', } class Command(NoArgsCommand): def handle_noargs(self, **opts): comments = Comment.objects.filter(id__gt=3000) for comment in comments: save = False for key, val in SMILEY_MAP.items(): if key in comment.comment: comment.comment = comment.comment.replace(key, val) save = True if save: comment.save()