Using Alembic updating an ENUM TYPE I found myself blocked because the datamigration didn't want to use the enum new values without a commit in between files.
I tried to force the commit in the migration with no luck. And I finally ran alembic twice in order to fix it.
(alembic upgrade +1 && alembic upgrade head) || exit 0
Which is not to my liking.
ChatGPT suggest to use a flag that doesn't exist but would be exactly what I'm looking for.
alembic upgrade --commit head
Do you know how I can run alembic upgrade head while ensuring that commits are made between each migration file?
Refs New enum values must be committed before they can be used
As described by Adrian, the way to fix this is to encapsulate the ALTER TYPE within an autocommit block:
with op.get_context().autocommit_block():
op.execute("ALTER TYPE rolename ADD VALUE IF NOT EXISTS 'OWNER'")