200 Migrations [2d]

Migrations change your database schema in a controlled, repeatable way. This lesson covers how migrations work, how to write complex ones, and how to deal with existing data.

Important

Work on this lesson in advisor mode.

Learning goals

• You can explain what migrations are for, and why schema changes go through migrations instead of manual changes on a server.
• You can write migrations that change the schema and migrate existing data.
• You can explain why we don't use application models in migrations, and what to use instead (e.g. plain SQL or a model class defined inside the migration).
• You can explain how migrations interact with feature branches, and handle switching branches with pending or rolled-back migrations.
• You can keep a cached column up to date with callbacks and backfill it for existing records.
• You can read complex migrations in a real project and explain what they do.

Resources

Read what's new to you, skim what's familiar, skip what you already master. Stop when you can meet the learning goals.

Your agent can also generate an overview, a tutorial or an explanation for anything here, tailored to what you already know. Just ask.

• 📄 Rails Guide: Active Record Migrations Show archive.org snapshot — the reference; read it fully once
• 📄 How to use models in your migrations (without killing kittens) — why we never use application models in migrations (archived blog post)
• 📄 How to write complex migrations in Rails — our card
• 📄 Rails Guide: Active Record Callbacks Show archive.org snapshot — for keeping the cached columns of the exercise up to date

Discuss with your mentor

• Instead of migrations, could we simply log into the production server's SQL console and alter tables there whenever we need a change?
• How do we need to work with migrations when we change feature branches?

Exercises

Read real migrations

Check out the repository Project Hero and read through some migrations in db/migrate. Find two complex migrations and discuss them with your mentor.

Tip

Find the largest files in the db/migrate folder.

Cached columns

In MovieDB, add two fields:

• Actor#total_movies: This field should cache the total number of movies an actor stars in
• Actor#first_movie_id: This field should cache the first movie to which the actor starred in. The first movie is the movie with the lowest #created_at timestamp.

Add callbacks Show archive.org snapshot to your ActiveRecord models so the field is always up to date. For the purpose of this exercise, please don't use the :counter_cache option and do everything manually instead.

Whenever you add a new column you need to take care of existing records. Add a migration that sets the total_movies and first_movie_id column for existing records. Write this migration in multiple styles:

• Embedding ActiveRecord models into your migration
• SQL statements (update "UPDATE actors SET ...")