Struct InsertQuery 

pub struct InsertQuery { /* private fields */ }

A single-row INSERT query builder.

Implementations

impl InsertQuery

pub fn new(table: &str) -> Self

Create a new INSERT query for the given table.

pub fn set(self, column: &str, value: impl Into<Value>) -> Self

Set a column value. Chainable.

pub fn returning_all(self) -> Self

Add RETURNING * to get the full inserted row back.

pub fn returning_col(self, column: &str) -> Self

Add RETURNING for a single column.

pub fn returning_cols(self, columns: &[&str]) -> Self

Add RETURNING for multiple columns.

pub fn on_conflict(self, column: &str) -> Self

Add ON CONFLICT (column) DO UPDATE SET …

pub fn do_update(self, column: &str, value: impl Into<Value>) -> Self

Add a column update for the ON CONFLICT clause. Must call on_conflict() first.

pub fn to_sql(&self) -> (String, Vec<Value>)

Render to SQL string + parameters.

Trait Implementations

impl Clone for InsertQuery

fn clone(&self) -> InsertQuery

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Debug for InsertQuery

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.