annotate gpp/weblinks/search_indexes.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 387d46abcb95
children
rev   line source
bgneal@220 1 """Haystack search index for the weblinks application."""
bgneal@220 2 from haystack.indexes import *
bgneal@220 3 from haystack import site
bgneal@469 4 from custom_search.indexes import CondQueuedSearchIndex
bgneal@220 5
bgneal@220 6 from weblinks.models import Link
bgneal@220 7
bgneal@220 8
bgneal@467 9 class LinkIndex(CondQueuedSearchIndex):
bgneal@220 10 text = CharField(document=True, use_template=True)
bgneal@220 11 author = CharField(model_attr='user')
bgneal@220 12 pub_date = DateTimeField(model_attr='date_added')
bgneal@220 13
bgneal@533 14 def index_queryset(self):
bgneal@220 15 return Link.public_objects.all()
bgneal@220 16
bgneal@277 17 def get_updated_field(self):
bgneal@277 18 return 'update_date'
bgneal@277 19
bgneal@467 20 def can_index(self, instance):
bgneal@467 21 return instance.is_public
bgneal@220 22
bgneal@220 23 site.register(Link, LinkIndex)