Struct Insert 

pub struct Insert { /* private fields */ }

An INSERT statement.

Implementations

impl Insert

pub fn into_table(self, table: impl Into<TableRef>) -> Self

Sets INSERT INTO table.

pub fn columns<C: IntoIden>(self, columns: impl IntoIterator<Item = C>) -> Self

Sets the column list.

pub fn values<V: Into<Expr>>(self, row: impl IntoIterator<Item = V>) -> Self

Adds a row of values, one per column.

pub fn default_values(self) -> Self

Sets INSERT INTO table DEFAULT VALUES.

pub fn select_from(self, select: Select) -> Self

Sets INSERT INTO table (...) SELECT ....

pub fn on_conflict(self, on_conflict: OnConflict) -> Self

Sets the ON CONFLICT clause.

pub fn returning(self, returning: Returning) -> Self

Sets the RETURNING clause.

pub fn returning_all(self) -> Self

Sets RETURNING *.

pub fn row_count(&self) -> usize

The number of rows added so far.

Trait Implementations

impl Build for Insert

fn to_statement(&self) -> Statement

Renders into a Statement.

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

Renders to the SQL text and the values to bind.

fn to_string_inlined(&self) -> String

Renders with literals inlined, for logs and tests only.

impl Clone for Insert

fn clone(&self) -> Self

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for Insert

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

Formats the value using the given formatter.

impl Default for Insert

fn default() -> Self

Returns the “default value” for a type.

impl PartialEq for Insert

fn eq(&self, other: &Self) -> bool

Equality operator ==.

fn ne(&self, other: &Rhs) -> bool

Inequality operator !=.

impl StructuralPartialEq for Insert