qail-core 0.28.0

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

use qail_core::ast::*;
use qail_core::parse;

#[test]
fn test_comments_and_whitespace() {
    let query = r#"
        get users
        fields *
        where active = true
        order by created_at desc
    "#;

    let cmd = parse(query).expect("Failed to parse query with comments");
    assert_eq!(cmd.action, Action::Get);
    assert_eq!(cmd.table, "users");
    assert_eq!(cmd.columns, vec![Expr::Star]);
    assert!(!cmd.cages.is_empty());
}

#[test]
fn test_inline_comments_in_cages() {
    let query = r#"
        get users fields *
        where active = true and role = 'admin'
    "#;

    let cmd = parse(query).expect("Failed to parse inline conditions");
    assert!(!cmd.cages.is_empty());
    // Both conditions parsed
    let cage = &cmd.cages[0];
    assert!(!cage.conditions.is_empty());
}

#[test]
fn test_multiline_query() {
    // Test that multiline works properly
    let query = "get users fields id, email where id = $1";
    let cmd = parse(query).expect("Failed to parse query");
    assert_eq!(cmd.columns.len(), 2);
}