Function TestAlterSequenceStatement_ToSQL

pkg/sql/ast/ast_sequence_test.go:118–156

(t *testing.T)

}

func TestAlterSequenceStatement_ToSQL(t *testing.T) {
	tests := []struct {
		name string
		stmt *ast.AlterSequenceStatement
		want string
	}{
		{
			name: "restart bare",
			stmt: &ast.AlterSequenceStatement{
				Name:    &ast.Identifier{Name: "s"},
				Options: ast.SequenceOptions{Restart: true},
			},
			want: "ALTER SEQUENCE s RESTART",
		},
		{
			name: "restart with value",
			stmt: &ast.AlterSequenceStatement{
				Name: &ast.Identifier{Name: "s"},
				Options: ast.SequenceOptions{
					RestartWith: &ast.LiteralValue{Value: "1"},
				},
			},
			want: "ALTER SEQUENCE s RESTART WITH 1",
		},
		{
			name: "nil name does not panic",
			stmt: &ast.AlterSequenceStatement{},
			want: "ALTER SEQUENCE ",
		},
	}
	for _, tt := range tests {
		t.Run(tt.name, func(t *testing.T) {
			got := tt.stmt.ToSQL()
			if got != tt.want {
				t.Errorf("ToSQL() = %q, want %q", got, tt.want)
			}
		})
	}
}

func TestSequencePool_RoundTrip(t *testing.T) {
	s := ast.NewCreateSequenceStatement()