sql_tools 0.4.0

A crate that aims to make creating simple SQL queries easy.
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
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115

use crate::{clauses::where_clause::utils::where_clause_value_format, data_types::ToSQLData, variations::{oracle::update::{batch_update_oracle, oracle_build_update}, sqlite::update::{batch_update_sqlite, sqlite_build_update}}, Error, SQLVariation};

use super::{SetMatch, UpdateBuilder, UpdateInitialization, UpdateProps};

impl UpdateInitialization {
    pub fn set<T: ToSQLData>(self, column: &str, new_value: T) -> UpdateProps {
        let set = vec![
            SetMatch {
                column: column.to_string(),
                value: new_value.fmt_data(),
                query: false,
            }
        ];
        UpdateProps {
            connect: self.connect,
            set_match: set,
            table: self.table,
            clause: None,
        }
    }

    pub fn set_query(self, column: &str, query: &str) -> UpdateProps {
        let set = vec![
            SetMatch {
                column: column.to_string(),
                value: query.fmt_data(),
                query: true,
            }
        ];
        UpdateProps {
            connect: self.connect,
            set_match: set,
            table: self.table,
            clause: None,
        }
    }
}

impl UpdateBuilder for UpdateProps {
    fn set<T: ToSQLData>(mut self, column: &str, new_value: T) -> Self {
        self.set_match.push(
            SetMatch {
                column: column.to_string(),
                value: new_value.fmt_data(),
                query: false,
            }
        );
        self
    }

    fn set_query(mut self, column: &str, query: &str) -> Self {
        self.set_match.push(
            SetMatch {
                column: column.to_string(),
                value: query.fmt_data(),
                query: true,
            }
        );
        self
    }

    fn where_in<T: ToSQLData>(mut self, column: &str, values: Vec<T>) -> Self {
        let value = where_clause_value_format(values);
        let where_clause = format!("{} IN ({})", column, value);
        self.clause = Some(where_clause);
        self
    }

    fn where_not<T: ToSQLData>(mut self, column: &str, values: Vec<T>) -> Self {
        let value = where_clause_value_format(values);
        let where_clause = format!("{} NOT IN ({})", column, value);
        self.clause = Some(where_clause);
        self
    }

    fn where_null(mut self, column: &str) -> Self {
        let where_clause = format!("{column} IS NULL");
        self.clause = Some(where_clause);
        self
    }
    
    fn where_not_null(mut self, column: &str) -> Self {
        let where_clause = format!("{column} IS NOT NULL");
        self.clause = Some(where_clause);
        self
    }

    fn build(self) -> Result<(), Error> {
        match self.connect {
            SQLVariation::Oracle(_) => {
                oracle_build_update(self)?;
                Ok(())
            },
            SQLVariation::SQLite(_) => {
                sqlite_build_update(self)?;
                Ok(())
            },
        }
    }

    fn build_return_count(self) -> Result<usize, Error> {
        match self.connect {
            SQLVariation::Oracle(_) => oracle_build_update(self),
            SQLVariation::SQLite(_) => sqlite_build_update(self),
        }
    }
}

pub fn batch_update(updates: Vec<UpdateProps>) -> Result<(), Error> {
    let connect = &updates[0].connect;
    match connect {
        SQLVariation::Oracle(_) => batch_update_oracle(updates),
        SQLVariation::SQLite(_) => batch_update_sqlite(updates),
    }
}