postgrest-parser 0.2.0

PostgREST URL-to-SQL parser for Rust and WASM
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
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136

use super::{LogicCondition, OrderTerm, SelectItem};
use serde::{Deserialize, Serialize};

#[derive(Debug, Clone, PartialEq, Serialize, Deserialize)]
pub struct ParsedParams {
    pub select: Option<Vec<SelectItem>>,
    pub filters: Vec<LogicCondition>,
    pub order: Vec<OrderTerm>,
    pub limit: Option<u64>,
    pub offset: Option<u64>,
}

impl ParsedParams {
    pub fn new() -> Self {
        Self {
            select: None,
            filters: Vec::new(),
            order: Vec::new(),
            limit: None,
            offset: None,
        }
    }

    pub fn with_select(mut self, select: Vec<SelectItem>) -> Self {
        self.select = Some(select);
        self
    }

    pub fn with_filters(mut self, filters: Vec<LogicCondition>) -> Self {
        self.filters = filters;
        self
    }

    pub fn with_order(mut self, order: Vec<OrderTerm>) -> Self {
        self.order = order;
        self
    }

    pub fn with_limit(mut self, limit: u64) -> Self {
        self.limit = Some(limit);
        self
    }

    pub fn with_offset(mut self, offset: u64) -> Self {
        self.offset = Some(offset);
        self
    }

    pub fn is_empty(&self) -> bool {
        self.select.is_none()
            && self.filters.is_empty()
            && self.order.is_empty()
            && self.limit.is_none()
            && self.offset.is_none()
    }

    pub fn has_filters(&self) -> bool {
        !self.filters.is_empty()
    }

    pub fn has_select(&self) -> bool {
        self.select.is_some()
    }
}

impl Default for ParsedParams {
    fn default() -> Self {
        Self::new()
    }
}

#[cfg(test)]
mod tests {
    use super::*;
    use crate::ast::{Field, Filter, FilterOperator, FilterValue};

    #[test]
    fn test_parsed_params_new() {
        let params = ParsedParams::new();
        assert!(params.select.is_none());
        assert!(params.filters.is_empty());
        assert!(params.order.is_empty());
        assert!(params.limit.is_none());
        assert!(params.offset.is_none());
    }

    #[test]
    fn test_parsed_params_with_select() {
        let select = vec![SelectItem::field("id"), SelectItem::field("name")];
        let params = ParsedParams::new().with_select(select);
        assert!(params.has_select());
        assert_eq!(params.select.as_ref().unwrap().len(), 2);
    }

    #[test]
    fn test_parsed_params_with_limit() {
        let params = ParsedParams::new().with_limit(100);
        assert_eq!(params.limit, Some(100));
    }

    #[test]
    fn test_parsed_params_with_offset() {
        let params = ParsedParams::new().with_offset(20);
        assert_eq!(params.offset, Some(20));
    }

    #[test]
    fn test_parsed_params_is_empty() {
        let params = ParsedParams::new();
        assert!(params.is_empty());
    }

    #[test]
    fn test_parsed_params_has_filters() {
        let filter = LogicCondition::Filter(Filter::new(
            Field::new("id"),
            FilterOperator::Eq,
            FilterValue::Single("1".to_string()),
        ));
        let params = ParsedParams::new().with_filters(vec![filter]);
        assert!(params.has_filters());
    }

    #[test]
    fn test_parsed_params_default() {
        let params = ParsedParams::default();
        assert!(params.is_empty());
    }

    #[test]
    fn test_parsed_params_serialization() {
        let params = ParsedParams::new().with_limit(10);
        let json = serde_json::to_string(&params).unwrap();
        assert!(json.contains("limit"));
    }
}