1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
use crate::ast::*;
#[derive(Debug, PartialEq, Clone)]
/// A builder for a `DELETE` statement.
pub struct Delete<'a> {
pub(crate) table: Table<'a>,
pub(crate) conditions: Option<ConditionTree<'a>>,
}
impl<'a> From<Delete<'a>> for Query<'a> {
#[inline]
fn from(delete: Delete<'a>) -> Self {
Query::Delete(Box::new(delete))
}
}
impl<'a> Delete<'a> {
/// Creates a new `DELETE` statement for the given table.
///
/// ```rust
/// # use quaint::{ast::*, visitor::{Visitor, Sqlite}};
/// let query = Delete::from_table("users");
/// let (sql, _) = Sqlite::build(query);
///
/// assert_eq!("DELETE FROM `users`", sql);
/// ```
#[inline]
pub fn from_table<T>(table: T) -> Self
where
T: Into<Table<'a>>,
{
Self {
table: table.into(),
conditions: None,
}
}
/// Adds `WHERE` conditions to the query. See
/// [Comparable](trait.Comparable.html#required-methods) for more examples.
///
/// ```rust
/// # use quaint::{ast::*, visitor::{Visitor, Sqlite}};
/// let query = Delete::from_table("users").so_that("bar".equals(false));
/// let (sql, params) = Sqlite::build(query);
///
/// assert_eq!("DELETE FROM `users` WHERE `bar` = ?", sql);
/// assert_eq!(vec![ParameterizedValue::Boolean(false)], params);
/// ```
pub fn so_that<T>(mut self, conditions: T) -> Self
where
T: Into<ConditionTree<'a>>,
{
self.conditions = Some(conditions.into());
self
}
}