在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)
    author = models.ForeignKey(Author, on_delete=models.CASCADE)

books = Book.objects.filter(author__exact='John')

books = Book.objects.filter(author__iexact='john')

books = Book.objects.filter(author__contains='John')

books = Book.objects.filter(author__startswith='J')

books = Book.objects.filter(author__endswith='n')

authors = ['John', 'Jane']
books = Book.objects.filter(author__in=authors)

books = Book.objects.filter(author__name='John')