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

use std::time::Duration;

use diesel::{
    r2d2,
    r2d2::{ConnectionManager, PooledConnection},
    result::Error as DieselError,
    PgConnection,
};
use diesel_migrations::EmbeddedMigrations;
use pepe_pg::check_pending_migrations;

pub type PgConnectionManager = ConnectionManager<PgConnection>;
pub type PgPool = r2d2::Pool<PgConnectionManager>;
pub type PgPooledConnection = PooledConnection<PgConnectionManager>;

#[derive(thiserror::Error, Debug)]
pub enum Error {
    #[error("create pool: {0}")]
    CreatePool(String),
    #[error("get connection from pool: {0}")]
    GetConnection(String),
    #[error("pepe pg migrations error: {0}")]
    PepePgMigrations(pepe_pg::MigrationError),
    #[error("diesel failed: {0}")]
    Diesel(DieselError),
}

#[derive(Clone)]
pub struct Pool {
    pool: PgPool,
}

#[derive(Clone, Debug)]
pub struct PoolOpts {
    pub connection_timeout: Option<Duration>,
    pub idle_timeout: Option<Duration>,
    pub max_size: Option<u32>,
    pub min_idle: Option<u32>,
    pub test_on_check_out: Option<bool>,
}

impl Default for PoolOpts {
    fn default() -> Self {
        Self {
            connection_timeout: Some(Duration::from_secs(10)),
            idle_timeout: None,
            max_size: None,
            min_idle: None,
            test_on_check_out: Some(true),
        }
    }
}

impl Pool {
    pub fn new(connection_url: String, migrations: EmbeddedMigrations) -> Result<Self, Error> {
        Self::new_with_opts(connection_url, migrations, PoolOpts::default())
    }

    pub fn new_with_opts(
        connection_url: String,
        migrations: EmbeddedMigrations,
        opts: PoolOpts,
    ) -> Result<Self, Error> {
        let mut builder = r2d2::Pool::builder();

        if let Some(connection_timeout) = opts.connection_timeout {
            builder = builder.connection_timeout(connection_timeout);
        }

        if let Some(idle_timeout) = opts.idle_timeout {
            builder = builder.idle_timeout(Some(idle_timeout));
        }

        if let Some(min_idle) = opts.min_idle {
            builder = builder.min_idle(Some(min_idle));
        }

        if let Some(max_size) = opts.max_size {
            builder = builder.max_size(max_size);
        }

        if let Some(test_on_check_out) = opts.test_on_check_out {
            builder = builder.test_on_check_out(test_on_check_out);
        }

        let pool = builder
            .build(ConnectionManager::<PgConnection>::new(connection_url))
            .map_err(|e| Error::CreatePool(e.to_string()))?;

        let mut conn = pool
            .get()
            .map_err(|e| Error::GetConnection(e.to_string()))?;

        check_pending_migrations(&mut conn, migrations).map_err(Error::PepePgMigrations)?;

        Ok(Self { pool })
    }

    pub fn execute<T, Q, E>(&self, query: Q) -> Result<T, E>
    where
        T: Send + 'static,
        Q: FnOnce(PgPooledConnection) -> Result<T, E> + Send + 'static,
        E: From<Error>,
    {
        let conn = self.connection()?;
        tokio::task::block_in_place(|| query(conn))
    }

    fn connection(&self) -> Result<PgPooledConnection, Error> {
        self.pool
            .get()
            .map_err(|e| Error::GetConnection(e.to_string()))
    }
}