On Fri, Jun 5, 2009 at 11:24 PM, Darren<blogposts.dar...@gmail.com> wrote:
>
> Hey,
>
> Would anyone be able to to help me convert this SQL to Django code?
>
> SELECT A.a, COUNT(B.b)
> FROM A, B
> WHERE A.id = B.a_id
> GROUP BY A.id
> ORDER BY A.id;
It's impossible to give you a canonical answer without a complete
Django model, but the query you have written would be rendered using
something like:
A.objects.values('a').annotate(Count(b__b)).order_by('id')
As a point of clarification - if you actually only want a count of B
objects, not a count of unique values of B.b, then you could use:
A.objects.values('a').annotate(Count(b)).order_by('id')
The values() clause is also potentially optional. The purpose of that
clause is to reduce the output set so that it contains only the field
'a' and the count. If you are happy with returning full A instances,
annotated with the count, you would use:
A.objects.annotate(Count(b)).order_by('id')
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
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
