Re: [SQLObject] third column in a MultipleJoin table

2006-12-14 Thread Oleg Broytmann
On Thu, Dec 14, 2006 at 02:34:52PM +0100, sophana wrote: > Too bad these methods don't have docstrings! Please write a few lines. Oleg. -- Oleg Broytmannhttp://phd.pp.ru/[EMAIL PROTECTED] Programmers don't die, they just GOSUB without RETURN. -

Re: [SQLObject] third column in a MultipleJoin table

2006-12-14 Thread sophana
Luke Opperman a écrit : > Indeed, documentation on SelectResults is pretty sparse - > http://www.sqlobject.org/class-sqlobject.sresults.SelectResults.html is about > it. I'm a heavy abuser of it, I'll see if I can write up some docs in the next > few days. > > > Too bad these methods don't have

Re: [SQLObject] third column in a MultipleJoin table

2006-12-13 Thread Dan Lenski
> Indeed, documentation on SelectResults is pretty sparse - > http://www.sqlobject.org/class-sqlobject.sresults.SelectResults.html is about > it. I'm a heavy abuser of it, I'll see if I can write up some docs in the next > few days. Thanks for the link. Well, I for one would appreciate any expand

Re: [SQLObject] third column in a MultipleJoin table

2006-12-13 Thread Luke Opperman
> One thing I'm wondering: is there some source of documentation that I'm > missing? The filter() method doesn't seem to be described anywhere in the > official docs at http://www.sqlobject.org/SQLObject.html > > Dan Indeed, documentation on SelectResults is pretty sparse - http://www.sqlobject.o

Re: [SQLObject] third column in a MultipleJoin table

2006-12-13 Thread Dan Lenski
On Wed, 13 Dec 2006 16:32:24 -0600, Luke Opperman hath writ: > Depending on what you're actually trying to do, there's a few options. One, if > you just want filtered results (like user.activeRoles), that's a simple filter > on user.roles. If you really want to loop over all roles and get informat

Re: [SQLObject] third column in a MultipleJoin table

2006-12-13 Thread Luke Opperman
Depending on what you're actually trying to do, there's a few options. One, if you just want filtered results (like user.activeRoles), that's a simple filter on user.roles. If you really want to loop over all roles and get information from the intermediate table, you probably want both a SQLRelated

Re: [SQLObject] third column in a MultipleJoin table

2006-12-13 Thread Dan Lenski
On Wed, 13 Dec 2006 23:00:36 +0300, Oleg Broytmann hath writ: > http://sqlobject.org/devel/FAQ.html#how-can-i-define-my-own-intermediate-table-in-my-many-to-many-relationship Thank you Oleg! I read through that example, and tried it out... but what I don't see is that this makes it more convenie

Re: [SQLObject] third column in a MultipleJoin table

2006-12-13 Thread Oleg Broytmann
On Wed, Dec 13, 2006 at 03:56:15PM -0500, Dan Lenski wrote: > How would I now find out the active roles, given a User instance? You can do it in Python: user = User.get(id) active_roles = [role for role in user.roles if role.active] The solution should be good enough because I don't expect t

Re: [SQLObject] third column in a MultipleJoin table

2006-12-13 Thread Dan Lenski
On Thu, 14 Dec 2006 00:35:55 +0300, Oleg Broytmann hath writ: > On Wed, Dec 13, 2006 at 03:56:15PM -0500, Dan Lenski wrote: >> How would I now find out the active roles, given a User instance? > >You can do it in Python: > user = User.get(id) > active_roles = [role for role in user.roles if ro

Re: [SQLObject] third column in a MultipleJoin table

2006-12-13 Thread Oleg Broytmann
On Wed, Dec 13, 2006 at 02:41:10PM -0500, Dan Lenski wrote: > This is basically a "many-to-many" relationship between User and Club, but > with an added wrinkle... when running Club.Users() I would like to get the > Role of each user as well. http://sqlobject.org/devel/FAQ.html#how-can-i-define-my

[SQLObject] third column in a MultipleJoin table

2006-12-13 Thread Dan Lenski
Hi all, I'm trying to convert a web application to use sqlobject, and not sure of the best way to express the following table relationship: * User table: the users of the system * Club table: clubs that users can belong to * Role table: the possible positions for users in clubs (President, Treasur