54 releases

new 1.0.0-rc.3 Mar 26, 2024
1.0.0-rc.1 Feb 6, 2024
0.12.15 Mar 15, 2024
0.12.10 Dec 14, 2023
0.4.0 Nov 19, 2021

#1750 in Database interfaces

Download history 24045/week @ 2023-12-08 31665/week @ 2023-12-15 19406/week @ 2023-12-22 18533/week @ 2023-12-29 22965/week @ 2024-01-05 23828/week @ 2024-01-12 31497/week @ 2024-01-19 26571/week @ 2024-01-26 28391/week @ 2024-02-02 27807/week @ 2024-02-09 18771/week @ 2024-02-16 28814/week @ 2024-02-23 28107/week @ 2024-03-01 33352/week @ 2024-03-08 34160/week @ 2024-03-15 23075/week @ 2024-03-22

125,619 downloads per month
Used in 15 crates (via sea-orm-migration)

MIT/Apache

94KB
2K SLoC

SeaORM CLI

Install and Usage:

> cargo install sea-orm-cli 
> sea-orm-cli help

Or:

> cargo install --bin sea
> sea help

Getting Help:

cargo run -- -h

Running Entity Generator:

# MySQL (`--database-schema` option is ignored)
cargo run -- generate entity -u mysql://sea:sea@localhost/bakery -o out

# SQLite (`--database-schema` option is ignored)
cargo run -- generate entity -u sqlite://bakery.db -o out

# PostgreSQL
cargo run -- generate entity -u postgres://sea:sea@localhost/bakery -s public -o out

Running Migration:

  • Initialize migration directory
    cargo run -- migrate init
    
  • Generate a new migration file
    cargo run -- migrate generate MIGRATION_NAME
    
  • Apply all pending migrations
    cargo run -- migrate
    
    cargo run -- migrate up
    
  • Apply first 10 pending migrations
    cargo run -- migrate up -n 10
    
  • Rollback last applied migrations
    cargo run -- migrate down
    
  • Rollback last 10 applied migrations
    cargo run -- migrate down -n 10
    
  • Drop all tables from the database, then reapply all migrations
    cargo run -- migrate fresh
    
  • Rollback all applied migrations, then reapply all migrations
    cargo run -- migrate refresh
    
  • Rollback all applied migrations
    cargo run -- migrate reset
    
  • Check the status of all migrations
    cargo run -- migrate status
    

Dependencies

~17–33MB
~466K SLoC