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_batch, parse_sql, types::Value, Engine};

fn exec(engine: &mut Engine, sql: &str) {
    engine.exec(sql).expect(sql);
}

fn query(engine: &mut Engine, sql: &str) -> iridium_core::QueryResult {
    engine.query(sql).expect(sql)
}

#[test]
fn parser_bracket_delimited_identifiers() {
    let mut e = Engine::new();
    exec(
        &mut e,
        "CREATE TABLE [dbo].[my table] ([my column] INT, [another col] NVARCHAR(50))",
    );
    exec(
        &mut e,
        "INSERT INTO [dbo].[my table] ([my column], [another col]) VALUES (1, N'test')",
    );

    let r = query(
        &mut e,
        "SELECT [my column], [another col] FROM [dbo].[my table]",
    );
    assert_eq!(r.rows[0][0], Value::Int(1));
    assert_eq!(r.rows[0][1].to_string_value(), "test");
}

#[test]
fn parser_semicolon_separated_statements() {
    let stmts = parse_batch("SELECT 1; SELECT 2; SELECT 3").unwrap();
    assert_eq!(stmts.len(), 3);
}

#[test]
fn parser_go_separator() {
    let stmts = parse_batch("SELECT 1 GO SELECT 2 GO").unwrap();
    assert_eq!(stmts.len(), 2);
}

#[test]
fn parser_empty_statements_ignored() {
    let stmts = parse_batch("SELECT 1; ; ; SELECT 2").unwrap();
    assert_eq!(stmts.len(), 2);
}

#[test]
fn parser_line_comment_mid_statement() {
    let mut e = Engine::new();
    let r = query(&mut e, "SELECT 1 -- this is a comment\n + 2");
    assert_eq!(r.rows[0][0], Value::BigInt(3));
}

#[test]
fn parser_block_comment() {
    let mut e = Engine::new();
    let r = query(&mut e, "SELECT /* block comment */ 1 + /* another */ 2");
    assert_eq!(r.rows[0][0], Value::BigInt(3));
}

#[test]
fn parser_trailing_whitespace_and_newlines() {
    let stmt = parse_sql("SELECT 1   \n\n  \t  ");
    assert!(stmt.is_ok());
}

#[test]
fn parser_unicode_string_literal() {
    let mut e = Engine::new();
    let r = query(&mut e, "SELECT N'caf\u{e9}'");
    assert_eq!(r.rows[0][0].to_string_value(), "caf\u{e9}");
}

#[test]
fn parser_nested_parentheses() {
    let mut e = Engine::new();
    let r = query(&mut e, "SELECT ((1 + 2) * (3 + 4))");
    assert_eq!(r.rows[0][0], Value::BigInt(21));
}

#[test]
fn parser_case_insensitive_keywords() {
    let mut e = Engine::new();
    let r = query(&mut e, "sElEcT 1 + 2 aS result");
    assert_eq!(r.rows[0][0], Value::BigInt(3));
    assert_eq!(r.columns[0], "result");
}

#[test]
fn parser_string_with_escaped_quotes() {
    let mut e = Engine::new();
    let r = query(&mut e, "SELECT 'it''s a test'");
    assert_eq!(r.rows[0][0].to_string_value(), "it's a test");
}

#[test]
fn parser_select_with_column_alias() {
    let mut e = Engine::new();
    let r = query(&mut e, "SELECT 42 AS the_answer");
    assert_eq!(r.columns[0], "the_answer");
    assert_eq!(r.rows[0][0], Value::Int(42));
}

#[test]
fn parser_use_statement_and_session_database_switch() {
    let stmts = parse_batch("USE [iridium_sql]; SELECT DB_NAME()").unwrap();
    assert_eq!(stmts.len(), 2);

    let mut e = Engine::new();
    exec(&mut e, "USE [iridium_sql]");
    let r = query(&mut e, "SELECT DB_NAME()");
    assert_eq!(r.rows[0][0], Value::NVarChar("iridium_sql".to_string()));
}