Re: [SQLObject] basic RelatedJoin + select question

2008-03-10 Thread Oleg Broytmann
On Mon, Mar 10, 2008 at 05:00:19PM +, Luke Opperman wrote: > (Oleg, the SQLBuilder.SQLObjectTable.__getattr__ stuff we pulled out for its > bad > interaction with FKs was also targetted at this sort of request, specifically > for not needing to declare the intermediate tables. If someone wants

Re: [SQLObject] basic RelatedJoin + select question

2008-03-10 Thread Luke Opperman
Oleg Broytmann phd.pp.ru> writes: > > On Mon, Mar 10, 2008 at 08:57:35AM -0700, Daniel Fetchinson wrote: > > On Mon, Mar 10, 2008 at 3:12 AM, Oleg Broytmann phd.pp.ru> wrote: > > > On Sun, Mar 09, 2008 at 08:52:28PM -0700, Daniel Fetchinson wrote: > > > > class zoo( SQLObject ): > > > > cag

Re: [SQLObject] basic RelatedJoin + select question

2008-03-10 Thread Oleg Broytmann
On Mon, Mar 10, 2008 at 08:57:35AM -0700, Daniel Fetchinson wrote: > On Mon, Mar 10, 2008 at 3:12 AM, Oleg Broytmann <[EMAIL PROTECTED]> wrote: > > On Sun, Mar 09, 2008 at 08:52:28PM -0700, Daniel Fetchinson wrote: > > > class zoo( SQLObject ): > > > cages = MultipleJoin( 'cage' ) > > > > > > c

Re: [SQLObject] basic RelatedJoin + select question

2008-03-10 Thread Daniel Fetchinson
On Mon, Mar 10, 2008 at 3:12 AM, Oleg Broytmann <[EMAIL PROTECTED]> wrote: > On Sun, Mar 09, 2008 at 08:52:28PM -0700, Daniel Fetchinson wrote: > > class zoo( SQLObject ): > > cages = MultipleJoin( 'cage' ) > > > > class cage( SQLObject ): > > zoo = ForeignKey( 'zoo' ) > > animals = Mu

Re: [SQLObject] Docs (was: Multiple join on a self class)

2008-03-10 Thread Oleg Broytmann
On Mon, Mar 10, 2008 at 03:11:42PM +0100, cedric briner wrote: > Is there some > places where we can find some more complex example that the one shown in > the main documentation. I mean a little bit more complicated and with > good comments. Alas, no! There were two failed attempts to maint

Re: [SQLObject] Multiple join on a self class

2008-03-10 Thread cedric briner
Oleg Broytmann wrote: > On Mon, Mar 10, 2008 at 02:16:46PM +0100, cedric briner wrote: >> sqlobject=9.4 >> >> class Person(SQLObject): >> sn = UnicodeCol() >> guarantor = ForeignKey('Person') >> # >> # guaranteds ; the opposed of guarantor like guest/host >> guaranteds = Multipl

Re: [SQLObject] Multiple join on a self class

2008-03-10 Thread Oleg Broytmann
On Mon, Mar 10, 2008 at 02:16:46PM +0100, cedric briner wrote: > sqlobject=9.4 > > class Person(SQLObject): > sn = UnicodeCol() > guarantor = ForeignKey('Person') > # > # guaranteds ; the opposed of guarantor like guest/host > guaranteds = MultipleJoin('person') > > boss = Per

[SQLObject] Multiple join on a self class

2008-03-10 Thread cedric briner
sqlobject=9.4 hello, the documentation you have only treat of Related Join and Multiple Join between two classes. But I didn't successfuly transpose your documentation/example on a self class. I'm trying to have a class person such as -- code - class Person(SQ

[SQLObject] SQLObject 0.9.5

2008-03-10 Thread Oleg Broytmann
Hello! I'm pleased to announce the 0.9.5, a minor bug fix release of SQLObject. What is SQLObject = SQLObject is an object-relational mapper. Your database tables are described as classes, and rows are instances of those classes. SQLObject is meant to be easy to use and quick

Re: [SQLObject] basic RelatedJoin + select question

2008-03-10 Thread Oleg Broytmann
On Sun, Mar 09, 2008 at 08:52:28PM -0700, Daniel Fetchinson wrote: > class zoo( SQLObject ): > cages = MultipleJoin( 'cage' ) > > class cage( SQLObject ): > zoo = ForeignKey( 'zoo' ) > animals = MultipleJoin( 'animal' ) > properties = RelatedJoin( 'property' ) > > class animal( SQ