sqlw 0.1.0

Compile-time SQL query building with schema-safe field references and automatic parameter binding
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
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115

/// cargo bench -p sqlw --bench generation
use criterion::{Criterion, black_box, criterion_group, criterion_main};
use sqlw::{query_qmark as query, schema};

schema!(User "user" {
    ID "id",
    NAME "name",
    AGE "age",
    HEIGHT "height",
    ACTIVE "active",
});

schema!(Post "post" {
    ID "id",
    USER_ID "user_id",
    TITLE "title",
    CONTENT "content",
    PUBLISHED "published",
});

fn bench_simple_select(c: &mut Criterion) {
    c.bench_function("simple_select", |b| {
        b.iter(|| {
            let name = black_box("John");
            let query = query!(
                SELECT User::NAME, User::AGE FROM User::TABLE
                WHERE User::NAME = {name}
            );
            let (sql, args) = query.split();
            black_box((sql, args));
        });
    });
}

fn bench_insert(c: &mut Criterion) {
    c.bench_function("insert", |b| {
        b.iter(|| {
            let name = black_box("John");
            let age = black_box(25);
            let height = black_box(Some(1.85));
            let active = black_box(true);
            let query = query!(
                INSERT INTO User::TABLE (User::NAME,
                                         User::AGE,
                                         User::HEIGHT,
                                         User::ACTIVE)
                VALUES ({name}, {age}, {height}, {active})
            );
            let (sql, args) = query.split();
            black_box((sql, args));
        });
    });
}

fn bench_update(c: &mut Criterion) {
    c.bench_function("update", |b| {
        b.iter(|| {
            let name = black_box("John");
            let age = black_box(30);
            let query = query!(
                UPDATE User::TABLE
                SET User::AGE = {age}
                WHERE User::NAME = {name}
            );
            let (sql, args) = query.split();
            black_box((sql, args));
        });
    });
}

fn bench_delete(c: &mut Criterion) {
    c.bench_function("delete", |b| {
        b.iter(|| {
            let name = black_box("John");
            let query = query!(
                DELETE FROM User::TABLE
                WHERE User::NAME = {name}
            );
            let (sql, args) = query.split();
            black_box((sql, args));
        });
    });
}

fn bench_complex_join(c: &mut Criterion) {
    c.bench_function("complex_join", |b| {
        b.iter(|| {
            let user_id = black_box(42);
            let published = black_box(true);
            let query = query!(
                SELECT User::NAME,
                       Post::TITLE,
                       Post::CONTENT
                FROM User::TABLE
                INNER JOIN Post::TABLE ON User::ID = Post::USER_ID
                WHERE User::ID = {user_id}
                    AND Post::PUBLISHED = {published}
            );
            let (sql, args) = query.split();
            black_box((sql, args));
        });
    });
}

criterion_group!(
    name = benches;
    config = Criterion::default();
    targets = bench_simple_select,
              bench_insert,
              bench_update,
              bench_delete,
              bench_complex_join
);

criterion_main!(benches);