On 1/24/07, Bram - Smartelectronix <[EMAIL PROTECTED]> wrote:
>
> Honza Kr�l wrote:
> > it occured before on the mailing list...
> >
> > if you add select_related(), it will work...
> >
> > the problem is that specifying ordering like this doesn't force the
> > join in the query so you might end up with a query that sorts on
> > something that just isn't there...
>
> That didn't work either:
>
> Book.objects.all().select_related()
> .order_by('-bookshop_bookstat.avg_rating')[0:10]
>
> still gives me:
>
> ERROR: missing FROM-clause entry for table "bookshop_bookstat"
>
>
> Perhaps I'm doing something else wrong. These are my models:
>
> -----------------------------------------------------------------
> class Book(models.Model):
> ....
>
> class BookStat(models.Model):
> book = models.OneToOneField(Song, related_name='stats')
> avg_rating = models.FloatField(max_digits=2, decimal_places=1)
> ...
> -----------------------------------------------------------------
those two models aren't related, so even if you do select_related()
book_stat still wouldn't get joined in...
How do you want to sort Books by BookStats when there is no relation
between them? Or is there something I am missing?
>
> We're doing this because the statistics are calculated in cron jobs.
>
> Btw, what if a certain book doesn't have statistics (yet)? Should I be
> dropping back into SQL? :-)
>
>
> - bram
>
> >
>
--
Honza Kr�l
E-Mail: [EMAIL PROTECTED]
ICQ#: 107471613
Phone: +420 606 678585
--~--~---------~--~----~------------~-------~--~----~
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?hl=en
-~----------~----~----~----~------~----~------~--~---
