use crate::{
backend::QueryBuilder,
prepare::inject_parameters,
value::{Value, Values},
SqlWriter, SubQueryStatement,
};
use std::fmt::Debug;
pub trait QueryStatementBuilder: Debug {
/// 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
fn build_collect_any(
&self,
query_builder: &dyn QueryBuilder,
collector: &mut dyn FnMut(Value),
) -> String {
let mut sql = SqlWriter::new();
self.build_collect_any_into(query_builder, &mut sql, collector);
sql.result()
}
/// Build corresponding SQL statement into the SqlWriter for certain database backend and collect query parameters
fn build_collect_any_into(
&self,
query_builder: &dyn QueryBuilder,
sql: &mut SqlWriter,
collector: &mut dyn FnMut(Value),
);
fn into_sub_query_statement(self) -> SubQueryStatement;
}
pub trait QueryStatementWriter: 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(Some(0)), Value::Int(Some(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
///
/// # 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(Some(0)), Value::Int(Some(2))]
/// );
/// ```
fn build_collect<T: QueryBuilder>(
&self,
query_builder: T,
collector: &mut dyn FnMut(Value),
) -> String;
}