Mercurial > public > sg101
view gpp/downloads/management/commands/dlcatreport.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 | 645025056dfa |
children |
line wrap: on
line source
""" dlcatreport - a management command to produce a HTML report of all the downloads in a given category. """ from django.core.management.base import LabelCommand, CommandError from django.template.loader import render_to_string from downloads.models import Category, Download class Command(LabelCommand): help = "Produce on standard output a report of all downloads in a category." args = "category-slug" def handle_label(self, slug, **options): """ Render a template using the downloads in a given category and send it to stdout. """ try: category = Category.objects.get(slug=slug) except Category.DoesNotExist: raise CommandError("category slug '%s' does not exist" % slug) downloads = Download.public_objects.filter(category=category).order_by( 'title').select_related() report = render_to_string('downloads/commands/category_report.html', { 'category': category, 'downloads': downloads, }) # encode it ourselves since it can fail if you try to redirect output to # a file and any of the content is not ASCII... print report.encode('utf-8')