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
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
103
104
105
106
107
108
109
110
111

#![allow(dead_code)]

use mool as db;
use mool::Model;
use serde::{Deserialize, Serialize};

#[derive(Debug, Clone, Copy, PartialEq, Eq, db::SqlEnum)]
#[sql_enum(rename_all = "snake_case")]
enum TextStatus {
    Draft,
    Published,
}

#[derive(Debug, Clone, Copy, PartialEq, Eq, db::SqlEnum)]
#[sql_enum(storage = "int", repr = "i16")]
enum IntStatus {
    #[sql_enum(code = 1)]
    Draft,
    #[sql_enum(code = 2)]
    Published,
}

#[derive(Debug, Clone, Copy, PartialEq, Eq, db::SqlEnum)]
#[sql_enum(storage = "native_postgres", name = "native_status")]
enum NativePostgresStatus {
    Draft,
    Published,
}

#[derive(Debug, Clone, Copy, PartialEq, Eq, db::SqlEnum)]
#[sql_enum(storage = "native_mysql", rename_all = "snake_case")]
enum NativeMysqlStatus {
    Draft,
    Published,
}

#[derive(Debug, Clone, Serialize, Deserialize)]
struct JsonMeta {
    label: String,
}

#[derive(Debug, Clone, db::Model)]
#[table(name = "compat_rows")]
struct CompatRow {
    #[column(primary_key)]
    id: i64,
    #[column(type = "uuid")]
    external_id: uuid::Uuid,
    #[column(type = "timestamptz")]
    created_at: chrono::DateTime<chrono::Utc>,
    #[column(nullable)]
    subtitle: Option<String>,
    #[column(type = "jsonb")]
    meta: JsonMeta,
    #[column(sql_enum)]
    text_status: TextStatus,
    #[column(sql_enum)]
    int_status: IntStatus,
    #[column(sql_enum)]
    native_pg_status: NativePostgresStatus,
    #[column(sql_enum)]
    native_mysql_status: NativeMysqlStatus,
}

fn assert_sqlx_value<T>()
where
    T: Clone
        + for<'q> sqlx::Encode<'q, db::Database>
        + for<'r> sqlx::Decode<'r, db::Database>
        + sqlx::Type<db::Database>
        + Send
        + Sync
        + Unpin
        + 'static,
{
}

#[cfg(feature = "postgres")]
fn assert_postgres_array<T>()
where
    T: Clone
        + for<'q> sqlx::Encode<'q, db::Database>
        + for<'r> sqlx::Decode<'r, db::Database>
        + sqlx::Type<db::Database>
        + Send
        + Sync
        + Unpin
        + 'static,
{
}

fn main() {
    assert_sqlx_value::<TextStatus>();
    assert_sqlx_value::<IntStatus>();
    assert_sqlx_value::<NativePostgresStatus>();
    assert_sqlx_value::<NativeMysqlStatus>();

    let rows = CompatRow::table();
    let _ = db::from(&rows)
        .filter(rows.text_status.eq(db::val(TextStatus::Published)))
        .filter(rows.int_status.eq(db::val(IntStatus::Draft)))
        .all::<CompatRow>()
        .plan(db::queries::Dialect::Postgres)
        .unwrap();

    #[cfg(feature = "postgres")]
    {
        assert_postgres_array::<Vec<String>>();
        assert_postgres_array::<Option<Vec<i64>>>();
    }
}