postgres_to_polars 0.2.0

A Rust library for direct and performant conversion of PostgreSQL data to Polars dataframes.
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

use std::time::Duration;

use bb8::{ManageConnection, Pool};

use crate::{Client, ClientOptions, PoolOptions};

pub struct ClientManager {
    pub options: ClientOptions,
}

//#[async_trait]
impl ManageConnection for ClientManager {
    type Connection = Client;
    type Error = anyhow::Error;

    async fn connect(&self) -> Result<Self::Connection, Self::Error> {
        let client = Client::new(self.options.clone()).await;
        client.connect().await?;
        Ok(client)
    }

    async fn is_valid(&self, conn: &mut Self::Connection) -> Result<(), Self::Error> {
        conn.ping().await
    }

    fn has_broken(&self, conn: &mut Self::Connection) -> bool {
        conn.has_broken()
    }
}

pub async fn build_pool(opts: PoolOptions) -> anyhow::Result<Pool<ClientManager>> {
    let mgr = ClientManager {
        options: opts.client_options,
    };
    let pool = Pool::builder()
        .max_size(opts.max_connections)
        .connection_timeout(Duration::from_secs(5))
        .idle_timeout(Some(Duration::from_secs(60)))
        .max_lifetime(Some(Duration::from_secs(30 * 60)))
        .test_on_check_out(true)
        .build(mgr)
        .await?;
    Ok(pool)
}

pub type PgToPlPool = Pool<ClientManager>;