SeaORM
SeaORM is a relational ORM to help you build web services in Rust with the familiarity of dynamic languages.
Getting Started
If you like what we do, consider starring, commenting, sharing and contributing!
Join our Discord server to chat with others in the SeaQL community!
Integration examples
- Actix v4 Example
- Actix v3 Example
- Axum Example
- GraphQL Example
- jsonrpsee Example
- Poem Example
- Rocket Example
- Salvo Example
- Tonic Example
Features
-
Async
Relying on SQLx, SeaORM is a new library with async support from day 1.
-
Dynamic
Built upon SeaQuery, SeaORM allows you to build complex queries without 'fighting the ORM'.
-
Testable
Use mock connections to write unit tests for your logic.
-
Service Oriented
Quickly build services that join, filter, sort and paginate data in APIs.
A quick taste of SeaORM
Entity
use *;
Select
// find all models
let cakes: = find.all.await?;
// find and filter
let chocolate: = find
.filter
.all
.await?;
// find one model
let cheese: = find_by_id.one.await?;
let cheese: Model = cheese.unwrap;
// find related models (lazy)
let fruits: = cheese.find_related.all.await?;
// find related models (eager)
let cake_with_fruits: =
find.find_with_related.all.await?;
Insert
let apple = ActiveModel ;
let pear = ActiveModel ;
// insert one
let pear = pear.insert.await?;
// insert many
insert_many.exec.await?;
Update
use ;
let pear: = find_by_id.one.await?;
let mut pear: ActiveModel = pear.unwrap.into;
pear.name = Set;
// update one
let pear: Model = pear.update.await?;
// update many: UPDATE "fruit" SET "cake_id" = NULL WHERE "fruit"."name" LIKE '%Apple%'
update_many
.col_expr
.filter
.exec
.await?;
Save
let banana = ActiveModel ;
// create, because primary key `id` is `NotSet`
let mut banana = banana.save.await?;
banana.name = Set;
// update, because primary key `id` is `Set`
let banana = banana.save.await?;
Delete
// delete one
let orange: = find_by_id.one.await?;
let orange: Model = orange.unwrap;
delete
.exec
.await?;
// or simply
let orange: = find_by_id.one.await?;
let orange: Model = orange.unwrap;
orange.delete.await?;
// delete many: DELETE FROM "fruit" WHERE "fruit"."name" LIKE 'Orange'
delete_many
.filter
.exec
.await?;
Learn More
Who's using SeaORM?
The following products are powered by SeaORM:
SeaORM is the foundation of:
- StarfishQL: an experimental graph database
- Seaography: GraphQL framework for SeaORM
For more projects, see Built with SeaORM.
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.
SeaORM is a community driven project. We welcome you to participate, contribute and together help build Rust's future.
A big shout out to our contributors:
Mascot
A friend of Ferris, Terres the hermit crab is the official mascot of SeaORM. His hobby is collecting shells.