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
48
49
50
51
52
53
54
55
56

use super::ExprNode;

impl ExprNode<'_> {
    #[must_use]
    pub fn regex<T: Into<Self>>(self, pattern: T) -> Self {
        Self::Regex {
            expr: Box::new(self),
            negated: false,
            pattern: Box::new(pattern.into()),
            case_sensitive: true,
        }
    }

    #[must_use]
    pub fn iregex<T: Into<Self>>(self, pattern: T) -> Self {
        Self::Regex {
            expr: Box::new(self),
            negated: false,
            pattern: Box::new(pattern.into()),
            case_sensitive: false,
        }
    }

    #[must_use]
    pub fn not_regex<T: Into<Self>>(self, pattern: T) -> Self {
        Self::Regex {
            expr: Box::new(self),
            negated: true,
            pattern: Box::new(pattern.into()),
            case_sensitive: true,
        }
    }

    #[must_use]
    pub fn not_iregex<T: Into<Self>>(self, pattern: T) -> Self {
        Self::Regex {
            expr: Box::new(self),
            negated: true,
            pattern: Box::new(pattern.into()),
            case_sensitive: false,
        }
    }
}

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

    #[test]
    fn regex() {
        test_expr(col("name").regex(text("a")), "name ~ 'a'");
        test_expr(col("name").iregex(text("a")), "name ~* 'a'");
        test_expr(col("name").not_regex(text("a")), "name !~ 'a'");
        test_expr(col("name").not_iregex(text("a")), "name !~* 'a'");
    }
}