Rust: ORM - SeaORM

[hhstore]

related:

• [x] #369
• [x] #347
• [x] #365

[hhstore]

Rust ORM - SeaORM 教程:

使用体验:

• 比较差. 基本的 CRUD 不能跳转源码(宏!), 报错复查效率非常低.
• 除了 entity 生成器, 挺使用, 其他体感很差.
• 弃了.
• 使用示例: https://github.com/better-rs/learn-rs

关于作者:

• 目测是 HK 的几个刚毕业没多久的学生.
• 可能维护的稳定性存疑.
• 目前的使用体验很差. 不建议使用.

特性:

• https://github.com/SeaQL/sea-orm
• 基于 sqlx, 支持 raw sql 模式.
• 支持 db 连接池.
• 支持异步, 方便集成 tokio.
• 借鉴 ruby ActiveRecord.

文档:

示例:

• https://www.sea-ql.org/SeaORM/docs/next/introduction/tutorial
• https://github.com/axumrs/axum-rs
  • axum + sea-orm
  • ⭐⭐⭐⭐⭐⭐
• https://github.com/AxumCourse/axum-with-seaorm
  • axum + sea-orm
  • ⭐⭐⭐

Debug 调试日志工具:

• https://www.sea-ql.org/SeaORM/docs/next/install-and-config/debug-log

Cli 工具:

自动生成 db model(entity) 数据结构.

• https://www.sea-ql.org/SeaORM/docs/next/generate-entity/sea-orm-cli

# Generate entity files of database `bakery` to `entity/src`
$ sea-orm-cli generate entity \
    -u sql://sea:sea@localhost/bakery \
    -o entity/src

自带 migration 工具.

• 初始化:
  • https://www.sea-ql.org/SeaORM/docs/next/migration/setting-up-migration

# Setup the migration directory in `./migration`
$ sea-orm-cli migrate init
Initializing migration directory...
Creating file `./migration/src/lib.rs`
Creating file `./migration/src/m20220101_000001_create_table.rs`
Creating file `./migration/src/main.rs`
Creating file `./migration/Cargo.toml`
Creating file `./migration/README.md`
Done!

# If you want to setup the migration directory in else where
$ sea-orm-cli migrate init -d ./other/migration/dir

• 执行: https://www.sea-ql.org/SeaORM/docs/next/migration/running-migration

$ sea-orm-cli migrate COMMAND

$ sea-orm-cli migrate COMMAND -d ./other/migration/dir

参考:

• https://rustmagazine.github.io/rust_magazine_2021/chapter_10/seaorm.html

[hhstore]

SeaORM 核心功能:

DB+Table 操作:

• 建表: https://www.sea-ql.org/SeaORM/docs/next/generate-database-schema/create-table
• 建索引: https://www.sea-ql.org/SeaORM/docs/next/generate-database-schema/create-index

CRUD:

• https://www.sea-ql.org/SeaORM/docs/next/basic-crud/select

关系表示:

• https://www.sea-ql.org/SeaORM/docs/next/relation/one-to-one

事务机制:

• https://www.sea-ql.org/SeaORM/docs/next/advanced-query/transaction

测试:

• https://www.sea-ql.org/SeaORM/docs/next/write-test/mock

[hhstore]

踩坑记录:

sea-orm 与 axum route 的冲突 & 解决.

• https://github.com/SeaQL/sea-orm/issues/438

[hhstore]

1

[hhstore]

1

[hhstore]

1

[hhstore]

1