Hi,

I'm using a schema with multiple DB, like :

engine1 = create_engine("mysql://localhost/{db}?charset=utf8".format(db=db1
))
engine2 = create_engine("mysql://localhost/{db}?charset=utf8".format(db=db2
))

Then I use automap and reflection to generate mapping of all classes needed.

Sometime, I want to use classes from both databases, but I cannot bind my 
session directly with two engines.

I noticed that I can use the Session `binds` argument to decide which class 
to bind to some engine, but I have many classes to include here, and this 
is somewhat error prone. 

Is there any solution to automate the binding definition against each class 
? Or to bind a session directly to multiple engines ?

Thank you


-- 
SQLAlchemy - 
The Python SQL Toolkit and Object Relational Mapper

http://www.sqlalchemy.org/

To post example code, please provide an MCVE: Minimal, Complete, and Verifiable 
Example.  See  http://stackoverflow.com/help/mcve for a full description.
--- 
You received this message because you are subscribed to the Google Groups 
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to sqlalchemy+unsubscr...@googlegroups.com.
To post to this group, send email to sqlalchemy@googlegroups.com.
Visit this group at https://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.

Reply via email to