changeset 5128:7bd9c5161836

Handle deletion of non-existent sounding results gracefully
author Tom Gottfried <tom@intevation.de>
date Fri, 27 Mar 2020 12:20:48 +0100
parents 2dcfab23dc86
children 882b3d2308c4 a6e5bb85f0a7
files pkg/imports/dsr.go
diffstat 1 files changed, 7 insertions(+), 2 deletions(-) [+]
line wrap: on
line diff
--- a/pkg/imports/dsr.go	Fri Mar 27 10:33:39 2020 +0100
+++ b/pkg/imports/dsr.go	Fri Mar 27 12:20:48 2020 +0100
@@ -112,8 +112,13 @@
 		dsr.BottleneckID, dsr.Date.Time)
 
 	var id int64
-	if err := tx.QueryRowContext(ctx, dsrFindSQL,
-		dsr.BottleneckID, dsr.Date.Time).Scan(&id); err != nil {
+	switch err := tx.QueryRowContext(ctx, dsrFindSQL,
+		dsr.BottleneckID, dsr.Date.Time).Scan(&id); err {
+	case sql.ErrNoRows:
+		return nil, UnchangedError("Sounding result does not exist")
+	case nil:
+		// Continue
+	default:
 		return nil, err
 	}