aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--fietsboek/views/climb.py10
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)