SeaORM

🐚 An async & dynamic ORM for Rust

[](https://crates.io/crates/sea-orm) [](https://docs.rs/sea-orm) [](https://github.com/SeaQL/sea-orm/actions/workflows/rust.yml)

SeaORM

SeaORM is a relational ORM to help you build web services in Rust with the familiarity of dynamic languages.

Getting Started

Join our Discord server to chat with others in the SeaQL community!

• Getting Started
• Usage Example
• Rocket Example
• Actix Example
• Axum Example
• Poem Example

Features

1. Async

   Relying on SQLx, SeaORM is a new library with async support from day 1.

2. Dynamic

   Built upon SeaQuery, SeaORM allows you to build complex queries without 'fighting the ORM'.

3. Testable

   Use mock connections to write unit tests for your logic.

4. Service Oriented

   Quickly build services that join, filter, sort and paginate data in APIs.

A quick taste of SeaORM

Entity

```rust use sea_orm::entity::prelude::*;

[derive(Clone, Debug, PartialEq, DeriveEntityModel)]

[seaorm(tablename = "cake")]

pub struct Model { #[seaorm(primarykey)] pub id: i32, pub name: String, }

[derive(Copy, Clone, Debug, EnumIter, DeriveRelation)]

pub enum Relation { #[seaorm(hasmany = "super::fruit::Entity")] Fruit, }

impl Related for Entity { fn to() -> RelationDef { Relation::Fruit.def() } } ```

Select

```rust // find all models let cakes: Vec = Cake::find().all(db).await?;

// find and filter let chocolate: Vec = Cake::find() .filter(cake::Column::Name.contains("chocolate")) .all(db) .await?;

// find one model let cheese: Option = Cake::findbyid(1).one(db).await?; let cheese: cake::Model = cheese.unwrap();

// find related models (lazy) let fruits: Vec = cheese.find_related(Fruit).all(db).await?;

// find related models (eager) let cakewithfruits: Vec<(cake::Model, Vec)> = Cake::find().findwithrelated(Fruit).all(db).await?;

```

Insert

```rust let apple = fruit::ActiveModel { name: Set("Apple".to_owned()), ..Default::default() // no need to set primary key };

let pear = fruit::ActiveModel { name: Set("Pear".to_owned()), ..Default::default() };

// insert one let pear = pear.insert(db).await?;

// insert many Fruit::insert_many(vec![apple, pear]).exec(db).await?; ```

Update

```rust use seaorm::seaquery::{Expr, Value};

let pear: Option = Fruit::findbyid(1).one(db).await?; let mut pear: fruit::ActiveModel = pear.unwrap().into();

pear.name = Set("Sweet pear".to_owned());

// update one let pear: fruit::Model = pear.update(db).await?;

// update many: UPDATE "fruit" SET "cakeid" = NULL WHERE "fruit"."name" LIKE '%Apple%' Fruit::updatemany() .col_expr(fruit::Column::CakeId, Expr::value(Value::Int(None))) .filter(fruit::Column::Name.contains("Apple")) .exec(db) .await?;

```

Save

```rust let banana = fruit::ActiveModel { id: NotSet, name: Set("Banana".to_owned()), ..Default::default() };

// create, because primary key id is NotSet let mut banana = banana.save(db).await?;

banana.name = Set("Banana Mongo".to_owned());

// update, because primary key id is Set let banana = banana.save(db).await?;

```

Delete

```rust // delete one let orange: Option = Fruit::findbyid(1).one(db).await?; let orange: fruit::Model = orange.unwrap(); fruit::Entity::delete(orange.intoactivemodel()) .exec(db) .await?;

// or simply let orange: Option = Fruit::findbyid(1).one(db).await?; let orange: fruit::Model = orange.unwrap(); orange.delete(db).await?;

// delete many: DELETE FROM "fruit" WHERE "fruit"."name" LIKE 'Orange' fruit::Entity::delete_many() .filter(fruit::Column::Name.contains("Orange")) .exec(db) .await?;

```

Learn More

1. Design
2. Architecture
3. Release Model
4. Change Log

License

Licensed under either of

• Apache License, Version 2.0 (LICENSE-APACHE or http://www.apache.org/licenses/LICENSE-2.0)
• MIT license (LICENSE-MIT or http://opensource.org/licenses/MIT)

at your option.

Contribution

Unless you explicitly state otherwise, any contribution intentionally submitted for inclusion in the work by you, as defined in the Apache-2.0 license, shall be dual licensed as above, without any additional terms or conditions.