grorm 0.1.1

Goroutine-native ORM for Rust with multi-database support
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

use crate::types::Value;

pub struct UpdateBuilder {
    table: String,
    sets: Vec<(String, Value)>,
    conditions: Vec<(String, String, Value)>,
}

impl UpdateBuilder {
    pub fn new(table: &str) -> Self {
        UpdateBuilder {
            table: table.to_string(),
            sets: Vec::new(),
            conditions: Vec::new(),
        }
    }

    pub fn set(mut self, column: &str, value: Value) -> Self {
        self.sets.push((column.to_string(), value));
        self
    }

    pub fn where_eq(mut self, column: &str, value: Value) -> Self {
        self.conditions
            .push((column.to_string(), "=".to_string(), value));
        self
    }

    pub fn where_ne(mut self, column: &str, value: Value) -> Self {
        self.conditions
            .push((column.to_string(), "!=".to_string(), value));
        self
    }

    pub fn build(&self) -> (String, Vec<Value>) {
        let mut sql = format!("UPDATE {}", self.table);
        let mut params = Vec::new();

        if !self.sets.is_empty() {
            let set_clauses: Vec<String> = self
                .sets
                .iter()
                .map(|(col, val)| {
                    params.push(val.clone());
                    format!("{} = ?", col)
                })
                .collect();
            sql.push_str(&format!(" SET {}", set_clauses.join(", ")));
        }

        if !self.conditions.is_empty() {
            let clauses: Vec<String> = self
                .conditions
                .iter()
                .map(|(col, op, val)| {
                    params.push(val.clone());
                    format!("{} {} ?", col, op)
                })
                .collect();
            sql.push_str(&format!(" WHERE {}", clauses.join(" AND ")));
        }

        (sql, params)
    }
}