mool 0.2.0

A source-first Rust database toolkit for typed SQL queries, migrations, and model metadata
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

use mool as db;
use mool::Model;

#[derive(Debug, Clone, db::Model)]
#[table(name = "posts")]
struct Post {
    #[column(primary_key)]
    id: i64,
    title: String,
    published: bool,
}

#[derive(Debug, Clone, db::Record)]
#[table(name = "posts")]
struct PostPatch {
    title: String,
    published: bool,
}

fn main() -> Result<(), db::QueryError> {
    let posts = Post::table();
    let patch = PostPatch {
        title: "Hello".to_string(),
        published: false,
    };

    let select = db::from(&posts)
        .filter(posts.published.eq(db::val(true)))
        .all::<Post>()
        .plan(db::queries::Dialect::Postgres)?;
    let insert = db::from(&posts)
        .insert(&patch)
        .plan(db::queries::Dialect::Postgres)?;
    let update = db::from(&posts)
        .filter(posts.id.eq(db::val(1_i64)))
        .update(&patch)
        .plan(db::queries::Dialect::Postgres)?;

    assert!(select.sql.starts_with("SELECT"));
    assert!(insert.sql.starts_with("INSERT INTO posts"));
    assert!(update.sql.starts_with("UPDATE posts"));
    Ok(())
}