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 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116
use crate::{ backend::QueryBuilder, prepare::inject_parameters, value::{Value, Values}, }; pub trait QueryStatementBuilder { /// Build corresponding SQL statement for certain database backend and return SQL string /// /// # Examples /// /// ``` /// use sea_query::{*, tests_cfg::*}; /// /// let query = Query::select() /// .column(Glyph::Aspect) /// .from(Glyph::Table) /// .and_where(Expr::expr(Expr::col(Glyph::Aspect).if_null(0)).gt(2)) /// .order_by(Glyph::Image, Order::Desc) /// .order_by_tbl(Glyph::Table, Glyph::Aspect, Order::Asc) /// .to_string(MysqlQueryBuilder); /// /// assert_eq!( /// query, /// r#"SELECT `aspect` FROM `glyph` WHERE IFNULL(`aspect`, 0) > 2 ORDER BY `image` DESC, `glyph`.`aspect` ASC"# /// ); /// ``` fn to_string<T: QueryBuilder>(&self, query_builder: T) -> String { let (sql, values) = self.build_any(&query_builder); inject_parameters(&sql, values.0, &query_builder) } /// Build corresponding SQL statement for certain database backend and collect query parameters into a vector /// /// # Examples /// /// ``` /// use sea_query::{*, tests_cfg::*}; /// /// let (query, params) = Query::select() /// .column(Glyph::Aspect) /// .from(Glyph::Table) /// .and_where(Expr::expr(Expr::col(Glyph::Aspect).if_null(0)).gt(2)) /// .order_by(Glyph::Image, Order::Desc) /// .order_by_tbl(Glyph::Table, Glyph::Aspect, Order::Asc) /// .build(MysqlQueryBuilder); /// /// assert_eq!( /// query, /// r#"SELECT `aspect` FROM `glyph` WHERE IFNULL(`aspect`, ?) > ? ORDER BY `image` DESC, `glyph`.`aspect` ASC"# /// ); /// assert_eq!( /// params, /// Values(vec![Value::Int(0), Value::Int(2)]) /// ); /// ``` fn build<T: QueryBuilder>(&self, query_builder: T) -> (String, Values) { let mut values = Vec::new(); let mut collector = |v| values.push(v); let sql = self.build_collect(query_builder, &mut collector); (sql, Values(values)) } /// Build corresponding SQL statement for certain database backend and collect query parameters into a vector fn build_any(&self, query_builder: &dyn QueryBuilder) -> (String, Values) { let mut values = Vec::new(); let mut collector = |v| values.push(v); let sql = self.build_collect_any(query_builder, &mut collector); (sql, Values(values)) } /// Build corresponding SQL statement for certain database backend and collect query parameters /// /// # Examples /// /// ``` /// use sea_query::{*, tests_cfg::*}; /// /// let query = Query::select() /// .column(Glyph::Aspect) /// .from(Glyph::Table) /// .and_where(Expr::expr(Expr::col(Glyph::Aspect).if_null(0)).gt(2)) /// .order_by(Glyph::Image, Order::Desc) /// .order_by_tbl(Glyph::Table, Glyph::Aspect, Order::Asc) /// .to_owned(); /// /// assert_eq!( /// query.to_string(MysqlQueryBuilder), /// r#"SELECT `aspect` FROM `glyph` WHERE IFNULL(`aspect`, 0) > 2 ORDER BY `image` DESC, `glyph`.`aspect` ASC"# /// ); /// /// let mut params = Vec::new(); /// let mut collector = |v| params.push(v); /// /// assert_eq!( /// query.build_collect(MysqlQueryBuilder, &mut collector), /// r#"SELECT `aspect` FROM `glyph` WHERE IFNULL(`aspect`, ?) > ? ORDER BY `image` DESC, `glyph`.`aspect` ASC"# /// ); /// assert_eq!( /// params, /// vec![Value::Int(0), Value::Int(2)] /// ); /// ``` fn build_collect<T: QueryBuilder>( &self, query_builder: T, collector: &mut dyn FnMut(Value), ) -> String; /// Build corresponding SQL statement for certain database backend and collect query parameters fn build_collect_any( &self, query_builder: &dyn QueryBuilder, collector: &mut dyn FnMut(Value), ) -> String; }