Struct DeleteQuery 

pub struct DeleteQuery {
    pub with: With,
    pub table: TableRef,
    pub where_: Where,
    pub returning: Returning,
}

A SQLite DELETE.

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

[ WITH [ RECURSIVE ] common-table-expression [, ...] ]
DELETE FROM qualified-table-name
    [ WHERE expr ]
    [ RETURNING result-column [, ...] ]

That is the whole statement — the shortest of the four by a wide margin. PostgreSQL’s USING has no counterpart, so there is no from-item, no join and no HasTableRef here; a delete driven by another table is written with a sub-query in the WHERE, which is what SQLite gives instead. There is also no OR clause: SQLite’s conflict-clause is offered on INSERT and UPDATE only, since a delete cannot violate a uniqueness constraint.

Fields

with: With

WITH ….

table: TableRef

The table rows are deleted from.

where_: Where

WHERE ….

returning: Returning

RETURNING …. SQLite 3.35 and later.

Implementations

impl DeleteQuery

pub fn new() -> DeleteQuery

A DELETE with nothing set yet.

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

Apply more mods to an existing query.

Trait Implementations

impl Clone for DeleteQuery

fn clone(&self) -> DeleteQuery

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for DeleteQuery

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

Formats the value using the given formatter.

impl Default for DeleteQuery

fn default() -> DeleteQuery

Returns the “default value” for a type.

impl Expression for DeleteQuery

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

Append this fragment to w.

impl HasReturning for DeleteQuery

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

The RETURNING clause to modify.

impl HasTargetTable for DeleteQuery

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

The target table to modify.

impl HasWhere for DeleteQuery

fn where_mut(&mut self) -> &mut Where

The WHERE clause to modify.

impl HasWith for DeleteQuery

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

The WITH clause to modify.

impl IntoExpr for DeleteQuery

fn into_expr(self) -> Expr

Perform the conversion.

impl IntoExprList for DeleteQuery

fn into_expr_list(self) -> Vec<Expr>

Perform the conversion.

impl Query for DeleteQuery

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 DeleteQuery

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.