sqlx-template 0.2.1

Template query library for Rust SQLx
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 sqlx_template::{SqliteTemplate, PostgresTemplate};
use sqlx::FromRow;

#[derive(SqliteTemplate, FromRow, Debug, Clone)]
#[table("users")]
#[tp_select_builder]
#[tp_update_builder]
#[tp_delete_builder]
pub struct UserSqlite {
    pub id: i32,
    pub name: String,
    pub email: String,
}

#[derive(PostgresTemplate, FromRow, Debug, Clone)]
#[table("users")]
#[tp_select_builder]
#[tp_update_builder]
#[tp_delete_builder]
pub struct UserPostgres {
    pub id: i32,
    pub name: String,
    pub email: String,
}

#[test]
fn test_select_builder_placeholders() {
    // Test SQLite SELECT
    let sqlite_builder = UserSqlite::builder_select()
        .name("John").unwrap()
        .email("john@example.com").unwrap();
    let sqlite_sql = sqlite_builder.build_sql();
    println!("SQLite SELECT: {}", sqlite_sql);
    assert!(sqlite_sql.contains("?"), "SQLite SELECT should use ? placeholders");

    // Test PostgreSQL SELECT
    let postgres_builder = UserPostgres::builder_select()
        .name("John").unwrap()
        .email("john@example.com").unwrap();
    let postgres_sql = postgres_builder.build_sql();
    println!("PostgreSQL SELECT: {}", postgres_sql);
    assert!(postgres_sql.contains("$1") && postgres_sql.contains("$2"), 
            "PostgreSQL SELECT should use $1, $2 placeholders");
}

#[test]
fn test_update_builder_placeholders() {
    // Test SQLite UPDATE
    let sqlite_builder = UserSqlite::builder_update()
        .on_name("John").unwrap()
        .on_email("john@example.com").unwrap()
        .by_id(&1).unwrap();
    let sqlite_sql = sqlite_builder.build_sql();
    println!("SQLite UPDATE: {}", sqlite_sql);
    assert!(sqlite_sql.contains("?"), "SQLite UPDATE should use ? placeholders");

    // Test PostgreSQL UPDATE
    let postgres_builder = UserPostgres::builder_update()
        .on_name("John").unwrap()
        .on_email("john@example.com").unwrap()
        .by_id(&1).unwrap();
    let postgres_sql = postgres_builder.build_sql();
    println!("PostgreSQL UPDATE: {}", postgres_sql);
    assert!(postgres_sql.contains("$1") && postgres_sql.contains("$2") && postgres_sql.contains("$3"), 
            "PostgreSQL UPDATE should use $1, $2, $3 placeholders");
}

#[test]
fn test_delete_builder_placeholders() {
    // Test SQLite DELETE
    let sqlite_builder = UserSqlite::builder_delete()
        .id(&1).unwrap()
        .name("John").unwrap();
    let sqlite_sql = sqlite_builder.build_sql();
    println!("SQLite DELETE: {}", sqlite_sql);
    assert!(sqlite_sql.contains("?"), "SQLite DELETE should use ? placeholders");

    // Test PostgreSQL DELETE
    let postgres_builder = UserPostgres::builder_delete()
        .id(&1).unwrap()
        .name("John").unwrap();
    let postgres_sql = postgres_builder.build_sql();
    println!("PostgreSQL DELETE: {}", postgres_sql);
    assert!(postgres_sql.contains("$1") && postgres_sql.contains("$2"), 
            "PostgreSQL DELETE should use $1, $2 placeholders");
}