iridium_core 0.1.12

SQL Server-compatible Rust engine core for Iridium SQL
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

use iridium_core::{parse_sql, Engine};

fn query(engine: &mut Engine, sql: &str) -> iridium_core::QueryResult {
    let stmt = parse_sql(sql).unwrap_or_else(|_| panic!("parse failed: {}", sql));
    engine
        .execute(stmt)
        .unwrap_or_else(|_| panic!("execute failed: {}", sql))
        .expect("expected result")
}

#[test]
fn test_string_split_no_match() {
    let mut e = Engine::new();

    let r = query(&mut e, "SELECT * FROM STRING_SPLIT('abc', ',')");
    assert_eq!(r.rows.len(), 1);
}

#[test]
fn test_string_split_comma_separator() {
    let mut e = Engine::new();

    let r = query(&mut e, "SELECT * FROM STRING_SPLIT('a,b,c', ',')");
    assert_eq!(r.rows.len(), 3);
    assert_eq!(
        r.rows[0][0],
        iridium_core::types::Value::VarChar("a".into())
    );
    assert_eq!(
        r.rows[1][0],
        iridium_core::types::Value::VarChar("b".into())
    );
    assert_eq!(
        r.rows[2][0],
        iridium_core::types::Value::VarChar("c".into())
    );
}

#[test]
fn test_string_split_pipe_separator() {
    let mut e = Engine::new();

    let r = query(&mut e, "SELECT * FROM STRING_SPLIT('x|y|z', '|')");
    assert_eq!(r.rows.len(), 3);
}

#[test]
fn test_string_split_multi_char_separator() {
    let mut e = Engine::new();

    let r = query(&mut e, "SELECT * FROM STRING_SPLIT('a::b::c', '::')");
    assert_eq!(r.rows.len(), 3);
}

#[test]
fn test_string_split_with_alias() {
    let mut e = Engine::new();

    let r = query(&mut e, "SELECT s.value FROM STRING_SPLIT('a,b', ',') AS s");
    assert_eq!(r.rows.len(), 2);
}

#[test]
fn test_string_split_ordinal_disabled() {
    let mut e = Engine::new();

    let r = query(&mut e, "SELECT value FROM STRING_SPLIT('a,b,c', ',', 0)");
    assert_eq!(r.columns.len(), 1);
    assert_eq!(r.columns[0], "value");
    assert_eq!(r.rows.len(), 3);
}

#[test]
fn test_string_split_ordinal_enabled() {
    let mut e = Engine::new();

    let r = query(
        &mut e,
        "SELECT value, ordinal FROM STRING_SPLIT('a,b,c', ',', 1)",
    );
    assert_eq!(r.columns.len(), 2);
    assert_eq!(r.columns[0], "value");
    assert_eq!(r.columns[1], "ordinal");
    assert_eq!(r.rows.len(), 3);

    assert_eq!(
        r.rows[0][0],
        iridium_core::types::Value::VarChar("a".into())
    );
    assert_eq!(r.rows[0][1], iridium_core::types::Value::Int(1));

    assert_eq!(
        r.rows[1][0],
        iridium_core::types::Value::VarChar("b".into())
    );
    assert_eq!(r.rows[1][1], iridium_core::types::Value::Int(2));

    assert_eq!(
        r.rows[2][0],
        iridium_core::types::Value::VarChar("c".into())
    );
    assert_eq!(r.rows[2][1], iridium_core::types::Value::Int(3));
}

#[test]
fn test_string_split_ordinal_only() {
    let mut e = Engine::new();

    let r = query(&mut e, "SELECT ordinal FROM STRING_SPLIT('x|y', '|', 1)");
    assert_eq!(r.columns.len(), 1);
    assert_eq!(r.columns[0], "ordinal");
    assert_eq!(r.rows.len(), 2);
    assert_eq!(r.rows[0][0], iridium_core::types::Value::Int(1));
    assert_eq!(r.rows[1][0], iridium_core::types::Value::Int(2));
}