Patches item #1117732, was opened at 2005-02-07 11:29
Message generated for change (Settings changed) made by phd
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=540674&aid=1117732&group_id=74338
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: None
Group: None
>Status: Closed
>Resolution: Out of Date
Priority: 5
Submitted By: gian paolo ciceri (zanzi)
Assigned to: Nobody/Anonymous (nobody)
Summary: preliminary work to enable joins between different dbms
Initial Comment:
In the patch there's some initial work to enable MultipleJoin and
RelatedJoin between objects that are physically located (i.e. the
underlying dbms tables that store their data) on two different dbms
(say, a mysql for Person and a sqlite for Address), connected with
two different db connections.
If you modify the tutorial example http://sqlobject.org/docs/
SQLObject.html#one-to-many-relationships and http://
sqlobject.org/docs/SQLObject.html#many-to-many-relationships to
displace objects on two different connections you should be able to
see what happens.
For example, the intermediate table (in RelatedJoin) is replicated
between the two connections, and I've still to optimize this point to
avoid this need.
I've tested the patch in two cases: with two different mysql
connections and with one mysql and one sqlite connections.
Caveat: transactions are expected *not* to work in this scenario.
Please report any bug or other feedback on the ML or directly to
me at gp....@ac....
Thanks for your attention, and patience.
Bye
/gp
----------------------------------------------------------------------
Comment By: gian paolo ciceri (zanzi)
Date: 2005-02-07 11:32
Message:
Logged In: YES
user_id=6932
(I've just forgot to flag the upload checkbox)
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=540674&aid=1117732&group_id=74338
|