- found_expected := false
- for i := range EXPECTED_UPDATE_ERRORS {
- if err.Error()[0:10] == EXPECTED_UPDATE_ERRORS[i] {
- found_expected = true
- break
+ lib.Logger.Println("- expected error so not running statement")
+ }
+ } else {
+ lib.Logger.Println("Prepare succeeded, trying to update", len(si.rows), "row(s)")
+ count = 0
+ for i := range si.rows {
+ lib.Logger.Println("- changing row:", si.rows[i].NAME)
+ lib.Logger.Println("stmt.Exec", "YES", "YES", si.rows[i].NAME)
+ if res, err := stmt.Exec("YES", "YES", si.rows[i].NAME); err == nil {
+ lib.Logger.Println("update succeeded")
+ si.update_succeeded = true
+ c, _ := res.RowsAffected()
+ count += int(c)
+ } else {
+ si.update_succeeded = false
+ if error_in_expected_list(err.Error(), EXPECTED_UPDATE_ERRORS) {
+ lib.Logger.Println("Insufficient privileges to UPDATE setup_instruments: " + err.Error())
+ lib.Logger.Println("Not attempting further updates")
+ return
+ } else {
+ log.Fatal(err)