aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorDaniel Schadt <kingdread@gmx.de>2026-11-12 19:32:17 +0100
committerDaniel Schadt <kingdread@gmx.de>2026-11-12 19:32:17 +0100
commit06c46db90149fd1afd39ba040630b55d0c4ae33c (patch)
treee473ce74d02af5ff43f561966369ee838434aab9
parentccb66ca8a6356b1472a08a001106bec29205d030 (diff)
downloadfietsboek-06c46db90149fd1afd39ba040630b55d0c4ae33c.tar.gz
fietsboek-06c46db90149fd1afd39ba040630b55d0c4ae33c.tar.bz2
fietsboek-06c46db90149fd1afd39ba040630b55d0c4ae33c.zip
add term search for climbs
-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)