#13 preliminary work to enable joins between different dbms

closed-out-of-date
nobody
None
5
2006-05-18
2005-02-07
No

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.ciceri@acm.org.

Thanks for your attention, and patience.
Bye
/gp

Discussion

  • this is the patch to joins.py and main.py

     
    Attachments
  • Logged In: YES
    user_id=6932

    (I've just forgot to flag the upload checkbox)

     
  • Oleg Broytman
    Oleg Broytman
    2006-05-18

    • status: open --> closed-out-of-date