# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1536595673 -7200
# Node ID 99cd44f19e86b199547b641915f651fcfc8d9922
# Parent  d127856e689d1d0ba0f64bac63f8ccb5826bbd56
Sounding results: Fetch bottleneck_id from bottleneck table by objnam.

diff -r d127856e689d -r 99cd44f19e86 cmd/soundingresults/main.go
--- a/cmd/soundingresults/main.go	Mon Sep 10 17:48:56 2018 +0200
+++ b/cmd/soundingresults/main.go	Mon Sep 10 18:07:53 2018 +0200
@@ -219,7 +219,9 @@
 				fmt.Fprintln(out, "  depth_reference,")
 				fmt.Fprintln(out, "  point_cloud")
 				fmt.Fprintln(out, ") VALUES (")
-				fmt.Fprintf(out, "  %s,\n", quote(r.m.name))
+				fmt.Fprintf(out,
+					"  (SELECT bottleneck_id from waterway.bottlenecks where objnam = %s),\n",
+					quote(r.m.name))
 				fmt.Fprintf(out, "  '%s'::date,\n", r.m.date.Format("2006-01-02"))
 				fmt.Fprintf(out, "  %s,\n", quote(r.m.depthReference))
 				fmt.Fprintf(out, "  '")