always reset auto-increment in tests

jmhodges · jmhodges · commit d3a7269ee149 · 2016-01-26T14:01:04.000-08:00
Fixes letsencrypt#1431 which unblocks the test failures in CI.
diff --git a/test/db.go b/test/db.go
@@ -70,7 +70,11 @@ func deleteEverythingInAllTables(db CleanUpDB) error {
 		// rejecting the DELETE for not having a WHERE clause.
 		_, err := db.Exec("delete from `" + tn + "` where 1 = 1")
 		if err != nil {
-			return err
+			return fmt.Errorf("unable to delete all rows from table %#v: %s", tn, err)
+		}
+		_, err = db.Exec("alter table `" + tn + "` AUTO_INCREMENT = 1")
+		if err != nil {
+			return fmt.Errorf("unable to reset autoincrement on table %#v: %s", tn, err)
 		}
 	}
 	return err

Original file line number	Diff line number	Diff line change
`@@ -70,7 +70,11 @@ func deleteEverythingInAllTables(db CleanUpDB) error {`
`70`	`70`	`// rejecting the DELETE for not having a WHERE clause.`
`71`	`71`	_, err := db.Exec("delete from `" + tn + "` where 1 = 1")
`72`	`72`	`if err != nil {`
`73`		`- return err`
	`73`	`+ return fmt.Errorf("unable to delete all rows from table %#v: %s", tn, err)`
	`74`	`+ }`
	`75`	+ _, err = db.Exec("alter table `" + tn + "` AUTO_INCREMENT = 1")
	`76`	`+ if err != nil {`
	`77`	`+ return fmt.Errorf("unable to reset autoincrement on table %#v: %s", tn, err)`
`74`	`78`	`}`
`75`	`79`	`}`
`76`	`80`	`return err`