Originally posted by @swelborn in #1353 (comment)
when people are adding new migrations, things can go wrong on both upgrade/downgrade - would be nice to have a test to traverse the migration chain to head and back to init, with both postgres + sqlite
can do this a number of ways but i think testcontainers is good for this - spin up postgres container, run alembic commands from python, make sure everything exits cleanly
Originally posted by @swelborn in #1353 (comment)
when people are adding new migrations, things can go wrong on both upgrade/downgrade - would be nice to have a test to traverse the migration chain to head and back to init, with both postgres + sqlite
can do this a number of ways but i think testcontainers is good for this - spin up postgres container, run alembic commands from python, make sure everything exits cleanly