时间戳

首页 > 解决方案 > 如何过滤没有评论的帖子

django - 如何过滤没有评论的帖子

问题描述

让我们来解决问题。我的观点应该向我展示所有未回答的问题，这些问题是在 4 小时后提出的。我已经尝试了很多，但没有成功，所以我问这个。我应该怎么做才能过滤没有评论的帖子

视图.py

def subject_unanswered(request, slug):
    subject = Subject.objects.filter(slug=slug).first()
    four_hours = datetime.today() - timedelta(hours=4)
    posts = Post.objects.filter(subject=subject, created_at__lt=four_hours).order_by('-created_at')
    args = {
        'subject'       : subject,
        'posts'         : posts,
        }
    return render(request, 'ask/subject_time_ago.html', args)

模型.py

class Comment(models.Model):
    related_post    = models.ForeignKey(Post, on_delete=models.CASCADE)
    comment         = models.TextField(max_length=1000)
    created_by      = models.ForeignKey(MyUser, on_delete=models.CASCADE, related_name='comments')
    created_at      = models.DateTimeField(auto_now_add=True)
    likes           = models.ManyToManyField(MyUser, related_name='comment_likes', blank=True)

class Post(models.Model):
    slug        = models.SlugField(unique=True, max_length=200)
    subject     = models.ForeignKey(Subject, on_delete=models.CASCADE)
    topic       = models.CharField(max_length=200)
    text        = models.TextField(max_length=5000)
    created_by  = models.ForeignKey(MyUser, on_delete=models.CASCADE, related_name='posts')
    created_at  = models.DateTimeField(auto_now_add=True)
    likes       = models.ManyToManyField(MyUser, related_name='likes', blank=True)

标签： djangodjango-modelsdjango-views

解决方案

您可以按反向关系过滤，例如

Post.objects.filter(comment__isnull=True)

这应该返回所有没有评论的帖子。

推荐阅读