How to get current events in queryset?

Question

class Event(models.Model):
    name = models.CharField(max_length=255)
    start = models.DateTimeField()
    stop = models.DateTimeField()

now = timezone.now() # 08:30 am
qs = Event.objects.filter(start__gte=now) #but this exclude `event1`

Events objects:

name   start             stop
event1 20.11.2015 08:15  20.11.2015 09:30
event2 20.11.2015 09:30  20.11.2015 10:25

What is the best way to get events including the currently ongoing?

similar question http://stackoverflow.com/questions/11245483/django-filter-events-occurring-today — Anush Devendra, Nov 20 '15 at 08:42
@Anush yes, but not include hours - this is important in my case. — user4812479812, Nov 20 '15 at 08:54

Michael Aquilina · Answer 1 · 2015-11-30T11:17:32.047

Based on your comment to Anush, you probably want to try the following:

now = timezone.now().date()
qs = Event.objects.filter(
   start__year__lte=now.year,
   start__month__lte=now.month,
   start__day__lte=now.day,
)

Unfortunately the current stable django version (1.8) does not provide the ability to truncate datetime fields to dates, which is why you need to specify year, month and day seperately.

The latest dev version as of this post's writing (1.9) provides the __date lookup which should solve this.

score 0 · Accepted Answer · answered Nov 20 '15 at 09:08

0

try:

now = timezone.now()
qs = Event.objects.filter(start__lte=now, end__gte=now)

answered Nov 20 '15 at 09:08

Anush Devendra

5,285
1
32
24

How to get current events in queryset?

2 Answers2