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

use iridium_core::{parse_sql, Engine};

fn exec(engine: &mut Engine, sql: &str) {
    let stmt = parse_sql(sql).unwrap_or_else(|_| panic!("parse failed: {}", sql));
    engine
        .execute(stmt)
        .unwrap_or_else(|_| panic!("execute failed: {}", sql));
}

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_sys_foreign_keys_empty() {
    let mut e = Engine::new();
    exec(&mut e, "CREATE TABLE t (id INT PRIMARY KEY)");

    let r = query(
        &mut e,
        "SELECT * FROM sys.foreign_keys WHERE parent_object_id = 9999",
    );
    println!("test_sys_foreign_keys_empty: {:?}", r);
    assert_eq!(r.rows.len(), 0);
}

#[test]
fn test_sys_foreign_keys_viewable() {
    let mut e = Engine::new();
    // Note: Inline FK not supported in parser, so we'll skip FK tables
    // The sys.foreign_keys view should at least be queryable
    let r = query(&mut e, "SELECT name, type, type_desc FROM sys.foreign_keys");
    println!("test_sys_foreign_keys_viewable: {:?}", r);
    // Should return empty result, not an error
}