Django view returning count of users based on last_login

Question

I have a Django application where I have a view that returns the count of the users who did login today. Corresponding statement is as follows:

login_count= User.objects.filter(last_login__startswith=timezone.now().date()).count()

I want to get the count of users who did login once in the last week and last the month. Like, here timezone.now() returns today's date, is there anything like range which will cover a week or a month?

docs.python.org/2/library/datetime.html#timedelta-objects

Shang Wang
– Shang Wang

2016-06-21 14:34:44 +00:00
Commented Jun 21, 2016 at 14:34 — Shang Wang
– Shang Wang, Commented Jun 21, 2016 at 14:34

C14L · Accepted Answer · 2016-06-21 15:32:30Z

4

Yes, there is, and its even named range.

Example

import datetime
start_date = datetime.date(2005, 1, 1)
end_date = datetime.date(2005, 3, 31)
User.objects.filter(last_login__range=(start_date, end_date))

Of for the last week

today = datetime.date.today()
last_week = today - datetime.timedelta(days=7)
User.objects.filter(last_login__range=(last_week, today))

However,

Filtering a DateTimeField with dates won’t include items on the last day, because the bounds are interpreted as “0am on the given date”. If pub_date was a DateTimeField, the above expression would be turned into this SQL:

A quick solution would be to simply add a day, so the date range includes up to the last minute of today, but not more (also update last_week).

today = datetime.date.today() + datetime.timedelta(days=1)
last_week = datetime.date.today() - datetime.timedelta(days=7)
User.objects.filter(last_login__range=(last_week, today))

edited Jun 21, 2016 at 15:32

answered Jun 21, 2016 at 14:53

C14L

12.6k4 gold badges43 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

5 Comments

Thinker Over a year ago

Okay great! But now start_date and end_date are hard coded. It is something which will be called everyday, so start_date could be datetime.date(timezone.now().date()). How can I extend it for end_date?

Thinker Over a year ago

Is timezone.now().date() - timedelta(days=7) the correct direction?

C14L Over a year ago

Yes, correct. Had also just added it to the answer.

Thinker Over a year ago

However, there is one problem, login_count returns me 2 as 2 users logged in today and the query in answer returns me 0, ideally this also should return 2 as today is still part of the week. can datetime.date.today() be converted to timezone.now().date()?

C14L Over a year ago

Added to my answer

Collectives™ on Stack Overflow

Django view returning count of users based on last_login

1 Answer 1

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related