qail-core 1.3.1

AST-native query builder - type-safe expressions, zero SQL strings
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

#![allow(unused_imports)]
use crate::ast::*;
use crate::parser::parse;

#[test]
fn test_index_basic() {
    let q = "index idx_users_email on users email";
    let cmd = parse(q).unwrap();

    assert_eq!(cmd.action, Action::Index);
    let idx = cmd.index_def.expect("index_def should be Some");
    assert_eq!(idx.name, "idx_users_email");
    assert_eq!(idx.table, "users");
    assert_eq!(idx.columns, vec!["email".to_string()]);
    assert!(!idx.unique);
}

#[test]
fn test_index_composite() {
    let q = "index idx_lookup on orders user_id, created_at";
    let cmd = parse(q).unwrap();

    assert_eq!(cmd.action, Action::Index);
    let idx = cmd.index_def.expect("index_def should be Some");
    assert_eq!(idx.name, "idx_lookup");
    assert_eq!(idx.table, "orders");
    assert_eq!(
        idx.columns,
        vec!["user_id".to_string(), "created_at".to_string()]
    );
}

#[test]
fn test_index_unique() {
    let q = "index idx_phone on users phone unique";
    let cmd = parse(q).unwrap();

    assert_eq!(cmd.action, Action::Index);
    let idx = cmd.index_def.expect("index_def should be Some");
    assert_eq!(idx.name, "idx_phone");
    assert!(idx.unique);
}

#[test]
fn test_index_rejects_malformed_identifiers() {
    for query in [
        "index 1idx on users email",
        "index .idx on users email",
        "index idx. on users email",
        "index idx on 1users email",
        "index idx on .users email",
        "index idx on users. email",
        "index idx on users .email",
        "index idx on users email.",
        "index idx on users email, .tenant_id",
    ] {
        assert!(
            parse(query).is_err(),
            "malformed index identifier parsed: {query}"
        );
    }
}