ormer 0.2.10

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

#![cfg(any(feature = "clickhouse", feature = "questdb"))]

use ormer::{DbType, OrmerError, Select};

#[derive(Debug, ormer::Model)]
#[table = "subquery_gate_users"]
struct SubqueryGateUser {
    #[primary]
    id: i32,
    profile: serde_json::Value,
}

#[test]
fn unsupported_inner_subquery_expression_is_propagated() {
    #[cfg(feature = "clickhouse")]
    let backend = DbType::ClickHouse;
    #[cfg(all(feature = "questdb", not(feature = "clickhouse")))]
    let backend = DbType::QuestDB;

    let error = Select::<SubqueryGateUser>::new()
        .filter(|user| {
            user.id.is_in(
                Select::<SubqueryGateUser>::new()
                    .filter(|user| {
                        user.profile
                            .json_contains(serde_json::json!({ "role": "admin" }))
                    })
                    .map_to(|user| user.id),
            )
        })
        .try_to_sql_with_params(backend)
        .expect_err("inner subquery capabilities must be validated");

    assert!(matches!(
        error,
        OrmerError::UnsupportedFeature {
            feature: "JSON containment predicates",
            ..
        }
    ));
}