Mercurial > public > sg101
view gpp/news/admin.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 | 7854d75427af |
children |
line wrap: on
line source
""" This file contains the automatic admin site definitions for the News models. """ import datetime from django.contrib import admin from django.conf import settings from news.models import PendingStory from news.models import Story from news.models import Category class CategoryAdmin(admin.ModelAdmin): prepopulated_fields = {'slug': ("title", )} list_display = ('title', 'slug') class PendingStoryAdmin(admin.ModelAdmin): list_display = ('title', 'date_submitted', 'submitter') list_filter = ('date_submitted', ) search_fields = ('title', 'short_text', 'long_text') date_hierarchy = 'date_submitted' actions = ('approve_story', ) readonly_fields = ('update_date', ) raw_id_fields = ('submitter', ) def approve_story(self, request, qs): for pending_story in qs: story = Story( title=pending_story.title, submitter=pending_story.submitter, category=pending_story.category, short_text=pending_story.short_text, long_text=pending_story.long_text, date_submitted=pending_story.date_submitted, allow_comments=pending_story.allow_comments, tags=pending_story.tags, front_page_expiration=pending_story.front_page_expiration, priority=pending_story.priority, meta_description=pending_story.meta_description) story.save() pending_story.delete() count = len(qs) msg = "1 story" if count == 1 else "%d stories" % count self.message_user(request, "%s approved." % msg) approve_story.short_description = "Approve selected pending stories" class Media: js = ['js/news_admin.js'] + settings.GPP_THIRD_PARTY_JS['tiny_mce'] class StoryAdmin(admin.ModelAdmin): list_display = ('title', 'date_submitted', 'submitter', 'category') list_filter = ('date_submitted', 'category') search_fields = ('title', 'short_text', 'long_text') date_hierarchy = 'date_submitted' readonly_fields = ('update_date', ) raw_id_fields = ('submitter', ) class Media: js = ['js/news_admin.js'] + settings.GPP_THIRD_PARTY_JS['tiny_mce'] admin.site.register(Category, CategoryAdmin) admin.site.register(Story, StoryAdmin) admin.site.register(PendingStory, PendingStoryAdmin)