sift-query-sqlx 0.1.0

PostgreSQL renderer and sqlx executor for SiftQuery
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

use super::typed;
use sift_query_core::{CustomOperator, ValueType};

#[derive(Debug, Clone, Copy, PartialEq, Eq)]
pub enum TextConfig {
    Simple,
    English,
    German,
    French,
}
impl TextConfig {
    pub(crate) fn name(self) -> &'static str {
        match self {
            Self::Simple => "pg_catalog.simple",
            Self::English => "pg_catalog.english",
            Self::German => "pg_catalog.german",
            Self::French => "pg_catalog.french",
        }
    }
}
#[derive(Debug, Clone, Copy, PartialEq, Eq)]
pub enum TextQuery {
    Plain,
    Phrase,
    Web,
    TsQuery,
}

/// Declare a `FilterOnly<String>` field over a tsvector column/expression.
pub fn full_text(config: TextConfig, mode: TextQuery) -> CustomOperator {
    macro_rules! modes {
        ($config:literal) => {
            match mode {
                TextQuery::Plain => typed(
                    "fts_plain",
                    concat!(
                        "{field} @@ plainto_tsquery('",
                        $config,
                        "'::regconfig, {0})"
                    ),
                    ValueType::Text,
                    ValueType::Text,
                ),
                TextQuery::Phrase => typed(
                    "fts_phrase",
                    concat!(
                        "{field} @@ phraseto_tsquery('",
                        $config,
                        "'::regconfig, {0})"
                    ),
                    ValueType::Text,
                    ValueType::Text,
                ),
                TextQuery::Web => typed(
                    "fts_web",
                    concat!(
                        "{field} @@ websearch_to_tsquery('",
                        $config,
                        "'::regconfig, {0})"
                    ),
                    ValueType::Text,
                    ValueType::Text,
                ),
                TextQuery::TsQuery => typed(
                    "fts_query",
                    concat!("{field} @@ to_tsquery('", $config, "'::regconfig, {0})"),
                    ValueType::Text,
                    ValueType::Text,
                ),
            }
        };
    }
    match config {
        TextConfig::Simple => modes!("pg_catalog.simple"),
        TextConfig::English => modes!("pg_catalog.english"),
        TextConfig::German => modes!("pg_catalog.german"),
        TextConfig::French => modes!("pg_catalog.french"),
    }
}