# HG changeset patch
# User Sascha L. Teichmann <sascha.teichmann@intevation.de>
# Date 1550058348 -3600
# Node ID 9b2f8e94671e7660eb094e3c5aff44da677840b9
# Parent  137addc77b1b3bf23347025a8f338f7be99ad97d
Gauge measurement import: Moved preparation of insert statement out of gauge iteration loop.

diff -r 137addc77b1b -r 9b2f8e94671e pkg/imports/gm.go
--- a/pkg/imports/gm.go	Wed Feb 13 12:39:56 2019 +0100
+++ b/pkg/imports/gm.go	Wed Feb 13 12:45:48 2019 +0100
@@ -256,6 +256,12 @@
 
 	mt := nts.Message_type_typeWRM
 
+	insertStmt, err := tx.PrepareContext(ctx, insertGMSQL)
+	if err != nil {
+		return nil, err
+	}
+	defer insertStmt.Close()
+
 	var gids []string
 	for _, g := range gauges {
 
@@ -289,12 +295,6 @@
 		}
 		result := resp.Result_message
 
-		insertStmt, err := tx.PrepareContext(ctx, insertGMSQL)
-		if err != nil {
-			return nil, err
-		}
-		defer insertStmt.Close()
-
 		for _, msg := range result {
 			var gid int64
 			feedback.Info("Found measurements for %s", g.location.String())