will_csdn_goadd wechat email pgsql sqlite

文件	最后提交记录	最后更新时间
src	add wechat email pgsql sqlite	4 个月前
Cargo.lock	add cargo.lock	10 个月前
Cargo.toml	once commit	1 年前
README.md	once commit	1 年前

Running Migrator CLI

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

Running Migrator CLI

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

sea-orm-cli generate entity -o src/model/sys/entity --with-serde=both

sea-orm-cli migrate up sea-orm-cli migrate down sea-orm-cli migrate status sea-orm-cli migrate generate role sea-orm-cli migrate up -n 1 sea-orm-cli migrate down -n 1

/// All column types /// /// | ColumnType /// |-----------------------|----- /// | Char | char /// | String | varchar /// | Text | text /// | TinyInteger | tinyint /// | SmallInteger | smallint /// | Integer | int /// | BigInteger | bigint /// | TinyUnsigned /// | SmallUnsigned /// | Unsigned | int unsigned /// | BigUnsigned /// | Float | float /// | Double | double /// | Decimal | decimal /// | DateTime | datetime /// | Timestamp | timestamp /// | TimestampWithTimeZone | timestamp /// | Time | time /// | Date | date /// | Year | year /// | Interval | N/A /// | Blob | blob /// | Binary | binary /// | VarBinary | varbinary /// | Bit | bit /// | VarBit | bit /// | Boolean | bool /// | Money | decimal /// | Json | json /// | JsonBinary | json /// | Uuid | binary(16) /// | Enum | ENUM(...) /// | Array | N/A /// | Cidr | N/A /// | Inet | N/A /// | MacAddr | N/A /// | LTree | N/A | MySQL data type | PostgreSQL data type | SQLite data type | --------------|-----------------------------|------------------------------| | char | char | | varchar | varchar | | text | text | | smallint | tinyint | | smallint | smallint | | integer | integer | | bigint | integer | | tinyint unsigned | smallint | tinyint | | smallint unsigned | smallint | smallint | | integer | integer | | bigint unsigned | bigint | integer | | real | float | | double precision | double | | decimal | real | | timestamp without time zone | datetime_text | | timestamp | timestamp_text | | timestamp with time zone | timestamp_with_timezone_text | | time | time_text | | date | date_text | | N/A | N/A | | interval | N/A | | bytea | blob | | bytea | blob | | bytea | varbinary_blob | | bit | N/A | | varbit | N/A | | bool | boolean | | money | real_money | | json | json_text | | jsonb | jsonb_text | | uuid | uuid_text | | ENUM_NAME | enum_text | | DATA_TYPE[] | N/A | | cidr | N/A | | inet | N/A | | macaddr | N/A | | ltree | N/A