Re: [sqlalchemy] How to create model with dynamically set schema?

2015-02-05 Thread Michael Bayer
sector119 wrote: > Michael, I want to set search_path to locality schema that depends on user > settings. that’s more like multi-tenancy. much easier, you don’t have to bother creating multiple models. > > And I have some kind of admin utility where user can setup locality > environment

Re: [sqlalchemy] How to create model with dynamically set schema?

2015-02-05 Thread sector119
Michael, I want to set search_path to locality schema that depends on user settings. And I have some kind of admin utility where user can setup locality environment (schema) with set of tables and I have the list of models those should be created at some schema that admin-user would specify..

Re: [sqlalchemy] How to create model with dynamically set schema?

2015-02-05 Thread Michael Bayer
sector119 wrote: > Hello! > > I have some model: > > class Person(Base): > __tablename__ = 'person' > > id = Column(BigInteger, primary_key=True, autoincrement=False) > locality_id = Column(Integer, ForeignKey(SYSTEM_SCHEMA + '.locality.id'), > nullable=False) > street_id =

[sqlalchemy] How to create model with dynamically set schema?

2015-02-05 Thread sector119
Hello! I have some model: class Person(Base): __tablename__ = 'person' id = Column(BigInteger, primary_key=True, autoincrement=False) locality_id = Column(Integer, ForeignKey(SYSTEM_SCHEMA + '.locality.id'), nullable=False) street_id = Column(Integer, ForeignKey('street.id'), nu