func Test_LoadFixture(t *testing.T) {
TruncateTable("test_1")
myT := new(assert.Tspy)
LoadFixture(myT, "/not/existing/fixture")
if !myT.Failed() {
t.Fatalf("Expected error loading not existing fixture")
}
myT = new(assert.Tspy)
LoadFixture(myT, "fixtures/fixture.sql")
if myT.Failed() {
t.Fatalf("Did not expect any error: %s", myT.GetMsg(0))
}
rows, res, err := dbcon.Query("SELECT * FROM test_1 ORDER BY Field ASC")
if err != nil {
t.Fatal("Did not expect error: " + err.Error())
}
if len(rows) != 3 {
t.Fatal("Expected three rows in the database.")
}
for idx, row := range rows {
if idx != row.Int(res.Map("Field")) {
t.Fatalf("Expected row %d Field to be equal to %d", idx, row.Int(res.Map("Field")))
}
}
}
