Re: [SQLObject] Intermediate table in RelatedJoins

[Miguel T. <mig...@gm...>]

Hi Oleg.

I think I didn't explain myself well. The example I provided has two
relationships. A->B, B->A, both different - so they can't (or
shouldn't) use the same table.

I guess with sqlobject it would something like

class A (SQLObject):
    Bs = sqlobject.RelatedJoin ('B')

class B (SQLObject):
    As = sqlobject.RelatedJoin ('A')

after the corresponding create tables was called then the tables "a",
"b", "a_b" and "b_a" should (I think) be created.

You stated in a previous email (one minute before this one) that
sqlobject doesn't support multiple intermediate tables. Maybe that's
what missing. I guess I'll can try to have a go at it, but my guess is
that I'll need some coaching (so I might come to annoy you all some
more :) ).

Best regards,

Miguel Tavares

2009/8/12 Oleg Broytmann <ph...@ph...>:
> On Wed, Aug 12, 2009 at 10:20:43AM +0100, Miguel Tavares wrote:
>> Like A having several B and B having several different A?
>
>   RelatedJoins do exactly that. It is a many-to-many relation.
>
> Oleg.
> --
>     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
>           Programmers don't die, they just GOSUB without RETURN.
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> sqlobject-discuss mailing list
> sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>