Function TestCreateSequenceStatement_ToSQL

pkg/sql/ast/ast_sequence_test.go:10–84

(t *testing.T)

)

func TestCreateSequenceStatement_ToSQL(t *testing.T) {
	tests := []struct {
		name string
		stmt *ast.CreateSequenceStatement
		want string
	}{
		{
			name: "minimal",
			stmt: &ast.CreateSequenceStatement{
				Name: &ast.Identifier{Name: "seq_orders"},
			},
			want: "CREATE SEQUENCE seq_orders",
		},
		{
			name: "or replace",
			stmt: &ast.CreateSequenceStatement{
				Name:      &ast.Identifier{Name: "seq_orders"},
				OrReplace: true,
			},
			want: "CREATE OR REPLACE SEQUENCE seq_orders",
		},
		{
			name: "if not exists",
			stmt: &ast.CreateSequenceStatement{
				Name:        &ast.Identifier{Name: "seq_orders"},
				IfNotExists: true,
			},
			want: "CREATE SEQUENCE IF NOT EXISTS seq_orders",
		},
		{
			name: "with options",
			stmt: &ast.CreateSequenceStatement{
				Name: &ast.Identifier{Name: "s"},
				Options: ast.SequenceOptions{
					StartWith:   &ast.LiteralValue{Value: "1"},
					IncrementBy: &ast.LiteralValue{Value: "1"},
					MinValue:    &ast.LiteralValue{Value: "1"},
					MaxValue:    &ast.LiteralValue{Value: "9999"},
					Cache:       &ast.LiteralValue{Value: "100"},
					CycleMode:   ast.CycleBehavior,
				},
			},
			want: "CREATE SEQUENCE s START WITH 1 INCREMENT BY 1 MINVALUE 1 MAXVALUE 9999 CACHE 100 CYCLE",
		},
		{
			name: "nocycle",
			stmt: &ast.CreateSequenceStatement{
				Name:    &ast.Identifier{Name: "s"},
				Options: ast.SequenceOptions{CycleMode: ast.NoCycleBehavior},
			},
			want: "CREATE SEQUENCE s NOCYCLE",
		},
		{
			name: "nocache",
			stmt: &ast.CreateSequenceStatement{
				Name:    &ast.Identifier{Name: "s"},
				Options: ast.SequenceOptions{NoCache: true},
			},