Mercurial > gemma
diff pkg/models/surveys.go @ 2149:ed0ee54fc49e
Extend /surveys endpoint to include waterlevel_value
* Change SQL to use the same strategy as used in schema/gemma.sql
for bottlenecks_geoserver to determine the waterlevel_value.
* Extend go controler to deal with the situation where the value is not
there. This is still suboptimal as this creates a json object for
the NullInt64 value.
| author | Bernhard Reiter <bernhard@intevation.de> |
|---|---|
| date | Fri, 08 Feb 2019 11:26:05 +0100 |
| parents | 7267f8168176 |
| children | 8132434f4093 |
line wrap: on
line diff
--- a/pkg/models/surveys.go Fri Feb 08 11:03:12 2019 +0100 +++ b/pkg/models/surveys.go Fri Feb 08 11:26:05 2019 +0100 @@ -13,11 +13,16 @@ package models +import ( + "database/sql" +) + type ( Survey struct { - BottleneckID string `json:"bottleneck_id"` - DateInfo string `json:"date_info"` - DepthReference string `json:"depth_reference"` - ReferenceGauge string `json:"gauge_objname"` + BottleneckID string `json:"bottleneck_id"` + DateInfo string `json:"date_info"` + DepthReference string `json:"depth_reference"` + ReferenceGauge string `json:"gauge_objname"` + WaterLevelValue sql.NullInt64 `json:"waterlevel_value"` } )