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

use {
    super::TableAccessNode,
    crate::{ast::IndexOperator, query_builder::ExprNode},
};

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

impl<'a> IndexPredicateNode<'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) -> TableAccessNode<'a> {
        let Self {
            index_name,
            operator,
            expr,
        } = self;

        TableAccessNode::Index {
            name: index_name,
            asc: Some(true),
            predicate: Some((operator, expr)),
        }
    }

    pub fn desc(self) -> TableAccessNode<'a> {
        let Self {
            index_name,
            operator,
            expr,
        } = self;

        TableAccessNode::Index {
            name: index_name,
            asc: Some(false),
            predicate: Some((operator, expr)),
        }
    }
}

#[cfg(test)]
mod tests {
    use crate::{
        ast::{IndexOperator, Literal},
        plan::{ExprPlan, IndexPredicatePlan, TableAccessPlan},
        query_builder::{TableAccessNode, table_access::non_clustered},
    };

    #[test]
    fn test() {
        let actual = non_clustered("idx".to_owned())
            .eq("1")
            .asc()
            .build_table_access_plan()
            .unwrap();
        let expected = TableAccessPlan::Index {
            name: "idx".to_owned(),
            asc: Some(true),
            predicate: Some(IndexPredicatePlan {
                operator: IndexOperator::Eq,
                expr: ExprPlan::Literal(Literal::Number(1.into())),
            }),
        };
        assert_eq!(actual, expected);

        let actual = non_clustered("idx".to_owned())
            .eq("2")
            .desc()
            .build_table_access_plan()
            .unwrap();
        let expected = TableAccessPlan::Index {
            name: "idx".to_owned(),
            asc: Some(false),
            predicate: Some(IndexPredicatePlan {
                operator: IndexOperator::Eq,
                expr: ExprPlan::Literal(Literal::Number(2.into())),
            }),
        };
        assert_eq!(actual, expected);

        let index_item: TableAccessNode = non_clustered("idx".to_owned()).eq("3").into();
        let actual = index_item.build_table_access_plan().unwrap();
        let expected = TableAccessPlan::Index {
            name: "idx".to_owned(),
            asc: None,
            predicate: Some(IndexPredicatePlan {
                operator: IndexOperator::Eq,
                expr: ExprPlan::Literal(Literal::Number(3.into())),
            }),
        };
        assert_eq!(actual, expected);
    }
}