mithril_persistence/sqlite/
connection_pool.rs

use std::{ops::Deref, time::Duration};

use mithril_common::StdResult;
use mithril_resource_pool::{Reset, ResourcePool, ResourcePoolItem};

use crate::sqlite::SqliteConnection;

/// SqliteConnection wrapper for a pooled connection
pub struct SqlitePooledConnection(SqliteConnection);

impl SqlitePooledConnection {
    /// Create a new SqlitePooledConnection
    pub fn new(connection: SqliteConnection) -> Self {
        Self(connection)
    }
}

impl Deref for SqlitePooledConnection {
    type Target = SqliteConnection;

    fn deref(&self) -> &Self::Target {
        &self.0
    }
}

impl Reset for SqlitePooledConnection {}

/// Pool of Sqlite connections
pub struct SqliteConnectionPool {
    connection_pool: ResourcePool<SqlitePooledConnection>,
}

impl SqliteConnectionPool {
    /// Create a new pool with the given size by calling the given builder function
    pub fn build(
        size: usize,
        builder: impl Fn() -> StdResult<SqliteConnection>,
    ) -> StdResult<Self> {
        let mut connections: Vec<SqlitePooledConnection> = Vec::with_capacity(size);
        for _count in 0..size {
            connections.push(SqlitePooledConnection::new(builder()?));
        }

        Ok(Self {
            connection_pool: ResourcePool::new(connections.len(), connections),
        })
    }

    /// Get a connection from the pool
    pub fn connection(&self) -> StdResult<ResourcePoolItem<SqlitePooledConnection>> {
        let timeout = Duration::from_millis(1000);
        let connection = self.connection_pool.acquire_resource(timeout)?;

        Ok(connection)
    }

    /// Returns a single resource pool connection
    pub fn build_from_connection(connection: SqliteConnection) -> Self {
        let connection_pool = ResourcePool::new(1, vec![SqlitePooledConnection::new(connection)]);

        Self { connection_pool }
    }
}

#[cfg(test)]
mod tests {
    use super::*;
    use crate::database::test_helper::cardano_tx_db_connection;

    #[test]
    fn can_build_pool_of_given_size() {
        let pool = SqliteConnectionPool::build(10, cardano_tx_db_connection).unwrap();

        assert_eq!(pool.connection_pool.size(), 10);
    }
}
mithril_persistence/sqlite/connection_pool.rs

mithril_persistence/sqlite/
connection_pool.rs
