Re: Autogenerate with Multi-Tenant

2020-03-19 Thread Brian Hill
On Thursday, March 19, 2020 at 8:20:06 PM UTC-4, Mike Bayer wrote: > > > > On Thu, Mar 19, 2020, at 7:41 PM, Brian Hill wrote: > > > > On Thursday, March 19, 2020 at 7:19:08 PM UTC-4, Mike Bayer wrote: > > so let me get this straight: > > 1. you have many schemas > > > yes > > > > 2. you want

Re: Autogenerate with Multi-Tenant

2020-03-19 Thread Brian Hill
i think i just figured out that what i'm trying to do is unreasonable and unecessary. alembic shouldn't have to know how to reverse map the schemas and i don't need to do it that way. i can create my dev schema in public and autogenerate against that, which maintains the same schema in metadata

Re: Autogenerate with Multi-Tenant

2020-03-19 Thread Mike Bayer
On Thu, Mar 19, 2020, at 7:41 PM, Brian Hill wrote: > > > On Thursday, March 19, 2020 at 7:19:08 PM UTC-4, Mike Bayer wrote: >> so let me get this straight: >> >> 1. you have many schemas >> > > yes > >> >> 2. you want to run autogenerate only once > > yes > >> 3. you want your

Re: Autogenerate with Multi-Tenant

2020-03-19 Thread Brian Hill
On Thursday, March 19, 2020 at 7:19:08 PM UTC-4, Mike Bayer wrote: > > so let me get this straight: > > 1. you have many schemas > > yes > 2. you want to run autogenerate only once > yes > 3. you want your mirations genrated with None for schema > yes > 4. *HOWEVER*, when you run

Re: Autogenerate with Multi-Tenant

2020-03-19 Thread Mike Bayer
so let me get this straight: 1. you have many schemas 2. you want to run autogenerate only once 3. you want your mirations genrated with None for schema 4. *HOWEVER*, when you run autogenerate, you are picking *one* (random? arbitrary?) schema to use as the target, is that right? As it

Re: Autogenerate with Multi-Tenant

2020-03-19 Thread Brian Hill
Here's my env.py. Thanks for the help. Brian On Thursday, March 19, 2020 at 5:37:38 PM UTC-4, Mike Bayer wrote: > > > > On Thu, Mar 19, 2020, at 5:30 PM, Brian Hill wrote: > > Are there known issues with using autogenerate with multi-tenant > (schema_translate_map)? > > > it's complicated and

Re: Autogenerate with Multi-Tenant

2020-03-19 Thread Mike Bayer
On Thu, Mar 19, 2020, at 5:30 PM, Brian Hill wrote: > Are there known issues with using autogenerate with multi-tenant > (schema_translate_map)? it's complicated and not one-size-fits-all, if you consider that to be an issue > > My metadata doesn't have a schema and I my >

Autogenerate with Multi-Tenant

2020-03-19 Thread Brian Hill
Are there known issues with using autogenerate with multi-tenant (schema_translate_map)? My metadata doesn't have a schema and I my schema_translate_map={None:'my_schema'}. This works for migrations but when I use autogenerate the generated revision file is the full schema and not the diff.