Re: [sqlalchemy] Does twophase=True limit to only two databases at the same time?

2015-08-14 Thread Jinghui Niu
Oh by the way, I'm using SQLite as backend. On Aug 14, 2015 2:04 AM, Jinghui Niu niujing...@gmail.com wrote: I have three different DBs, one is person.db, another is journal.db, yet another is tag.db. In the documentation it reads: Vertical partitioning places different kinds of objects, or

[sqlalchemy] Does twophase=True limit to only two databases at the same time?

2015-08-14 Thread Jinghui Niu
I have three different DBs, one is person.db, another is journal.db, yet another is tag.db. In the documentation it reads: Vertical partitioning places different kinds of objects, or different tables, across multiple databases: engine1 = create_engine('postgresql://db1') engine2 =

Re: [sqlalchemy] Does twophase=True limit to only two databases at the same time?

2015-08-14 Thread Mike Bayer
On 8/14/15 5:07 AM, Jinghui Niu wrote: Oh by the way, I'm using SQLite as backend. On Aug 14, 2015 2:04 AM, Jinghui Niu niujing...@gmail.com mailto:niujing...@gmail.com wrote: I have three different DBs, one is person.db, another is journal.db, yet another is tag.db. In the

Re: [sqlalchemy] Does twophase=True limit to only two databases at the same time?

2015-08-14 Thread Jonathan Vanasco
twophase deals with the transaction commit protocol , and is unlreated to anything else in your example. (http://docs.sqlalchemy.org/en/latest/orm/session_api.html#sqlalchemy.orm.session.Session.params.twophase) You'd simply create an engine3 and bind whatever object classes to it. FWIW.