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
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

use crate::{
  concat::{concat_raw_before_after, Concat},
  fmt,
  structure::{Values, ValuesClause},
};

impl Concat for Values {
  fn concat(&self, fmts: &fmt::Formatter) -> String {
    let mut query = "".to_string();

    query = self.concat_raw(query, &fmts, &self._raw);
    query = self.concat_values(query, &fmts);

    query.trim_end().to_string()
  }
}

impl Values {
  fn concat_values(&self, query: String, fmts: &fmt::Formatter) -> String {
    let fmt::Formatter { comma, lb, space, .. } = fmts;
    let sql = if self._values.is_empty() == false {
      let sep = format!("{comma}{lb}");
      let rows = self
        ._values
        .iter()
        .filter(|item| item.is_empty() == false)
        .map(|item| {
          #[cfg(not(feature = "mysql"))]
          {
            item.clone()
          }
          #[cfg(feature = "mysql")]
          {
            format!("ROW{item}")
          }
        })
        .collect::<Vec<_>>()
        .join(&sep);

      if rows.is_empty() == true {
        return "".to_string();
      };

      format!("VALUES{space}{lb}{rows}{space}{lb}")
    } else {
      "".to_string()
    };

    concat_raw_before_after(
      &self._raw_before,
      &self._raw_after,
      query,
      fmts,
      ValuesClause::Values,
      sql,
    )
  }
}