Re: [sqlalchemy] Relationship between two databases

2016-02-23 Thread Thierry Florac
Hi, I don't think that the solution can come from SQLAlchemy. You may have to create a database link between your two databases to be able to query both of them with a single instruction... Best regards, Thierry 2016-02-23 11:43 GMT+01:00 Mehdi : > Hi > Is it possible two

[sqlalchemy] Relationship between two databases

2016-02-23 Thread Mehdi
Hi Is it possible two have a one-to-many or many-to-many relationship between two models which they are exist in two different databases? I have two oracle dbs on two different machines on lan. so i've created two engines like: main_engine = create_engine("oracle://user:pass@ip1/sid")