Mercurial > gemma
diff pkg/controllers/surveys.go @ 1572:056a86b24be2
Made bottleneck primary key an int. Attention: This may break something!
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Wed, 12 Dec 2018 19:21:02 +0100 |
| parents | 447db2bce052 |
| children | 8f6345ad5f13 |
line wrap: on
line diff
--- a/pkg/controllers/surveys.go Wed Dec 12 17:21:11 2018 +0100 +++ b/pkg/controllers/surveys.go Wed Dec 12 19:21:02 2018 +0100 @@ -23,10 +23,13 @@ ) const ( - listSurveysSQL = `SELECT s.bottleneck_id, - s.date_info::text -FROM waterway.bottlenecks b, waterway.sounding_results s -WHERE b.objnam=$1 AND s.bottleneck_id = b.bottleneck_id;` + listSurveysSQL = ` +SELECT + s.bottleneck_id, + s.date_info::text +FROM waterway.bottlenecks b JOIN waterway.sounding_results s +ON b.id = s.bottleneck_id +WHERE b.objnam=$1` ) func listSurveys(