aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorPavel Puchkin <i@neoascetic.me>2018-05-28 01:06:57 +0200
committerrubenwardy <rw@rubenwardy.com>2018-05-28 00:06:57 +0100
commit179d0be933ddf52f9b20ba42a7a6f9593fcc80cc (patch)
treefa4fecc79381c336fc142428aabcdfdef43f5034
parentd6790903a654691bd56dabd62674e960ad4d7f91 (diff)
downloadcheatdb-179d0be933ddf52f9b20ba42a7a6f9593fcc80cc.tar.xz
Make search case-insensitive by using ilike
-rw-r--r--app/views/packages/__init__.py2
1 files changed, 1 insertions, 1 deletions
diff --git a/app/views/packages/__init__.py b/app/views/packages/__init__.py
index 6cb06d8..30b1f90 100644
--- a/app/views/packages/__init__.py
+++ b/app/views/packages/__init__.py
@@ -51,7 +51,7 @@ def packages_page():
search = request.args.get("q")
if search is not None:
- query = query.filter(Package.title.contains(search))
+ query = query.filter(Package.title.ilike('%' + search + '%'))
if shouldReturnJson():
pkgs = [package.getAsDictionary(app.config["BASE_URL"]) \