Re: [sqlalchemy] mixing two models/schema

2013-04-26 Thread Andi Blake
thank you michael, very helpful points. in the end i'll just use PostgreSQL native schema since i'm not able to get the multi-connection thing working. for that i use a common `` DeclarativeBase`` and ``__table_args__ = {'schema': 'market'}`` or ``__table_args__ = {'schema': 'site'}``. i'm

Re: [sqlalchemy] mixing two models/schema

2013-04-26 Thread Michael Bayer
On Apr 26, 2013, at 5:46 AM, Andi Blake andi.ba...@googlemail.com wrote: i'm still interested in the solution of http://docs.sqlalchemy.org/en/rel_0_7/orm/session.html#simple-vertical-partitioning since it toke me some time and i don't like having such an open issue ;) this is my original

[sqlalchemy] mixing two models/schema

2013-04-25 Thread Andi Blake
hi all, i have a webapp with an existing database-model ``site``, including users. in a second service i create a new database-model ``market``, but still want to access the users (which works via separate engine). goal: i want to create a relation from the ``market``-model to the

Re: [sqlalchemy] mixing two models/schema

2013-04-25 Thread Michael Bayer
On Apr 25, 2013, at 10:21 AM, Andi Blake andi.ba...@googlemail.com wrote: hi all, i have a webapp with an existing database-model ``site``, including users. in a second service i create a new database-model ``market``, but still want to access the users (which works via separate