advanced patterns with Django's QuerySet in a Loop When Using Prefetch Related
I'm stuck on something that should probably be simple. I am experiencing unexpected behavior when using Django's `prefetch_related` in a loop. I'm on Django 4.0 and using PostgreSQL as my database. I have a model `Author` that has a foreign key relationship to a model `Book`. I want to fetch all authors and their related books to minimize database hits, but when I iterate through the authors, I only get the first author's books repeated for all authors. Here’s the code I used: ```python from myapp.models import Author, Book # Prefetching related books for authors authors = Author.objects.prefetch_related('book_set').all() for author in authors: books = author.book_set.all() print(f'Author: {author.name}') for book in books: print(f' - Book: {book.title}') ``` The output I get is: ``` Author: Author 1 - Book: Book A - Book: Book A Author: Author 2 - Book: Book A - Book: Book A ``` I expected to see different books for each author. I’ve tried removing the `prefetch_related` to see if it made any difference, but that just resulted in additional queries, which isn’t what I want. I also checked if the database entries are correct, and they are. Can someone guide to figure out what’s going wrong? I'm also wondering if this could be related to how I'm using the relationship names in the `prefetch_related` call. This is for a desktop app running on Windows 10. Hoping someone can shed some light on this.