sqlx_clean_querybuilder 0.1.7

Simple, clean querybuidler for sqlx!
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

pub struct InsertQuery {
    table: String,
    columns: Vec<String>,
    values: Vec<String>,
    returning: Vec<String>,
}

impl InsertQuery {
    pub fn new(table: &str) -> Self {
        Self {
            table: table.to_string(),
            columns: Vec::new(),
            values: Vec::new(),
            returning: Vec::new(),
        }
    }

    /// INSERT INTO table (col1, col2, ...)
    pub fn columns(mut self, cols: &[&str]) -> Self {
        self.columns = cols.iter().map(|s| s.to_string()).collect();
        self
    }

    /// VALUES (val1, val2, ...)
    pub fn values(mut self, vals: &[&str]) -> Self {
        self.values = vals.iter().map(|s| s.to_string()).collect();
        self
    }

    /// RETURNING col1, col2 (Postgres-specific)
    pub fn returning(mut self, cols: &[&str]) -> Self {
        self.returning = cols.iter().map(|s| s.to_string()).collect();
        self
    }

    /// Build SQL string
    pub fn build(self) -> String {
        let mut query = format!("INSERT INTO {}", self.table);

        if !self.columns.is_empty() {
            query.push_str(&format!(" ({})", self.columns.join(", ")));
        }

        if !self.values.is_empty() {
            query.push_str(&format!(" VALUES ({})", self.values.join(", ")));
        }

        if !self.returning.is_empty() {
            query.push_str(&format!(" RETURNING {}", self.returning.join(", ")));
        }

        query
    }
}