Function TestInsert

pkg/sql/ast/dml_test.go:134–220

Test Insert node (DML)

(t *testing.T)

// Test Insert node (DML)
func TestInsert(t *testing.T) {
	tests := []struct {
		name        string
		ins         *Insert
		wantLiteral string
		minChildren int
	}{
		{
			name: "simple INSERT with values",
			ins: &Insert{
				Table: TableReference{Name: "users"},
				Columns: []Expression{
					&Identifier{Name: "name"},
					&Identifier{Name: "email"},
				},
				Values: [][]Expression{
					{
						&LiteralValue{Value: "John"},
						&LiteralValue{Value: "john@example.com"},
					},
				},
			},
			wantLiteral: "INSERT",
			minChildren: 5,
		},
		{
			name: "INSERT with multiple rows",
			ins: &Insert{
				Table: TableReference{Name: "products"},
				Columns: []Expression{
					&Identifier{Name: "name"},
					&Identifier{Name: "price"},
				},
				Values: [][]Expression{
					{
						&LiteralValue{Value: "Widget"},
						&LiteralValue{Value: "9.99"},
					},
					{
						&LiteralValue{Value: "Gadget"},
						&LiteralValue{Value: "19.99"},
					},
				},
			},
			wantLiteral: "INSERT",
			minChildren: 7,
		},
		{
			name: "INSERT with RETURNING",
			ins: &Insert{
				Table: TableReference{Name: "users"},
				Columns: []Expression{
					&Identifier{Name: "name"},
				},
				Values: [][]Expression{
					{
						&LiteralValue{Value: "Jane"},
					},