db-http-core 0.1.0

Core types and traits for HTTP-based database backends
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

use crate::backend::DatabaseBackend;
use crate::deserializer::{deserialize_all, deserialize_one};
use crate::error::Error;
use crate::types::{Query, QueryResult};
use serde::de::DeserializeOwned;

pub struct QueryBuilder<B: DatabaseBackend> {
    backend: B,
    sql: String,
    params: Vec<serde_json::Value>,
}

impl<B: DatabaseBackend> QueryBuilder<B> {
    pub fn new(backend: B, sql: impl Into<String>) -> Self {
        Self {
            backend,
            sql: sql.into(),
            params: Vec::new(),
        }
    }

    pub fn bind(mut self, value: impl Into<serde_json::Value>) -> Self {
        self.params.push(value.into());
        self
    }

    pub fn build(self) -> Query {
        Query {
            sql: self.sql,
            params: self.params,
        }
    }

    pub async fn fetch_one<T: DeserializeOwned>(self) -> Result<T, Error> {
        let query = Query {
            sql: self.sql,
            params: self.params,
        };
        let result = self.backend.execute_query(&query).await?;
        deserialize_one(result)
    }

    pub async fn fetch_all<T: DeserializeOwned>(self) -> Result<Vec<T>, Error> {
        let query = Query {
            sql: self.sql,
            params: self.params,
        };
        let result = self.backend.execute_query(&query).await?;
        deserialize_all(result)
    }

    pub async fn execute(self) -> Result<QueryResult, Error> {
        let query = Query {
            sql: self.sql,
            params: self.params,
        };
        self.backend.execute_query(&query).await
    }
}