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

use qail_core::{parse, transpiler::ToSqlParameterized};

fn main() {
    let query = "get t fields coalesce(uc.unread_count, 0) as unread_count";

    match parse(query) {
        Ok(cmd) => {
            let res = cmd.to_sql_parameterized();
            println!("SQL: {}", res.sql);
            if res
                .sql
                .contains("coalesce(uc.unread_count, 0) AS \"unread_count\"")
                || res
                    .sql
                    .contains("COALESCE(uc.unread_count, 0) AS \"unread_count\"")
                || res
                    .sql
                    .contains("coalesce(uc.unread_count, 0) AS unread_count")
                || res
                    .sql
                    .contains("COALESCE(uc.unread_count, 0) AS unread_count")
            {
                println!("SUCCESS: Alias found correctly.");
            } else {
                println!("FAILURE: Alias missing in parameterized SQL.");
                std::process::exit(1);
            }
        }
        Err(e) => {
            eprintln!("Parse error: {}", e);
            std::process::exit(1);
        }
    }
}