sea orm下載 - sea orm源代碼下載

sea orm

其他源碼

1.1.3

下載

海洋

？生鏽的異步和動態ORM

海洋

SEAORM是一種關係ORM，可以幫助您熟悉動態語言的熟悉，以生鏽的形式構建Web服務。

如果您喜歡我們的工作，請考慮主演，分享和貢獻！

請通過完成2024年SEAQL社區調查來幫助我們維護海洋公司！

加入我們的Discord服務器，與Seaql社區的其他成員聊天！

入門

文件
教程
食譜

集成示例：

Actix V4示例
斧頭示例
GraphQl示例
JSONRPSEE示例
Loco todo榜樣 /機車休息起動器
詩例
火箭示例 /火箭openapi示例
Salvo示例
補品示例
Seaography示例

特徵

異步
依靠SQLX，Seaorm是一個新圖書館，並從第1天開始提供異步支持。
動態的
Seaorm建立在海格（Seaquery）上，可讓您構建複雜的動態查詢。
可測試
使用模擬連接和/或SQLite為您的應用程序邏輯編寫測試。
面向服務
快速構建連接，過濾，分類和分頁的服務中REST，GraphQL和GRPC API的服務。

快速味道

實體

 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 ( )
    }
}

選擇

 // find all models
let cakes : Vec < cake :: Model > = Cake :: find ( ) . all ( db ) . await ? ;

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

// find one model
let 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 ? ;

插入

 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 ( [ apple , pear ] ) . exec ( db ) . await ? ;

更新

 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 one
let 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 ? ;

節省

 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 one
let 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 simply
let 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 ? ;