sea-orm 2.0.0

🐚 An async & dynamic ORM for Rust
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112

#![allow(unused_imports, dead_code)]

pub mod common;

pub use common::{TestContext, features::*, setup::*};
use pretty_assertions::assert_eq;
use sea_orm::{DatabaseConnection, entity::prelude::*, entity::*};
use serde_json::json;

#[sea_orm_macros::test]
async fn main() -> Result<(), DbErr> {
    let ctx = TestContext::new("bakery_chain_uuid_tests").await;
    create_metadata_table(&ctx.db).await?;
    create_and_update_metadata(&ctx.db).await?;
    insert_metadata(&ctx.db).await?;
    ctx.delete().await;

    Ok(())
}

pub async fn insert_metadata(db: &DatabaseConnection) -> Result<(), DbErr> {
    let metadata = metadata::Model {
        uuid: Uuid::new_v4(),
        ty: "Type".to_owned(),
        key: "markup".to_owned(),
        value: "1.18".to_owned(),
        bytes: vec![1, 2, 3],
        date: Some(Date::from_ymd_opt(2021, 9, 27).unwrap()),
        time: Some(Time::from_hms_opt(11, 32, 55).unwrap()),
    };

    let result = metadata.clone().into_active_model().insert(db).await?;

    assert_eq!(result, metadata);

    let mut json = metadata::Entity::find()
        .filter(metadata::Column::Uuid.eq(metadata.uuid))
        .into_json()
        .one(db)
        .await?;

    #[cfg(feature = "rusqlite")]
    {
        json.as_mut()
            .unwrap()
            .as_object_mut()
            .unwrap()
            .remove("uuid");
        // rusqlite current has no rich type info to properly deserialize a uuid
        assert_eq!(
            json,
            Some(json!({
                "type": metadata.ty,
                "key": metadata.key,
                "value": metadata.value,
                "bytes": metadata.bytes,
                "date": metadata.date,
                "time": metadata.time,
            }))
        );
    }
    #[cfg(not(feature = "rusqlite"))]
    {
        assert_eq!(
            json,
            Some(json!({
                "uuid": metadata.uuid,
                "type": metadata.ty,
                "key": metadata.key,
                "value": metadata.value,
                "bytes": metadata.bytes,
                "date": metadata.date,
                "time": metadata.time,
            }))
        );
    }

    Ok(())
}

pub async fn create_and_update_metadata(db: &DatabaseConnection) -> Result<(), DbErr> {
    let metadata = metadata::Model {
        uuid: Uuid::new_v4(),
        ty: "Type".to_owned(),
        key: "markup".to_owned(),
        value: "1.18".to_owned(),
        bytes: vec![1, 2, 3],
        date: Some(Date::from_ymd_opt(2021, 9, 27).unwrap()),
        time: Some(Time::from_hms_opt(11, 32, 55).unwrap()),
    };

    let res = Metadata::insert(metadata.clone().into_active_model())
        .exec(db)
        .await?;

    assert_eq!(Metadata::find().one(db).await?, Some(metadata.clone()));

    assert_eq!(res.last_insert_id, metadata.uuid);

    let update_res = Metadata::update(metadata::ActiveModel {
        value: Set("0.22".to_owned()),
        ..metadata.clone().into_active_model()
    })
    .validate()?
    .filter(metadata::Column::Uuid.eq(Uuid::default()))
    .exec(db)
    .await;

    assert_eq!(update_res, Err(DbErr::RecordNotUpdated));

    Ok(())
}