qoo 0.1.1

query builder library. Query Object Oriented.
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

use crate::base::{Base, SelectDeleteBase, SelectInsertBase, SelectUpdateDeleteBase};

/// Structure for select statement.
pub struct SelectBuilder {
    q: String
}

impl SelectBuilder {
    /// Assemble the select statement.
    ///
    ///
    /// # Examples
    ///
    /// ```
    /// let select_query =
    ///     SelectBuilder::select(["col0", "col1"].to_vec())
    ///         .columns(["col2", "col3"].to_vec())
    ///         .from("table1")
    ///         .wheres("id >= 100");
    /// assert_eq!(
    ///     select_query.to_sql(),
    ///     "select col0, col1, col2, col3 from table1 where id >= 100".to_string()
    /// );
    /// ```
    pub fn select(columns: Vec<&str>) -> Self {
        let mut clms: String = "".to_string();
        let cs = &columns;
        for c in cs {
            if cs.last() == Some(&c) {
                clms = format!("{}{}", clms, c.to_string());
                break;
            }
            clms = format!("{}{}, ", clms, c.to_string())
        }

        SelectBuilder {
            q: format!("{} {}", "select", clms),
        }
    }

    pub fn columns(mut self, columns: Vec<&str>) -> Self {
        let exists_prev_clmn = self.q.split(" ").count();
        if exists_prev_clmn >= 2 {
            self.q = format!("{},", self.q);
        }

        let clms = self.clmns(columns);
        self.q = format!("{} {}", self.q, clms);
        self
    }

    pub fn from(mut self, table: &str) -> Self {
        self.q = self.from_phrase(table);
        self
    }

    pub fn wheres(mut self, where_str: &str) -> Self {
        self.q = self.where_phrase(where_str);
        self
    }
}

impl Base for SelectBuilder {
    fn query(&self) -> String {
        self.q.to_string()
    }
}

impl SelectDeleteBase for SelectBuilder {}

impl SelectInsertBase for SelectBuilder {
    fn clmns(&self, columns: Vec<&str>) -> String {
        let mut clms: String = "".to_string();
        let cs = &columns;
        for c in cs {
            if cs.last() == Some(&c) {
                clms = format!("{}{}", clms, c.to_string());
                break;
            }
            clms = format!("{}{}, ", clms, c.to_string())
        }
        clms
    }
}

impl SelectUpdateDeleteBase for SelectBuilder {}