miniorm 0.4.1

a *very* simple ORM built 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
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158

mod common;

use common::Todo;
use miniorm::prelude::*;
use serial_test::serial;
use std::error::Error;

#[macro_export]
macro_rules! test_crud {
    ($db: block) => {
        async fn get_clean_store() -> Result<impl Crud<Todo>, Box<dyn Error>> {
            let pool = $db;
            let store = Store::new(pool);
            store.recreate_table().await?;
            Ok(store)
        }

        #[cfg_attr(not(feature = "integration_tests"), ignore)]
        #[serial]
        #[tokio::test]
        async fn create() {
            let store = get_clean_store().await.unwrap();
            let todo = store.create(Todo::new("checkout miniorm")).await.unwrap();
            assert_eq!(todo.id(), 1);
            assert_eq!(todo.description(), "checkout miniorm");
            assert!(!todo.is_done());
        }

        #[cfg_attr(not(feature = "integration_tests"), ignore)]
        #[serial]
        #[tokio::test]
        async fn read() {
            let store = get_clean_store().await.unwrap();
            let todo = store.create(Todo::new("checkout miniorm")).await.unwrap();
            assert_eq!(todo, store.read(todo.id()).await.unwrap());
        }

        #[cfg_attr(not(feature = "integration_tests"), ignore)]
        #[serial]
        #[tokio::test]
        async fn list() {
            let store = get_clean_store().await.unwrap();
            let todo1 = store.create(Todo::new("todo1")).await.unwrap();
            let todo2 = store.create(Todo::new("todo2")).await.unwrap();
            let todo3 = store.create(Todo::new("todo3")).await.unwrap();

            let all_todos = store.list().await.unwrap();
            assert_eq!(all_todos, [todo1, todo2, todo3]);
        }

        #[cfg_attr(not(feature = "integration_tests"), ignore)]
        #[serial]
        #[tokio::test]
        async fn count() {
            let store = get_clean_store().await.unwrap();
            assert_eq!(store.count().await.unwrap(), 0);

            store.create(Todo::new("todo1")).await.unwrap();
            assert_eq!(store.count().await.unwrap(), 1);

            store.create(Todo::new("todo2")).await.unwrap();
            assert_eq!(store.count().await.unwrap(), 2);

            store.create(Todo::new("todo3")).await.unwrap();
            assert_eq!(store.count().await.unwrap(), 3);
        }

        #[cfg_attr(not(feature = "integration_tests"), ignore)]
        #[serial]
        #[tokio::test]
        async fn update() {
            let store = get_clean_store().await.unwrap();
            let mut todo = store.create(Todo::new("checkout miniorm")).await.unwrap();
            let id = todo.id();

            assert!(!store.read(id).await.unwrap().is_done());

            todo.mark_as_done();
            assert!(!store.read(id).await.unwrap().is_done());

            store.update(todo).await.unwrap();
            assert!(store.read(id).await.unwrap().is_done());
        }

        #[cfg_attr(not(feature = "integration_tests"), ignore)]
        #[serial]
        #[tokio::test]
        async fn delete() {
            let store = get_clean_store().await.unwrap();
            let todo = store.create(Todo::new("checkout miniorm")).await.unwrap();

            store.delete(todo.id()).await.unwrap();

            assert!(matches!(
                store.delete(todo.id()).await,
                Err(sqlx::Error::RowNotFound)
            ));

            assert!(matches!(
                store.read(todo.id()).await,
                Err(sqlx::Error::RowNotFound)
            ));
        }

        #[cfg_attr(not(feature = "integration_tests"), ignore)]
        #[serial]
        #[tokio::test]
        async fn delete_all() {
            let store = get_clean_store().await.unwrap();
            let todo1 = store.create(Todo::new("todo1")).await.unwrap();
            let todo2 = store.create(Todo::new("todo2")).await.unwrap();
            let todo3 = store.create(Todo::new("todo3")).await.unwrap();

            let all_todos = store.list().await.unwrap();
            assert_eq!(all_todos, [todo1, todo2, todo3]);

            let result = store.delete_all().await.unwrap();
            assert_eq!(result, 3);
            assert!(store.list().await.unwrap().is_empty());
        }
    };
}

mod test_crud {
    use super::*;

    #[cfg(feature = "mysql")]
    mod mysql {
        use super::*;
        use sqlx::MySqlPool;

        test_crud!({
            dotenv::dotenv()?;
            let url = std::env::var("MYSQL_URL").expect("missing MYSQL_URL env");
            MySqlPool::connect(&url).await?
        });
    }

    #[cfg(feature = "postgres")]
    mod postgres {
        use super::*;
        use sqlx::PgPool;

        test_crud!({
            dotenv::dotenv()?;
            let url = std::env::var("POSTGRES_URL").expect("missing POSTGRES_URL env");
            PgPool::connect(&url).await?
        });
    }

    #[cfg(feature = "sqlite")]
    mod sqlite {
        use super::*;
        use sqlx::SqlitePool;

        test_crud!({ SqlitePool::connect(":memory:").await? });
    }
}