Struct DeleteStatement 

pub struct DeleteStatement { /* private fields */ }

DELETE statement builder

This struct provides a fluent API for constructing DELETE queries.

Examples

use reinhardt_query::prelude::*;

let query = Query::delete()
    .from_table("users")
    .and_where(Expr::col("active").eq(false));

Implementations

impl DeleteStatement

pub fn new() -> Self

Create a new DELETE statement

pub fn take(&mut self) -> Self

Take the ownership of data in the current DeleteStatement

pub fn from_table<T>(&mut self, tbl: T) -> &mut Self

where T: IntoTableRef,

Set the table to delete from

Examples

use reinhardt_query::prelude::*;

let query = Query::delete()
    .from_table("users");

pub fn and_where<C>(&mut self, condition: C) -> &mut Self

where C: IntoCondition,

Add a condition to the WHERE clause

Examples

use reinhardt_query::prelude::*;

let query = Query::delete()
    .from_table("users")
    .and_where(Expr::col("deleted_at").is_not_null())
    .and_where(Expr::col("deleted_at").lt("2020-01-01"));

pub fn cond_where(&mut self, condition: Condition) -> &mut Self

Add a conditional WHERE clause.

This is an alias for and_where that accepts a Condition.

pub fn returning<I, C>(&mut self, cols: I) -> &mut Self

where I: IntoIterator<Item = C>, C: IntoColumnRef,

Add a RETURNING clause

Examples

use reinhardt_query::prelude::*;

let query = Query::delete()
    .from_table("users")
    .and_where(Expr::col("id").eq(1))
    .returning(["id", "name"]);

pub fn returning_all(&mut self) -> &mut Self

Add a RETURNING * clause

Examples

use reinhardt_query::prelude::*;

let query = Query::delete()
    .from_table("users")
    .and_where(Expr::col("id").eq(1))
    .returning_all();

Trait Implementations

impl Clone for DeleteStatement

fn clone(&self) -> DeleteStatement

Returns a duplicate of the value.

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

Performs copy-assignment from source.

impl Debug for DeleteStatement

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

Formats the value using the given formatter.

impl Default for DeleteStatement

fn default() -> Self

Returns the “default value” for a type.

impl QueryStatementBuilder for DeleteStatement

fn build_any(&self, query_builder: &dyn QueryBuilderTrait) -> (String, Values)

Build SQL statement for a database backend and collect query parameters

fn to_string<T: QueryBuilderTrait>(&self, query_builder: T) -> String

Build SQL statement for a database backend and return SQL string with values inlined as SQL literals.

fn build<T: QueryBuilderTrait>(&self, query_builder: T) -> (String, Values)

Build SQL statement with parameter collection

impl QueryStatementWriter for DeleteStatement