Back to Sea Orm

Bakery Schema

examples/seaography_example/migration/README.md

1.1.201014 B
Original Source

Bakery Schema

sql
CREATE DATABASE bakery;
GRANT ALL PRIVILEGES ON bakery.* TO sea;

Assume the database is named bakery:

sh
export DATABASE_URL=mysql://sea:sea@localhost/bakery

Re-generate entities

sh
sea-orm-cli generate entity --output-dir src/entity

Running Migrator CLI

  • Apply all pending migrations
    sh
    cargo run
    
    sh
    cargo run -- up
    
  • Apply first 10 pending migrations
    sh
    cargo run -- up -n 10
    
  • Rollback last applied migrations
    sh
    cargo run -- down
    
  • Rollback last 10 applied migrations
    sh
    cargo run -- down -n 10
    
  • Drop all tables from the database, then reapply all migrations
    sh
    cargo run -- fresh
    
  • Rollback all applied migrations, then reapply all migrations
    sh
    cargo run -- refresh
    
  • Rollback all applied migrations
    sh
    cargo run -- reset
    
  • Check the status of all migrations
    sh
    cargo run -- status