Trait sea_query::backend::QueryBuilder

pub trait QueryBuilder {
    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_select_distinct(
        &self, 
        select_distinct: &SelectDistinct, 
        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_table_ref(
        &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(
        &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(
        &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: &Order, 
        sql: &mut SqlWriter, 
        collector: &mut dyn FnMut(Value)
    );
    fn prepare_value(
        &self, 
        value: &Value, 
        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;
}

Required methods

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

Translate InsertStatement into database specific SQL statement.

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

Translate SelectStatement into database specific SQL statement.

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

Translate UpdateStatement into database specific SQL statement.

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

Translate DeleteStatement into database specific SQL statement.

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

Translate SimpleExpr into database specific SQL statement.

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

Translate SelectDistinct into database specific SQL statement.

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

Translate SelectExpr into database specific SQL statement.

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

Translate JoinExpr into database specific SQL statement.

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

Translate TableRef into database specific SQL statement.

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

Translate UnOper into database specific SQL statement.

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

Translate BinOper into database specific 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 database specific SQL statement.

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

Translate Function into database specific SQL statement.

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

Translate JoinType into database specific SQL statement.

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

Translate OrderExpr into database specific SQL statement.

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

Translate JoinOn into database specific SQL statement.

fn prepare_order(
    &self,
    order: &Order,
    sql: &mut SqlWriter,
    collector: &mut dyn FnMut(Value)
)

Translate Order into database specific SQL statement.

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

Translate Value into database specific SQL statement.

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

Translate Keyword into database specific SQL statement.

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

Convert a SQL value into syntax-specific string

Loading content...

Implementors

impl QueryBuilder for MysqlQueryBuilder

This is supported on crate feature backend-mysql only.

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_select_distinct(
    &self,
    select_distinct: &SelectDistinct,
    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_table_ref(
    &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(
    &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(
    &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: &Order,
    sql: &mut SqlWriter,
    _collector: &mut dyn FnMut(Value)
)

fn prepare_value(
    &self,
    value: &Value,
    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

impl QueryBuilder for PostgresQueryBuilder

This is supported on crate feature backend-postgres only.

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_select_distinct(
    &self,
    select_distinct: &SelectDistinct,
    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_table_ref(
    &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(
    &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(
    &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: &Order,
    sql: &mut SqlWriter,
    _collector: &mut dyn FnMut(Value)
)

fn prepare_value(
    &self,
    value: &Value,
    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

impl QueryBuilder for SqliteQueryBuilder

This is supported on crate feature backend-sqlite only.

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_select_distinct(
    &self,
    select_distinct: &SelectDistinct,
    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_table_ref(
    &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(
    &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(
    &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: &Order,
    sql: &mut SqlWriter,
    _collector: &mut dyn FnMut(Value)
)

fn prepare_value(
    &self,
    value: &Value,
    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

Loading content...