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

use crate::execution::Execution;
use std::fmt::Debug;
use std::marker::PhantomData;
use tracing::debug;

use crate::model::{Model, UpdateModel};
use crate::order_by::OrderBy;
use crate::pagination::Cursor;
use crate::pool::*;
use crate::query_builder::{QueryBuilder, QueryType};
use crate::where_delete::WhereDelete;
use crate::where_select::WhereSelect;
use crate::where_update::WhereUpdate;

#[derive(Clone)]
pub struct Database {
    pool: Pool<PostgresConnectionManager<NoTls>>,
}

impl Database {
    pub async fn new(url: &str) -> anyhow::Result<Self> {
        let manager = PostgresConnectionManager::new_from_stringlike(url, NoTls)?;
        let pool = Pool::builder().build(manager).await?;

        Ok(Self { pool })
    }

    pub async fn get(&self) -> anyhow::Result<PooledConnection<PostgresConnectionManager<NoTls>>> {
        Ok(self.pool.get().await?)
    }

    pub fn bind<T>(&self) -> WhereSelect<T>
    where
        T: Model + Debug,
    {
        WhereSelect {
            pool: &self.pool,
            columns: T::COLUMNS,
            params: vec![],
            predicates: vec![],
            order_by: vec![],
            _t: PhantomData::<T>,
        }
    }

    pub async fn insert<T>(&self, data: &T) -> anyhow::Result<T>
    where
        T: Model + Debug,
    {
        let params = data.params();
        let qb = QueryBuilder::builder()
            .table_name(T::NAME)
            .columns(T::COLUMNS)
            .params(&params)
            .ty(QueryType::Insert)
            .is_returning(true)
            .build();

        let execution = Execution::new(&self.pool, &qb);
        execution.first_or_throw().await
    }

    pub async fn insert_many<T>(&self, data: &[T]) -> anyhow::Result<Vec<T>>
    where
        T: Model + Debug,
    {
        let mut params = vec![];
        for d in data {
            params.extend(d.params());
        }

        let qb = QueryBuilder::builder()
            .table_name(T::NAME)
            .columns(T::COLUMNS)
            .params(&params)
            .ty(QueryType::Insert)
            .is_returning(true)
            .build();

        let execution = Execution::new(&self.pool, &qb);
        execution.all().await
    }

    pub fn update<'a, T, U>(&'a self, data: &'a U) -> WhereUpdate<'a, T, U>
    where
        T: Model + Debug,
        U: UpdateModel,
    {
        WhereUpdate {
            pool: &self.pool,
            columns: data.columns(),
            params: data.params(),
            predicates: vec![],
            _t: PhantomData,
            _u: PhantomData,
        }
    }

    pub fn delete<T>(&self) -> WhereDelete<T>
    where
        T: Model + Debug,
    {
        WhereDelete {
            pool: &self.pool,
            predicates: vec![],
            _t: PhantomData,
        }
    }
}