vantage-sql 0.4.9

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
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
63
64
65
66
67
68
69
70
71
72
73

//! Test 2e: Identifier quoting with mysql_expr! macro.
//! Verifies that Identifier works as an Expressive in expression macros
//! and handles unusual but valid MySQL identifier characters.

use vantage_sql::mysql_expr;
use vantage_sql::primitives::identifier::ident;

// ── ident() in expr macro via (parentheses) ───────────────────────────────────

#[test]
fn test_id_in_select() {
    let expr = mysql_expr!("SELECT {} FROM {}", (ident("name")), (ident("product")));
    assert_eq!(expr.preview(), "SELECT `name` FROM `product`");
}

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

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

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

// ── Unusual but valid identifier characters ────────────────────────────────
// MySQL and PostgreSQL both allow spaces, hyphens, special chars inside
// quoted identifiers.

#[test]
fn test_id_with_space() {
    let expr = mysql_expr!("SELECT {}", (ident("first name")));
    assert_eq!(expr.preview(), "SELECT `first name`");
}

#[test]
fn test_id_with_hyphen() {
    let expr = mysql_expr!("SELECT {}", (ident("my-column")));
    assert_eq!(expr.preview(), "SELECT `my-column`");
}

#[test]
fn test_id_reserved_word() {
    let expr = mysql_expr!("SELECT {} FROM {}", (ident("select")), (ident("order")));
    assert_eq!(expr.preview(), "SELECT `select` FROM `order`");
}

#[test]
fn test_id_with_dot_in_name() {
    // A single identifier containing a literal dot (not qualified)
    let expr = mysql_expr!("SELECT {}", (ident("weird.name")));
    assert_eq!(expr.preview(), "SELECT `weird.name`");
}

#[test]
fn test_id_unicode() {
    let expr = mysql_expr!("SELECT {}", (ident("名前")));
    assert_eq!(expr.preview(), "SELECT `名前`");
}

#[test]
fn test_id_number_start() {
    let expr = mysql_expr!("SELECT {}", (ident("1bad_name")));
    assert_eq!(expr.preview(), "SELECT `1bad_name`");
}