Re: Updating multiple Postgres schema objects from single SQL Alchemy model

2014-11-17 Thread Nick Retallack
On Monday, November 17, 2014 6:55:49 PM UTC-8, Michael Bayer wrote: > > for what specifically? Autogenerate will work with whatever data you > give it. Send in a target_metadata with what you want to view on the > Python side and tailor an include_object() function if you need in order to > f

Re: Updating multiple Postgres schema objects from single SQL Alchemy model

2014-11-17 Thread Nick Retallack
If alembic didn't track schemas at all, it would probably do exactly what I want, which is: Set the search path If a table is visible, and the metadata doesn't set a specific schema for it, assume it's in the right schema. If a schema is explicitly specified in the table, use that schema when c

Re: Updating multiple Postgres schema objects from single SQL Alchemy model

2014-11-17 Thread Michael Bayer
for what specifically? Autogenerate will work with whatever data you give it. Send in a target_metadata with what you want to view on the Python side and tailor an include_object() function if you need in order to filter what comes from the database. > On Nov 17, 2014, at 7:46 PM, Nick Re

Re: Updating multiple Postgres schema objects from single SQL Alchemy model

2014-11-17 Thread Nick Retallack
I am doing exactly the same thing in my application. Is there a way I can get alembic to generate migrations for this? -- You received this message because you are subscribed to the Google Groups "sqlalchemy-alembic" group. To unsubscribe from this group and stop receiving emails from it, send

Re: Error when autogenerate migration scripts with alembic

2014-11-17 Thread Ons
It worked. Thank you for your great explanation. On Monday, November 17, 2014 4:27:37 PM UTC+1, Michael Bayer wrote: > > > > On Nov 17, 2014, at 10:20 AM, Ons > > wrote: > > > > Hi, > > > > I want to use alembic to auto-generate migrations scripts for my > postgres db. When i tried: > > #al

Re: Error when autogenerate migration scripts with alembic

2014-11-17 Thread Michael Bayer
> On Nov 17, 2014, at 10:20 AM, Ons wrote: > > Hi, > > I want to use alembic to auto-generate migrations scripts for my postgres db. > When i tried: > #alembic upgrade and alembic downgrade both worked properly, but when i > modified my models and tried > #alembic revision --autogenerate i

Error when autogenerate migration scripts with alembic

2014-11-17 Thread Ons
Hi, I want to use alembic to auto-generate migrations scripts for my postgres db. When i tried: #alembic upgrade and alembic downgrade both worked properly, but when i modified my models and tried #alembic revision --autogenerate it raises this error : INFO [alembic.migration] Context impl