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
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
use expression::grouped::Grouped;
use expression::operators::{And, Or};
use expression::{AsExpression, Expression};
use sql_types::Bool;
/// Methods present on boolean expressions
pub trait BoolExpressionMethods: Expression<SqlType = Bool> + Sized {
/// Creates a SQL `AND` expression
///
/// # Example
///
/// ```
/// # #[macro_use] extern crate diesel;
/// # include!("../doctest_setup.rs");
/// #
/// # fn main() {
/// # run_test().unwrap();
/// # }
/// #
/// # fn run_test() -> QueryResult<()> {
/// # use schema::animals::dsl::*;
/// # let connection = establish_connection();
/// #
/// diesel::insert_into(animals)
/// .values(&vec![
/// (species.eq("ferret"), legs.eq(4), name.eq("Freddy")),
/// (species.eq("ferret"), legs.eq(4), name.eq("Jack")),
/// ])
/// .execute(&connection)?;
///
/// let data = animals.select((species, name))
/// .filter(species.eq("ferret").and(name.eq("Jack")))
/// .load(&connection)?;
/// let expected = vec![
/// (String::from("ferret"), Some(String::from("Jack"))),
/// ];
/// assert_eq!(expected, data);
/// # Ok(())
/// # }
fn and<T: AsExpression<Bool>>(self, other: T) -> And<Self, T::Expression> {
And::new(self.as_expression(), other.as_expression())
}
/// Creates a SQL `OR` expression
///
/// The result will be wrapped in parenthesis, so that precedence matches
/// that of your function calls. For example, `false.and(false.or(true))`
/// will generate the SQL `FALSE AND (FALSE OR TRUE)`, which returns `false`
///
/// # Example
///
/// ```
/// # #[macro_use] extern crate diesel;
/// # include!("../doctest_setup.rs");
/// #
/// # fn main() {
/// # run_test().unwrap();
/// # }
/// #
/// # fn run_test() -> QueryResult<()> {
/// # use schema::animals::dsl::*;
/// # let connection = establish_connection();
/// #
/// diesel::insert_into(animals)
/// .values(&vec![
/// (species.eq("ferret"), legs.eq(4), name.eq("Freddy")),
/// (species.eq("ferret"), legs.eq(4), name.eq("Jack")),
/// ])
/// .execute(&connection)?;
///
/// let data = animals.select((species, name))
/// .filter(species.eq("ferret").or(name.eq("Jack")))
/// .load(&connection)?;
/// let expected = vec![
/// (String::from("dog"), Some(String::from("Jack"))),
/// (String::from("ferret"), Some(String::from("Freddy"))),
/// (String::from("ferret"), Some(String::from("Jack"))),
/// ];
/// assert_eq!(expected, data);
/// # Ok(())
/// # }
fn or<T: AsExpression<Bool>>(self, other: T) -> Grouped<Or<Self, T::Expression>> {
Grouped(Or::new(self, other.as_expression()))
}
}
impl<T: Expression<SqlType = Bool>> BoolExpressionMethods for T {}