acts-store-postgres 0.17.2

acts store plugin for postgres
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

use futures::executor::block_on;
use sqlx::{
    Database, Error, IntoArguments, PgPool, Postgres,
    postgres::{PgPoolOptions, PgRow},
};
use std::time::Duration;

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

impl SynClient {
    pub fn connect(db_url: &str) -> Self {
        #[allow(clippy::expect_fun_call)]
        let pool = block_on(async move {
            PgPoolOptions::new()
                .acquire_timeout(Duration::from_secs(5))
                .max_connections(200)
                .connect(db_url)
                .await
        })
        .expect(&format!("failed to connect to DB {}", db_url));

        Self { pool }
    }

    pub fn query_one<'q, A>(&self, sql: &'q str, params: A) -> Result<PgRow, Error>
    where
        A: IntoArguments<'q, Postgres> + 'q,
    {
        block_on(async move {
            let mut conn = self
                .pool
                .acquire()
                .await
                .expect("failed to get connection from pool");

            sqlx::query_with(sql, params).fetch_one(&mut *conn).await
        })
    }

    pub fn query<'q, A>(&self, sql: &'q str, params: A) -> Result<Vec<PgRow>, Error>
    where
        A: IntoArguments<'q, Postgres> + 'q,
    {
        block_on(async move {
            let mut conn = self
                .pool
                .acquire()
                .await
                .expect("failed to get connection from pool");

            sqlx::query_with(sql, params).fetch_all(&mut *conn).await
        })
    }

    pub fn execute<'q, A>(
        &self,
        sql: &'q str,
        params: A,
    ) -> Result<<Postgres as Database>::QueryResult, Error>
    where
        A: IntoArguments<'q, Postgres> + 'q,
    {
        block_on(async move {
            let mut conn = self
                .pool
                .acquire()
                .await
                .expect("failed to get connection from pool");

            sqlx::query_with(sql, params).execute(&mut *conn).await
        })
    }

    pub fn batch_execute(&self, sqls: &[String]) -> Result<(), Error> {
        block_on(async move {
            let mut tx = self
                .pool
                .begin()
                .await
                .expect("failed to get connection from pool");

            for sql in sqls {
                sqlx::query(sql).execute(&mut *tx).await?;
            }
            tx.commit().await
        })
    }
}