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

use {
    super::IndexItemNode,
    crate::{ast::IndexOperator, ast_builder::ExprNode},
};

#[derive(Clone, Debug)]
pub struct CmpExprNode<'a> {
    pub index_name: String,
    pub operator: IndexOperator,
    pub expr: ExprNode<'a>,
}

impl<'a> CmpExprNode<'a> {
    pub fn new<T: Into<ExprNode<'a>>>(
        index_name: String,
        operator: IndexOperator,
        expr: T,
    ) -> Self {
        Self {
            index_name,
            operator,
            expr: expr.into(),
        }
    }

    pub fn asc(self) -> IndexItemNode<'a> {
        IndexItemNode::NonClustered {
            name: self.index_name,
            asc: Some(true),
            cmp_expr: Some((self.operator, self.expr)),
        }
    }

    pub fn desc(self) -> IndexItemNode<'a> {
        IndexItemNode::NonClustered {
            name: self.index_name,
            asc: Some(false),
            cmp_expr: Some((self.operator, self.expr)),
        }
    }
}

#[cfg(test)]
mod tests {

    use crate::{
        ast::{AstLiteral, Expr, IndexOperator},
        ast_builder::{
            index_item::{non_clustered, IndexItem},
            select::Prebuild,
            IndexItemNode,
        },
    };

    #[test]
    fn test() {
        let actual = non_clustered("idx".to_owned())
            .eq("1")
            .asc()
            .prebuild()
            .unwrap();
        let expected = IndexItem::NonClustered {
            name: "idx".to_owned(),
            asc: Some(true),
            cmp_expr: Some((
                IndexOperator::Eq,
                Expr::Literal(AstLiteral::Number(1.into())),
            )),
        };
        assert_eq!(actual, expected);

        let actual = non_clustered("idx".to_owned())
            .eq("2")
            .desc()
            .prebuild()
            .unwrap();
        let expected = IndexItem::NonClustered {
            name: "idx".to_owned(),
            asc: Some(false),
            cmp_expr: Some((
                IndexOperator::Eq,
                Expr::Literal(AstLiteral::Number(2.into())),
            )),
        };
        assert_eq!(actual, expected);

        let index_item: IndexItemNode = non_clustered("idx".to_owned()).eq("3").into();
        let actual = index_item.prebuild().unwrap();
        let expected = IndexItem::NonClustered {
            name: "idx".to_owned(),
            asc: None,
            cmp_expr: Some((
                IndexOperator::Eq,
                Expr::Literal(AstLiteral::Number(3.into())),
            )),
        };
        assert_eq!(actual, expected);
    }
}