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

#[cfg(test)]
mod bool_expr_tests {
    use rust_ef::provider::DbValue;
    use rust_ef::query::{BoolExpr, FilterCondition, QueryState};

    #[test]
    fn test_and_or_combination_sql() {
        let mut state = QueryState::new("items");
        state.parameters.push(DbValue::I32(1));
        state.parameters.push(DbValue::I32(2));
        state.parameters.push(DbValue::I32(3));
        state.where_expr = Some(
            BoolExpr::Filter(FilterCondition::new("a", "=", 1))
                .and(BoolExpr::Or(
                    Box::new(BoolExpr::Filter(FilterCondition::new("a", "=", 1))),
                    Box::new(BoolExpr::Filter(FilterCondition::new("a", "=", 1))),
                ))
                .and(BoolExpr::Filter(FilterCondition::new("b", ">", 1))),
        );
        let sql = state.to_sql();
        assert!(sql.contains("WHERE"));
        assert!(sql.contains("AND"));
        assert!(sql.contains("OR"));
        assert!(sql.contains("b"));
    }

    #[test]
    fn test_not_filter_sql() {
        let mut state = QueryState::new("items");
        state.parameters.push(DbValue::I32(5));
        state.where_expr = Some(BoolExpr::Not(Box::new(BoolExpr::Filter(
            FilterCondition::new("status", "=", 1),
        ))));
        let sql = state.to_sql();
        assert!(sql.contains("NOT"));
        assert!(sql.contains("status"));
    }

    #[test]
    fn test_filter_in_placeholders() {
        use rust_ef::entity::IEntityType;
        struct Item;
        impl IEntityType for Item {
            fn entity_meta() -> rust_ef::metadata::EntityTypeMeta {
                unimplemented!()
            }
        }
        let sql = rust_ef::query::QueryBuilder::<Item>::new("items")
            .filter_in(
                "id",
                vec![
                    rust_ef::provider::DbValue::I32(1),
                    rust_ef::provider::DbValue::I32(2),
                    rust_ef::provider::DbValue::I32(3),
                ],
            )
            .to_sql();
        assert!(sql.contains("IN"));
        assert!(sql.contains("?, ?, ?"));
    }

    #[test]
    fn test_complex_or_and_pattern() {
        let mut state = QueryState::new("posts");
        state.parameters.push(DbValue::I32(3));
        state.parameters.push(DbValue::I32(1));
        state.where_expr = Some(
            BoolExpr::Filter(FilterCondition::new("rating", ">", 1))
                .or(BoolExpr::Filter(FilterCondition::new("featured", "=", 1))),
        );
        let sql = state.to_sql();
        assert!(sql.contains("OR"));
        assert!(sql.contains("rating"));
        assert!(sql.contains("featured"));
    }
}