Hi,
I haven't been using SO for some time but i'm pretty sure you can use
the following:
Shot.selectBy(lead_td=user)
or alternatively
Shot.select(Shot.q.lead_tdID==user.id)
hope this works.
On Sep 9, 4:41 pm, "Rangi Sutton" <[EMAIL PROTECTED]> wrote:
> Hi folks,
>
> I'm trying to add some query logic to my fledgling app (with SO), but
> having a bit of trouble with select and foreign keys. The story with
> reduced complexity model:
>
> class Shot(SQLObject):
> shot_name = UnicodeCol(length=16)
> lead_td = ForeignKey('User')
> lead_comp = ForeignKey('User')
> start_frame = IntCol(default=1)
>
> class Project(SQLObject):
> project_name = UnicodeCol(length=16, alternateID=True,
> alternateMethodName="by_project_name")
> display_name = UnicodeCol(length=55)
> shots = MultipleJoin('Shot')
>
> def usersShots(self, user):
> shot_list = Shot.select(Shot.q.lead_td == user)
> return shot_list
>
> When I make the call to usersShots() I get:
>
> "AttributeError: Shot instance has no attribute 'lead_ld'"
>
> To test things I try to modify that function to not use a foreign key:
>
> def usersShots(self, user):
> shot_list = Shot.select(Shot.q.start_frame == 101)
> return shot_list
>
> And it works fine.
>
> Is my problem to do with it being a foreign key, or perhaps it's to do
> with the _ in the "lead_td" as seems suggested by my researching the
> problem. If it is the _ problem, is there a fix that doesn't involve
> me changing all my code?This wont be the only attribute named like
> that! I tried dbname="leadtd" in the declaration but didn't find any
> joy.
>
> Thanks in advance for any help.
>
> Cheers,
> Rangi.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---
