this is untested: m = Membership.objects.select_related().get(person__name='ringo') ringo = m.person
i agree, this is not as convenient as could be. may be it will be in the next version? konstantin On Sep 23, 5:16 pm, Nate Thelen <[EMAIL PROTECTED]> wrote: > Yeah, that would work, too. I was thinking more like if you got the > ringo like this: > > ringo = Person.objects.select_related(depth=2).get(name='ringo') > > how could you get the data without having to make another DB call. > > Ideas? > > Thanks, > Nate > > On Sep 23, 2:04 pm, akonsu <[EMAIL PROTECTED]> wrote: > > > hello, > > > how about > > > for m in Membership.objects.filter(person=ringo) : print m.date_joined > > > konstantin > > > On Sep 23, 4:58 pm, Nate Thelen <[EMAIL PROTECTED]> wrote: > > > > So if I have a Person object "ringo" and I want to get info about the > > > Groups he is a member of, I would do this: > > > > for group in ringo.group_set.all() > > > print( group.name ) > > > > My question is, how do I print the "date_joined" without having to do > > > this: > > > > for group in ringo.group_set.all() > > > print( Membership.objects.get(person=ringo, > > > group=group).date_joined ) > > > > That seems very DB inefficient. > > > > Nate > > > > On Sep 19, 9:43 pm, "Russell Keith-Magee" <[EMAIL PROTECTED]> > > > wrote: > > > > > On Sat, Sep 20, 2008 at 8:37 AM, Nate Thelen <[EMAIL PROTECTED]> wrote: > > > > > > Looking at the docs here: > > > > > >http://docs.djangoproject.com/en/dev/topics/db/models/#extra-fields-o... > > > > > > I cannot find any reference to how to access the data in the > > > > > "Membership" table. For example, if I have a reference to the > > > > > "beatles" object, how do I find the "date_joined" for each of the > > > > > "Person" objects. I have looked through the other sections of the > > > > > documentation, searched this group, and searched via Google, but > > > > > couldn't find the info. > > > > > Short version: You access the membership table using the foreign key > > > > relationship that the membership defines. > > > > > Long version: Your question ("the date_joined for each person object") > > > > is actually ill posed - a person doesn't have a date_joined without a > > > > group to also give context. "The date person X joined group Y" can be > > > > answered as: > > > > > >>> Membership.objects.get(person=X, group=y).date_joined > > > > > It might help to think about it like this - m2m-intermediate tables > > > > don't add extra data to an m2m relation, they make a 2-step foreign > > > > key relation behave like an m2m relation. > > > > > 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 [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
