Trait sea_query::backend::QueryBuilder

pub trait QueryBuilder: QuotedBuilder {
    fn prepare_query_statement(
        &self, 
        query: &SubQueryStatement, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    );

    fn placeholder(&self) -> (&str, bool) { ... }
    fn prepare_insert_statement(
        &self, 
        insert: &InsertStatement, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_select_statement(
        &self, 
        select: &SelectStatement, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_update_statement(
        &self, 
        update: &UpdateStatement, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_delete_statement(
        &self, 
        delete: &DeleteStatement, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_simple_expr(
        &self, 
        simple_expr: &SimpleExpr, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_simple_expr_common(
        &self, 
        simple_expr: &SimpleExpr, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_select_distinct(
        &self, 
        select_distinct: &SelectDistinct, 
        sql: &mut SqlWriter, 
        _collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_select_lock(
        &self, 
        lock: &LockClause, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_select_expr(
        &self, 
        select_expr: &SelectExpr, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_join_expr(
        &self, 
        join_expr: &JoinExpr, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_join_table_ref(
        &self, 
        join_expr: &JoinExpr, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_table_ref(
        &self, 
        table_ref: &TableRef, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_table_ref_common(
        &self, 
        table_ref: &TableRef, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_un_oper(
        &self, 
        un_oper: &UnOper, 
        sql: &mut SqlWriter, 
        _collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_bin_oper_common(
        &self, 
        bin_oper: &BinOper, 
        sql: &mut SqlWriter, 
        _collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_bin_oper(
        &self, 
        bin_oper: &BinOper, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_logical_chain_oper(
        &self, 
        log_chain_oper: &LogicalChainOper, 
        i: usize, 
        length: usize, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_function_common(
        &self, 
        function: &Function, 
        sql: &mut SqlWriter, 
        _collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_with_query(
        &self, 
        query: &WithQuery, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_with_clause(
        &self, 
        with_clause: &WithClause, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_with_clause_recursive_options(
        &self, 
        with_clause: &WithClause, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_with_clause_common_tables(
        &self, 
        with_clause: &WithClause, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_with_query_clause_common_table(
        &self, 
        cte: &CommonTableExpression, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_with_query_clause_materialization(
        &self, 
        cte: &CommonTableExpression, 
        sql: &mut SqlWriter
    ) { ... }
    fn prepare_with_clause_start(
        &self, 
        with_clause: &WithClause, 
        sql: &mut SqlWriter
    ) { ... }
    fn prepare_insert(&self, replace: bool, sql: &mut SqlWriter) { ... }
    fn prepare_function(
        &self, 
        function: &Function, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_join_type(
        &self, 
        join_type: &JoinType, 
        sql: &mut SqlWriter, 
        _collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_order_expr(
        &self, 
        order_expr: &OrderExpr, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_join_on(
        &self, 
        join_on: &JoinOn, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_order(
        &self, 
        order_expr: &OrderExpr, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_field_order(
        &self, 
        order_expr: &OrderExpr, 
        values: &Values, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_value(
        &self, 
        value: &Value, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_tuple(
        &self, 
        exprs: &[SimpleExpr], 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    ) { ... }
    fn prepare_keyword(
        &self, 
        keyword: &Keyword, 
        sql: &mut SqlWriter, 
        _collector: &mut dyn FnMut(Value)
    ) { ... }
    fn value_to_string(&self, v: &Value) -> String { ... }
    fn insert_default_keyword(&self) -> &str { ... }
    fn insert_default_values(&self, num_rows: u32, sql: &mut SqlWriter) { ... }
}

Required Methods

fn prepare_query_statement(
    &self,
    query: &SubQueryStatement,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

Translate QueryStatement into SQL statement.

Provided Methods

fn placeholder(&self) -> (&str, bool)

The type of placeholder the builder uses for values, and whether it is numbered.

fn prepare_insert_statement(
    &self,
    insert: &InsertStatement,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

Translate InsertStatement into SQL statement.

fn prepare_select_statement(
    &self,
    select: &SelectStatement,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

Translate SelectStatement into SQL statement.

fn prepare_update_statement(
    &self,
    update: &UpdateStatement,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

Translate UpdateStatement into SQL statement.

fn prepare_delete_statement(
    &self,
    delete: &DeleteStatement,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

Translate DeleteStatement into SQL statement.

fn prepare_simple_expr(
    &self,
    simple_expr: &SimpleExpr,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

Translate SimpleExpr into SQL statement.

fn prepare_simple_expr_common(
    &self,
    simple_expr: &SimpleExpr,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

fn prepare_select_distinct(
    &self,
    select_distinct: &SelectDistinct,
    sql: &mut SqlWriter,
    _collector: &mut dyn FnMut(Value)
)

Translate SelectDistinct into SQL statement.

fn prepare_select_lock(
    &self,
    lock: &LockClause,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

Translate LockType into SQL statement.

fn prepare_select_expr(
    &self,
    select_expr: &SelectExpr,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

Translate SelectExpr into SQL statement.

fn prepare_join_expr(
    &self,
    join_expr: &JoinExpr,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

Translate JoinExpr into SQL statement.

fn prepare_join_table_ref(
    &self,
    join_expr: &JoinExpr,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

fn prepare_table_ref(
    &self,
    table_ref: &TableRef,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

Translate TableRef into SQL statement.

fn prepare_table_ref_common(
    &self,
    table_ref: &TableRef,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

fn prepare_un_oper(
    &self,
    un_oper: &UnOper,
    sql: &mut SqlWriter,
    _collector: &mut dyn FnMut(Value)
)

Translate UnOper into SQL statement.

fn prepare_bin_oper_common(
    &self,
    bin_oper: &BinOper,
    sql: &mut SqlWriter,
    _collector: &mut dyn FnMut(Value)
)

fn prepare_bin_oper(
    &self,
    bin_oper: &BinOper,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

Translate BinOper into SQL statement.

fn prepare_logical_chain_oper(
    &self,
    log_chain_oper: &LogicalChainOper,
    i: usize,
    length: usize,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

Translate LogicalChainOper into SQL statement.

fn prepare_function_common(
    &self,
    function: &Function,
    sql: &mut SqlWriter,
    _collector: &mut dyn FnMut(Value)
)

Translate Function into SQL statement.

fn prepare_with_query(
    &self,
    query: &WithQuery,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

fn prepare_with_clause(
    &self,
    with_clause: &WithClause,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

fn prepare_with_clause_recursive_options(
    &self,
    with_clause: &WithClause,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

fn prepare_with_clause_common_tables(
    &self,
    with_clause: &WithClause,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

fn prepare_with_query_clause_common_table(
    &self,
    cte: &CommonTableExpression,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

fn prepare_with_query_clause_materialization(
    &self,
    cte: &CommonTableExpression,
    sql: &mut SqlWriter
)

fn prepare_with_clause_start(
    &self,
    with_clause: &WithClause,
    sql: &mut SqlWriter
)

fn prepare_insert(&self, replace: bool, sql: &mut SqlWriter)

fn prepare_function(
    &self,
    function: &Function,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

fn prepare_join_type(
    &self,
    join_type: &JoinType,
    sql: &mut SqlWriter,
    _collector: &mut dyn FnMut(Value)
)

Translate JoinType into SQL statement.

fn prepare_order_expr(
    &self,
    order_expr: &OrderExpr,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

Translate OrderExpr into SQL statement.

fn prepare_join_on(
    &self,
    join_on: &JoinOn,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

Translate JoinOn into SQL statement.

fn prepare_order(
    &self,
    order_expr: &OrderExpr,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

Translate Order into SQL statement.

fn prepare_field_order(
    &self,
    order_expr: &OrderExpr,
    values: &Values,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

Translate Order::Field into SQL statement

fn prepare_value(
    &self,
    value: &Value,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

Translate Value into SQL statement.

fn prepare_tuple(
    &self,
    exprs: &[SimpleExpr],
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

Translate SimpleExpr::Tuple into SQL statement.

fn prepare_keyword(
    &self,
    keyword: &Keyword,
    sql: &mut SqlWriter,
    _collector: &mut dyn FnMut(Value)
)

Translate Keyword into SQL statement.

fn value_to_string(&self, v: &Value) -> String

Convert a SQL value into syntax-specific string

fn insert_default_keyword(&self) -> &str

The keywords for insert default row.

fn insert_default_values(&self, num_rows: u32, sql: &mut SqlWriter)

Write insert default rows expression.

Implementors

impl QueryBuilder for MysqlQueryBuilder

Available on crate feature backend-mysql only.

impl QueryBuilder for PostgresQueryBuilder

Available on crate feature backend-postgres only.

impl QueryBuilder for SqliteQueryBuilder

Available on crate feature backend-sqlite only.