gluesql-core 0.20.0

GlueSQL - Open source SQL database engine fully written in Rust with pure functional execution layer, easily swappable storage and web assembly support!
Documentation 
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

use super::ExprNode;

impl ExprNode<'_> {
    #[must_use]
    pub fn between<T: Into<Self>, U: Into<Self>>(self, low: T, high: U) -> Self {
        Self::Between {
            expr: Box::new(self),
            negated: false,
            low: Box::new(low.into()),
            high: Box::new(high.into()),
        }
    }

    #[must_use]
    pub fn not_between<T: Into<Self>, U: Into<Self>>(self, low: T, high: U) -> Self {
        Self::Between {
            expr: Box::new(self),
            negated: true,
            low: Box::new(low.into()),
            high: Box::new(high.into()),
        }
    }
}

#[cfg(test)]
mod tests {
    use crate::query_builder::{col, num, test_expr, text};

    #[test]
    fn between() {
        let actual = col("num").between(1, 10);
        let expected = "num BETWEEN 1 AND 10";
        test_expr(actual, expected);

        let actual = col("date").between(text("2022-01-01"), "'2023-01-01'");
        let expected = "date BETWEEN '2022-01-01' AND '2023-01-01'";
        test_expr(actual, expected);

        let actual = col("num").not_between(num(1), 10);
        let expected = "num NOT BETWEEN 1 AND 10";
        test_expr(actual, expected);

        let actual = col("date").not_between(text("2022-01-01"), text("2023-01-01"));
        let expected = "date NOT BETWEEN '2022-01-01' AND '2023-01-01'";
        test_expr(actual, expected);
    }
}