rust使用sea-orm-cli来操作数据库

详细文档链接https://www.sea-ql.org/SeaORM/docs/migration/setting-up-migration/

初始化

sea-orm-cli migrate init

创建表

sea-orm-cli migrate generate table_name

生成实体数据

sea-orm-cli generate entity -o src/entities -v --with-serde both

设置外键

fk_role: 外键表名 from: 当前表的某个字段 (需要映射的外键) to: 外表,对应表的对应ID

.foreign_key(ForeignKeyCreateStatement::new()
.name("fk_role")
.from(PermissionRole::Table, PermissionRole::RoleId)
.to(Role::Table, Role::Id)
.on_delete(ForeignKeyAction::Cascade))