pub struct PostgresQueryBuilder;
Expand description
Postgres query builder.
Trait Implementations§
Source§impl Debug for PostgresQueryBuilder
impl Debug for PostgresQueryBuilder
Source§impl Default for PostgresQueryBuilder
impl Default for PostgresQueryBuilder
Source§fn default() -> PostgresQueryBuilder
fn default() -> PostgresQueryBuilder
Returns the “default value” for a type. Read more
Source§impl EscapeBuilder for PostgresQueryBuilder
impl EscapeBuilder for PostgresQueryBuilder
Source§fn escape_string(&self, string: &str) -> String
fn escape_string(&self, string: &str) -> String
Escape a SQL string literal
Source§fn unescape_string(&self, string: &str) -> String
fn unescape_string(&self, string: &str) -> String
Unescape a SQL string literal
Source§impl ForeignKeyBuilder for PostgresQueryBuilder
impl ForeignKeyBuilder for PostgresQueryBuilder
Source§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.Source§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.Source§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.Source§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.Source§impl IndexBuilder for PostgresQueryBuilder
impl IndexBuilder for PostgresQueryBuilder
Source§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.Source§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.Source§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.Source§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.Source§impl QueryBuilder for PostgresQueryBuilder
impl QueryBuilder for PostgresQueryBuilder
Source§fn placeholder(&self) -> (&str, bool)
fn placeholder(&self) -> (&str, bool)
The type of placeholder the builder uses for values, and whether it is numbered.
Source§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.Source§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.Source§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.Source§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_function(&self, function: &Function, sql: &mut dyn SqlWriter)
Source§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.Source§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.Source§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)
Source§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.Source§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.Source§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.Source§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_common( &self, simple_expr: &SimpleExpr, sql: &mut dyn SqlWriter, )
Source§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.Source§fn prepare_select_lock(&self, lock: &LockClause, sql: &mut dyn SqlWriter)
fn prepare_select_lock(&self, lock: &LockClause, sql: &mut dyn SqlWriter)
Translate
LockType
into SQL statement.Source§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.Source§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)
Source§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)
Source§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)
Source§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.Source§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.Source§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_recursive_options( &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)
Source§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.Source§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.Source§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.Source§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 statementSource§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.Source§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.Source§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.Source§fn value_to_string(&self, v: &Value) -> String
fn value_to_string(&self, v: &Value) -> String
Convert a SQL value into syntax-specific string
Source§fn insert_default_keyword(&self) -> &str
fn insert_default_keyword(&self) -> &str
The keywords for insert default row.
Source§fn insert_default_values(&self, num_rows: u32, sql: &mut dyn SqlWriter)
fn insert_default_values(&self, num_rows: u32, sql: &mut dyn SqlWriter)
Write insert default rows expression.
Source§impl QuotedBuilder for PostgresQueryBuilder
impl QuotedBuilder for PostgresQueryBuilder
Source§impl TableBuilder for PostgresQueryBuilder
impl TableBuilder for PostgresQueryBuilder
Source§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.Source§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.Source§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.
Source§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.Source§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.Source§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.Source§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.Source§fn prepare_column_spec(&self, column_spec: &ColumnSpec, sql: &mut dyn SqlWriter)where
Self: Sized + QueryBuilder,
fn prepare_column_spec(&self, column_spec: &ColumnSpec, sql: &mut dyn SqlWriter)where
Self: Sized + QueryBuilder,
Translate
ColumnSpec
into SQL statement.Source§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.Source§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.Source§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.Source§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.Source§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.Source§impl TypeBuilder for PostgresQueryBuilder
impl TypeBuilder for PostgresQueryBuilder
Source§fn prepare_type_create_statement(
&self,
create: &TypeCreateStatement,
sql: &mut dyn SqlWriter,
)
fn prepare_type_create_statement( &self, create: &TypeCreateStatement, sql: &mut dyn SqlWriter, )
Translate
TypeCreateStatement
into database specific SQL statement.Source§fn prepare_type_drop_statement(
&self,
drop: &TypeDropStatement,
sql: &mut dyn SqlWriter,
)
fn prepare_type_drop_statement( &self, drop: &TypeDropStatement, sql: &mut dyn SqlWriter, )
Translate
TypeDropStatement
into database specific SQL statement.Source§fn prepare_type_alter_statement(
&self,
alter: &TypeAlterStatement,
sql: &mut dyn SqlWriter,
)
fn prepare_type_alter_statement( &self, alter: &TypeAlterStatement, sql: &mut dyn SqlWriter, )
Translate
TypeAlterStatement
into database specific SQL statement.impl GenericBuilder for PostgresQueryBuilder
impl SchemaBuilder for PostgresQueryBuilder
Auto Trait Implementations§
impl Freeze for PostgresQueryBuilder
impl RefUnwindSafe for PostgresQueryBuilder
impl Send for PostgresQueryBuilder
impl Sync for PostgresQueryBuilder
impl Unpin for PostgresQueryBuilder
impl UnwindSafe for PostgresQueryBuilder
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
Source§impl<T> Instrument for T
impl<T> Instrument for T
Source§fn instrument(self, span: Span) -> Instrumented<Self>
fn instrument(self, span: Span) -> Instrumented<Self>
Source§fn in_current_span(self) -> Instrumented<Self>
fn in_current_span(self) -> Instrumented<Self>
Source§impl<T> IntoEither for T
impl<T> IntoEither for T
Source§fn into_either(self, into_left: bool) -> Either<Self, Self>
fn into_either(self, into_left: bool) -> Either<Self, Self>
Converts
self
into a Left
variant of Either<Self, Self>
if into_left
is true
.
Converts self
into a Right
variant of Either<Self, Self>
otherwise. Read moreSource§fn into_either_with<F>(self, into_left: F) -> Either<Self, Self>
fn into_either_with<F>(self, into_left: F) -> Either<Self, Self>
Converts
self
into a Left
variant of Either<Self, Self>
if into_left(&self)
returns true
.
Converts self
into a Right
variant of Either<Self, Self>
otherwise. Read more