diff options
| author | rr- | 2016-09-26 21:56:19 +0200 |
|---|---|---|
| committer | rr- | 2016-09-26 21:58:27 +0200 |
| commit | 0e31e1fd14d35b1caef49ce18e0dbd8980b30c0f (patch) | |
| tree | 40e95fd4afc02d56de41e1bdc98a824949e450aa | |
| parent | 71a4ce876401fa239671ae32dbb53c05fb4acdbc (diff) | |
server/search: fix underscores and percentages
Escape them for LIKE statements.
| -rw-r--r-- | server/szurubooru/search/configs/util.py | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/server/szurubooru/search/configs/util.py b/server/szurubooru/search/configs/util.py index 28418db..d3cb584 100644 --- a/server/szurubooru/search/configs/util.py +++ b/server/szurubooru/search/configs/util.py @@ -5,7 +5,10 @@ from szurubooru.search import criteria def wildcard_transformer(value): - return value.replace('*', '%') + return (value + .replace('%', r'\%') + .replace('_', r'\_') + .replace('*', '%')) def apply_num_criterion_to_column(column, criterion): |