from lippukala.models import Order from dateutil.tz import tzlocal from datetime import datetime tz = tzlocal() loerdag_start = datetime(2015, 9, 5, 0, 0, 0, tzinfo=tz) soendag_start = datetime(2015, 9, 6, 0, 0, 0, tzinfo=tz) Order.objects.filter(code__used_on__gte=loerdag_start, code__used_on__lt=soendag_start).distinct().count() # 2600 |
SELECT date_trunc('minutes', used_on) as ts, count(order_id) FROM lippukala_code WHERE used_on between '2015-09-05 00:07:00'::timestamp AND '2015-09-05 14:00:00'::timestamp GROUP BY ts ORDER BY ts; |
SELECT date_trunc('minutes', used_on) as ts, count(*) FROM lippukala_order o, lippukala_code c WHERE o.id=c.id AND c.used_on between '2015-09-05 00:07:00'::timestamp AND '2015-09-05 14:00:00'::timestamp GROUP BY ts ORDER BY ts; |
from programme.models import Programme for programme in Programme.objects.filter(category__event__slug='traconx', programmerole__person__email='').distinct(): print programme.title |