How to check if models are in sync with generated migrations?

[mglowinski93]

Hi,
is there a way to check that models are in sync with generated migrations?

alembic-autogen-check is a nice tool to check that with alembic,
but it isn't working with flask-migrate. It gives below error:

alembic.util.exc.CommandError: No 'script_location' key found in configuration.

I saw this and this topic, but those are checking database and migrations sync, not models and migrations sync.

Thanks for help in advance.

[miguelgrinberg]

The tool that you referenced does not check for sync between models and migrations, it checks for sync between models and your database.

You can do the same with the flask db migrate command. If this command returns an error, then your models are identical to your database tables and there is nothing to migrate. If this command generates a migration file, that means that there are some differences and these will be listed in the generated migration script. If you don't care to keep the generate migration script, you can safely delete it.

[mglowinski93]

thank you @miguelgrinberg for clear answer :)

Ticket/discussion can be closed.

[KyloEntro]

I can see that alembic check command has been merged in flask-migrate last week which checks if the models and migration are synchronized.
@miguelgrinberg Do you know when this feature will be released ?

[miguelgrinberg]

This is now released. 🎉

[KyloEntro]

Nice thank you 🙏