Alembic recipes
3 tested Alembic integration recipes with SQLAlchemy, SQLite, Flask, Flask-SQLAlchemy. Exact pinned versions and a last-passed receipt, last run 2026-10-15.
passed6/6python
Alembic autogenerate compare_metadata drift check against SQLite
Declare SQLAlchemy 2 models with a naming convention, then detect schema drift offline by diffing the live SQLite schema against the metadata with Alembic compare_metadata.
sqlalchemy@2.1.4alembic@1.20.0pytest@9.1.1
last passed 2026-10-15 13:33 UTC
passed4/4python
Flask-SQLAlchemy models with Flask-Migrate upgrades on sqlite in tests
Define Flask-SQLAlchemy models, version the schema with Flask-Migrate, and test upgrade, downgrade and model/migration drift offline on a temporary sqlite file.
flask@3.1.3flask-sqlalchemy@3.1.1flask-migrate@4.1.0
last passed 2026-10-15 13:29 UTC
passed2/2python
SQLAlchemy 2 + Alembic programmatic migrations
Alembic migrations driven from Python (upgrade, downgrade, autogenerate check) against SQLite, with SQLAlchemy 2 models.
sqlalchemy@2.1.4alembic@1.20.0pytest@9.1.1
last passed 2026-10-15 13:33 UTC