rust-ef 1.7.0

Rust Entity Framework - An EFCore-inspired 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
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136

//! Cascade save tests: self-referential tree insert and cascade delete.

mod common;

use common::*;
use rust_ef::db_context::{DbContext, DbContextOptionsBuilder};
use rust_ef::prelude::*;
use rust_ef_sqlite::DbContextOptionsBuilderExt as _;

#[tokio::test]
async fn cascade_insert_self_referential_tree() {
    let mut builder = DbContextOptionsBuilder::new();
    builder.use_sqlite_in_memory();
    let options = builder.build();
    let mut ctx = DbContext::from_options(&options).unwrap();

    ctx.set::<CascadeCategory>();
    ctx.ensure_created().await.unwrap();

    let root = CascadeCategory {
        category_id: 0,
        name: "Root".into(),
        parent_id: 0,
        children: HasMany::with(vec![
            CascadeCategory {
                category_id: 0,
                name: "Child A".into(),
                parent_id: 0,
                children: HasMany::new(),
            },
            CascadeCategory {
                category_id: 0,
                name: "Child B".into(),
                parent_id: 0,
                children: HasMany::new(),
            },
        ]),
    };
    ctx.set::<CascadeCategory>().add(root);
    ctx.save_changes().await.unwrap();

    let categories = ctx
        .set::<CascadeCategory>()
        .query()
        .to_list()
        .await
        .unwrap();
    assert_eq!(categories.len(), 3, "Root + 2 children");

    let root = categories
        .iter()
        .find(|c| c.name == "Root")
        .expect("Root should exist");
    assert!(root.category_id > 0, "Root PK should be backfilled");

    let children: Vec<&CascadeCategory> = categories
        .iter()
        .filter(|c| c.name == "Child A" || c.name == "Child B")
        .collect();
    assert_eq!(children.len(), 2);
    for child in &children {
        assert_eq!(
            child.parent_id, root.category_id,
            "Child parent_id should be fixed up via self-ref UPDATE"
        );
    }
}

#[tokio::test]
async fn cascade_delete_self_referential() {
    let mut builder = DbContextOptionsBuilder::new();
    builder.use_sqlite_in_memory();
    let options = builder.build();
    let mut ctx = DbContext::from_options(&options).unwrap();

    ctx.set::<CascadeCategory>();
    ctx.ensure_created().await.unwrap();

    let root = CascadeCategory {
        category_id: 0,
        name: "Root".into(),
        parent_id: 0,
        children: HasMany::with(vec![
            CascadeCategory {
                category_id: 0,
                name: "Child A".into(),
                parent_id: 0,
                children: HasMany::new(),
            },
            CascadeCategory {
                category_id: 0,
                name: "Child B".into(),
                parent_id: 0,
                children: HasMany::new(),
            },
        ]),
    };
    ctx.set::<CascadeCategory>().add(root);
    ctx.save_changes().await.unwrap();

    // Re-query with include to populate children, then mark Deleted
    ctx.set::<CascadeCategory>().clear_entries();
    let loaded = ctx
        .set::<CascadeCategory>()
        .query()
        .include_internal("children")
        .to_list()
        .await
        .unwrap();
    let root_loaded = loaded
        .iter()
        .find(|c| c.name == "Root")
        .expect("Root should exist");
    assert_eq!(
        root_loaded.children.len(),
        2,
        "Children should be loaded via include"
    );

    let root_idx = loaded.iter().position(|c| c.name == "Root").unwrap();
    let root_entity = loaded.into_iter().nth(root_idx).unwrap();
    ctx.set::<CascadeCategory>().attach(root_entity);
    ctx.set::<CascadeCategory>().remove_at(0).unwrap();
    ctx.save_changes().await.unwrap();

    let categories = ctx
        .set::<CascadeCategory>()
        .query()
        .to_list()
        .await
        .unwrap();
    assert!(
        categories.is_empty(),
        "All categories should be deleted (cascade)"
    );
}