Python avoid_duplicate_queries Examples

Example #1

File: feed.py Project: okeefm/Observatory

def feed(request):
    qs = InheritanceQuerySet(model=Event)
    objs = qs.select_subclasses().order_by("date").reverse()[:INDEX_EVENT_COUNT]

    avoid_duplicate_queries(
        objs, "author", "project", author={request.user.id: request.user} if request.user.is_authenticated() else {}
    )

    return render_to_response(
        "feed/feed.html", {"events": objs, "disable_content": True}, context_instance=RequestContext(request)
    )

Example #2

File: feed.py Project: jkuruzovich/Observatory

def feed(request):
  objs = Event.objects.select_subclasses().order_by('date').reverse()[:INDEX_EVENT_COUNT]
  
  avoid_duplicate_queries(objs, "author", "project",
                          author = { request.user.id: request.user }
                                   if request.user.is_authenticated() else {})
  
  return render_to_response('feed/feed.html', {
      'events': objs,
      'disable_content': True
    }, context_instance = RequestContext(request))

Example #3

File: feed.py Project: rcos/Observatory-retired

def feed(request):
    objs = Event.objects.select_subclasses().order_by(
        'date').reverse()[:INDEX_EVENT_COUNT]

    avoid_duplicate_queries(objs,
                            "author",
                            "project",
                            author={request.user.id: request.user}
                            if request.user.is_authenticated() else {})

    return render_to_response('feed/feed.html', {
        'events': objs,
        'disable_content': True
    },
                              context_instance=RequestContext(request))

Example #4

File: feed.py Project: ejamesc/Observatory

def main(request):
  qs = InheritanceQuerySet(model = Event)
  objs = qs.select_subclasses().order_by('date').reverse()[:INDEX_EVENT_COUNT]
  projs = Project.objects.exclude(active = False).exclude(score = None).order_by('score')
  projs = projs[0:4] if projs else None

  avoid_duplicate_queries(objs, "author", "project",
                          author = { request.user.id: request.user }
                                   if request.user.is_authenticated() else {})

  return render_to_response('feed/feed.html', {
      'form': ShareForm(),
      'events': objs,
      'projects': projs,
      'disable_content': True
    }, context_instance = RequestContext(request))

Example #5

File: blogs.py Project: Einarin/Observatory

def posts_page(request, page_num):
  paginator = Paginator(BlogPost.objects.order_by('date').reverse(),
                        POSTS_PER_PAGE)
  
  # if the page requested does not exist, 404
  if int(page_num) not in paginator.page_range:
    raise Http404
  
  page = paginator.page(page_num)
  avoid_duplicate_queries(page.object_list, "author", "project",
                          author = { request.user.id: request.user }
                                   if request.user.is_authenticated() else {})
  
  # otherwise, render
  return render_to_response('blogs/posts.html', {
      'page': page,
      'disable_content': True
    }, context_instance = RequestContext(request))

Example #6

File: commits.py Project: Einarin/Observatory

def show_page(request, page_num, queryset, template, project = None):
  paginator = Paginator(queryset, COMMITS_PER_PAGE)
  
  # if the page requested does not exist, 404
  if int(page_num) not in paginator.page_range:
    raise Http404
  
  page = paginator.page(page_num)
  avoid_duplicate_queries(page.object_list, "author", "project",
                          author = { request.user.id: request.user }
                                   if request.user.is_authenticated() else {},
                          project = { project.id: project }
                                    if project is not None else {})
  
  # otherwise, render
  return render_to_response(template, {
      'page': page,
      'disable_content': True,
      'project': project
    }, context_instance = RequestContext(request))

Example #7

def posts_page(request, page_num):
    paginator = Paginator(
        BlogPost.objects.order_by('date').reverse(), POSTS_PER_PAGE)

    # if the page requested does not exist, 404
    if int(page_num) not in paginator.page_range:
        raise Http404

    page = paginator.page(page_num)
    avoid_duplicate_queries(page.object_list,
                            "author",
                            "project",
                            author={request.user.id: request.user}
                            if request.user.is_authenticated() else {})

    # otherwise, render
    return render_to_response('blogs/posts.html', {
        'page': page,
        'disable_content': True
    },
                              context_instance=RequestContext(request))

Example #8

File: commits.py Project: rozant/Observatory

def show_page(request, page_num, queryset, template, project=None):
    paginator = Paginator(queryset, COMMITS_PER_PAGE)

    # if the page requested does not exist, 404
    if int(page_num) not in paginator.page_range:
        raise Http404

    page = paginator.page(page_num)
    avoid_duplicate_queries(
        page.object_list,
        "author",
        "project",
        author={request.user.id: request.user}
        if request.user.is_authenticated() else {},
        project={project.id: project} if project is not None else {})

    # otherwise, render
    return render_to_response(template, {
        'page': page,
        'disable_content': True,
        'project': project
    },
                              context_instance=RequestContext(request))