python - 如何过滤日期时间字段上的对象？

Question

我有以下模型:

class Announcement(models.Model):
    name = models.CharField(max_length=500)
    content = models.CharField(max_length=1000)
    is_active = models.BooleanField(default=False)
    date_start = models.DateTimeField()
    date_end = models.DateTimeField()

    def __str__(self):
        return self.name

我可以像这样过滤 is_active 字段上的对象:

def announcements(request):
    announcements = Announcement.objects.all().filter(
        is_active = True
    )
    return HttpResponse(
        serializers.serialize("json", announcements))

这很好用。但是当我想像这样基于 date_start 字段过滤它们时:

def announcements(request):
    announcements = Announcement.objects.all().filter(
        date_start >= datetime.now()
    )
    return HttpResponse(
        serializers.serialize("json", announcements))

我收到 global name 'date_start' is not defined 错误。

Answer 1

您需要使用 queryset过滤查找，__gte (greater than or equal) :

announcements = Announcement.objects.all().filter(date_start__gte = datetime.now())