Migrations
When developing locally, use
copper run to run database migrations before starting the app server. You can disable this behavior with copper run -migrate=false.To run migrations in production, use the
migrate binary built by copper build. This binary can be run with prod.toml configuration on your server.Migrations are stored in the
migrations/ directory found at the root of the project. By default, it already has 0001_initial.sql in it that looks similar to --- +migrate Up
-- +migrate Down
You can SQL statements that update your database schema after the
-- +migrate Up line and SQL statements that rollback those changes after the -- +migrate Down line --- +migrate Up
CREATE TABLE rockets (
id text PRIMARY KEY,
name text
);
-- +migrate Down
DROP TABLE rockets;
Each migration file can only be applied once. Once a migration has been applied, create a new migration file
migrations/0002_launches.sql. Continue creating a new migration file for each change to your database schema.Last modified 1yr ago