drizzle 0.3.0

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

use drizzle::core::expr::eq;
use drizzle::sqlite::prelude::*;
use drizzle::sqlite::rusqlite::Drizzle;

#[SQLiteTable]
struct Users {
    #[column(primary)]
    id: i32,
    name: String,
    manager_id: Option<i32>,
}

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

struct Manager;
impl drizzle::core::Tag for Manager {
    const NAME: &'static str = "manager";
}

struct Peer;
impl drizzle::core::Tag for Peer {
    const NAME: &'static str = "peer";
}

fn main() {
    let conn = rusqlite::Connection::open_in_memory().unwrap();
    let (db, Schema { users }) = Drizzle::new(conn);
    let manager = Users::alias::<Manager>();

    // Self-join: the alias is a separate source, its columns are in scope.
    let _rows: drizzle::Result<Vec<(String, String)>> = db
        .select((users.name, manager.name))
        .from(users)
        .join((manager, eq(users.manager_id, manager.id)))
        .all();

    // LEFT JOIN on the alias: its columns decode as Option.
    let _rows: drizzle::Result<Vec<(String, Option<String>)>> = db
        .select((users.name, manager.name))
        .from(users)
        .left_join((manager, eq(users.manager_id, manager.id)))
        .all();
}