drizzle 0.1.5

A type-safe SQL query builder for Rust
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

#![cfg(any(feature = "rusqlite", feature = "turso", feature = "libsql"))]

use drizzle::core::expr::*;
use drizzle::sqlite::prelude::*;
use drizzle_macros::sqlite_test;
#[cfg(feature = "serde")]
use serde::{Deserialize, Serialize};
#[cfg(feature = "uuid")]
use uuid::Uuid;

#[cfg(feature = "serde")]
#[derive(Serialize, Deserialize, Debug, PartialEq, Clone, Default)]
pub struct Profile {
    age: i64,
    name: String,
    interests: Vec<String>,
}

#[cfg(all(feature = "serde", feature = "uuid"))]
#[derive(SQLiteFromRow, Serialize, Deserialize, Debug, PartialEq, Clone, Default)]
pub struct UserResult {
    id: Uuid,
    age: i64,
}

#[cfg(all(feature = "serde", feature = "uuid"))]
#[SQLiteTable(NAME = "json_users", STRICT)]
struct JsonUser {
    id: Uuid,
    email: String,
    #[column(JSON)]
    profile: Profile,
}
#[cfg(all(feature = "serde", feature = "uuid"))]
#[derive(SQLiteSchema)]
struct Schema {
    jsonuser: JsonUser,
}

#[cfg(all(feature = "serde", feature = "uuid"))]
#[derive(SQLiteFromRow, Debug, PartialEq, Default)]
pub struct JsonReadResult {
    id: Uuid,
    email: String,
    #[json]
    profile: Profile,
}

#[cfg(all(feature = "serde", feature = "uuid"))]
sqlite_test!(json_storage, Schema, {
    let Schema { jsonuser } = schema;

    println!("{}", jsonuser.sql());

    let profile = Profile {
        age: 30,
        name: "John".to_string(),
        interests: vec!["Coding".to_string(), "Reading".to_string()],
    };

    let id = Uuid::new_v4();

    let stmt =
        db.insert(jsonuser)
            .values([InsertJsonUser::new(id, "john@test.com", profile.clone())]);

    // let stmt2 =
    //     db.insert(jsonuser)
    //         .values([InsertJsonUser::new(id, "john@test.com", jsonb(profile))]);

    println!("{}", stmt.to_sql());

    println!("{}", profile.to_sql());
    drizzle_exec!(stmt.execute());

    let stmt = db
        .select((
            jsonuser.id,
            drizzle::sqlite::expressions::json_extract(jsonuser.profile, "age").alias("age"),
        ))
        .from(jsonuser)
        .r#where(eq(jsonuser.id, id));

    println!("{}", stmt.to_sql());

    let user: UserResult = drizzle_exec!(stmt.get());

    assert_eq!(user.id, id);
    assert_eq!(user.age, 30);

    // Test reading full JSON column back via #[json] on FromRow struct
    let stmt = db
        .select((jsonuser.id, jsonuser.email, jsonuser.profile))
        .from(jsonuser)
        .r#where(eq(jsonuser.id, id));

    let result: JsonReadResult = drizzle_exec!(stmt.get());

    assert_eq!(result.id, id);
    assert_eq!(result.email, "john@test.com");
    assert_eq!(result.profile, profile);
});