[Fixed]-Django. Chain select_related()

by

15👍

Try this:

queryset = a.objects.filter(...).select_related("b__c")

See the docs

from django.db import models

class City(models.Model):
    # ...
    pass

class Person(models.Model):
    # ...
    hometown = models.ForeignKey(City)

class Book(models.Model):
    # ...
    author = models.ForeignKey(Person)

and the query:

b = Book.objects.select_related('author__hometown').get(id=4)
p = b.author         # Doesn't hit the database.
c = p.hometown       # Doesn't hit the database.
👤Paulo Pessoa

Leave a comment