Struct sql_query_builder::Delete

pub struct Delete { /* private fields */ }

Builder to contruct a Delete command

Implementations

impl Delete

pub fn and(self, condition: &str) -> Self

The same as where_clause method, useful to write more idiomatic SQL query

Example

use sql_query_builder as sql;

let delete = sql::Delete::new()
  .delete_from("users")
  .where_clause("created_at < $1")
  .and("active = false");

pub fn as_string(&self) -> String

Gets the current state of the Delete and returns it as string

Example

use sql_query_builder as sql;

let query = sql::Delete::new()
  .delete_from("users")
  .where_clause("id = $1")
  .as_string();

Output

DELETE FROM users WHERE id = $1

pub fn debug(self) -> Self

Prints the current state of the Delete into console output in a more ease to read version. This method is useful to debug complex queries or just to print the generated SQL while you type

Example

use sql_query_builder as sql;

let delete_query = sql::Delete::new()
  .delete_from("users")
  .where_clause("login = 'foo'")
  .debug()
  .where_clause("name = 'Foo'")
  .as_string();

Output

DELETE FROM users
WHERE login = 'foo'

pub fn delete_from(self, table_name: &str) -> Self

The delete clause. This method overrides the previous value

Example

use sql_query_builder as sql;

let delete = sql::Delete::new()
  .delete_from("orders");

let delete = sql::Delete::new()
  .delete_from("address")
  .delete_from("orders");

pub fn new() -> Self

Create Delete’s instance

pub fn print(self) -> Self

Prints the current state of the Delete into console output similar to debug method, the difference is that this method prints in one line.

pub fn raw(self, raw_sql: &str) -> Self

Adds at the beginning a raw SQL query.

Example

use sql_query_builder as sql;

let raw_query = "delete from users";
let delete_query = sql::Delete::new()
  .raw(raw_query)
  .where_clause("login = 'foo'")
  .as_string();

Output

delete from users
WHERE login = 'foo'

pub fn raw_after(self, clause: DeleteClause, raw_sql: &str) -> Self

Adds a raw SQL query after a specified clause.

Example

use sql_query_builder as sql;

let raw = "where name = 'Foo'";
let delete_query = sql::Delete::new()
  .delete_from("users")
  .raw_after(sql::DeleteClause::DeleteFrom, raw)
  .as_string();

Output

DELETE FROM users
where name = 'Foo'

pub fn raw_before(self, clause: DeleteClause, raw_sql: &str) -> Self

Adds a raw SQL query before a specified clause.

Example

use sql_query_builder as sql;

let raw = "delete from users";
let delete_query = sql::Delete::new()
  .raw_before(sql::DeleteClause::Where, raw)
  .where_clause("name = 'Bar'")
  .as_string();

Output

delete from users
WHERE name = 'Bar'

pub fn where_clause(self, condition: &str) -> Self

The where clause

Example

use sql_query_builder as sql;

let delete = sql::Delete::new()
  .delete_from("users")
  .where_clause("login = 'foo'");

impl Delete

pub fn returning(self, output_name: &str) -> Self

The returning clause, this method can be used enabling the feature flag postgresql

pub fn with(self, name: &str, query: impl WithQuery + 'static) -> Self

The with clause, this method can be used enabling the feature flag postgresql

Example

use sql_query_builder as sql;

let deactivated_users = sql::Select::new().select("id").from("users").where_clause("ative = false");
let delete = sql::Delete::new()
  .with("deactivated_users", deactivated_users)
  .delete_from("users")
  .where_clause("id in (select * from deactivated_users)")
  .debug();

Output

WITH deactivated_users AS (
  SELECT id
  FROM users
  WHERE ative = false
)
DELETE FROM users
WHERE id in (select * from deactivated_users)

Trait Implementations

impl Clone for Delete

fn clone(&self) -> Delete

Returns a copy of the value.

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

Performs copy-assignment from source.

impl Debug for Delete

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

Formats the value using the given formatter.

impl Default for Delete

fn default() -> Delete

Returns the “default value” for a type.

impl Display for Delete

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

Formats the value using the given formatter.