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
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
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121

use super::ExprNode;

impl<'a> ExprNode<'a> {
    pub fn case(self) -> CaseNode<'a> {
        CaseNode {
            operand: Some(Box::new(self)),
        }
    }
}

pub fn case() -> CaseNode<'static> {
    CaseNode { operand: None }
}

#[derive(Clone, Debug)]
pub struct CaseNode<'a> {
    operand: Option<Box<ExprNode<'a>>>,
}

impl<'a> CaseNode<'a> {
    pub fn when_then<W: Into<ExprNode<'a>>, T: Into<ExprNode<'a>>>(
        self,
        when: W,
        then: T,
    ) -> WhenThenNode<'a> {
        WhenThenNode {
            prev_node: self,
            when_then: vec![(when.into(), then.into())],
        }
    }
}

#[derive(Clone, Debug)]
pub struct WhenThenNode<'a> {
    prev_node: CaseNode<'a>,
    when_then: Vec<(ExprNode<'a>, ExprNode<'a>)>,
}

impl<'a> WhenThenNode<'a> {
    pub fn when_then<W: Into<ExprNode<'a>>, T: Into<ExprNode<'a>>>(
        mut self,
        when: W,
        then: T,
    ) -> Self {
        self.when_then.push((when.into(), then.into()));
        self
    }

    pub fn or_else<T: Into<ExprNode<'a>>>(self, else_result: T) -> ExprNode<'a> {
        ExprNode::Case {
            operand: self.prev_node.operand,
            when_then: self.when_then,
            else_result: Some(Box::new(else_result.into())),
        }
    }

    pub fn end(self) -> ExprNode<'a> {
        ExprNode::Case {
            operand: self.prev_node.operand,
            when_then: self.when_then,
            else_result: None,
        }
    }
}

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

    #[test]
    fn case_with_operand() {
        let actual = col("id")
            .case()
            .when_then(num(1), text("a"))
            .when_then(2, text("b"))
            .or_else(text("c"));
        let expected = "
            CASE id
              WHEN 1 THEN 'a'
              WHEN 2 THEN 'b'
              ELSE 'c'
            END
            ";
        test_expr(actual, expected);

        let actual = col("id")
            .gt(10)
            .case()
            .when_then(true, text("a"))
            .when_then(false, text("b"))
            .end();
        let expected = "
            CASE id > 10
              WHEN True THEN 'a'
              WHEN False THEN 'b'
            END
            ";
        test_expr(actual, expected);
    }

    #[test]
    fn case_without_operand() {
        let actual = case()
            .when_then(
                "City IS NULL",
                case()
                    .when_then("Country IS NULL", text("weird"))
                    .or_else("Country"),
            )
            .or_else("City");
        let expected = r"
            CASE
              WHEN City IS NULL THEN CASE WHEN Country IS NULL THEN 'weird'
                                          ELSE Country
                                          END
              ELSE City
            END
            ";
        test_expr(actual, expected);
    }
}