vantage-sql 0.10.0

Vantage extension for SQL databases (Postgres, MySQL, SQLite)
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

//! Test 2e: Identifier quoting with sqlite_expr! macro.

use vantage_sql::primitives::identifier::ident;
use vantage_sql::sqlite_expr;

#[test]
fn test_id_in_condition() {
    let expr = sqlite_expr!("{} = {}", (ident("price")), 100i64);
    assert_eq!(expr.preview(), "\"price\" = 100");
}

#[test]
fn test_id_with_alias() {
    let expr = sqlite_expr!("SELECT {}", (ident("name").with_alias("n")));
    assert_eq!(expr.preview(), "SELECT \"name\" AS \"n\"");
}

#[test]
fn test_id_embedded_quote_is_doubled() {
    let expr = sqlite_expr!("SELECT {}", (ident("x\" ; DROP TABLE users --")));
    assert_eq!(expr.preview(), "SELECT \"x\"\" ; DROP TABLE users --\"");
}

#[test]
fn test_id_embedded_quote_in_alias_is_doubled() {
    let expr = sqlite_expr!("SELECT {}", (ident("col").with_alias("a\"b")));
    assert_eq!(expr.preview(), "SELECT \"col\" AS \"a\"\"b\"");
}

#[test]
fn test_id_qualified() {
    let expr = sqlite_expr!("SELECT {}", (ident("name").dot_of("t")));
    assert_eq!(expr.preview(), "SELECT \"t\".\"name\"");
}