sql_query_builder 2.6.2

Write SQL queries in a simple and composable way
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

#[cfg(feature = "sqlite")]
use crate::{
  concat::concat_raw_before_after,
  fmt,
  structure::{UpdateClause, UpdateVars},
};

#[cfg(feature = "sqlite")]
pub(crate) trait ConcatUpdate {
  fn concat_update(
    &self,
    items_raw_before: &Vec<(UpdateClause, String)>,
    items_raw_after: &Vec<(UpdateClause, String)>,
    query: String,
    fmts: &fmt::Formatter,
    update: &(UpdateVars, String),
  ) -> String {
    let fmt::Formatter { lb, space, .. } = fmts;
    let (clause, sql) = match update {
      (UpdateVars::Update, table_name) if table_name.is_empty() => (UpdateClause::Update, "".to_string()),
      (UpdateVars::Update, table_name) => (UpdateClause::Update, format!("UPDATE{space}{table_name}{space}{lb}")),

      (UpdateVars::UpdateOr, expression) if expression.is_empty() => (UpdateClause::UpdateOr, "".to_string()),
      (UpdateVars::UpdateOr, expression) => (
        UpdateClause::UpdateOr,
        format!("UPDATE OR{space}{expression}{space}{lb}"),
      ),
    };

    concat_raw_before_after(items_raw_before, items_raw_after, query, fmts, clause, sql)
  }
}