Misago/misago/search_indexes.py

from haystack import indexes
from misago.models import Post

class PostIndex(indexes.SearchIndex, indexes.Indexable):
    text = indexes.CharField(document=True, use_template=True)
    forum = indexes.IntegerField(model_attr='forum_id')
    thread = indexes.IntegerField(model_attr='thread_id')
    thread_name = indexes.CharField(model_attr='thread')
    thread_starter = indexes.IntegerField(model_attr='thread_id')
    username = indexes.CharField(model_attr='user_name')
    date = indexes.DateTimeField(model_attr='date')

    def get_model(self):
        return Post

    def prepare_thread_name(self, obj):
        return obj.thread.name

    def prepare_thread_starter(self, obj):
        return obj.thread.start_poster_id

    def get_updated_field(self):
        return 'current_date'

    def should_update(self, instance, **kwargs):
        if (instance.deleted or instance.moderated
                or instance.thread.deletedor or instance.thread.moderated):
            self.remove_object(instance, **kwargs)
            return False
        return True

    def read_queryset(self, using=None):
        return Post.objects.all().select_related('forum', 'thread', 'user')

    def index_queryset(self, using=None):
        return self.get_model().objects.all().select_related('thread')