Struct InsertQuery 

pub struct InsertQuery {
    pub with: With,
    pub or: Option<Or>,
    pub table: TableRef,
    pub values: Values,
    pub upserts: Vec<ConflictClause>,
    pub returning: Returning,
}

A SQLite INSERT.

From https://www.sqlite.org/lang_insert.html:

[ WITH [ RECURSIVE ] common-table-expression [, ...] ]
INSERT [ OR { ROLLBACK | ABORT | REPLACE | FAIL | IGNORE } ]
    INTO [ schema. ] table [ AS alias ] [ ( column [, ...] ) ]
    { VALUES ( expr [, ...] ) [, ...] [ upsert-clause ]
    | select-stmt [ upsert-clause ]
    | DEFAULT VALUES }
    [ RETURNING result-column [, ...] ]

DEFAULT VALUES is the alternative Values cannot represent — an absent clause has to render nothing — so an empty Values is what DEFAULT VALUES is here, and this query writes the keywords itself. Note from the grammar that DEFAULT VALUES admits no upsert-clause; a row of defaults conflicts with nothing worth updating, and SQLite refuses the combination.

A source select-stmt with an upsert-clause after it must have a WHERE, even a trivial one, or the parser reads the ON as the start of a join condition. That is SQLite’s rule, not this type’s, and it is left to the parser to say so — with an unusually clear message.

Fields

with: With

WITH ….

or: Option<Or>

OR REPLACE and friends. None is the default, ABORT.

table: TableRef

The target: table, optional alias, and the insert column list.

values: Values

The rows, or the query to insert the results of. Empty means DEFAULT VALUES.

upserts: Vec<ConflictClause>

The upsert-clause list. SQLite 3.35 and later accept several, tried in order, and only the last may omit its conflict target.

returning: Returning

RETURNING …. SQLite 3.35 and later.

Implementations

impl InsertQuery

pub fn new() -> InsertQuery

An INSERT with nothing set yet.

pub fn apply(&mut self, mods: impl Mod<InsertQuery>)

Apply more mods to an existing query.

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.

impl Default for InsertQuery

fn default() -> InsertQuery

Returns the “default value” for a type.

impl Expression for InsertQuery

fn write_sql(&self, w: &mut SqlWriter<'_>)

Append this fragment to w.

impl HasOr for InsertQuery

fn or_mut(&mut self) -> &mut Option<Or>

The conflict algorithm to modify.

impl HasReturning for InsertQuery

fn returning_mut(&mut self) -> &mut Returning

The RETURNING clause to modify.

impl HasTableRef for InsertQuery

fn table_ref_mut(&mut self) -> &mut TableRef

The table reference to modify.

impl HasUpserts for InsertQuery

fn upserts_mut(&mut self) -> &mut Vec<ConflictClause>

The upsert clauses to modify.

impl HasValues for InsertQuery

fn values_mut(&mut self) -> &mut Values

The row source to modify.

impl HasWith for InsertQuery

fn with_mut(&mut self) -> &mut With

The WITH clause to modify.

impl IntoExpr for InsertQuery

fn into_expr(self) -> Expr

Perform the conversion.

impl IntoExprList for InsertQuery

fn into_expr_list(self) -> Vec<Expr>

Perform the conversion.

impl Query for InsertQuery

fn query_type(&self) -> QueryType

Which statement this renders.

fn dialect(&self) -> &dyn Dialect

The dialect this query renders itself in.

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

Render to SQL and arguments, numbering placeholders from 1.

fn build_from(&self, start: usize) -> Result<(String, Vec<Value>), Error>

build with a different first placeholder position, for splicing into a statement that already has arguments — bob’s BuildN.

impl<H, L, M> QueryExtensions<H, L, M> for InsertQuery

fn hooks(&self) -> &[Hook]

Hooks to run before this query executes.

fn loaders(&self) -> &[Loader]

Loaders to run after this query executes, for eagerly loaded relations.

fn mapper_mods(&self) -> &[MapperMod]

Adjustments to the row mapper, for relations loaded in the same query.