使用父子M2M关系反转django对象查询

from django.db import models

class Author(models.Model):
    name = models.CharField(max_length=100)

class Book(models.Model):
    title = models.CharField(max_length=100)
    authors = models.ManyToManyField(Author, related_name='books')

# 反转查询：通过Book查询Author
books = Book.objects.filter(title='Django for Beginners')
authors = books.first().authors.all()

# 反转查询：通过Author查询Book
author = Author.objects.get(name='John Doe')
books = author.books.all()

# 确保中间表数据正确
Book.objects.filter(title='Django for Beginners').first().authors.all()

# 使用正确的查询条件
author = Author.objects.get(name='John Doe')
books = author.books.filter(title__icontains='Django')

authors = Author.objects.prefetch_related('books')
for author in authors:
    print(author.name)
    for book in author.books.all():
        print(book.title)