Re: [sqlalchemy] Configuring Alembic in SQL-only mode

2021-08-22 Thread Mike Bayer
it should be fine though I'm surprised PostgreSQL isn't forcing you to ROLLBACK the transaction when one of those operations fails.if it isn't then should be fine for now. I'd probably make a function that does the command execution that you import from somewhere else though, that way your

[sqlalchemy] Configuring Alembic in SQL-only mode

2021-08-21 Thread zsol...@gmail.com
Hi, I'm using SQLAlchemy 1.3 with PostgreSQL. I'm trying to use alembic in SQL-only mode. I'm using a custom sql-diff script which takes the pg_dump's --schema output and compares it with a clean db setup's one and tells me exactly what changes do I need to make. This way I catch 100% of the