Struct UpsertBuilder 

pub struct UpsertBuilder<Table, Values, Conflict> { /* private fields */ }

A type-safe UPSERT (INSERT … ON CONFLICT) builder for SQLite.

Implementations

impl UpsertBuilder<NoTable, NoValues, NoConflict>

pub fn new() -> Self

Creates a new UPSERT builder.

impl<Values, Conflict> UpsertBuilder<NoTable, Values, Conflict>

pub fn into_table( self, table: &str, ) -> UpsertBuilder<HasTable, Values, Conflict>

Specifies the table to insert into.

impl<Values, Conflict> UpsertBuilder<HasTable, Values, Conflict>

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

Specifies the columns to insert into.

impl<Conflict> UpsertBuilder<HasTable, NoValues, Conflict>

pub fn values<T: ToSqlValue>( self, vals: Vec<T>, ) -> UpsertBuilder<HasTable, HasValues, Conflict>

Adds values to insert.

impl UpsertBuilder<HasTable, HasValues, NoConflict>

pub fn on_conflict( self, cols: &[&str], ) -> UpsertBuilder<HasTable, HasValues, HasConflict>

Specifies the conflict target columns.

impl UpsertBuilder<HasTable, HasValues, HasConflict>

pub fn do_nothing(self) -> Self

Sets DO NOTHING action.

pub fn do_update(self, cols: &[&str]) -> Self

Sets DO UPDATE with specified columns.

pub fn build(self) -> (String, Vec<SqlValue>)

Builds the UPSERT statement and returns SQL with parameters.

pub fn build_sql(self) -> String

Builds the UPSERT statement and returns only the SQL string.

Trait Implementations

impl Default for UpsertBuilder<NoTable, NoValues, NoConflict>

fn default() -> Self

Returns the “default value” for a type.