Django -注释多个字段并加载相关对象

from django.db import models

class Post(models.Model):
    title = models.CharField(max_length=200)
    content = models.TextField()
    pub_date = models.DateTimeField('date published')

class Comment(models.Model):
    post = models.ForeignKey(Post, on_delete=models.CASCADE)
    author = models.CharField(max_length=100)
    text = models.TextField()
    created_date = models.DateTimeField(auto_now_add=True)

from django.db.models import Count

posts_with_comment_count = Post.objects.annotate(comment_count=Count('comment'))

for post in posts_with_comment_count:
    print(f"{post.title} - Comments: {post.comment_count}")

# 错误示例
posts_with_comment_and_author_count = Post.objects.annotate(
    comment_count=Count('comment'),
    author_count=Count('author')  # 'author' 字段不存在
)

# 正确示例
posts_with_comment_and_author_count = Post.objects.annotate(
    comment_count=Count('comment'),
    author_count=Count('comment__author')  # 正确引用关联字段
)