Django | Annotate objects to query

Question

I am currently struggling to figure out how to deal with the following problem:

Imagine I got this two models:

class author(models.Model):
     name = models.CharField(mac_length=50)
     ...

and

class book(models.Model):
     author = models.ForeignKey('author', on_delete=models.CASCADE)
     ...

Now I want to create a view which list all authors with all their book's. This could look something like this:

Joanne K. Rowling:

Harry Potter and the Philosopher's Stone
...

J. R. R. Tolkien:

The Hobbit
...

Question:
How should the Django Query look like to access the Books in the template? `

authors = authors.objects.all()

This gives me the set for the authors, but not their belonging books. Is there a way to annotate or aggregate Dict's to the Queryset? I feel like this beeing Rookie stuff, but it would still be nice if you could help me out.

Hamidreza Mahmoodian · Accepted Answer · 2021-07-20 12:42:00Z

2

I think you are looking for something like :

authors = authors.objects.all().prefetch_related('book_set')

then access them this way:

for author in authors:
    books = author.book_set.all()

answered Jul 20, 2021 at 12:42

Hamidreza Mahmoodian

995 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Abhyudai Over a year ago

please add explanation and/or relevant documentation as well.

Collectives™ on Stack Overflow

Django | Annotate objects to query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related