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
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
|
from typing import Any, Callable, Dict, Optional, Union
import sqlalchemy as sa
from szurubooru import db, errors
from szurubooru.func import util
from szurubooru.search import criteria
from szurubooru.search.configs.base_search_config import Filter
from szurubooru.search.typing import SaColumn, SaQuery
Number = Union[int, float]
WILDCARD = "(--wildcard--)" # something unlikely to be used by the users
def unescape(text: str, make_wildcards_special: bool = False) -> str:
output = ""
i = 0
while i < len(text):
if text[i] == "\\":
try:
char = text[i + 1]
i += 1
except IndexError:
raise errors.SearchError(
"Unterminated escape sequence (did you forget to escape "
"the ending backslash?)"
)
if char not in "*\\:-.,":
raise errors.SearchError(
"Unknown escape sequence (did you forget to escape "
"the backslash?)"
)
elif text[i] == "*" and make_wildcards_special:
char = WILDCARD
else:
char = text[i]
output += char
i += 1
return output
def wildcard_transformer(value: str) -> str:
return (
unescape(value, make_wildcards_special=True)
.replace("\\", "\\\\")
.replace("%", "\\%")
.replace("_", "\\_")
.replace(WILDCARD, "%")
)
def enum_transformer(available_values: Dict[str, Any], value: str) -> str:
try:
return available_values[unescape(value.lower())]
except KeyError:
raise errors.SearchError(
"Invalid value: %r. Possible values: %r."
% (value, list(sorted(available_values.keys())))
)
def integer_transformer(value: str) -> int:
return int(unescape(value))
def float_transformer(value: str) -> float:
for sep in list("/:"):
if sep in value:
a, b = value.split(sep, 1)
return float(unescape(a)) / float(unescape(b))
return float(unescape(value))
def apply_num_criterion_to_column(
column: Any,
criterion: criteria.BaseCriterion,
transformer: Callable[[str], Number] = integer_transformer,
) -> SaQuery:
try:
if isinstance(criterion, criteria.PlainCriterion):
expr = column == transformer(criterion.value)
elif isinstance(criterion, criteria.ArrayCriterion):
expr = column.in_(transformer(value) for value in criterion.values)
elif isinstance(criterion, criteria.RangedCriterion):
assert criterion.min_value or criterion.max_value
if criterion.min_value and criterion.max_value:
expr = column.between(
transformer(criterion.min_value),
transformer(criterion.max_value),
)
elif criterion.min_value:
expr = column >= transformer(criterion.min_value)
elif criterion.max_value:
expr = column <= transformer(criterion.max_value)
else:
assert False
except ValueError:
raise errors.SearchError(
"Criterion value %r must be a number." % (criterion,)
)
return expr
def create_num_filter(
column: Any, transformer: Callable[[str], Number] = integer_transformer
) -> SaQuery:
def wrapper(
query: SaQuery,
criterion: Optional[criteria.BaseCriterion],
negated: bool,
) -> SaQuery:
assert criterion
expr = apply_num_criterion_to_column(column, criterion, transformer)
if negated:
expr = ~expr
return query.filter(expr)
return wrapper
def create_float_filter(column: Any) -> SaQuery:
return create_num_filter(column, float_transformer)
def apply_str_criterion_to_column(
column: SaColumn,
criterion: criteria.BaseCriterion,
transformer: Callable[[str], str] = wildcard_transformer,
) -> SaQuery:
if isinstance(criterion, criteria.PlainCriterion):
expr = column.ilike(transformer(criterion.value))
elif isinstance(criterion, criteria.ArrayCriterion):
expr = sa.sql.false()
for value in criterion.values:
expr = expr | column.ilike(transformer(value))
elif isinstance(criterion, criteria.RangedCriterion):
raise errors.SearchError(
"Ranged criterion is invalid in this context. "
"Did you forget to escape the dots?"
)
else:
assert False
return expr
def create_str_filter(
column: SaColumn, transformer: Callable[[str], str] = wildcard_transformer
) -> Filter:
def wrapper(
query: SaQuery,
criterion: Optional[criteria.BaseCriterion],
negated: bool,
) -> SaQuery:
assert criterion
expr = apply_str_criterion_to_column(column, criterion, transformer)
if negated:
expr = ~expr
return query.filter(expr)
return wrapper
def apply_date_criterion_to_column(
column: SaQuery, criterion: criteria.BaseCriterion
) -> SaQuery:
if isinstance(criterion, criteria.PlainCriterion):
min_date, max_date = util.parse_time_range(criterion.value)
expr = column.between(min_date, max_date)
elif isinstance(criterion, criteria.ArrayCriterion):
expr = sa.sql.false()
for value in criterion.values:
min_date, max_date = util.parse_time_range(value)
expr = expr | column.between(min_date, max_date)
elif isinstance(criterion, criteria.RangedCriterion):
assert criterion.min_value or criterion.max_value
if criterion.min_value and criterion.max_value:
min_date = util.parse_time_range(criterion.min_value)[0]
max_date = util.parse_time_range(criterion.max_value)[1]
expr = column.between(min_date, max_date)
elif criterion.min_value:
min_date = util.parse_time_range(criterion.min_value)[0]
expr = column >= min_date
elif criterion.max_value:
max_date = util.parse_time_range(criterion.max_value)[1]
expr = column <= max_date
else:
assert False
return expr
def create_date_filter(column: SaColumn) -> Filter:
def wrapper(
query: SaQuery,
criterion: Optional[criteria.BaseCriterion],
negated: bool,
) -> SaQuery:
assert criterion
expr = apply_date_criterion_to_column(column, criterion)
if negated:
expr = ~expr
return query.filter(expr)
return wrapper
def create_subquery_filter(
left_id_column: SaColumn,
right_id_column: SaColumn,
filter_column: SaColumn,
filter_factory: SaColumn,
subquery_decorator: Callable[[SaQuery], None] = None,
) -> Filter:
filter_func = filter_factory(filter_column)
def wrapper(
query: SaQuery,
criterion: Optional[criteria.BaseCriterion],
negated: bool,
) -> SaQuery:
assert criterion
subquery = db.session.query(right_id_column.label("foreign_id"))
if subquery_decorator:
subquery = subquery_decorator(subquery)
subquery = subquery.options(sa.orm.lazyload("*"))
subquery = filter_func(subquery, criterion, False)
subquery = subquery.subquery("t")
expression = left_id_column.in_(subquery)
if negated:
expression = ~expression
return query.filter(expression)
return wrapper
|
