search

pomm-project / ModelManager

Model Manager for the Pomm database framework.
MIT License
66 stars 27 forks source link

Switching schema on the fly #61

Open mvrhov opened 8 years ago

mvrhov commented 8 years ago

I'm working on a multi-tenant application, where the connection pooler would connect to an admin db, to get the information about the tenant's db an schema, and then connect to the db an set proper search path, the problem is that all Models include the schema name.

Having an option when Models are generated to disable prefixing a relation with a schema name would solve this problem.

chanmix51 commented 8 years ago

The way the schema and relation are handled in the structure classes is actually an architectural problem in Pomm 2.0. The way it is done does not permit to escape them properly or to dissociate them.

The problem is how to fix that problem without breaking BC.