sql_query 0.0.0

composible sql query builder, with support of binding into query buffer
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
92
93
94
95
96
97

use std::marker::PhantomData;

use sqlx::{database::HasArguments, Database};

use crate::{returning::ReturningClause, IntoMutArguments};

pub struct InsertMany<S, B, R = ()> {
    into: &'static str,
    cols: Vec<&'static str>,
    buffer: B,
    argument_count: usize,
    returning: R,
    _db: PhantomData<S>,
}

impl<'q, S: Database, R>
    InsertMany<S, <S as HasArguments<'q>>::Arguments, R>
where
    R: ReturningClause,
{
    pub fn _build(
        self,
    ) -> (String, <S as HasArguments<'q>>::Arguments) {
        let column = self.cols.len();
        let str = format!(
            "INSERT INTO {} ({}) VALUES ({}){};",
            self.into,
            self.cols.join(", "),
            {
                let mut binds = 1;
                let mut s_inner = Vec::new();
                for _ in 0..column {
                    for _ in 0..self.argument_count {
                        s_inner.push(format!("${}", binds));
                        binds += 1;
                    }
                }

                s_inner.join(", ")
            },
            self.returning.returning(),
        );

        (str, self.buffer)
    }
}

pub fn insert_many<'q, S: Database>(
    into: &'static str,
) -> InsertMany<S, <S as HasArguments<'q>>::Arguments> {
    InsertMany {
        into,
        cols: Default::default(),
        buffer: Default::default(),
        returning: (),
        _db: PhantomData,
        argument_count: Default::default(),
    }
}

impl<'q, S: Database>
    InsertMany<S, <S as HasArguments<'q>>::Arguments>
{
    pub fn returning(
        self,
        returning: Vec<&'static str>,
    ) -> InsertMany<
        S,
        <S as HasArguments<'q>>::Arguments,
        Vec<&'static str>,
    > {
        InsertMany {
            returning,
            into: self.into,
            cols: self.cols,
            buffer: self.buffer,
            _db: PhantomData,
            argument_count: self.argument_count,
        }
    }
    pub fn columns(
        self,
        cols: Vec<&'static str>,
    ) -> InsertMany<S, <S as HasArguments<'q>>::Arguments> {
        InsertMany { cols, ..self }
    }
    pub fn values<B>(mut self, values: Vec<B>) -> Self
    where
        B: IntoMutArguments<'q, S>,
    {
        self.argument_count += values.len();
        for value in values {
            value.into_arguments(&mut self.buffer);
        }
        self
    }
}