drizzle 0.4.2

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

use drizzle::sqlite::prelude::*;

mod schema {
    use drizzle::sqlite::prelude::*;

    #[SQLiteTable(NAME = "users")]
    pub struct User {
        #[column(PRIMARY)]
        pub id: i32,
        pub name: String,
        // Any collation the application registers, named as an identifier.
        #[column(collate = my_collation)]
        pub handle: String,
    }
}

// Qualified table paths name the table by the segment before the column,
// in views and in indexes.
#[SQLiteView(
    query(
        select(schema::User::id, schema::User::name),
        from(schema::User),
        filter(eq(schema::User::name, "admin")),
    ),
    NAME = "admins"
)]
struct AdminsView {
    id: i32,
    name: String,
}

#[SQLiteIndex]
struct UserNameIdx(schema::User::name);

fn main() {
    let _sql = AdminsView::VIEW_DEFINITION_SQL;
    let _ddl = AdminsView::ddl_sql();
    let _index = UserNameIdx::new();
}