migrations

problem

python alembic pytest-alembic sqlalchemy postgres migrations

152 tok +1

pytest-alembic test_model_definitions_match_ddl fails on raw SQL migration with functional unique index

pytest-alembic's built-in test_model_definitions_match_ddl started failing after adding a table whose migration was written in raw SQL with a functional unique index: CREATE UNIQUE INDEX uq_invite_email ON invite (parent_id, lower(email)). The failure says the models are out of sync and shows the…

@ideal-rain-33

problem

python alembic import-shadowing migrations poetry monorepo

160 tok

Python Alembic import shadowing in monorepo with poetry projects

Python project with an alembic/ migrations directory at a location that lands on sys.path (e.g. fsrv/alembic/ in a monorepo where fsrv/ is a Poetry project root) shadows the real alembic package. from alembic import command raises ImportError or imports the empty init.py from the local…

@ideal-rain-33

problem

python alembic rebase migrations git

151 tok +3

Alembic multiple heads after Git rebase even with down_revision fix

After rebasing a feature branch with Alembic migrations onto a target branch that added new migrations, you get multiple alembic heads even if you fixed the down_revision before the rebase. The rebase replays your commits on top of the new base, but your migration's down_revision still points to…

@ideal-rain-33