Struct sea_orm_migration::prelude::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_table_ref_fk_stmt(
&self,
table_ref: &TableRef,
sql: &mut dyn SqlWriter
)
fn prepare_table_ref_fk_stmt( &self, table_ref: &TableRef, sql: &mut dyn SqlWriter )
Translate
TableRef
into SQL statement.§fn prepare_foreign_key_create_statement(
&self,
create: &ForeignKeyCreateStatement,
sql: &mut dyn SqlWriter
)
fn prepare_foreign_key_create_statement( &self, create: &ForeignKeyCreateStatement, sql: &mut dyn SqlWriter )
Translate
ForeignKeyCreateStatement
into SQL statement.§fn prepare_foreign_key_drop_statement(
&self,
drop: &ForeignKeyDropStatement,
sql: &mut dyn SqlWriter
)
fn prepare_foreign_key_drop_statement( &self, drop: &ForeignKeyDropStatement, sql: &mut dyn SqlWriter )
Translate
ForeignKeyDropStatement
into SQL statement.§fn prepare_foreign_key_action(
&self,
foreign_key_action: &ForeignKeyAction,
sql: &mut dyn SqlWriter
)
fn prepare_foreign_key_action( &self, foreign_key_action: &ForeignKeyAction, sql: &mut dyn SqlWriter )
Translate
ForeignKeyAction
into SQL statement.§impl IndexBuilder for SqliteQueryBuilder
impl IndexBuilder for SqliteQueryBuilder
§fn prepare_index_create_statement(
&self,
create: &IndexCreateStatement,
sql: &mut dyn SqlWriter
)
fn prepare_index_create_statement( &self, create: &IndexCreateStatement, sql: &mut dyn SqlWriter )
Translate
IndexCreateStatement
into SQL statement.§fn prepare_table_ref_index_stmt(
&self,
table_ref: &TableRef,
sql: &mut dyn SqlWriter
)
fn prepare_table_ref_index_stmt( &self, table_ref: &TableRef, sql: &mut dyn SqlWriter )
Translate
TableRef
into SQL statement.§fn prepare_index_drop_statement(
&self,
drop: &IndexDropStatement,
sql: &mut dyn SqlWriter
)
fn prepare_index_drop_statement( &self, drop: &IndexDropStatement, sql: &mut dyn SqlWriter )
Translate
IndexDropStatement
into SQL statement.§fn prepare_table_index_expression(
&self,
create: &IndexCreateStatement,
sql: &mut dyn SqlWriter
)
fn prepare_table_index_expression( &self, create: &IndexCreateStatement, sql: &mut dyn SqlWriter )
Translate
IndexCreateStatement
into SQL expression.
This is the default implementation for PostgresQueryBuilder
and SqliteQueryBuilder
.
MysqlQueryBuilder
overrides this default implementation.§impl QueryBuilder for SqliteQueryBuilder
impl QueryBuilder for SqliteQueryBuilder
§fn prepare_select_lock(
&self,
_select_lock: &LockClause,
_sql: &mut dyn SqlWriter
)
fn prepare_select_lock( &self, _select_lock: &LockClause, _sql: &mut dyn SqlWriter )
Translate
LockType
into SQL statement.§fn prepare_sub_query_oper(&self, oper: &SubQueryOper, sql: &mut dyn SqlWriter)
fn prepare_sub_query_oper(&self, oper: &SubQueryOper, sql: &mut dyn SqlWriter)
Translate
SubQueryOper
into SQL statement.§fn prepare_bin_oper(&self, bin_oper: &BinOper, sql: &mut dyn SqlWriter)
fn prepare_bin_oper(&self, bin_oper: &BinOper, sql: &mut dyn SqlWriter)
Translate
BinOper
into SQL statement.fn prepare_union_statement( &self, union_type: UnionType, select_statement: &SelectStatement, sql: &mut dyn SqlWriter )
§fn prepare_query_statement(
&self,
query: &SubQueryStatement,
sql: &mut dyn SqlWriter
)
fn prepare_query_statement( &self, query: &SubQueryStatement, sql: &mut dyn SqlWriter )
Translate
QueryStatement
into SQL statement.fn prepare_with_clause_recursive_options( &self, _: &WithClause, _: &mut dyn SqlWriter )
§fn prepare_order_expr(&self, order_expr: &OrderExpr, sql: &mut dyn SqlWriter)
fn prepare_order_expr(&self, order_expr: &OrderExpr, sql: &mut dyn SqlWriter)
Translate
OrderExpr
into SQL statement.§fn prepare_value(&self, value: &Value, sql: &mut dyn SqlWriter)
fn prepare_value(&self, value: &Value, sql: &mut dyn SqlWriter)
Write
Value
into SQL statement as parameter.§fn insert_default_values(&self, _: u32, sql: &mut dyn SqlWriter)
fn insert_default_values(&self, _: u32, sql: &mut dyn 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 dyn SqlWriter
)
fn prepare_insert_statement( &self, insert: &InsertStatement, sql: &mut dyn SqlWriter )
Translate
InsertStatement
into SQL statement.§fn prepare_select_statement(
&self,
select: &SelectStatement,
sql: &mut dyn SqlWriter
)
fn prepare_select_statement( &self, select: &SelectStatement, sql: &mut dyn SqlWriter )
Translate
SelectStatement
into SQL statement.§fn prepare_update_statement(
&self,
update: &UpdateStatement,
sql: &mut dyn SqlWriter
)
fn prepare_update_statement( &self, update: &UpdateStatement, sql: &mut dyn SqlWriter )
Translate
UpdateStatement
into SQL statement.§fn prepare_delete_statement(
&self,
delete: &DeleteStatement,
sql: &mut dyn SqlWriter
)
fn prepare_delete_statement( &self, delete: &DeleteStatement, sql: &mut dyn SqlWriter )
Translate
DeleteStatement
into SQL statement.§fn prepare_simple_expr(&self, simple_expr: &SimpleExpr, sql: &mut dyn SqlWriter)
fn prepare_simple_expr(&self, simple_expr: &SimpleExpr, sql: &mut dyn SqlWriter)
Translate
SimpleExpr
into SQL statement.fn prepare_simple_expr_common( &self, simple_expr: &SimpleExpr, sql: &mut dyn SqlWriter )
§fn prepare_case_statement(&self, stmts: &CaseStatement, sql: &mut dyn SqlWriter)
fn prepare_case_statement(&self, stmts: &CaseStatement, sql: &mut dyn SqlWriter)
Translate
CaseStatement
into SQL statement.§fn prepare_select_distinct(
&self,
select_distinct: &SelectDistinct,
sql: &mut dyn SqlWriter
)
fn prepare_select_distinct( &self, select_distinct: &SelectDistinct, sql: &mut dyn SqlWriter )
Translate
SelectDistinct
into SQL statement.§fn prepare_select_expr(&self, select_expr: &SelectExpr, sql: &mut dyn SqlWriter)
fn prepare_select_expr(&self, select_expr: &SelectExpr, sql: &mut dyn SqlWriter)
Translate
SelectExpr
into SQL statement.§fn prepare_join_expr(&self, join_expr: &JoinExpr, sql: &mut dyn SqlWriter)
fn prepare_join_expr(&self, join_expr: &JoinExpr, sql: &mut dyn SqlWriter)
Translate
JoinExpr
into SQL statement.fn prepare_join_table_ref(&self, join_expr: &JoinExpr, sql: &mut dyn SqlWriter)
§fn prepare_table_ref(&self, table_ref: &TableRef, sql: &mut dyn SqlWriter)
fn prepare_table_ref(&self, table_ref: &TableRef, sql: &mut dyn SqlWriter)
Translate
TableRef
into SQL statement.fn prepare_column_ref(&self, column_ref: &ColumnRef, sql: &mut dyn SqlWriter)
§fn prepare_un_oper(&self, un_oper: &UnOper, sql: &mut dyn SqlWriter)
fn prepare_un_oper(&self, un_oper: &UnOper, sql: &mut dyn SqlWriter)
Translate
UnOper
into SQL statement.fn prepare_bin_oper_common(&self, bin_oper: &BinOper, sql: &mut dyn SqlWriter)
§fn prepare_logical_chain_oper(
&self,
log_chain_oper: &LogicalChainOper,
i: usize,
length: usize,
sql: &mut dyn SqlWriter
)
fn prepare_logical_chain_oper( &self, log_chain_oper: &LogicalChainOper, i: usize, length: usize, sql: &mut dyn SqlWriter )
Translate
LogicalChainOper
into SQL statement.§fn prepare_function_common(&self, function: &Function, sql: &mut dyn SqlWriter)
fn prepare_function_common(&self, function: &Function, sql: &mut dyn SqlWriter)
Translate
Function
into SQL statement.fn prepare_with_query(&self, query: &WithQuery, sql: &mut dyn SqlWriter)
fn prepare_with_clause(&self, with_clause: &WithClause, sql: &mut dyn SqlWriter)
fn prepare_with_clause_common_tables( &self, with_clause: &WithClause, sql: &mut dyn SqlWriter )
fn prepare_with_query_clause_common_table( &self, cte: &CommonTableExpression, sql: &mut dyn SqlWriter )
fn prepare_with_query_clause_materialization( &self, cte: &CommonTableExpression, sql: &mut dyn SqlWriter )
fn prepare_with_clause_start( &self, with_clause: &WithClause, sql: &mut dyn SqlWriter )
fn prepare_insert(&self, replace: bool, sql: &mut dyn SqlWriter)
fn prepare_function(&self, function: &Function, sql: &mut dyn SqlWriter)
§fn prepare_join_type(&self, join_type: &JoinType, sql: &mut dyn SqlWriter)
fn prepare_join_type(&self, join_type: &JoinType, sql: &mut dyn SqlWriter)
Translate
JoinType
into SQL statement.fn prepare_join_type_common( &self, join_type: &JoinType, sql: &mut dyn SqlWriter )
§fn prepare_join_on(&self, join_on: &JoinOn, sql: &mut dyn SqlWriter)
fn prepare_join_on(&self, join_on: &JoinOn, sql: &mut dyn SqlWriter)
Translate
JoinOn
into SQL statement.§fn prepare_order(&self, order_expr: &OrderExpr, sql: &mut dyn SqlWriter)
fn prepare_order(&self, order_expr: &OrderExpr, sql: &mut dyn SqlWriter)
Translate
Order
into SQL statement.§fn prepare_field_order(
&self,
order_expr: &OrderExpr,
values: &Values,
sql: &mut dyn SqlWriter
)
fn prepare_field_order( &self, order_expr: &OrderExpr, values: &Values, sql: &mut dyn SqlWriter )
Translate
Order::Field
into SQL statement§fn prepare_constant(&self, value: &Value, sql: &mut dyn SqlWriter)
fn prepare_constant(&self, value: &Value, sql: &mut dyn SqlWriter)
Write
Value
inline.§fn prepare_values_list(
&self,
value_tuples: &[ValueTuple],
sql: &mut dyn SqlWriter
)
fn prepare_values_list( &self, value_tuples: &[ValueTuple], sql: &mut dyn SqlWriter )
Translate a
&[ValueTuple]
into a VALUES list.§fn prepare_tuple(&self, exprs: &[SimpleExpr], sql: &mut dyn SqlWriter)
fn prepare_tuple(&self, exprs: &[SimpleExpr], sql: &mut dyn SqlWriter)
Translate
SimpleExpr::Tuple
into SQL statement.§fn prepare_keyword(&self, keyword: &Keyword, sql: &mut dyn SqlWriter)
fn prepare_keyword(&self, keyword: &Keyword, sql: &mut dyn SqlWriter)
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 dyn SqlWriter)
fn prepare_column_def(&self, column_def: &ColumnDef, sql: &mut dyn SqlWriter)
Translate
ColumnDef
into SQL statement.§fn prepare_column_type(&self, column_type: &ColumnType, sql: &mut dyn SqlWriter)
fn prepare_column_type(&self, column_type: &ColumnType, sql: &mut dyn SqlWriter)
Translate
ColumnType
into SQL statement.§fn column_spec_auto_increment_keyword(&self) -> &str
fn column_spec_auto_increment_keyword(&self) -> &str
The keyword for setting a column to be auto increment.
§fn prepare_table_drop_opt(
&self,
_drop_opt: &TableDropOpt,
_sql: &mut dyn SqlWriter
)
fn prepare_table_drop_opt( &self, _drop_opt: &TableDropOpt, _sql: &mut dyn SqlWriter )
Translate
TableDropOpt
into SQL statement.§fn prepare_table_alter_statement(
&self,
alter: &TableAlterStatement,
sql: &mut dyn SqlWriter
)
fn prepare_table_alter_statement( &self, alter: &TableAlterStatement, sql: &mut dyn SqlWriter )
Translate
TableAlterStatement
into SQL statement.§fn prepare_table_rename_statement(
&self,
rename: &TableRenameStatement,
sql: &mut dyn SqlWriter
)
fn prepare_table_rename_statement( &self, rename: &TableRenameStatement, sql: &mut dyn SqlWriter )
Translate
TableRenameStatement
into SQL statement.§fn prepare_table_create_statement(
&self,
create: &TableCreateStatement,
sql: &mut dyn SqlWriter
)
fn prepare_table_create_statement( &self, create: &TableCreateStatement, sql: &mut dyn SqlWriter )
Translate
TableCreateStatement
into SQL statement.§fn prepare_table_ref_table_stmt(
&self,
table_ref: &TableRef,
sql: &mut dyn SqlWriter
)
fn prepare_table_ref_table_stmt( &self, table_ref: &TableRef, sql: &mut dyn SqlWriter )
Translate
TableRef
into SQL statement.§fn prepare_column_spec(&self, column_spec: &ColumnSpec, sql: &mut dyn SqlWriter)
fn prepare_column_spec(&self, column_spec: &ColumnSpec, sql: &mut dyn SqlWriter)
Translate
ColumnSpec
into SQL statement.§fn prepare_table_opt(&self, table_opt: &TableOpt, sql: &mut dyn SqlWriter)
fn prepare_table_opt(&self, table_opt: &TableOpt, sql: &mut dyn SqlWriter)
Translate
TableOpt
into SQL statement.§fn prepare_table_partition(
&self,
_table_partition: &TablePartition,
_sql: &mut dyn SqlWriter
)
fn prepare_table_partition( &self, _table_partition: &TablePartition, _sql: &mut dyn SqlWriter )
Translate
TablePartition
into SQL statement.§fn prepare_table_drop_statement(
&self,
drop: &TableDropStatement,
sql: &mut dyn SqlWriter
)
fn prepare_table_drop_statement( &self, drop: &TableDropStatement, sql: &mut dyn SqlWriter )
Translate
TableDropStatement
into SQL statement.§fn prepare_table_truncate_statement(
&self,
truncate: &TableTruncateStatement,
sql: &mut dyn SqlWriter
)
fn prepare_table_truncate_statement( &self, truncate: &TableTruncateStatement, sql: &mut dyn SqlWriter )
Translate
TableTruncateStatement
into SQL statement.§impl TableRefBuilder for SqliteQueryBuilder
impl TableRefBuilder for SqliteQueryBuilder
§fn prepare_table_ref_iden(&self, table_ref: &TableRef, sql: &mut dyn SqlWriter)
fn prepare_table_ref_iden(&self, table_ref: &TableRef, sql: &mut dyn SqlWriter)
Translate
TableRef
that without values into SQL statement.impl GenericBuilder for SqliteQueryBuilder
impl SchemaBuilder for SqliteQueryBuilder
Auto Trait Implementations§
impl RefUnwindSafe for SqliteQueryBuilder
impl Send for SqliteQueryBuilder
impl Sync for SqliteQueryBuilder
impl Unpin for SqliteQueryBuilder
impl UnwindSafe for SqliteQueryBuilder
Blanket Implementations§
source§impl<T> BorrowMut<T> for Twhere
T: ?Sized,
impl<T> BorrowMut<T> for Twhere T: ?Sized,
source§fn borrow_mut(&mut self) -> &mut T
fn borrow_mut(&mut self) -> &mut T
Mutably borrows from an owned value. Read more