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

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

use drizzle::sqlite::prelude::*;
#[cfg(feature = "uuid")]
use uuid::Uuid;

#[cfg(feature = "uuid")]
#[SQLiteTable]
pub struct Users {
    #[column(primary, default_fn = Uuid::new_v4)]
    id: Uuid,
    name: String,
    age: i64,
}

#[cfg(feature = "uuid")]
#[SQLiteTable]
pub struct Posts {
    #[column(primary, default_fn = Uuid::new_v4)]
    id: Uuid,
    #[column(references = Users::id)]
    user_id: Uuid,
    context: Option<String>,
}

#[cfg(not(feature = "uuid"))]
#[SQLiteTable]
pub struct Users {
    #[column(primary)]
    id: i64,
    name: String,
    age: i64,
}

#[cfg(not(feature = "uuid"))]
#[SQLiteTable]
pub struct Posts {
    #[column(primary)]
    id: i64,
    #[column(references = Users::id)]
    user_id: i64,
    context: Option<String>,
}

#[derive(SQLiteSchema)]
pub struct Schema {
    pub users: Users,
    pub posts: Posts,
}