qail-core 1.2.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

//! SQL Dialect tests.

use crate::ast::{Action, Expr, Qail};
use crate::parser::parse;
use crate::transpiler::{Dialect, ToSql};

#[test]
fn test_sqlite_dialect() {
    let cmd = parse("get users fields * where active = true").unwrap();
    assert_eq!(
        cmd.to_sql_with_dialect(Dialect::SQLite),
        "SELECT * FROM \"users\" WHERE \"active\" = 1"
    );

    let cmd_fuzzy = parse("get users fields * where name ~ $1").unwrap();
    assert_eq!(
        cmd_fuzzy.to_sql_with_dialect(Dialect::SQLite),
        "SELECT * FROM \"users\" WHERE \"name\" LIKE '%' || ? || '%'"
    );
}

#[test]
fn sqlite_identifier_quoting_escapes_embedded_quotes() {
    let cmd = Qail {
        action: Action::Get,
        table: "users\"; DROP TABLE audit; --".to_string(),
        columns: vec![Expr::Named("na\"me".to_string())],
        ..Default::default()
    };

    assert_eq!(
        cmd.to_sql_with_dialect(Dialect::SQLite),
        "SELECT \"na\"\"me\" FROM \"users\"\"; DROP TABLE audit; --\""
    );
}