cratestack-sqlx 0.3.6

Rust-native schema-first framework for typed HTTP APIs, generated clients, and backend services.
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

#![cfg(test)]

use crate::{FieldRef, render::render_filter_expr_sql};

#[test]
fn json_has_key_renders_question_operator_with_one_bind() {
    let filter = FieldRef::<(), serde_json::Value>::new("metrics").json_has_key("loss");
    let mut bind_index = 1usize;
    let mut sql = String::new();
    render_filter_expr_sql(&filter, &mut sql, &mut bind_index);
    assert_eq!(sql, "metrics ? $1");
    assert_eq!(bind_index, 2);
}

#[test]
fn json_get_text_eq_renders_arrow_arrow_operator() {
    let filter = FieldRef::<(), serde_json::Value>::new("metrics")
        .json_get_text("loss")
        .eq("0.001");
    let mut bind_index = 1usize;
    let mut sql = String::new();
    render_filter_expr_sql(&filter, &mut sql, &mut bind_index);
    assert_eq!(sql, "metrics ->> $1 = $2");
    assert_eq!(bind_index, 3);
}

#[test]
fn json_get_text_is_not_null_renders_no_value_bind() {
    let filter = FieldRef::<(), serde_json::Value>::new("metrics")
        .json_get_text("loss")
        .is_not_null();
    let mut bind_index = 1usize;
    let mut sql = String::new();
    render_filter_expr_sql(&filter, &mut sql, &mut bind_index);
    assert_eq!(sql, "metrics ->> $1 IS NOT NULL");
    assert_eq!(bind_index, 2, "only the key consumes a bind slot");
}