from django.db.models.sql.aggregates ImportError: No module named aggregates

Question

I've been facing a particular problem with aggregates. In this code, sumcase class has a method add_to_query which is intended to instantiate the SQL implementation of the aggregate and sets it as a class variable (aggregate) which i'd be using to call the as_sql method in Default SQL Aggregate (django/db.models.sql.aggregates.Aggregate) from another file.

My code (The first file, how I implement aggregate):

from django.db.models.aggregates import Aggregate
from django.db.models.sql.aggregates import Aggregate as SQLAggregate

class SQLsumcase(SQLAggregate):

is_ordinal = True

sql_function = 'SUM'

sql_template = "%(function)s(CASE WHEN %(when)s THEN %(field)s ELSE 0 END)"

def __init__(self, col, **extra):
    if isinstance(extra['when'], basestring):
        extra['when'] = "%s" % extra['when']

    if extra['when'] is None:
        extra['when'] = True

    super(SQLSumCase, self).__init__(col, **extra)


class SumCase(Aggregate):

What Django version are you using

iklinac
– iklinac

2018-04-20 13:39:45 +00:00
Commented Apr 20, 2018 at 13:39 — iklinac
– iklinac, Commented Apr 20, 2018 at 13:39
Django 1.11.12 python 2.7.6

saranya
– saranya

2018-04-20 13:49:50 +00:00
Commented Apr 20, 2018 at 13:49 — saranya
– saranya, Commented Apr 20, 2018 at 13:49

kholioeg · Accepted Answer · 2019-04-29 12:09:11Z

1

The aggregates module has been moved to django.db.models as I see in version 1.11.17

Don't know if this is the case you encounter but it may help.

answered Apr 29, 2019 at 12:09

kholioeg

3363 silver badges5 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Juanmi Gabarron · Accepted Answer · 2018-04-20 14:12:20Z

0

There is not a module named aggregates in django.db.models.sql also Aggregate is not a class on this sql module. I think you should use:

from django.db.models.sql import AggregateQuery

answered Apr 20, 2018 at 14:12

Juanmi Gabarron

4415 silver badges11 bronze badges

Comments

Community · Accepted Answer · 2019-01-27 00:29:00Z

0

django.db.models.sql.aggregates module is removed from 1.10 version.

edited Jan 27, 2019 at 0:29

CommunityBot

11 silver badge

answered Jan 25, 2019 at 15:35

Sefoo13

112 bronze badges

1 Comment

kvantour Over a year ago

While this may theoretically answer the question, it could be suggested as a comment only. Maybe you can expand the answer a bit by clicking edit and tell from which version onwards this module is removed.

Collectives™ on Stack Overflow

from django.db.models.sql.aggregates ImportError: No module named aggregates

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related