Alembic migrations in FastAPI - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is Alembic used for in FastAPI projects?

Alembic helps manage database schema changes by creating and applying migrations. It keeps the database structure in sync with your code changes.

beginner

What command initializes Alembic in your project?

The command alembic init alembic creates the Alembic folder and configuration files needed to start migrations.

beginner

How do you create a new migration script with Alembic?

Use alembic revision -m "message" to create a new migration file where you define schema changes.

beginner

What does the command alembic upgrade head do?

It applies all pending migrations to update the database schema to the latest version.

intermediate

Why is it important to keep migration scripts under version control?

Migration scripts track database changes over time. Keeping them in version control helps teams share and apply consistent database updates safely.

Which Alembic command creates the initial setup files?

A alembic migrate

B alembic upgrade head

C alembic revision -m "init"

D alembic init alembic

The alembic init alembic command sets up the Alembic environment with necessary files.

What does alembic revision -m "add users table" do?

A Applies the migration to the database

B Creates a new migration script with the message

C Deletes old migration scripts

D Rolls back the last migration

This command creates a new migration file where you can define schema changes.

How do you apply all migrations to update your database?

A alembic upgrade head

B alembic downgrade base

C alembic create all

D alembic migrate

The alembic upgrade head command applies all migrations to bring the database to the latest version.

Where do Alembic migration scripts live by default?

A In the root project folder

B In the database folder

C In the alembic/versions folder

D In the migrations folder

Alembic stores migration scripts inside the alembic/versions directory by default.

Why should you not edit migration scripts after applying them to production?

A It can cause database inconsistencies

B Because they are read-only files

C Alembic will delete them automatically

D They are encrypted

Changing applied migrations can cause the database to get out of sync and lead to errors.

Explain the steps to create and apply a new Alembic migration in a FastAPI project.

Think about setup, writing changes, and applying them.

Describe why Alembic migrations are important for managing database changes in web applications.

Consider teamwork and database consistency.