| 156 | } |
| 157 | |
| 158 | func TestUpdateStatementSQL(t *testing.T) { |
| 159 | stmt := &UpdateStatement{ |
| 160 | TableName: "users", |
| 161 | Assignments: []UpdateExpression{{Column: &Identifier{Name: "name"}, Value: &LiteralValue{Value: "Bob", Type: "STRING"}}}, |
| 162 | Where: &BinaryExpression{Left: &Identifier{Name: "id"}, Operator: "=", Right: &LiteralValue{Value: 1, Type: "INTEGER"}}, |
| 163 | } |
| 164 | want := "UPDATE users SET name = 'Bob' WHERE id = 1" |
| 165 | if got := stmt.SQL(); got != want { |
| 166 | t.Errorf("SQL() = %s, want %s", got, want) |
| 167 | } |
| 168 | } |
| 169 | |
| 170 | func TestDeleteStatementSQL(t *testing.T) { |
| 171 | stmt := &DeleteStatement{ |