Struct Insert 

pub struct Insert<D, R: InsertRow> { /* private fields */ }

Implementations

impl<D, R: InsertRow + Insertable> Insert<D, R>

pub fn values(self, row: R) -> Self

Bulk insert: add another row to the same statement.

pub fn values_all(self, rows: impl IntoIterator<Item = R>) -> Self

The same for a collection. Infallible, unlike the seed’s: this statement already has a row, so an empty collection adds nothing rather than describing an INSERT with nothing in it.

impl<D: Dialect, R: InsertRow> Insert<D, R>

pub fn on_conflict_do_nothing( self, target: impl ConflictTarget<R::Table>, ) -> Self

where D: SupportsOnConflict,

ON CONFLICT (..) DO NOTHING.

pub fn on_conflict_do_update( self, target: impl ConflictTarget<R::Table>, set: Assignments<R::Table>, ) -> Self

where D: SupportsOnConflict,

ON CONFLICT (..) DO UPDATE SET .., taking the same Assignments an UPDATE sets.

Trait Implementations

impl<D: Dialect, R: InsertRow> Statement for Insert<D, R>

type Dialect = D

type Table = <R as InsertRow>::Table

fn to_sql(&self, _dialect: Self::Dialect) -> (String, Vec<Value>)

The dialect is an argument for the reason Select::to_sql’s is.

fn returning<Sel, Idx>(self, sel: Sel) -> Returning<Self, Sel>

where Self: Sized, Self::Dialect: SupportsReturning, Sel: Selection<WrittenTable<Self::Table>, Idx>,

RETURNING, on whichever of the three this is — the clause is the same clause. A distinct type rather than Self with a flag set: the execution layer needs Sel’s concrete type to know what to decode a returned row into, and an optional field would erase it.