Count values grouped by date

[Martin Tiršel]

Hi,

I have:
class BannerStats(models.Model):
    ACTION_TYPE_VIEW = 0
    ACTION_TYPE_CLICK = 1

    ACTION_TYPES = (
        (ACTION_TYPE_VIEW, 'view'),
        (ACTION_TYPE_CLICK, 'click'),
    )

    banner = models.ForeignKey(
        Banner
    )
    date = models.DateTimeField(
        auto_now_add=True
    )
    action = models.PositiveSmallIntegerField(
        choices=ACTION_TYPES,
        default=ACTION_TYPE_VIEW
    )

I need to get list of dates with sum of views and sum of clicks grouped by  
date. I use:

BannerStats.objects.filter(
    banner=banner
).extra(
    {'date': 'date(date)'}
).values(
    'date',
).annotate(
    views=models.Count('id')
)

But this works only for vies, is there a way how can I get views and click  
in one query? Or have I to do two queries and join it in Python? Or should  
I remove action column and split it to views and clicks columns?

Thanks,
Martin

--
You received this message because you are subscribed to the Google Groups "Django 
users" group.
To post to this group, send email to django-users@googlegroups.com.
To unsubscribe from this group, send email to 
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en.