paginator-utils 0.2.2

Shared pagination response structures
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 crate::cursor::Cursor;
use crate::filter::Filter;
use crate::search::SearchParams;
use serde::{Deserialize, Serialize};

#[derive(Clone, Debug, Serialize, Deserialize, PartialEq, Eq)]
#[serde(rename_all = "lowercase")]
pub enum SortDirection {
    Asc,
    Desc,
}

#[derive(Clone, Debug, Serialize, Deserialize)]
pub struct PaginationParams {
    pub page: u32,
    pub per_page: u32,
    pub sort_by: Option<String>,
    pub sort_direction: Option<SortDirection>,
    #[serde(default)]
    pub filters: Vec<Filter>,
    pub search: Option<SearchParams>,
    #[serde(default)]
    pub disable_total_count: bool,
    pub cursor: Option<Cursor>,
}

impl Default for PaginationParams {
    fn default() -> Self {
        Self {
            page: 1,
            per_page: 20,
            sort_by: None,
            sort_direction: None,
            filters: Vec::new(),
            search: None,
            disable_total_count: false,
            cursor: None,
        }
    }
}

impl PaginationParams {
    pub fn new(page: u32, per_page: u32) -> Self {
        Self {
            page: page.max(1),
            per_page: per_page.clamp(1, 100),
            sort_by: None,
            sort_direction: None,
            filters: Vec::new(),
            search: None,
            disable_total_count: false,
            cursor: None,
        }
    }

    pub fn with_sort(mut self, field: impl Into<String>) -> Self {
        self.sort_by = Some(field.into());
        self
    }

    pub fn with_direction(mut self, direction: SortDirection) -> Self {
        self.sort_direction = Some(direction);
        self
    }

    pub fn with_filter(mut self, filter: Filter) -> Self {
        self.filters.push(filter);
        self
    }

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

    pub fn with_search(mut self, search: SearchParams) -> Self {
        self.search = Some(search);
        self
    }

    pub fn offset(&self) -> u32 {
        (self.page - 1) * self.per_page
    }

    pub fn limit(&self) -> u32 {
        self.per_page
    }

    pub fn to_sql_where(&self) -> Option<String> {
        let mut conditions = Vec::new();

        for filter in &self.filters {
            conditions.push(filter.to_sql_where());
        }

        if let Some(ref search) = self.search {
            conditions.push(search.to_sql_where());
        }

        if conditions.is_empty() {
            None
        } else {
            Some(conditions.join(" AND "))
        }
    }

    pub fn to_surrealql_where(&self) -> Option<String> {
        let mut conditions = Vec::new();

        for filter in &self.filters {
            conditions.push(filter.to_surrealql_where());
        }

        if let Some(ref search) = self.search {
            let search_conditions: Vec<String> = search
                .fields
                .iter()
                .map(|field| {
                    let pattern = if search.exact_match {
                        format!("'{}'", search.query.replace('\'', "''"))
                    } else {
                        format!("'%{}%'", search.query.replace('\'', "''"))
                    };
                    format!("{} ~ {}", field, pattern)
                })
                .collect();
            conditions.push(format!("({})", search_conditions.join(" OR ")));
        }

        if conditions.is_empty() {
            None
        } else {
            Some(conditions.join(" AND "))
        }
    }
}