sea-orm-sync 2.0.0-rc.40

🐚 The sync version of SeaORM
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

#![allow(unused_imports, dead_code)]

pub mod common;
pub use common::{TestContext, features::*, setup::*};
use sea_orm::{DatabaseConnection, IntoActiveModel, entity::prelude::*};

#[sea_orm_macros::test]
fn main() -> Result<(), DbErr> {
    let ctx = TestContext::new("delete_by_id_tests");
    create_log_table(&ctx.db)?;
    create_and_delete_applog(&ctx.db)?;

    ctx.delete();

    Ok(())
}

pub fn create_and_delete_applog(db: &DatabaseConnection) -> Result<(), DbErr> {
    let log1 = applog::Model {
        id: 1,
        action: "Testing".to_owned(),
        json: Json::String("HI".to_owned()),
        created_at: "2021-09-17T17:50:20+08:00".parse().unwrap(),
    };

    Applog::insert(log1.clone().into_active_model()).exec(db)?;

    let log2 = applog::Model {
        id: 2,
        action: "Tests".to_owned(),
        json: Json::String("HELLO".to_owned()),
        created_at: "2022-09-17T17:50:20+08:00".parse().unwrap(),
    };

    Applog::insert(log2.clone().into_active_model()).exec(db)?;

    let delete_res = Applog::delete_by_id(2).exec(db)?;
    assert_eq!(delete_res.rows_affected, 1);

    let find_res = Applog::find_by_id(1).all(db)?;
    assert_eq!(find_res, [log1]);

    let find_res = Applog::find_by_id(2).all(db)?;
    assert_eq!(find_res, []);

    let delete_res = Applog::delete_by_id(3).exec(db)?;
    assert_eq!(delete_res.rows_affected, 0);

    Ok(())
}