Re: [SQLObject] Intermediate table in RelatedJoins

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

Hi Oleg,

Running your example this is the schema on the database:
CREATE TABLE a (
    id INTEGER PRIMARY KEY
);
CREATE TABLE a1_b1 (
a_id INT NOT NULL,
b_id INT NOT NULL
);
CREATE TABLE a2_b2 (
a_id INT NOT NULL,
b_id INT NOT NULL
);
CREATE TABLE b (
    id INTEGER PRIMARY KEY
);

I'll try with a newer version of sqlobject and then I'll come back
with the status.

Best regards,

Miguel Tavares

2009/8/12 Oleg Broytmann <ph...@ph...>:
> On Wed, Aug 12, 2009 at 11:25:58AM +0100, Miguel Tavares wrote:
>> You stated in a previous email (one minute before this one) that
>> sqlobject doesn't support multiple intermediate tables.
>
>   I meant - for a single RelatedJoin. But you can crate as many different
> joins - just name the table explicitly:
>
> class A (SQLObject):
>    B1 = sqlobject.RelatedJoin ('B', intermediateTable='a1_b1')
>    B2 = sqlobject.RelatedJoin ('B', intermediateTable='a2_b2')
>
> class B (SQLObject):
>    A1 = sqlobject.RelatedJoin ('A', intermediateTable='a1_b1')
>    A2 = sqlobject.RelatedJoin ('A', intermediateTable='a2_b2')
>
> 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
>