dinoco_engine 0.0.7

Database adapters, query execution, and migration engine components for Dinoco.
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

use crate::{DinocoValue, Expression, UpdateBatchItem};

#[derive(Debug, Clone, PartialEq)]
pub enum UpdateOperation {
    Set(DinocoValue),
    Increment(DinocoValue),
    Decrement(DinocoValue),
    Multiply(DinocoValue),
    Division(DinocoValue),
}

#[derive(Debug, Clone, PartialEq)]
pub struct UpdateAssignment {
    pub column: String,
    pub operation: UpdateOperation,
}

#[derive(Debug, Clone, PartialEq, Eq)]
pub struct UpdateTarget {
    pub primary_keys: Vec<String>,
}

#[derive(Debug, Clone, Default)]
pub struct UpdateStatement {
    pub table: String,
    pub sets: Vec<UpdateAssignment>,
    pub conditions: Vec<Expression>,
    pub batches: Vec<UpdateBatchItem>,
    pub target: Option<UpdateTarget>,
}

impl UpdateStatement {
    pub fn new() -> Self {
        Self::default()
    }

    pub fn table(mut self, table: impl Into<String>) -> Self {
        self.table = table.into();
        self
    }

    pub fn set(mut self, column: impl Into<String>, value: impl Into<DinocoValue>) -> Self {
        self.sets.push(UpdateAssignment { column: column.into(), operation: UpdateOperation::Set(value.into()) });
        self
    }

    pub fn increment(mut self, column: impl Into<String>, value: impl Into<DinocoValue>) -> Self {
        self.sets.push(UpdateAssignment { column: column.into(), operation: UpdateOperation::Increment(value.into()) });
        self
    }

    pub fn decrement(mut self, column: impl Into<String>, value: impl Into<DinocoValue>) -> Self {
        self.sets.push(UpdateAssignment { column: column.into(), operation: UpdateOperation::Decrement(value.into()) });
        self
    }

    pub fn multiply(mut self, column: impl Into<String>, value: impl Into<DinocoValue>) -> Self {
        self.sets.push(UpdateAssignment { column: column.into(), operation: UpdateOperation::Multiply(value.into()) });
        self
    }

    pub fn division(mut self, column: impl Into<String>, value: impl Into<DinocoValue>) -> Self {
        self.sets.push(UpdateAssignment { column: column.into(), operation: UpdateOperation::Division(value.into()) });
        self
    }

    pub fn target_first_match(mut self, primary_keys: &[&str]) -> Self {
        self.target = Some(UpdateTarget { primary_keys: primary_keys.iter().map(|item| item.to_string()).collect() });
        self
    }

    pub fn condition(mut self, condition: Expression) -> Self {
        self.conditions.push(condition);
        self
    }

    pub fn batch(mut self, item: UpdateBatchItem) -> Self {
        self.batches.push(item);

        self
    }
}