lame groupbys in django

django_groupby.py

from itertools import groupby
from operator import attrgetter

from django.db import models

class Item(models.Model):
  name = models.CharField(max_length=255)
  
class ItemCountAggregate(models.Model):
  item = models.ForeignKey(Item, related_name="count_aggregates")
  date = models.DateField()
  count = models.PositiveIntegerField()
  
counts = ItemCountAggregate.objects.order_by("-date", "-count")
groups = groupby(counts, attrgetter("date"))
for date, counts in groups:
  print date, list(counts)

# 2015-09-02 [<ItemCountAggregate object>, <ItemCountAggregate object>]
# 2015-09-01 [<ItemCountAggregate object>, <ItemCountAggregate object>]