spg-engine 7.11.18

Execution engine for SPG: glues spg-sql parsing to spg-storage. Foreign keys, joins, vectors, cold tier.
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

//! v7.9.16 — F4: column named `key` works (post-F1 + F4 sweep).

use spg_engine::{Engine, QueryResult};

#[test]
fn bare_key_as_column_name_in_create_table() {
    let mut eng = Engine::new();
    let r = eng.execute("CREATE TABLE t1 (key TEXT)");
    assert!(matches!(r, Ok(QueryResult::CommandOk { .. })), "{r:?}");
}

#[test]
fn bare_key_with_primary_key_constraint() {
    // mailrs greylist_triplets pattern.
    let mut eng = Engine::new();
    let r = eng.execute("CREATE TABLE greylist (key TEXT PRIMARY KEY)");
    assert!(matches!(r, Ok(QueryResult::CommandOk { .. })), "{r:?}");
}

#[test]
fn quoted_key_as_column_name() {
    let mut eng = Engine::new();
    let r = eng.execute(r#"CREATE TABLE t3 ("key" TEXT)"#);
    assert!(matches!(r, Ok(QueryResult::CommandOk { .. })), "{r:?}");
}

#[test]
fn quoted_key_with_primary_key() {
    let mut eng = Engine::new();
    let r = eng.execute(r#"CREATE TABLE t4 ("key" TEXT PRIMARY KEY)"#);
    assert!(matches!(r, Ok(QueryResult::CommandOk { .. })), "{r:?}");
}

#[test]
fn key_column_insert_and_select() {
    let mut eng = Engine::new();
    eng.execute("CREATE TABLE config (key TEXT PRIMARY KEY, value TEXT)")
        .unwrap();
    eng.execute("INSERT INTO config VALUES ('host', 'localhost')")
        .unwrap();
    let r = eng
        .execute("SELECT value FROM config WHERE key = 'host'")
        .unwrap();
    let QueryResult::Rows { rows, .. } = r else {
        panic!()
    };
    assert_eq!(rows.len(), 1);
}