# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1571153123 -7200
# Node ID e1cf039ea25a28b4bcadca800cd091a4866d19f1
# Parent  fa55e48bbca1403dff251dd57c38ea901cf5ffa0
Section deletion: return error if nothing deleted

If nothing is deleted on acceptance of such an import, it's probably
because row level security does not allow deletion of the entry.

diff -r fa55e48bbca1 -r e1cf039ea25a pkg/imports/dsec.go
--- a/pkg/imports/dsec.go	Tue Oct 15 17:16:36 2019 +0200
+++ b/pkg/imports/dsec.go	Tue Oct 15 17:25:23 2019 +0200
@@ -16,7 +16,9 @@
 import (
 	"context"
 	"database/sql"
+	"errors"
 	"fmt"
+	"log"
 )
 
 // DeleteSection is a Job to delete a section from the database.
@@ -65,7 +67,20 @@
 	tx *sql.Tx,
 	id int64,
 ) error {
-	_, err := tx.ExecContext(ctx, dsecStageDoneSQL, id)
+	res, err := tx.ExecContext(ctx, dsecStageDoneSQL, id)
+	if err != nil {
+		return err
+	}
+	n, err := res.RowsAffected()
+	if err != nil {
+		log.Println(
+			"error: RowsAffected returned an error. Missing driver support?")
+		return nil
+	}
+	if n == 0 {
+		return errors.New(
+			"Nothing deleted. Probably due to missing access rights.")
+	}
 	return err
 }