rbdc 4.9.10

The Rust SQL Toolkit and ORM Library. An async, pure Rust SQL crate featuring compile-time Dynamic SQL
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
74
75
76
77
78
79
80
81
82
83
84
85
86

use rbdc::util::impl_exchange;

#[test]
fn test_impl_exchange_basic() {
    let result = impl_exchange("$", 1, "SELECT * FROM t WHERE id = ?");
    assert_eq!(result, "SELECT * FROM t WHERE id = $1");
}

#[test]
fn test_impl_exchange_multiple_placeholders() {
    let result = impl_exchange("$", 1, "INSERT INTO t VALUES (?, ?, ?)");
    assert_eq!(result, "INSERT INTO t VALUES ($1, $2, $3)");
}

#[test]
fn test_impl_exchange_escape_sequence() {
    let result = impl_exchange("$", 1, "SELECT jsonb '{\"a\":1}' \\? ?");
    assert_eq!(result, "SELECT jsonb '{\"a\":1}' ? $1");
}

#[test]
fn test_impl_escape_only() {
    let result = impl_exchange("$", 1, "\\?");
    assert_eq!(result, "?");
}

#[test]
fn test_impl_escape_with_placeholder() {
    let result = impl_exchange("$", 1, "\\? ?");
    assert_eq!(result, "? $1");
}

#[test]
fn test_impl_exchange_no_placeholders() {
    let result = impl_exchange("$", 1, "SELECT * FROM users");
    assert_eq!(result, "SELECT * FROM users");
}

#[test]
fn test_impl_exchange_start_num() {
    let result = impl_exchange("$", 5, "SELECT * FROM t WHERE id = ?");
    assert_eq!(result, "SELECT * FROM t WHERE id = $5");

    let result = impl_exchange("$", 5, "VALUES (?, ?, ?)");
    assert_eq!(result, "VALUES ($5, $6, $7)");
}

#[test]
fn test_impl_exchange_different_prefix() {
    let result = impl_exchange(":", 1, "SELECT * FROM t WHERE id = ?");
    assert_eq!(result, "SELECT * FROM t WHERE id = :1");
}

#[test]
fn test_impl_exchange_complex_query() {
    let sql = "INSERT INTO users (id, name, email) VALUES (?, ?, ?) WHERE status = ?";
    let result = impl_exchange("$", 1, sql);
    assert_eq!(
        result,
        "INSERT INTO users (id, name, email) VALUES ($1, $2, $3) WHERE status = $4"
    );
}

#[test]
fn test_impl_exchange_multiple_escapes() {
    let result = impl_exchange("$", 1, "\\? \\? ?");
    assert_eq!(result, "? ? $1");
}

#[test]
fn test_impl_exchange_empty_string() {
    let result = impl_exchange("$", 1, "");
    assert_eq!(result, "");
}

#[test]
fn test_impl_exchange_only_placeholder() {
    let result = impl_exchange("$", 1, "?");
    assert_eq!(result, "$1");
}

#[test]
fn test_impl_exchange_backslash_not_escape() {
    let result = impl_exchange("$", 1, "SELECT * FROM t WHERE path = '\\'");
    assert_eq!(result, "SELECT * FROM t WHERE path = '\\'");
}