| 83 | } |
| 84 | |
| 85 | func TestLoad(t *testing.T) { |
| 86 | stool := newStool() |
| 87 | db := &DBStub{} |
| 88 | //db, builder := squirrelFixture() |
| 89 | |
| 90 | r := New(db, "mysql").Bind("test_table", stool) |
| 91 | |
| 92 | if err := r.Load(); err != nil { |
| 93 | t.Errorf("Error running query: %s", err) |
| 94 | } |
| 95 | |
| 96 | expect := "SELECT number_of_legs, material, color FROM test_table WHERE id = ? AND id_two = ?" |
| 97 | if db.LastQueryRowSql != expect { |
| 98 | t.Errorf("Unexpected SQL: %s", db.LastQueryRowSql) |
| 99 | } |
| 100 | |
| 101 | expectargs := []interface{}{1, 2} |
| 102 | got := db.LastQueryRowArgs |
| 103 | for i, exp := range expectargs { |
| 104 | if exp != got[i] { |
| 105 | t.Errorf("Surprise! %v doesn't equal %v", exp, got[i]) |
| 106 | } |
| 107 | } |
| 108 | } |
| 109 | |
| 110 | func TestLoadWhere(t *testing.T) { |
| 111 | stool := newStool() |