view gpp/forums/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 79d454ff2de0
children 98b373ca09f3
line wrap: on
line source
"""
This file contains the admin definitions for the forums application.
"""
from django.contrib import admin

from forums.models import Category
from forums.models import Forum
from forums.models import Topic
from forums.models import Post
from forums.models import FlaggedPost
from forums.models import ForumLastVisit
from forums.models import TopicLastVisit
import bio.badges


class CategoryAdmin(admin.ModelAdmin):
    list_display = ('name', 'position', )
    list_editable = ('position', )
    prepopulated_fields = { 'slug': ('name', ) }
    save_on_top = True


class ForumAdmin(admin.ModelAdmin):
    list_display = ('name', 'category', 'position', 'topic_count', 'post_count')
    list_editable = ('position', )
    prepopulated_fields = { 'slug': ('name', ) }
    raw_id_fields = ('last_post', )
    ordering = ('category', )
    save_on_top = True


class TopicAdmin(admin.ModelAdmin):
    list_display = ('name', 'forum', 'creation_date', 'update_date', 'user', 'sticky', 'locked',
            'post_count')
    raw_id_fields = ('user', 'last_post', 'subscribers', 'bookmarkers')
    search_fields = ('name', )
    date_hierarchy = 'creation_date'
    list_filter = ('creation_date', 'update_date', )
    save_on_top = True


class PostAdmin(admin.ModelAdmin):
    list_display = ('user', 'creation_date', 'update_date', 'user_ip', 'summary')
    raw_id_fields = ('topic', 'user', )
    exclude = ('html', )
    search_fields = ('body', )
    date_hierarchy = 'creation_date'
    list_filter = ('creation_date', 'update_date', )
    ordering = ('-creation_date', )
    save_on_top = True

    def queryset(self, request):
        return Post.objects.select_related('user')


class FlaggedPostAdmin(admin.ModelAdmin):
    list_display = ['__unicode__', 'flag_date', 'get_post_url']
    actions = ['accept_flags']
    raw_id_fields = ['post', 'user', ]

    def accept_flags(self, request, qs):
        """This admin action awards a security pin to the user who reported
        the post and then deletes the flagged post object.
        """
        for flag in qs:
            bio.badges.award_badge(bio.badges.SECURITY_PIN, flag.user)
            flag.delete()

    accept_flags.short_description = "Accept selected flagged posts"


class ForumLastVisitAdmin(admin.ModelAdmin):
    raw_id_fields = ('user', 'forum')
    list_display = ('user', 'forum', 'begin_date', 'end_date')


class TopicLastVisitAdmin(admin.ModelAdmin):
    raw_id_fields = ('user', 'topic')
    list_display = ('user', 'topic', 'last_visit')


admin.site.register(Category, CategoryAdmin)
admin.site.register(Forum, ForumAdmin)
admin.site.register(Topic, TopicAdmin)
admin.site.register(Post, PostAdmin)
admin.site.register(FlaggedPost, FlaggedPostAdmin)
admin.site.register(ForumLastVisit, ForumLastVisitAdmin)
admin.site.register(TopicLastVisit, TopicLastVisitAdmin)