changeset 2234:9b2f8e94671e

Gauge measurement import: Moved preparation of insert statement out of gauge iteration loop.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 13 Feb 2019 12:45:48 +0100
parents 137addc77b1b
children 39586a34979c 4ca41516115b
files pkg/imports/gm.go
diffstat 1 files changed, 6 insertions(+), 6 deletions(-) [+]
line wrap: on
line diff
--- 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())