diff options
| author | Daniel Schadt <kingdread@gmx.de> | 2026-11-12 19:32:17 +0100 |
|---|---|---|
| committer | Daniel Schadt <kingdread@gmx.de> | 2026-11-12 19:32:17 +0100 |
| commit | 06c46db90149fd1afd39ba040630b55d0c4ae33c (patch) | |
| tree | e473ce74d02af5ff43f561966369ee838434aab9 | |
| parent | ccb66ca8a6356b1472a08a001106bec29205d030 (diff) | |
| download | fietsboek-06c46db90149fd1afd39ba040630b55d0c4ae33c.tar.gz fietsboek-06c46db90149fd1afd39ba040630b55d0c4ae33c.tar.bz2 fietsboek-06c46db90149fd1afd39ba040630b55d0c4ae33c.zip | |
add term search for climbs
| -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) |
