What are the common Flask-Migrate commands?

What are the common Flask-Migrate commands I should know?

Flask-Migrate provides several commands for managing database migrations. The most common ones are:

1. flask db init - Initializes a new migration repository.
2. flask db migrate - Creates a new migration script based on changes in your models.
3. flask db upgrade - Applies the migration to the database.
4. flask db downgrade - Reverts the database to a previous migration.
5. flask db history - Shows the migration history.

Can you explain what each command does in more detail?

Sure!

• flask db init: This sets up a new directory for your migration scripts, allowing you to track changes.
• flask db migrate: It detects changes in your models and generates a migration script that describes those changes.
• flask db upgrade: This command applies the migration script to your database, updating its schema.
• flask db downgrade: If you need to revert changes, this command will roll back the database to a previous state.
• flask db history: This lists all the migrations that have been applied, helping you keep track of your database's evolution.

What if I want to see the SQL commands that will be executed?

You can use the flask db migrate --message 'your_message' --sql command. This will generate the SQL commands without applying them, allowing you to review what changes will be made.