#13 preliminary work to enable joins between different dbms


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.


  • gian paolo ciceri

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

  • gian paolo ciceri

    Logged In: YES

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

  • Oleg Broytman

    Oleg Broytman - 2006-05-18
    • status: open --> closed-out-of-date

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.

No, thanks