ormer 0.2.3

A minimalist ORM framework that supports SQLite, PostgreSQL, MySQL, and SqlServer
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

#![cfg(feature = "sqlite")]

use ormer::{DbType, UpdateFields, Value};

#[derive(Debug, Clone, PartialEq, ormer::Model)]
#[table = "json_array_dsl_users"]
struct JsonArrayUser {
    #[primary]
    id: i32,
    profile: serde_json::Value,
    tags: Vec<String>,
}

#[test]
fn json_and_array_filter_dsl_renders_sql_and_params() {
    let (sql, params) = ormer::Select::<JsonArrayUser>::new()
        .filter(|u| {
            u.profile
                .json_contains(serde_json::json!({ "role": "admin" }))
        })
        .filter(|u| u.profile.json_path_text(["account", "role"]).eq("admin"))
        .filter(|u| u.tags.overlaps(["ops", "admin"]))
        .filter(|u| u.tags.contains_all(["ops"]))
        .filter(|u| u.tags.len().gt(1))
        .to_sql_with_params(DbType::Sqlite);

    assert!(sql.contains("json_type(profile) IS NOT NULL"), "SQL: {sql}");
    assert!(
        sql.contains("json_extract(profile, '$.account.role') = ?"),
        "SQL: {sql}"
    );
    assert!(
        sql.contains("json_each(tags)") && sql.contains("json_array_length(tags) > ?"),
        "SQL: {sql}"
    );
    assert_eq!(params.len(), 5);
    assert!(matches!(params[0], Value::Json(_)));
    assert_text_param(&params[1], "admin");
    assert_text_array_param(&params[2], &["ops", "admin"]);
    assert_text_array_param(&params[3], &["ops"]);
    assert_integer_param(&params[4], 1);
}

fn assert_text_param(value: &Value, expected: &str) {
    match value {
        Value::Text(value) => assert_eq!(value, expected),
        other => panic!("expected text parameter, got {other:?}"),
    }
}

fn assert_text_array_param(value: &Value, expected: &[&str]) {
    match value {
        Value::TextArray(values) => {
            assert_eq!(
                values,
                &expected
                    .iter()
                    .map(|value| value.to_string())
                    .collect::<Vec<_>>()
            );
        }
        other => panic!("expected text array parameter, got {other:?}"),
    }
}

fn assert_integer_param(value: &Value, expected: i64) {
    match value {
        Value::Integer(value) => assert_eq!(*value, expected),
        other => panic!("expected integer parameter, got {other:?}"),
    }
}

#[test]
fn json_set_update_dsl_renders_sql_and_params() {
    let (sql, params) =
        ormer::abstract_layer::common::common_helpers::build_update_sql::<JsonArrayUser>(
            DbType::Sqlite,
            &{
                let mut update = <JsonArrayUser as ormer::Model>::Update::default();
                update.profile = update
                    .profile
                    .json_set("last_login", serde_json::json!("2026-08-13T00:00:00Z"));
                update.assignments()
            },
            &[],
        )
        .expect("update SQL renders");

    assert!(
        sql.contains(
            "UPDATE json_array_dsl_users SET profile = json_set(profile, '$.last_login', ?)"
        ),
        "SQL: {sql}"
    );
    assert_eq!(params.len(), 1);
    assert!(matches!(params[0], Value::Json(_)));
}