Your Web News in One Place

Help Webnuz

Referal links:

Sign up for GreenGeeks web hosting
February 15, 2022 03:01 pm GMT

An async & dynamic ORM for Rust!

SeaORM

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

Getting Started

GitHub stars If you like what we do, consider starring, commenting, sharing and contributing!

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

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

use sea_orm::entity::prelude::*;#[derive(Clone, Debug, PartialEq, DeriveEntityModel)]#[sea_orm(table_name = "cake")]pub struct Model {    #[sea_orm(primary_key)]    pub id: i32,    pub name: String,}#[derive(Copy, Clone, Debug, EnumIter, DeriveRelation)]pub enum Relation {    #[sea_orm(has_many = "super::fruit::Entity")]    Fruit,}impl Related<super::fruit::Entity> for Entity {    fn to() -> RelationDef {        Relation::Fruit.def()    }}

Select

// find all modelslet cakes: Vec<cake::Model> = Cake::find().all(db).await?;// find and filterlet chocolate: Vec<cake::Model> = Cake::find()    .filter(cake::Column::Name.contains("chocolate"))    .all(db)    .await?;// find one modellet cheese: Option<cake::Model> = Cake::find_by_id(1).one(db).await?;let cheese: cake::Model = cheese.unwrap();// find related models (lazy)let fruits: Vec<fruit::Model> = cheese.find_related(Fruit).all(db).await?;// find related models (eager)let cake_with_fruits: Vec<(cake::Model, Vec<fruit::Model>)> =    Cake::find().find_with_related(Fruit).all(db).await?;

Insert

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 onelet pear = pear.insert(db).await?;// insert manyFruit::insert_many(vec![apple, pear]).exec(db).await?;

Update

use sea_orm::sea_query::{Expr, Value};let pear: Option<fruit::Model> = Fruit::find_by_id(1).one(db).await?;let mut pear: fruit::ActiveModel = pear.unwrap().into();pear.name = Set("Sweet pear".to_owned());// update onelet pear: fruit::Model = pear.update(db).await?;// update many: UPDATE "fruit" SET "cake_id" = NULL WHERE "fruit"."name" LIKE '%Apple%'Fruit::update_many()    .col_expr(fruit::Column::CakeId, Expr::value(Value::Int(None)))    .filter(fruit::Column::Name.contains("Apple"))    .exec(db)    .await?;

Save

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

// delete onelet orange: Option<fruit::Model> = Fruit::find_by_id(1).one(db).await?;let orange: fruit::Model = orange.unwrap();fruit::Entity::delete(orange.into_active_model())    .exec(db)    .await?;// or simplylet orange: Option<fruit::Model> = Fruit::find_by_id(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

Original Link: https://dev.to/billy1624/an-async-dynamic-orm-for-rust-4l36

Share this article:    Share on Facebook
View Full Article

Dev To

An online community for sharing and discovering great ideas, having debates, and making friends

More About this Source Visit Dev To