Struct migration::SqliteQueryBuilder
pub struct SqliteQueryBuilder;
Expand description
Sqlite query builder.
Trait Implementations§
§impl Debug for SqliteQueryBuilder
impl Debug for SqliteQueryBuilder
§impl Default for SqliteQueryBuilder
impl Default for SqliteQueryBuilder
§fn default() -> SqliteQueryBuilder
fn default() -> SqliteQueryBuilder
Returns the “default value” for a type. Read more
§impl EscapeBuilder for SqliteQueryBuilder
impl EscapeBuilder for SqliteQueryBuilder
§fn escape_string(&self, string: &str) -> String
fn escape_string(&self, string: &str) -> String
Escape a SQL string literal
§fn unescape_string(&self, string: &str) -> String
fn unescape_string(&self, string: &str) -> String
Unescape a SQL string literal
§impl ForeignKeyBuilder for SqliteQueryBuilder
impl ForeignKeyBuilder for SqliteQueryBuilder
§fn prepare_foreign_key_create_statement(
&self,
create: &ForeignKeyCreateStatement,
sql: &mut SqlWriter
)
fn prepare_foreign_key_create_statement( &self, create: &ForeignKeyCreateStatement, sql: &mut SqlWriter )
Translate
ForeignKeyCreateStatement
into SQL statement.§fn prepare_foreign_key_drop_statement(
&self,
drop: &ForeignKeyDropStatement,
sql: &mut SqlWriter
)
fn prepare_foreign_key_drop_statement( &self, drop: &ForeignKeyDropStatement, sql: &mut SqlWriter )
Translate
ForeignKeyDropStatement
into SQL statement.§fn prepare_foreign_key_action(
&self,
foreign_key_action: &ForeignKeyAction,
sql: &mut SqlWriter
)
fn prepare_foreign_key_action( &self, foreign_key_action: &ForeignKeyAction, sql: &mut SqlWriter )
Translate
ForeignKeyAction
into SQL statement.§impl IndexBuilder for SqliteQueryBuilder
impl IndexBuilder for SqliteQueryBuilder
§fn prepare_table_index_expression(
&self,
create: &IndexCreateStatement,
sql: &mut SqlWriter
)
fn prepare_table_index_expression( &self, create: &IndexCreateStatement, sql: &mut SqlWriter )
Translate
IndexCreateStatement
into SQL expression.§fn prepare_index_create_statement(
&self,
create: &IndexCreateStatement,
sql: &mut SqlWriter
)
fn prepare_index_create_statement( &self, create: &IndexCreateStatement, sql: &mut SqlWriter )
Translate
IndexCreateStatement
into SQL statement.§fn prepare_index_drop_statement(
&self,
drop: &IndexDropStatement,
sql: &mut SqlWriter
)
fn prepare_index_drop_statement( &self, drop: &IndexDropStatement, sql: &mut SqlWriter )
Translate
IndexDropStatement
into SQL statement.§impl QueryBuilder for SqliteQueryBuilder
impl QueryBuilder for SqliteQueryBuilder
§fn prepare_select_lock(
&self,
_select_lock: &LockClause,
_sql: &mut SqlWriter,
_collector: &mut dyn FnMut(Value)
)
fn prepare_select_lock( &self, _select_lock: &LockClause, _sql: &mut SqlWriter, _collector: &mut dyn FnMut(Value) )
Translate
LockType
into SQL statement.§fn prepare_order_expr(
&self,
order_expr: &OrderExpr,
sql: &mut SqlWriter,
collector: &mut dyn FnMut(Value)
)
fn prepare_order_expr( &self, order_expr: &OrderExpr, sql: &mut SqlWriter, collector: &mut dyn FnMut(Value) )
Translate
OrderExpr
into SQL statement.§fn prepare_query_statement(
&self,
query: &SubQueryStatement,
sql: &mut SqlWriter,
collector: &mut dyn FnMut(Value)
)
fn prepare_query_statement( &self, query: &SubQueryStatement, sql: &mut SqlWriter, collector: &mut dyn FnMut(Value) )
Translate
QueryStatement
into SQL statement.fn prepare_with_clause_recursive_options( &self, _: &WithClause, _: &mut SqlWriter, _: &mut dyn FnMut(Value) )
§fn insert_default_values(&self, _: u32, sql: &mut SqlWriter)
fn insert_default_values(&self, _: u32, sql: &mut SqlWriter)
Write insert default rows expression.
§fn placeholder(&self) -> (&str, bool)
fn placeholder(&self) -> (&str, bool)
The type of placeholder the builder uses for values, and whether it is numbered.
§fn values_list_tuple_prefix(&self) -> &str
fn values_list_tuple_prefix(&self) -> &str
Prefix for tuples in VALUES list (e.g. ROW for Mysql)
§fn prepare_insert_statement(
&self,
insert: &InsertStatement,
sql: &mut SqlWriter,
collector: &mut dyn FnMut(Value)
)
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)
)
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)
)
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)
)
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)
)
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_case_statement(
&self,
stmts: &CaseStatement,
sql: &mut SqlWriter,
collector: &mut dyn FnMut(Value)
)
fn prepare_case_statement( &self, stmts: &CaseStatement, sql: &mut SqlWriter, collector: &mut dyn FnMut(Value) )
Translate
CaseStatement
into SQL statement.§fn prepare_select_distinct(
&self,
select_distinct: &SelectDistinct,
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_expr(
&self,
select_expr: &SelectExpr,
sql: &mut SqlWriter,
collector: &mut dyn FnMut(Value)
)
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)
)
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)
)
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_column_ref(&self, column_ref: &ColumnRef, sql: &mut SqlWriter)
§fn prepare_un_oper(
&self,
un_oper: &UnOper,
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)
)
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)
)
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)
)
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_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_join_type( &self, join_type: &JoinType, sql: &mut SqlWriter, _collector: &mut dyn FnMut(Value) )
Translate
JoinType
into SQL statement.§fn prepare_join_on(
&self,
join_on: &JoinOn,
sql: &mut SqlWriter,
collector: &mut dyn FnMut(Value)
)
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)
)
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)
)
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)
)
fn prepare_value( &self, value: &Value, sql: &mut SqlWriter, collector: &mut dyn FnMut(Value) )
Write
Value
into SQL statement as parameter.§fn prepare_constant(&self, value: &Value, sql: &mut SqlWriter)
fn prepare_constant(&self, value: &Value, sql: &mut SqlWriter)
Write
Value
inline.§fn prepare_values_list(
&self,
value_tuples: &[ValueTuple],
sql: &mut SqlWriter,
collector: &mut dyn FnMut(Value)
)
fn prepare_values_list( &self, value_tuples: &[ValueTuple], sql: &mut SqlWriter, collector: &mut dyn FnMut(Value) )
Translate a
&[ValueTuple]
into a VALUES list.§fn prepare_tuple(
&self,
exprs: &[SimpleExpr],
sql: &mut SqlWriter,
collector: &mut dyn FnMut(Value)
)
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)
)
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
fn value_to_string(&self, v: &Value) -> String
Convert a SQL value into syntax-specific string
§fn insert_default_keyword(&self) -> &str
fn insert_default_keyword(&self) -> &str
The keywords for insert default row.
§impl QuotedBuilder for SqliteQueryBuilder
impl QuotedBuilder for SqliteQueryBuilder
§impl TableBuilder for SqliteQueryBuilder
impl TableBuilder for SqliteQueryBuilder
§fn prepare_column_def(&self, column_def: &ColumnDef, sql: &mut SqlWriter)
fn prepare_column_def(&self, column_def: &ColumnDef, sql: &mut SqlWriter)
Translate
ColumnDef
into SQL statement.§fn prepare_column_type(&self, column_type: &ColumnType, sql: &mut SqlWriter)
fn prepare_column_type(&self, column_type: &ColumnType, sql: &mut SqlWriter)
Translate
ColumnType
into SQL statement.§fn prepare_column_spec(&self, column_spec: &ColumnSpec, sql: &mut SqlWriter)
fn prepare_column_spec(&self, column_spec: &ColumnSpec, sql: &mut SqlWriter)
Translate
ColumnSpec
into SQL statement.§fn prepare_table_drop_opt(&self, _drop_opt: &TableDropOpt, _sql: &mut dyn Write)
fn prepare_table_drop_opt(&self, _drop_opt: &TableDropOpt, _sql: &mut dyn Write)
Translate
TableDropOpt
into SQL statement.§fn prepare_table_alter_statement(
&self,
alter: &TableAlterStatement,
sql: &mut SqlWriter
)
fn prepare_table_alter_statement( &self, alter: &TableAlterStatement, sql: &mut SqlWriter )
Translate
TableAlterStatement
into SQL statement.§fn prepare_table_rename_statement(
&self,
rename: &TableRenameStatement,
sql: &mut SqlWriter
)
fn prepare_table_rename_statement( &self, rename: &TableRenameStatement, sql: &mut SqlWriter )
Translate
TableRenameStatement
into SQL statement.§fn prepare_table_create_statement(
&self,
create: &TableCreateStatement,
sql: &mut SqlWriter
)
fn prepare_table_create_statement( &self, create: &TableCreateStatement, sql: &mut SqlWriter )
Translate
TableCreateStatement
into SQL statement.§fn prepare_table_ref(&self, table_ref: &TableRef, sql: &mut SqlWriter)
fn prepare_table_ref(&self, table_ref: &TableRef, sql: &mut SqlWriter)
Translate
TableRef
into SQL statement.fn prepare_table_ref_common(&self, table_ref: &TableRef, sql: &mut SqlWriter)
§fn prepare_table_opt(&self, table_opt: &TableOpt, sql: &mut SqlWriter)
fn prepare_table_opt(&self, table_opt: &TableOpt, sql: &mut SqlWriter)
Translate
TableOpt
into SQL statement.§fn prepare_table_partition(
&self,
_table_partition: &TablePartition,
_sql: &mut SqlWriter
)
fn prepare_table_partition( &self, _table_partition: &TablePartition, _sql: &mut SqlWriter )
Translate
TablePartition
into SQL statement.§fn prepare_table_drop_statement(
&self,
drop: &TableDropStatement,
sql: &mut SqlWriter
)
fn prepare_table_drop_statement( &self, drop: &TableDropStatement, sql: &mut SqlWriter )
Translate
TableDropStatement
into SQL statement.§fn prepare_table_truncate_statement(
&self,
truncate: &TableTruncateStatement,
sql: &mut SqlWriter
)
fn prepare_table_truncate_statement( &self, truncate: &TableTruncateStatement, sql: &mut SqlWriter )
Translate
TableTruncateStatement
into SQL statement.