diff options
| -rw-r--r-- | fietsboek/views/climb.py | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/fietsboek/views/climb.py b/fietsboek/views/climb.py index af42162..e4d6c49 100644 --- a/fietsboek/views/climb.py +++ b/fietsboek/views/climb.py @@ -10,7 +10,7 @@ from pyramid.httpexceptions import ( from pyramid.request import Request from pyramid.response import Response from pyramid.view import view_config -from sqlalchemy import nulls_first, nulls_last, or_, select +from sqlalchemy import and_, nulls_first, nulls_last, or_, select from sqlalchemy.orm import aliased from .. import models, util @@ -54,6 +54,14 @@ def _apply_order(query: Select, order: ResultOrder) -> Select: def _apply_filters(query: Select, request: Request) -> Select: + if request.params.get("search-terms"): + terms = request.params.get("search-terms").split() + clauses = [] + for term in terms: + escaped = term.replace("/", "//").replace("%", "/%").replace("_", "/_") + clauses.append(models.Climb.automatic_name.ilike(f"%{escaped}%")) + query = query.where(and_(*clauses)) + if request.params.get("min-length"): min_length = util.get_int(request, "min-length") query = query.where(models.Climb.length >= min_length * 1000) |
