Hi Daniel,
On Apr 22, 5:57 pm, Daniel Gerzo <dge...@gmail.com> wrote:
> I have a following models:
>
> class Movie(models.Model):
> title = models.CharField(max_length=255)
> year = models.IntegerField(max_length=4)
> rating = models.DecimalField(max_digits=2, decimal_places=1, default=0)
>
> class Request(models.Model):
> movie = models.ForeignKey(Movie)
> user = models.ForeignKey(User)
> language = models.CharField(max_length=7, db_index=True)
> notes = models.CharField(max_length=255, blank=True, null=True)
> added = models.DateTimeField(default=datetime.now)
>
> I want to get all Requests, with count per each pair of Movie and language.
>
> So far I got this:
> Request.objects.values('movie', 'language').annotate(Count('language'))
>
> That seems to give me almost what I want, but that way I get a
> ValueQuerySet. Is there a way to get or convert this to a QuerySet? I'd
> like to get an easy way to access Movie attributes from the above query
> as I will need to display movie title and rating in the template for
> each result from the above query.
>
> So, is there some better way of what am I trying to accomplish? If not,
> how should I proceed in retrieving the Movie attributes? Will I need to
> fetch those with something like Movie.objects.filter(pk__in=[list of
> ids]) and then manually map those?
That's one way, if you actually get full Movie objects out. However,
if you just need certain fields from the movie, you should be able to
do this:
Request.objects.values("movie__title",
"language").annotate(Count("language"))
Carl
--
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.
