Function TestUpdate

pkg/sql/ast/dml_test.go:299–394

Test Update node (DML)

(t *testing.T)

// Test Update node (DML)
func TestUpdate(t *testing.T) {
	tests := []struct {
		name        string
		upd         *Update
		wantLiteral string
		minChildren int
	}{
		{
			name: "simple UPDATE",
			upd: &Update{
				Table: TableReference{Name: "users"},
				Updates: []UpdateExpression{
					{
						Column: &Identifier{Name: "email"},
						Value:  &LiteralValue{Value: "new@example.com"},
					},
				},
			},
			wantLiteral: "UPDATE",
			minChildren: 2,
		},
		{
			name: "UPDATE with multiple columns",
			upd: &Update{
				Table: TableReference{Name: "users"},
				Updates: []UpdateExpression{
					{
						Column: &Identifier{Name: "name"},
						Value:  &LiteralValue{Value: "John"},
					},
					{
						Column: &Identifier{Name: "age"},
						Value:  &LiteralValue{Value: "30"},
					},
				},
			},
			wantLiteral: "UPDATE",
			minChildren: 3,
		},
		{
			name: "UPDATE with WHERE",
			upd: &Update{
				Table: TableReference{Name: "users"},
				Updates: []UpdateExpression{
					{
						Column: &Identifier{Name: "status"},
						Value:  &LiteralValue{Value: "inactive"},
					},
				},
				Where: &BinaryExpression{
					Left:     &Identifier{Name: "id"},
					Operator: "=",
					Right:    &LiteralValue{Value: "10"},
				},
			},
			wantLiteral: "UPDATE",
			minChildren: 3,
		},