How to use prefetch_related with Django's DetailView

vaibhav jain

I want to use prefetch_related with Django's DetailView.

Model:

class Customer(models.Model):
    name = models.CharField(
        verbose_name='customer name',
        max_length=100
    )
    # Other fields

class Packet(models.Model):
    customer = models.ForeignKey(
        Customer
    )
    # Other fields

class Credit(models.Model)   :
    customer = models.ForeignKey(
        Customer
    )
    # Other fields

View:

class CustomerDetailsView(LoginRequiredMixin, DetailView):
    model = Customer
    http_method_names = ['get']
    template_name = 'detail_templates/customer_details.html'

Templates:

{% for p in object.packet_set %}
    {{ do something }}
{% endif %}

{% for p in object.credit_set %}
    {{ do something }}
{% endif %}

Tried:

class CustomerDetailsView(LoginRequiredMixin, DetailView):
    model = Customer
    http_method_names = ['get']
    template_name = 'detail_templates/customer_details.html'

    def get_queryset(self):
        queryset = super(CustomerDetailsView, self).get_queryset()
        pk = self.kwargs.get(self.pk_url_kwarg, None)
        return queryset.filter(id=pk).prefetch_related('packet_set', 'credit_set')

debug_toolbar shows no improvement. How do I prefetch_related packet and credit

catavaran

There is no sense to use prefetch_related() in the DetailView. This view loads the single master object with get() while prefetch_related() is usable for loading related objects of multiple master objects.

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

How to use prefetch_related with Django's DetailView

From Dev

How to clear Django's cached query after prefetch_related

From Dev

django- Use prefetch_related inside of another prefetch_related

From Dev

Django proper use of select_related or prefetch_related on a ForeignKey

From Dev

Could not figure out the use of prefetch_related in django

From Dev

Could not figure out the use of prefetch_related in django

From Java

What's the difference between select_related and prefetch_related in Django ORM?

From Dev

Django prefetch_related and select_related

From Dev

How do we filter results from two tables using prefetch_related function in Django

From Dev

Joining ManyToMany fields with prefetch_related in Django

From Dev

django prefetch_related id only

From Dev

Filter prefetch_related empty in django

From Dev

Is django prefetch_related supposed to work with GenericRelation

From Dev

django prefetch_related id only

From Dev

Django, general version of prefetch_related()?

From Dev

How to use value from URL and request in Django DetailView?

From Dev

How to use value from URL and request in Django DetailView?

From Dev

prefetch_related with Django 1.5 + django-model-utils

From Dev

Get method in Django's detailview

From Java

django rest framework - backward serialization to avoid prefetch_related

From Dev

Django prefetch_related - filter with or-clause from different tables

From Dev

Django prefetch_related GenericForeignKey with multiple content types

From Dev

Django prefetch_related From Model With Multiple ManyToMany Relationships

From Dev

Django prefetch_related with m2m through relationship

From Dev

Django prefetch_related from foreignkey with manytomanyfield not working

From Dev

Django avoid extra queries using prefetch_related not working

From Dev

Django 1.9.1 prefetch_related with only hit multiple times to the database

From Dev

django rest framework - backward serialization to avoid prefetch_related

From Dev

Django prefetch_related from foreignkey with manytomanyfield not working

Related Related

  1. 1

    How to use prefetch_related with Django's DetailView

  2. 2

    How to clear Django's cached query after prefetch_related

  3. 3

    django- Use prefetch_related inside of another prefetch_related

  4. 4

    Django proper use of select_related or prefetch_related on a ForeignKey

  5. 5

    Could not figure out the use of prefetch_related in django

  6. 6

    Could not figure out the use of prefetch_related in django

  7. 7

    What's the difference between select_related and prefetch_related in Django ORM?

  8. 8

    Django prefetch_related and select_related

  9. 9

    How do we filter results from two tables using prefetch_related function in Django

  10. 10

    Joining ManyToMany fields with prefetch_related in Django

  11. 11

    django prefetch_related id only

  12. 12

    Filter prefetch_related empty in django

  13. 13

    Is django prefetch_related supposed to work with GenericRelation

  14. 14

    django prefetch_related id only

  15. 15

    Django, general version of prefetch_related()?

  16. 16

    How to use value from URL and request in Django DetailView?

  17. 17

    How to use value from URL and request in Django DetailView?

  18. 18

    prefetch_related with Django 1.5 + django-model-utils

  19. 19

    Get method in Django's detailview

  20. 20

    django rest framework - backward serialization to avoid prefetch_related

  21. 21

    Django prefetch_related - filter with or-clause from different tables

  22. 22

    Django prefetch_related GenericForeignKey with multiple content types

  23. 23

    Django prefetch_related From Model With Multiple ManyToMany Relationships

  24. 24

    Django prefetch_related with m2m through relationship

  25. 25

    Django prefetch_related from foreignkey with manytomanyfield not working

  26. 26

    Django avoid extra queries using prefetch_related not working

  27. 27

    Django 1.9.1 prefetch_related with only hit multiple times to the database

  28. 28

    django rest framework - backward serialization to avoid prefetch_related

  29. 29

    Django prefetch_related from foreignkey with manytomanyfield not working

HotTag

Archive