Re: multiple levels of join

2006-01-12 Thread Cheng Zhang
On Jan 12, 2006, at 5:38 AM, Adrian Holovaty wrote: On 1/11/06, Cheng Zhang <[EMAIL PROTECTED]> wrote: class Entry(meta.Model): submission_user = meta.ForeignKey(users.User) class Friend(meta.Model): myself = meta.ForeignKey(users.User, related_name="myself", verbose_name="m

Re: multiple levels of join

2006-01-12 Thread Russell Keith-Magee
On 1/12/06, Adrian Holovaty <[EMAIL PROTECTED] > wrote: > > You can do it in two queries: > > my_friends = friends.get_list(myself__exact=my_id) > entries.get_list(submission_user__in=[f.id for f in my_friends]) If you are using the magic-removal branch, there is an alternative approach that onl

Re: multiple levels of join

2006-01-11 Thread Adrian Holovaty
On 1/11/06, Cheng Zhang <[EMAIL PROTECTED]> wrote: > class Entry(meta.Model): > submission_user = meta.ForeignKey(users.User) > > class Friend(meta.Model): > myself = meta.ForeignKey(users.User, related_name="myself", > verbose_name="myself") > friend = meta.ForeignKey(user

multiple levels of join

2006-01-11 Thread Cheng Zhang
I'd like to ask a question on multiple levels of join. My models are: class Entry(meta.Model): submission_user = meta.ForeignKey(users.User) class Friend(meta.Model): myself = meta.ForeignKey(users.User, related_name="myself", verbose_name="myself")