Struct PostgresSqlWriter 

pub struct PostgresSqlWriter {}

Postgres SQL writer.

Implementations

impl PostgresSqlWriter

pub fn write_copy<E>(&self, out: &mut DynQuery)

where Self: Sized, E: Entity,

Write COPY FROM STDIN BINARY.

Trait Implementations

impl SqlCoreWriter for PostgresSqlWriter

fn as_dyn(&self) -> &dyn SqlWriter

Upcasts self to the full SqlWriter view.

fn write_column_overridden_type( &self, _context: &mut Context, out: &mut DynQuery, _column: &ColumnDef, types: &BTreeMap<&'static str, &'static str>, )

Write overridden type.

fn write_column_type( &self, context: &mut Context, out: &mut DynQuery, value: &Value, )

Write SQL type name.

fn separator(&self) -> &str

Separator used for qualified names (e.g. schema.table.column)

fn is_alias_declaration(&self, context: &mut Context) -> bool

Determines if the current SQL context supports alias declarations.

fn write_identifier( &self, _context: &mut Context, out: &mut DynQuery, value: &str, quoted: bool, )

Writes an identifier (like a table or column name) to the query builder, optionally quoting it.

fn write_table_ref( &self, context: &mut Context, out: &mut DynQuery, value: &TableRef, )

Write table reference.

fn write_column_ref( &self, context: &mut Context, out: &mut DynQuery, value: &ColumnRef, )

Write column reference.

impl SqlExpressionWriter for PostgresSqlWriter

fn write_question_mark(&self, context: &mut Context, out: &mut DynQuery)

fn write_current_timestamp_ms(&self, _context: &mut Context, out: &mut DynQuery)

fn write_function( &self, context: &mut Context, out: &mut DynQuery, function: &str, args: &[&dyn Expression], )

fn expression_unary_op_precedence(&self, value: &UnaryOpType) -> i32

Precedence table for unary operators.

fn expression_binary_op_precedence(&self, value: &BinaryOpType) -> i32

Precedence table for binary operators.

fn expression_binary_op_fragments( &self, _context: &mut Context, op_type: BinaryOpType, ) -> (&str, &str, &str, bool, bool)

fn write_operand( &self, context: &mut Context, out: &mut DynQuery, value: &Operand<'_>, )

fn write_unary_op( &self, context: &mut Context, out: &mut DynQuery, value: &UnaryOp<&dyn Expression>, )

fn write_binary_op( &self, context: &mut Context, out: &mut DynQuery, value: &BinaryOp<&dyn Expression, &dyn Expression>, )

Render binary operator expression handling precedence and parenthesis.

fn write_cast( &self, context: &mut Context, out: &mut DynQuery, expr: &dyn Expression, ty: &dyn Expression, )

fn write_ordered( &self, context: &mut Context, out: &mut DynQuery, value: &Ordered<&dyn Expression>, )

Render ordered expression inside ORDER BY.

impl SqlFragmentWriter for PostgresSqlWriter

fn write_join_type_fragment( &self, _context: &mut Context, out: &mut DynQuery, join_type: &JoinType, )

Render join keyword(s) for the given join type.

fn write_join_fragment( &self, context: &mut Context, out: &mut DynQuery, join: &Join<&dyn Dataset, &dyn Dataset, &dyn Expression>, )

Render a JOIN clause fragment.

fn write_create_table_column_fragment( &self, context: &mut Context, out: &mut DynQuery, column: &ColumnDef, )

where Self: Sized,

Emit single column definition fragment.

fn write_create_table_primary_key_fragment<'a, It>( &self, context: &mut Context, out: &mut DynQuery, primary_key: It, )

where Self: Sized, It: IntoIterator<Item = &'a ColumnDef>, <It as IntoIterator>::IntoIter: Clone,

Write PRIMARY KEY constraint fragment.

fn write_create_table_references_action_fragment( &self, _context: &mut Context, out: &mut DynQuery, action: &Action, )

Write referential action fragment.

fn write_column_comment_inline_fragment( &self, _context: &mut Context, _out: &mut DynQuery, _column: &ColumnDef, )

where Self: Sized,

fn write_column_comments_statements_fragment<E>( &self, context: &mut Context, out: &mut DynQuery, )

where Self: Sized, E: Entity,

Write column comments fragment.

fn write_insert_update_fragment<'a, E>( &self, context: &mut Context, out: &mut DynQuery, columns: impl Iterator<Item = &'a ColumnDef> + Clone, )

where Self: Sized, E: Entity,

Write ON CONFLICT DO UPDATE fragment for upsert.

impl SqlValueWriter for PostgresSqlWriter

fn write_blob(&self, _context: &mut Context, out: &mut DynQuery, value: &[u8])

fn write_date(&self, context: &mut Context, out: &mut DynQuery, value: &Date)

fn write_time(&self, context: &mut Context, out: &mut DynQuery, value: &Time)

fn write_timestamp( &self, context: &mut Context, out: &mut DynQuery, value: &PrimitiveDateTime, )

fn write_timestamptz( &self, context: &mut Context, out: &mut DynQuery, value: &OffsetDateTime, )

fn write_list( &self, context: &mut Context, out: &mut DynQuery, value: &mut dyn Iterator<Item = &dyn Expression>, ty: Option<&Value>, _is_array: bool, )

fn write_value(&self, context: &mut Context, out: &mut DynQuery, value: &Value)

Write value.

fn write_null(&self, context: &mut Context, out: &mut DynQuery)

fn write_bool(&self, context: &mut Context, out: &mut DynQuery, value: bool)

fn write_value_i8(&self, context: &mut Context, out: &mut DynQuery, value: i8)

fn write_value_i16(&self, context: &mut Context, out: &mut DynQuery, value: i16)

fn write_value_i32(&self, context: &mut Context, out: &mut DynQuery, value: i32)

fn write_value_i64(&self, context: &mut Context, out: &mut DynQuery, value: i64)

fn write_value_i128( &self, context: &mut Context, out: &mut DynQuery, value: i128, )

fn write_value_u8(&self, context: &mut Context, out: &mut DynQuery, value: u8)

fn write_value_u16(&self, context: &mut Context, out: &mut DynQuery, value: u16)

fn write_value_u32(&self, context: &mut Context, out: &mut DynQuery, value: u32)

fn write_value_u64(&self, context: &mut Context, out: &mut DynQuery, value: u64)

fn write_value_u128( &self, context: &mut Context, out: &mut DynQuery, value: u128, )

fn write_value_f32(&self, context: &mut Context, out: &mut DynQuery, value: f32)

fn write_value_f64(&self, context: &mut Context, out: &mut DynQuery, value: f64)

fn write_string(&self, context: &mut Context, out: &mut DynQuery, value: &str)

fn value_interval_units(&self) -> &[(&str, i128)]

Units used to decompose intervals (notice the decreasing order).

fn write_interval( &self, context: &mut Context, out: &mut DynQuery, value: &Interval, )

fn write_uuid(&self, context: &mut Context, out: &mut DynQuery, value: &Uuid)

fn write_tuple( &self, context: &mut Context, out: &mut DynQuery, value: &mut dyn Iterator<Item = &dyn Expression>, )

fn write_map( &self, context: &mut Context, out: &mut DynQuery, value: &HashMap<Value, Value>, )

fn write_json(&self, context: &mut Context, out: &mut DynQuery, value: &Value)

fn write_struct( &self, context: &mut Context, out: &mut DynQuery, value: &[(String, Value)], )

impl SqlWriter for PostgresSqlWriter

fn write_select<'a, Data>( &self, out: &mut DynQuery, query: &impl SelectQuery<Data>, )

where Self: Sized, Data: Dataset + 'a,

Write SELECT statement.

fn write_insert<It>(&self, out: &mut DynQuery, entities: It, update: bool)

where Self: Sized, It: IntoIterator, <It as IntoIterator>::Item: AsEntity,

Write INSERT statement.

fn write_delete<E>(&self, out: &mut DynQuery, condition: impl Expression)

where Self: Sized, E: Entity,

Write DELETE statement.

fn write_create_schema<E>(&self, out: &mut DynQuery, if_not_exists: bool)

where Self: Sized, E: Entity,

Emit CREATE SCHEMA.

fn write_drop_schema<E>(&self, out: &mut DynQuery, if_exists: bool)

where Self: Sized, E: Entity,

Emit DROP SCHEMA.

fn write_create_table<E>(&self, out: &mut DynQuery, if_not_exists: bool)

where Self: Sized, E: Entity,

Emit CREATE TABLE with columns, constraints & comments.

fn write_drop_table<E>(&self, out: &mut DynQuery, if_exists: bool)

where Self: Sized, E: Entity,

Write DROP TABLE statement.

fn write_transaction_begin(&self, out: &mut DynQuery)

Emit BEGIN statement.

fn write_transaction_commit(&self, out: &mut DynQuery)

Emit COMMIT statement.

fn write_transaction_rollback(&self, out: &mut DynQuery)

Emit ROLLBACK statement.