Struct DeleteQuery 

pub struct DeleteQuery {
    pub with: With,
    pub table: TableRef,
    pub using: TableRef,
    pub extra_using: Vec<TableRef>,
    pub where_: Where,
    pub returning: Returning,
}

A PostgreSQL DELETE.

From https://www.postgresql.org/docs/17/sql-delete.html:

[ WITH [ RECURSIVE ] with_query [, ...] ]
DELETE FROM [ ONLY ] table_name [ * ] [ [ AS ] alias ]
    [ USING from_item [, ...] ]
    [ WHERE condition | WHERE CURRENT OF cursor_name ]
    [ RETURNING … ]

USING is a FROM list under another keyword, which is why it is the HasTableRef slot here and the deleted-from table is the HasTargetTable one.

Fields

with: With

WITH ….

table: TableRef

The table rows are deleted from.

using: TableRef

The first USING item, with its joins.

extra_using: Vec<TableRef>

Further comma-separated USING items.

where_: Where

WHERE ….

returning: Returning

RETURNING ….

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 HasExtraTables for DeleteQuery

fn extra_tables_mut(&mut self) -> &mut Vec<TableRef>

The additional from-items to modify.

impl HasJoins for DeleteQuery

fn joins_mut(&mut self) -> &mut Vec<Join>

The join list to modify.

impl HasReturning for DeleteQuery

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

The RETURNING clause to modify.

impl HasTableRef for DeleteQuery

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

The table reference 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.