Mercurial > gemma

comparison pkg/controllers/surveys.go @ 2146:7267f8168176

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Extending endpoint /surveys to return depth_reference * Extending the endpoint because the depth_reference is an attribute of the survey and could be different in principle between several surveys.
author Bernhard Reiter <bernhard@intevation.de>
date Thu, 07 Feb 2019 17:45:00 +0100
parents 8f6345ad5f13
children ed0ee54fc49e
comparison
equal deleted inserted replaced
2145:ba43b29e8694 2146:7267f8168176
26 const ( 26 const (
27 listSurveysSQL = ` 27 listSurveysSQL = `
28 SELECT 28 SELECT
29 s.bottleneck_id, 29 s.bottleneck_id,
30 s.date_info::text, 30 s.date_info::text,
31 s.depth_reference,
31 bg.objname AS gauge_objname 32 bg.objname AS gauge_objname
32 FROM 33 FROM
33 ( SELECT * FROM waterway.bottlenecks AS b, waterway.gauges AS g 34 ( SELECT * FROM waterway.bottlenecks AS b, waterway.gauges AS g
34 WHERE b.fk_g_fid = g.location 35 WHERE b.fk_g_fid = g.location
35 ) AS bg 36 ) AS bg
59 for rows.Next() { 60 for rows.Next() {
60 var survey models.Survey 61 var survey models.Survey
61 if err = rows.Scan( 62 if err = rows.Scan(
62 &survey.BottleneckID, 63 &survey.BottleneckID,
63 &survey.DateInfo, 64 &survey.DateInfo,
65 &survey.DepthReference,
64 &survey.ReferenceGauge, 66 &survey.ReferenceGauge,
65 ); err != nil { 67 ); err != nil {
66 return 68 return
67 } 69 }
68 surveys = append(surveys, survey) 70 surveys = append(surveys, survey)