Hi everyone!
How can I do nested SELECTs in django queries, like in the following SQL?
SELECT anon_1.timestamp AS anon_1_timestamp, max(anon_1.users) AS users, max
(anon_1.servers) AS servers
FROM (
SELECT datediff_hours(:datediff_hours_1, statistics.time) AS timestamp,
sum(statistics.users) AS users,
sum(statistics.servers) AS servers
FROM statistics
WHERE statistics.gameid = :gameid_1 AND
datediff_hours(:datediff_hours_1, statistics.time) >=
datediff_hours(:datediff_hours_2, :datediff_hours_3) AND
datediff_hours(:datediff_hours_1, statistics.time) <=
datediff_hours(:datediff_hours_4, :datediff_hours_5)
GROUP BY statistics.time
) AS anon_1
GROUP BY anon_1.timestamp
My model looks like this:
class Statistics(models.Model):
game_id = models.IntegerField(db_column='gameid', primary_key=True)
time = models.DateTimeField()
servers = models.IntegerField()
users = models.IntegerField()
`datediff_hours` in SQL is a database function and can be called the
following way:
from django.db.models import Func, Value, F
class DateDiffHoursFunc(Func):
function = 'datediff_hours'
query = Statistics.objects.annotate(timestamp=DateDiffHoursFunc(Value(
datetime(2016, 5, 26)), F('time')))
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to django-users+unsubscr...@googlegroups.com.
To post to this group, send email to django-users@googlegroups.com.
Visit this group at https://groups.google.com/group/django-users.
To view this discussion on the web visit
https://groups.google.com/d/msgid/django-users/ae3e2007-e0cc-477e-bbb2-7864f4a9eb91%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
