ayumu 0.3.6

A small, lightweight, user-oriented query language for search forms.
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

use crate::{
    ast::Value,
    converters::{
        sqlite::{SQLiteWhere, WhereClause},
        Convert, ConvertError,
    },
    tests::list_string,
};

#[test]
pub fn empty_query() {
    let mut sqlite = SQLiteWhere::new(list_string(&["title", "tags", "year"]), true);
    assert_eq!(
        sqlite.match_keywords_with(list_string(&["tagsB"])),
        Err("Invalid column \"tagsB\"".to_string())
    );

    sqlite.match_keywords_with(list_string(&[])).unwrap();

    debug_assert_eq!(
        sqlite.convert("should be ignored as there are no columns for match keywords"),
        Ok(WhereClause {
            where_clause: "".to_string(),
            order_by: "".to_string(),
            bindings: vec![]
        })
    );

    debug_assert_eq!(
        sqlite.convert("sortby : year  desc sortby :tags"),
        Ok(WhereClause {
            where_clause: "".to_string(),
            order_by: "year DESC, tags".to_string(),
            bindings: vec![]
        })
    );
}

#[test]
pub fn simple_keyword() {
    let mut sqlite = SQLiteWhere::new(list_string(&["title", "tags", "year"]), true);
    sqlite
        .match_keywords_with(list_string(&["title", "tags"]))
        .unwrap();

    debug_assert_eq!(
        sqlite.convert("Some title !~ BadTitle Keyword sortby:tags desc"),
        Ok(WhereClause {
            where_clause: "(title LIKE ? OR tags LIKE ?) AND (title NOT LIKE ?)".to_string(),
            order_by: "tags DESC".to_string(),
            bindings: vec![
                (
                    "title".to_string(),
                    Value::String("%Some%Keyword%".to_string())
                ),
                (
                    "tags".to_string(),
                    Value::String("%Some%Keyword%".to_string())
                ),
                ("title".to_string(), Value::String("BadTitle".to_string())),
            ]
        })
    );

    debug_assert_eq!(
        sqlite.convert(r#" title ~"nar"  "#),
        Ok(WhereClause {
            where_clause: "(title LIKE ?)".to_string(),
            order_by: "".to_string(),
            bindings: vec![("title".to_string(), Value::String("nar".to_string()))]
        })
    );

    debug_assert_eq!(
        sqlite.convert("Hayao sortby:title sortby:tags rand year>=2000 Miyazaki sortby:year asc"),
        Ok(WhereClause {
            where_clause: "(title LIKE ? OR tags LIKE ?) AND (year >= ?)".to_string(),
            order_by: "title, tags, RANDOM(), year ASC".to_string(),
            bindings: vec![
                (
                    "title".to_string(),
                    Value::String("%Hayao%Miyazaki%".to_string())
                ),
                (
                    "tags".to_string(),
                    Value::String("%Hayao%Miyazaki%".to_string())
                ),
                ("year".to_string(), Value::Number(2000.0))
            ]
        })
    );
}

#[test]
fn special_values() {
    let mut sqlite = SQLiteWhere::new(list_string(&["title", "tags", "year"]), true);
    sqlite
        .match_keywords_with(list_string(&["title", "tags"]))
        .unwrap();

    debug_assert_eq!(
        sqlite.convert("title ~ @null"),
        Err(ConvertError {
            error: "null comparison expects = or !=, got \"~\" instead".to_string(),
            start: 6,
            end: 7
        })
    );

    debug_assert_eq!(
        sqlite.convert("title = @null tags != @null sortby: @rand asc sortby: title"),
        Ok(WhereClause {
            where_clause: "(title IS NULL AND tags IS NOT NULL)".to_string(),
            order_by: "RANDOM(), title".to_string(),
            bindings: vec![]
        })
    );
}