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 <[email protected]>:
> 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/ [email protected]
> 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
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
>
------------------------------------------------------------------------------
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
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlobject-discuss
