如何使用Django ORM或SQL在一个查询中更新相关模型的字段？

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)
    price = models.DecimalField(max_digits=5, decimal_places=2)

# 更新某个作者的所有书籍的价格
author = Author.objects.get(name='J.K. Rowling')
Book.objects.filter(author=author).update(price=models.F('price') * 1.1)

from django.db.models import F

# 增加某个作者的所有书籍的价格
Book.objects.filter(author=author).update(price=F('price') + 10)

from django.db.models import Sum

# 计算某个作者的所有书籍的总价格并更新作者的总收入
author = Author.objects.annotate(total_income=Sum('book__price'))
author.total_income = author.total_income * 1.05  # 增加5%的收入
author.save()

from django.db import transaction

with transaction.atomic():
    Book.objects.filter(author=author).update(price=F('price') + 10)