easy-sql 0.101.1

Macro-first SQL toolkit with compile-time checked queries, optional migrations on top of sqlx.
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

#[cfg(all(feature = "postgres", not(feature = "sqlite")))]
use crate::drivers::postgres::{Database, Postgres as TestDriver};

#[cfg(all(feature = "sqlite", not(feature = "postgres")))]
use crate::drivers::sqlite::{Database, Sqlite as TestDriver};

use crate::{DatabaseSetup, Table};
use easy_macros::{add_code, always_context};

#[cfg(not(feature = "migrations"))]
#[always_context(skip(!))]
#[no_context]
#[add_code(after = {
    Database::setup_for_testing::<DocUserTable>().await?;
    assert_eq!(
        <DocUserTable as Table<TestDriver>>::table_name(),
        "doc_users"
    );
    Ok(())
})]
#[tokio::test]
#[docify::export_content]
async fn table_basic_example() -> anyhow::Result<()> {
    #[derive(Table)]
    #[sql(table_name = "doc_users")]
    struct DocUserTable {
        #[sql(primary_key)]
        #[sql(auto_increment)]
        id: i32,
        #[sql(unique)]
        email: String,
        #[sql(default = "guest".to_string())]
        role: String,
        nickname: Option<String>,
    }
}

#[always_context(skip(!))]
#[no_context]
#[add_code(after = {
    #[derive(DatabaseSetup)]
    #[allow(dead_code)]
    struct Tables{
        post_table: PostTable,
        comment_table: CommentTable,
    }

    Database::setup_for_testing::<Tables>().await?;
    assert_eq!(
        <CommentTable as Table<TestDriver>>::primary_keys(),
        vec!["id"]
    );
    Ok(())
})]
#[tokio::test]
#[docify::export_content]
async fn table_foreign_key_example() -> anyhow::Result<()> {
    #[derive(Table)]
    #[sql(no_version)]
    struct PostTable {
        #[sql(primary_key)]
        id: i32,
        title: String,
    }

    #[derive(Table)]
    #[sql(version = 2)]
    #[sql(table_name = "doc_comments")]
    // Auto generated by build script
    #[sql(unique_id = "43af18d0-f056-4b18-9958-3fadb41e4334")]
    struct CommentTable {
        #[sql(primary_key)]
        #[sql(auto_increment)]
        id: i32,
        #[sql(foreign_key = PostTable, cascade)]
        post_id: i32,
        body: String,
    }
}

#[always_context(skip(!))]
#[no_context]
#[add_code(after = {
    Database::setup_for_testing::<DocMembershipTable>().await?;
    assert_eq!(
        <DocMembershipTable as Table<TestDriver>>::primary_keys(),
        vec!["org_id", "user_id"]
    );
    Ok(())
})]
#[cfg(not(feature = "migrations"))]
#[tokio::test]
#[docify::export_content]
async fn table_composite_primary_key_example() -> anyhow::Result<()> {
    #[derive(Table)]
    struct DocMembershipTable {
        #[sql(primary_key)]
        org_id: i32,
        #[sql(primary_key)]
        user_id: i32,
        joined_at: i64,
    }
}