Mercurial > gemma

comparison pkg/controllers/search.go @ 3584:7b15a6dd4ae5

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
search: replace commata via SQL
author Thomas Junk <thomas.junk@intevation.de>
date Tue, 04 Jun 2019 09:50:24 +0200
parents 571801483a70
children 02951a62e8c6
comparison
equal deleted inserted replaced
3583:391afcc961a2 3584:7b15a6dd4ae5
25 ) 25 )
26 26
27 const ( 27 const (
28 searchHectometreSQL = `SELECT COALESCE(json_agg(r),'[]') 28 searchHectometreSQL = `SELECT COALESCE(json_agg(r),'[]')
29 FROM (SELECT (location_code).hectometre || ' rhm' AS name, 29 FROM (SELECT (location_code).hectometre || ' rhm' AS name,
30 concat(location_code) AS locationcode, 30 replace(concat(location_code), ',','') AS locationcode,
31 ST_AsGeoJSON(geom)::json AS geom, 'rhm' AS type 31 ST_AsGeoJSON(geom)::json AS geom, 'rhm' AS type
32 FROM waterway.distance_marks_virtual 32 FROM waterway.distance_marks_virtual
33 WHERE (location_code).hectometre = $1) r` 33 WHERE (location_code).hectometre = $1) r`
34 34
35 searchMostSQL = `SELECT search_most($1)::text` 35 searchMostSQL = `SELECT search_most($1)::text`