Mercurial > gemma

changeset 744:6fe6839f5ce6

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Make search return an array of features, including name. This form should be sufficiently generic.
author Sascha Wilde <wilde@intevation.de>
date Mon, 24 Sep 2018 13:51:26 +0200
parents fdff2de616ad
children 97b0beecf7c3
files pkg/controllers/search.go
diffstat 1 files changed, 5 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/controllers/search.go	Mon Sep 24 13:26:57 2018 +0200
+++ b/pkg/controllers/search.go	Mon Sep 24 13:51:26 2018 +0200
@@ -12,8 +12,11 @@
 )
 
 const (
-	searchHectometreSQL = `SELECT ST_AsGeoJSON(geom) FROM waterway.distance_marks
-WHERE (location_code).hectometre = $1`
+	searchHectometreSQL = `SELECT json_agg(r)
+FROM (SELECT location_code::text AS name,
+             ST_AsGeoJSON(geom)::json AS geom
+      FROM waterway.distance_marks
+     WHERE (location_code).hectometre = $1) r`
 )
 
 var rkmRegex = regexp.MustCompile(