Struct sea_query::backend::PostgresQueryBuilder
source · [−]pub struct PostgresQueryBuilder;
Expand description
Postgres query builder.
Trait Implementations
sourceimpl Debug for PostgresQueryBuilder
Available on crate feature backend-postgres
only.
impl Debug for PostgresQueryBuilder
backend-postgres
only.sourceimpl Default for PostgresQueryBuilder
Available on crate feature backend-postgres
only.
impl Default for PostgresQueryBuilder
backend-postgres
only.sourceimpl ForeignKeyBuilder for PostgresQueryBuilder
Available on crate feature backend-postgres
only.
impl ForeignKeyBuilder for PostgresQueryBuilder
backend-postgres
only.sourcefn 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.
sourcefn 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.
sourcefn 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.
sourceimpl IndexBuilder for PostgresQueryBuilder
Available on crate feature backend-postgres
only.
impl IndexBuilder for PostgresQueryBuilder
backend-postgres
only.sourcefn 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.
sourcefn 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.
sourcefn 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.
sourceimpl QueryBuilder for PostgresQueryBuilder
Available on crate feature backend-postgres
only.
impl QueryBuilder for PostgresQueryBuilder
backend-postgres
only.sourcefn placeholder(&self) -> (&str, bool)
fn placeholder(&self) -> (&str, bool)
The type of placeholder the builder uses for values, and whether it is numbered.
sourcefn 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_function(
&self,
function: &Function,
sql: &mut SqlWriter,
collector: &mut dyn FnMut(Value)
)
sourcefn 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.
sourcefn 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.
sourcefn 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.
sourcefn 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.
sourcefn 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.
sourcefn 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.
sourcefn 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_common(
&self,
simple_expr: &SimpleExpr,
sql: &mut SqlWriter,
collector: &mut dyn FnMut(Value)
)
sourcefn 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.
sourcefn prepare_select_lock(
&self,
lock: &LockClause,
sql: &mut SqlWriter,
collector: &mut dyn FnMut(Value)
)
fn prepare_select_lock(
&self,
lock: &LockClause,
sql: &mut SqlWriter,
collector: &mut dyn FnMut(Value)
)
Translate LockType
into SQL statement.
sourcefn 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.
sourcefn 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)
)
sourcefn 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)
)
sourcefn 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)
)
sourcefn 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.
sourcefn 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_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)
sourcefn 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.
sourcefn 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.
sourcefn 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.
sourcefn 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
sourcefn 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)
)
Translate Value
into SQL statement.
sourcefn 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.
sourcefn 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.
sourcefn value_to_string(&self, v: &Value) -> String
fn value_to_string(&self, v: &Value) -> String
Convert a SQL value into syntax-specific string
sourcefn insert_default_keyword(&self) -> &str
fn insert_default_keyword(&self) -> &str
The keywords for insert default row.
sourcefn insert_default_values(&self, num_rows: u32, sql: &mut SqlWriter)
fn insert_default_values(&self, num_rows: u32, sql: &mut SqlWriter)
Write insert default rows expression.
sourceimpl QuotedBuilder for PostgresQueryBuilder
Available on crate feature backend-postgres
only.
impl QuotedBuilder for PostgresQueryBuilder
backend-postgres
only.sourceimpl TableBuilder for PostgresQueryBuilder
Available on crate feature backend-postgres
only.
impl TableBuilder for PostgresQueryBuilder
backend-postgres
only.sourcefn 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.
sourcefn 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.
sourcefn 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.
sourcefn 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.
sourcefn 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.
sourcefn 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.
sourcefn 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)
sourcefn 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.
sourcefn 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.
sourcefn 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.
sourcefn 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.
sourcefn 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.
sourceimpl TypeBuilder for PostgresQueryBuilder
Available on crate feature backend-postgres
only.
impl TypeBuilder for PostgresQueryBuilder
backend-postgres
only.sourcefn prepare_type_create_statement(
&self,
create: &TypeCreateStatement,
sql: &mut SqlWriter,
collector: &mut dyn FnMut(Value)
)
fn prepare_type_create_statement(
&self,
create: &TypeCreateStatement,
sql: &mut SqlWriter,
collector: &mut dyn FnMut(Value)
)
Translate TypeCreateStatement
into database specific SQL statement.
sourcefn prepare_type_drop_statement(
&self,
drop: &TypeDropStatement,
sql: &mut SqlWriter,
_collector: &mut dyn FnMut(Value)
)
fn prepare_type_drop_statement(
&self,
drop: &TypeDropStatement,
sql: &mut SqlWriter,
_collector: &mut dyn FnMut(Value)
)
Translate TypeDropStatement
into database specific SQL statement.
sourcefn prepare_type_alter_statement(
&self,
alter: &TypeAlterStatement,
sql: &mut SqlWriter,
collector: &mut dyn FnMut(Value)
)
fn prepare_type_alter_statement(
&self,
alter: &TypeAlterStatement,
sql: &mut SqlWriter,
collector: &mut dyn FnMut(Value)
)
Translate TypeAlterStatement
into database specific SQL statement.
impl GenericBuilder for PostgresQueryBuilder
backend-postgres
only.impl SchemaBuilder for PostgresQueryBuilder
backend-postgres
only.Auto Trait Implementations
impl RefUnwindSafe for PostgresQueryBuilder
impl Send for PostgresQueryBuilder
impl Sync for PostgresQueryBuilder
impl Unpin for PostgresQueryBuilder
impl UnwindSafe for PostgresQueryBuilder
Blanket Implementations
sourceimpl<T> BorrowMut<T> for T where
T: ?Sized,
impl<T> BorrowMut<T> for T where
T: ?Sized,
const: unstable · sourcefn borrow_mut(&mut self) -> &mut T
fn borrow_mut(&mut self) -> &mut T
Mutably borrows from an owned value. Read more
sourceimpl<T> Instrument for T
impl<T> Instrument for T
sourcefn instrument(self, span: Span) -> Instrumented<Self>
fn instrument(self, span: Span) -> Instrumented<Self>
sourcefn in_current_span(self) -> Instrumented<Self>
fn in_current_span(self) -> Instrumented<Self>
impl<V, T> VZip<V> for T where
V: MultiLane<T>,
impl<V, T> VZip<V> for T where
V: MultiLane<T>,
fn vzip(self) -> V
sourceimpl<T> WithSubscriber for T
impl<T> WithSubscriber for T
sourcefn with_subscriber<S>(self, subscriber: S) -> WithDispatch<Self> where
S: Into<Dispatch>,
fn with_subscriber<S>(self, subscriber: S) -> WithDispatch<Self> where
S: Into<Dispatch>,
Attaches the provided Subscriber
to this type, returning a
WithDispatch
wrapper. Read more
sourcefn with_current_subscriber(self) -> WithDispatch<Self>
fn with_current_subscriber(self) -> WithDispatch<Self>
Attaches the current default Subscriber
to this type, returning a
WithDispatch
wrapper. Read more