db-pool 0.6.0

A thread-safe database pool for running database-tied integration tests in parallel
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

fn main() {}

#[cfg(test)]
mod tests {
    #![allow(clippy::needless_return)]

    use db_pool::{
        r#async::{
            DatabasePool, DatabasePoolBuilderTrait, ReusableConnectionPool, SeaORMPostgresBackend,
        },
        PrivilegedPostgresConfig,
    };
    use dotenvy::dotenv;
    use sea_orm::{prelude::*, Set};
    use tokio::sync::OnceCell;
    use tokio_shared_rt::test;

    async fn get_connection_pool() -> ReusableConnectionPool<'static, SeaORMPostgresBackend> {
        static POOL: OnceCell<DatabasePool<SeaORMPostgresBackend>> = OnceCell::const_new();

        let db_pool = POOL
            .get_or_init(|| async {
                dotenv().ok();

                let config = PrivilegedPostgresConfig::from_env().unwrap();

                let backend = SeaORMPostgresBackend::new(
                    config,
                    |opts| {
                        opts.max_connections(10);
                    },
                    |opts| {
                        opts.max_connections(2);
                    },
                    move |conn| {
                        Box::pin(async move {
                            conn.execute_unprepared(
                                "CREATE TABLE book(id SERIAL PRIMARY KEY, title TEXT NOT NULL)",
                            )
                            .await
                            .unwrap();
                        })
                    },
                )
                .await
                .unwrap();

                backend.create_database_pool().await.unwrap()
            })
            .await;

        db_pool.pull_immutable().await
    }

    async fn test() {
        #[derive(Clone, Debug, DeriveEntityModel)]
        #[sea_orm(table_name = "book")]
        pub struct Model {
            #[sea_orm(primary_key)]
            id: i32,
            title: String,
        }

        #[derive(Debug, EnumIter, DeriveRelation)]
        pub enum Relation {}

        impl ActiveModelBehavior for ActiveModel {}

        let conn_pool = get_connection_pool().await;
        let conn = &**conn_pool;

        let book = ActiveModel {
            title: Set("Title".to_owned()),
            ..Default::default()
        };

        book.insert(conn).await.unwrap();

        let count = Entity::find().count(conn).await.unwrap();

        assert_eq!(count, 1);
    }

    #[test(shared)]
    async fn test1() {
        test().await;
    }

    #[test(shared)]
    async fn test2() {
        test().await;
    }
}