view news/utils.py @ 693:ad69236e8501

For issue #52, update many 3rd party Javascript libraries. Updated to jquery 1.10.2, jquery ui 1.10.3. This broke a lot of stuff. - Found a newer version of the jquery cycle all plugin (3.0.3). - Updated JPlayer to 2.4.0. - Updated to MarkItUp 1.1.14. This also required me to add multiline attributes set to true on various buttons in the markdown set. - As per a stackoverflow post, added some code to get multiline titles in a jQuery UI dialog. They removed that functionality but allow you to put it back. Tweaked the MarkItUp preview CSS to show blockquotes in italic. Did not update TinyMCE at this time. I'm not using the JQuery version and this version appears to work ok for now. What I should do is make a repo for MarkItUp and do a vendor branch thing so I don't have to futz around diffing directories to figure out if I'll lose changes when I update.
author Brian Neal <bgneal@gmail.com>
date Wed, 04 Sep 2013 19:55:20 -0500
parents ee87ea74d46b
children c6c3ba5cf6eb
line wrap: on
line source
"""
Common utility/helper code for the news app.

"""
from django.contrib.contenttypes.models import ContentType

from comments.models import Comment
from tagging.models import TaggedItem
from news.models import Story


def attach_extra_attrs(stories):
    """
    For each story in the input stories list, attach 2 new attributes:
    tag_list and comment_count. The tags and comment count info is pulled from
    the database in bulk. This saves database queries when lots of news
    stories are displayed at once. For best results, use ".defer('tags')"
    when retrieve the stories from the database.

    """
    stories_dict = dict((story.id, story) for story in stories)
    story_ids = stories_dict.keys()

    # Get all the tags out in one query
    ct = ContentType.objects.get_for_model(Story)
    tagged_items = TaggedItem.objects.filter(content_type=ct,
            object_id__in=story_ids).select_related('tag')

    for story in stories_dict.values():
        story.tag_list = []
        story.comment_count = 0

    # attach tags
    for item in tagged_items:
        stories_dict[item.object_id].tag_list.append(item.tag.name)

    # Now get all the comment counts out in one fell swoop

    story_ids = Comment.objects.filter(content_type=ct,
            object_id__in=story_ids).values_list('object_id', flat=True)

    # compute comment_count
    for story_id in story_ids:
        stories_dict[story_id].comment_count += 1