如何在反向外键上选择相关？

发布于 2024-11-27 04:22:19 字数 616 浏览 1 评论 0原文

可能的重复：
Django 中的左外反向 select_lated？

A BlogPost 有很多评论。我想获取 BlogPost 及其所有评论的列表。

因此，我有

BlogPost.objects.filter(my_filter).select_related()

但外键位于 Comment 上，而不是 BlogPost 上，因此 select_lated() 不会预取任何评论。有办法让它发挥作用吗？

我无法反转查询 (Comment.objects...)，因为 select_lated() 确实获取的其他对象将不会'不工作。我需要它双向工作。

原文

Possible Duplicate:
A left outer reverse select_related in Django?

A BlogPost has many Comments. I want to get a list of BlogPosts and all their comments.

Thus, I have

BlogPost.objects.filter(my_filter).select_related()

But the ForeignKey is on the Comment, not the BlogPost, so the select_related() doesn't prefetch any comments. Is there a way to get this to work?

I can't reverse the query (Comment.objects...) because then the other objects that the select_related() does fetch wouldn't work. I need it to work both ways.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

枯叶蝶 2024-12-04 04:22:19

为什么不获取评论，然后使用重新分组模板标签来显示它们：

# Select all Comments with BlogPost data - one query
comments = Comment.objects.select_related('blog_post').order_by('-blog_post').all()

然后在模板中：

{% regroup comments by blog_post as posts %}
{% for blog_post in posts %}

    <p>Blog post {{ blog_post.title }}</p>
    <ul>
    {% for comment in blog_post.comments %}
    ...
    {% endfor %}
    </ul>
    </p>
{% endfor %}

Why won't you fetch the comments and then use regroup template tag to display them:

# Select all Comments with BlogPost data - one query
comments = Comment.objects.select_related('blog_post').order_by('-blog_post').all()

Then in template:

{% regroup comments by blog_post as posts %}
{% for blog_post in posts %}

    <p>Blog post {{ blog_post.title }}</p>
    <ul>
    {% for comment in blog_post.comments %}
    ...
    {% endfor %}
    </ul>
    </p>
{% endfor %}

回复收藏 0 原文

~没有更多了~