On 7/14/06, Carlos Yoder <[EMAIL PROTECTED]> wrote:
Django doesn't currently have any specific support for aggregate clauses; However, it can be done - in a slightly hackish way.
If you add your 'HAVING' clause to a 'where' block in a call to extra(), the SQL that is generated will have the HAVING at the end of your query.
If you want to see a preview of the SQL that will be executed, you can run _get_sql_clause() on any QuerySet. If
Articles.objects.filter(...).extra(where=['.... HAVING ...'])
is your query,
Articles.objects.filter(...).extra(where=['.... HAVING ...'])._get_sql_clause()
will give you an almost-sql look at what will be passed to the databse (without actually executing it)
This is undocumented, and more than a little hackish, but it should work. Long term, I hope to get around to getting aggregates into the query system properly, but that is for another day.
Yours,
Russ Magee %-)
Hello there,
In plain SQL I'd do something with a HAVING clause, effectively
filtering the COUNT(*) on the cars.
Has anybody done sth like this before? Any clues?
Django doesn't currently have any specific support for aggregate clauses; However, it can be done - in a slightly hackish way.
If you add your 'HAVING' clause to a 'where' block in a call to extra(), the SQL that is generated will have the HAVING at the end of your query.
If you want to see a preview of the SQL that will be executed, you can run _get_sql_clause() on any QuerySet. If
Articles.objects.filter(...).extra(where=['.... HAVING ...'])
is your query,
Articles.objects.filter(...).extra(where=['.... HAVING ...'])._get_sql_clause()
will give you an almost-sql look at what will be passed to the databse (without actually executing it)
This is undocumented, and more than a little hackish, but it should work. Long term, I hope to get around to getting aggregates into the query system properly, but that is for another day.
Yours,
Russ Magee %-)
--~--~---------~--~----~------------~-------~--~----~
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 [EMAIL PROTECTED]
For more options, visit this group at http://groups.google.com/group/django-users
-~----------~----~----~----~------~----~------~--~---
