Struct InsertStmt 

pub struct InsertStmt {
    pub table: SchemaRef,
    pub columns: Option<Vec<String>>,
    pub source: InsertSource,
    pub on_conflict: Option<Vec<OnConflictDef>>,
    pub returning: Option<Vec<SelectColumn>>,
    pub ctes: Option<Vec<CteDef>>,
    pub overriding: Option<OverridingKind>,
    pub conflict_resolution: Option<ConflictResolution>,
    pub partition: Option<Vec<String>>,
    pub ignore: bool,
}

INSERT INTO … VALUES / SELECT / DEFAULT VALUES.

Fields

table: SchemaRef

columns: Option<Vec<String>>

source: InsertSource

on_conflict: Option<Vec<OnConflictDef>>

Multiple ON CONFLICT clauses (SQLite processes in order; last may omit target).

returning: Option<Vec<SelectColumn>>

ctes: Option<Vec<CteDef>>

overriding: Option<OverridingKind>

PG: OVERRIDING { SYSTEM | USER } VALUE (for identity columns).

conflict_resolution: Option<ConflictResolution>

SQLite: INSERT OR REPLACE / OR IGNORE / OR ABORT / etc.

partition: Option<Vec<String>>

MySQL/Oracle: PARTITION targeting.

ignore: bool

MySQL: IGNORE modifier (downgrades errors to warnings).

Implementations

impl InsertStmt

pub fn values(table: &str, columns: Vec<&str>, rows: Vec<Vec<Expr>>) -> Self

pub fn from_select(table: &str, columns: Vec<&str>, query: QueryStmt) -> Self

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

pub fn returning(self, cols: Vec<SelectColumn>) -> Self

pub fn on_conflict(self, def: OnConflictDef) -> Self

Trait Implementations

impl Clone for InsertStmt

fn clone(&self) -> InsertStmt

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for InsertStmt

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

Formats the value using the given formatter.

impl Default for InsertStmt

fn default() -> Self

Returns the “default value” for a type.