a3s-orm 0.3.1

A type-safe, executor-neutral SQL query builder for Rust
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

use std::marker::PhantomData;

use crate::ast::{QueryNode, TableNode, UpdateAssignment, UpdateNode};
use crate::expression::{Column, Expression, Selection};
use crate::function::TypedExpression;
use crate::schema::Table;
use crate::value::IntoSqlValue;

use super::{Cte, Query};

#[derive(Clone, Debug)]
pub struct UpdateQuery<T: Table, O = ()> {
    node: UpdateNode,
    marker: PhantomData<fn() -> (T, O)>,
}

pub fn update_table<T: Table>() -> UpdateQuery<T> {
    UpdateQuery {
        node: UpdateNode {
            ctes: Vec::new(),
            table: TableNode {
                name: T::NAME,
                alias: None,
            },
            assignments: Vec::new(),
            from: Vec::new(),
            filter: None,
            returning: Vec::new(),
        },
        marker: PhantomData,
    }
}

impl<T: Table, O> UpdateQuery<T, O> {
    pub fn with<C: Table>(mut self, cte: Cte<C>) -> Self {
        self.node.ctes.push(cte.node);
        self
    }

    pub fn set<V>(mut self, column: Column<T, V>, value: impl IntoSqlValue<V>) -> Self {
        self.node.assignments.push(UpdateAssignment {
            table: column.table_name(),
            column: column.name(),
            value: Expression::Value(value.into_sql_value()),
        });
        self
    }

    pub fn set_expression<V>(mut self, column: Column<T, V>, value: TypedExpression<V>) -> Self {
        self.node.assignments.push(UpdateAssignment {
            table: column.table_name(),
            column: column.name(),
            value: value.expression(),
        });
        self
    }

    pub fn from<F: Table>(mut self) -> Self {
        self.node.from.push(TableNode {
            name: F::NAME,
            alias: None,
        });
        self
    }

    pub fn filter(mut self, expression: Expression) -> Self {
        self.node.filter = Some(match self.node.filter.take() {
            Some(existing) => existing.and(expression),
            None => expression,
        });
        self
    }

    pub fn returning<S: Selection>(mut self, selection: S) -> UpdateQuery<T, S::Output> {
        self.node.returning.extend(selection.expressions());
        UpdateQuery {
            node: self.node,
            marker: PhantomData,
        }
    }
}

impl<T: Table, O> Query for UpdateQuery<T, O> {
    type Output = O;

    fn compile(self, dialect: &impl crate::Dialect) -> crate::Result<crate::CompiledQuery> {
        crate::compiler::compile(QueryNode::Update(self.node), dialect)
    }
}