django-easyfilters / django_easyfilters /

Luke Plant f0f72eb 

Luke Plant ebbcee6 

Luke Plant f0f72eb 

Luke Plant ebbcee6 
Luke Plant f0f72eb 

from django.db.models.sql.datastructures import Date
from django.db.models.sql.subqueries import AggregateQuery
from django.db.models.sql.compiler import SQLCompiler
from django.db.models.sql.constants import MULTI

# Some fairly brittle, low level stuff, to get the aggregation
# queries we need.

class DateAggregateQuery(AggregateQuery):
    # Need to override to return a compiler not in django.db.models.sql.compiler
    def get_compiler(self, using=None, connection=None):
        return DateAggregateCompiler(self, connection, using)

    def get_counts(self, using):
        from django.db import connections
        connection = connections[using]
        return list(self.get_compiler(using, connection).results_iter())

class DateAggregateCompiler(SQLCompiler):
    def results_iter(self):
        resolve_columns = hasattr(self, 'resolve_columns')
        if resolve_columns:
            from django.db.models.fields import DateTimeField, IntegerField
            fields = [DateTimeField(), IntegerField]
            from django.db.backends.util import typecast_timestamp
            needs_string_cast = self.connection.features.needs_datetime_string_cast

        offset = len(self.query.extra_select)
        for rows in self.execute_sql(MULTI):
            for row in rows:
                if resolve_columns:
                    vals = self.resolve_columns(row, fields)
                elif needs_string_cast:
                    vals = [typecast_timestamp(str(row[0])),
                    vals = row
                yield vals

    def as_sql(self, qn=None):
        sql = ('SELECT %s, COUNT(%s) FROM (%s) subquery GROUP BY (%s) ORDER BY (%s)' % (
                DateWithAlias.alias, DateWithAlias.alias, self.query.subquery,
                DateWithAlias.alias, DateWithAlias.alias)
        params = self.query.sub_params
        return (sql, params)

class DateWithAlias(Date):
    alias = 'easyfilter_date_alias'
    def as_sql(self, qn, connection):
        return super(DateWithAlias, self).as_sql(qn, connection) + ' as ' + self.alias

def date_aggregation(date_qs):
    Performs an aggregation for a supplied DateQuerySet
    # The DateQuerySet gives us a query that we need to clone and hack
    date_q = date_qs.query.clone()
    date_q.distinct = False

    # Replace 'select' to add an alias
    date_obj =[0] = [DateWithAlias(date_obj.col, date_obj.lookup_type)]

    # Now use as a subquery to do aggregation
    query = DateAggregateQuery(date_qs.model)
    query.add_subquery(date_q, date_qs.db)
    return query.get_counts(date_qs.db)