Hi folks,
I have a seemingly straightforward problem but can't figure out a way
to do it natively in the ORM. I have two models:
class Puzzle(models.Model):
name = models.CharField(max_length=50)
class Result(models.Model):
user = models.ForeignKey(User)
puzzle = models.ForeignKey(Puzzle)
seconds_taken = models.PositiveIntegerField()
I have a nice query set up to aggregate the results for a given user,
tot up the average time taken for each type of puzzle, etc:
user_results = Result.objects.filter(user=user).values
('puzzle__name').annotate(Min('seconds_taken'), Avg('seconds_taken'),
Count('id'))
However, I can only get those puzzles included for which the user has
results. Behind the scenes I assume this is a simple matter of an
inner join instead of a left outer join on "Puzzle". But what I want
is a table that includes *every* puzzle, and *if applicable*, their
stats for each.
Am I best off writing (admittedly quite simple) raw SQL for this, or
is there a method in the ORM that I'm missing?
Thanks all,
Scott
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
