| 675 | const TABLENAME = "insert_table0" |
| 676 | |
| 677 | func prepareBenchTable(db *sql.DB) { |
| 678 | _, err := db.Exec("DROP TABLE IF EXISTS " + TABLENAME + ";") |
| 679 | So(err, ShouldBeNil) |
| 680 | |
| 681 | _, err = db.Exec(`CREATE TABLE ` + TABLENAME + ` ("k" INT, "v1" TEXT, PRIMARY KEY("k"))`) |
| 682 | So(err, ShouldBeNil) |
| 683 | |
| 684 | _, err = db.Exec("REPLACE INTO "+TABLENAME+" VALUES(?, ?)", ROWSTART-1, "test") |
| 685 | So(err, ShouldBeNil) |
| 686 | } |
| 687 | |
| 688 | func cleanBenchTable(db *sql.DB) { |
| 689 | _, err := db.Exec("DELETE FROM "+TABLENAME+" WHERE k >= ?", ROWSTART) |