sqlm-postgres-macros 0.1.0

macros for `sqlm-postgres`
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

use std::fmt::Debug;

use sqlm_postgres::{sql, Sql};

#[test]
fn parameter_reuse_named() {
    let sql: Sql<'_, _, ()> = sql!(
        "SELECT * FROM users \
         WHERE id > {after} AND id < {after} + 42",
        after = 8,
    );
    assert_eq!(
        sql.query,
        "SELECT * FROM users WHERE id > $1 AND id < $1 + 42",
    );
    assert_eq!(
        sql.parameters.iter().map(fmt_debug).collect::<Vec<_>>(),
        vec!["8"]
    );
}

#[test]
fn parameter_reuse_positional() {
    let sql: Sql<'_, _, ()> = sql!(
        "SELECT * FROM users \
         WHERE id > {} AND id < {0} + 42",
        8,
    );
    assert_eq!(
        sql.query,
        "SELECT * FROM users WHERE id > $1 AND id < $1 + 42",
    );
    assert_eq!(
        sql.parameters.iter().map(fmt_debug).collect::<Vec<_>>(),
        vec!["8"]
    );
}

#[test]
fn parameter_reuse_variable() {
    let after = 8;
    let sql: Sql<'_, _, ()> = sql!(
        "SELECT * FROM users \
         WHERE id > {after} AND id < {after} + 42",
    );
    assert_eq!(
        sql.query,
        "SELECT * FROM users WHERE id > $1 AND id < $1 + 42",
    );
    assert_eq!(
        sql.parameters.iter().map(fmt_debug).collect::<Vec<_>>(),
        vec!["8"]
    );
}

fn fmt_debug(v: impl Debug) -> String {
    format!("{:?}", v)
}