Mercurial > gemma
comparison pkg/controllers/surveys.go @ 2146:7267f8168176
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) |