sqlx-paginated 0.3.1

A flexible, type-safe SQLx query builder for dynamic web APIs, offering seamless pagination, searching, filtering, and sorting.
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

use crate::paginated_query_as::internal::{
    default_date_range_column, default_page, default_page_size, default_search_columns,
    default_sort_column, default_sort_direction, page_deserialize, page_size_deserialize,
    search_columns_deserialize, search_deserialize,
};

use crate::QuerySortDirection;
use chrono::{DateTime, Utc};
use serde::{Deserialize, Serialize};

#[derive(Serialize, Deserialize, Clone, Debug)]
#[serde(rename_all = "snake_case")]
pub struct QueryPaginationParams {
    #[serde(deserialize_with = "page_deserialize", default = "default_page")]
    pub page: i64,
    #[serde(
        deserialize_with = "page_size_deserialize",
        default = "default_page_size"
    )]
    pub page_size: i64,
}

impl Default for QueryPaginationParams {
    fn default() -> Self {
        Self {
            page: default_page(),
            page_size: default_page_size(),
        }
    }
}

#[derive(Serialize, Deserialize, Clone, Debug)]
#[serde(rename_all = "snake_case")]
pub struct QuerySortParams {
    #[serde(default = "default_sort_direction")]
    pub sort_direction: QuerySortDirection,
    #[serde(default = "default_sort_column")]
    pub sort_column: String,
}

impl Default for QuerySortParams {
    fn default() -> Self {
        Self {
            sort_direction: default_sort_direction(),
            sort_column: default_sort_column(),
        }
    }
}

#[derive(Serialize, Deserialize, Clone, Debug)]
#[serde(rename_all = "snake_case")]
pub struct QuerySearchParams {
    #[serde(deserialize_with = "search_deserialize")]
    pub search: Option<String>,
    #[serde(
        deserialize_with = "search_columns_deserialize",
        default = "default_search_columns"
    )]
    pub search_columns: Option<Vec<String>>,
}

impl Default for QuerySearchParams {
    fn default() -> Self {
        Self {
            search: None,
            search_columns: default_search_columns(),
        }
    }
}

#[derive(Serialize, Deserialize, Clone, Debug)]
#[serde(rename_all = "snake_case")]
pub struct QueryDateRangeParams {
    pub date_after: Option<DateTime<Utc>>,
    pub date_before: Option<DateTime<Utc>>,
    #[serde(default = "default_date_range_column")]
    pub date_column: Option<String>,
}

impl Default for QueryDateRangeParams {
    fn default() -> Self {
        Self {
            date_after: None,
            date_before: None,
            date_column: default_date_range_column(),
        }
    }
}