/
list_sql_plan_baselines_request_response.go
352 lines (292 loc) · 17.5 KB
/
list_sql_plan_baselines_request_response.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
// Copyright (c) 2016, 2018, 2024, Oracle and/or its affiliates. All rights reserved.
// This software is dual-licensed to you under the Universal Permissive License (UPL) 1.0 as shown at https://oss.oracle.com/licenses/upl or Apache License 2.0 as shown at http://www.apache.org/licenses/LICENSE-2.0. You may choose either license.
// Code generated. DO NOT EDIT.
package databasemanagement
import (
"fmt"
"github.com/oracle/oci-go-sdk/v65/common"
"net/http"
"strings"
)
// ListSqlPlanBaselinesRequest wrapper for the ListSqlPlanBaselines operation
//
// # See also
//
// Click https://docs.cloud.oracle.com/en-us/iaas/tools/go-sdk-examples/latest/databasemanagement/ListSqlPlanBaselines.go.html to see an example of how to use ListSqlPlanBaselinesRequest.
type ListSqlPlanBaselinesRequest struct {
// The OCID (https://docs.cloud.oracle.com/Content/General/Concepts/identifiers.htm) of the Managed Database.
ManagedDatabaseId *string `mandatory:"true" contributesTo:"path" name:"managedDatabaseId"`
// A filter to return only SQL plan baselines that match the plan name.
PlanName *string `mandatory:"false" contributesTo:"query" name:"planName"`
// A filter to return all the SQL plan baselines for the specified SQL handle.
SqlHandle *string `mandatory:"false" contributesTo:"query" name:"sqlHandle"`
// A filter to return all the SQL plan baselines that match the SQL text. By default, the search
// is case insensitive. To run an exact or case-sensitive search, double-quote the search string.
// You may also use the '%' symbol as a wildcard.
SqlText *string `mandatory:"false" contributesTo:"query" name:"sqlText"`
// A filter to return only SQL plan baselines that are either enabled or not enabled.
// By default, all SQL plan baselines are returned.
IsEnabled *bool `mandatory:"false" contributesTo:"query" name:"isEnabled"`
// A filter to return only SQL plan baselines that are either accepted or not accepted.
// By default, all SQL plan baselines are returned.
IsAccepted *bool `mandatory:"false" contributesTo:"query" name:"isAccepted"`
// A filter to return only SQL plan baselines that were either reproduced or
// not reproduced by the optimizer. By default, all SQL plan baselines are returned.
IsReproduced *bool `mandatory:"false" contributesTo:"query" name:"isReproduced"`
// A filter to return only SQL plan baselines that are either fixed or not fixed.
// By default, all SQL plan baselines are returned.
IsFixed *bool `mandatory:"false" contributesTo:"query" name:"isFixed"`
// A filter to return only SQL plan baselines that are either adaptive or not adaptive.
// By default, all SQL plan baselines are returned.
IsAdaptive *bool `mandatory:"false" contributesTo:"query" name:"isAdaptive"`
// A filter to return all the SQL plan baselines that match the origin.
Origin ListSqlPlanBaselinesOriginEnum `mandatory:"false" contributesTo:"query" name:"origin" omitEmpty:"true"`
// The page token representing the page from where the next set of paginated results
// are retrieved. This is usually retrieved from a previous list call.
Page *string `mandatory:"false" contributesTo:"query" name:"page"`
// The maximum number of records returned in the paginated response.
Limit *int `mandatory:"false" contributesTo:"query" name:"limit"`
// The option to sort the SQL plan baseline summary data.
SortBy ListSqlPlanBaselinesSortByEnum `mandatory:"false" contributesTo:"query" name:"sortBy" omitEmpty:"true"`
// The option to sort information in ascending (‘ASC’) or descending (‘DESC’) order. Descending order is the default order.
SortOrder ListSqlPlanBaselinesSortOrderEnum `mandatory:"false" contributesTo:"query" name:"sortOrder" omitEmpty:"true"`
// A filter to return only SQL plan baselines that are either auto-purged or not auto-purged.
// By default, all SQL plan baselines are returned.
IsAutoPurged *bool `mandatory:"false" contributesTo:"query" name:"isAutoPurged"`
// A filter to return only SQL plan baselines whose last execution time is
// after the specified value. By default, all SQL plan baselines are returned.
TimeLastExecutedGreaterThan *common.SDKTime `mandatory:"false" contributesTo:"query" name:"timeLastExecutedGreaterThan"`
// A filter to return only SQL plan baselines whose last execution time is
// before the specified value. By default, all SQL plan baselines are returned.
TimeLastExecutedLessThan *common.SDKTime `mandatory:"false" contributesTo:"query" name:"timeLastExecutedLessThan"`
// A filter to return only SQL plan baselines that are not executed till now.
// By default, all SQL plan baselines are returned.
IsNeverExecuted *bool `mandatory:"false" contributesTo:"query" name:"isNeverExecuted"`
// The client request ID for tracing.
OpcRequestId *string `mandatory:"false" contributesTo:"header" name:"opc-request-id"`
// The OCID of the Named Credential.
OpcNamedCredentialId *string `mandatory:"false" contributesTo:"header" name:"opc-named-credential-id"`
// Metadata about the request. This information will not be transmitted to the service, but
// represents information that the SDK will consume to drive retry behavior.
RequestMetadata common.RequestMetadata
}
func (request ListSqlPlanBaselinesRequest) String() string {
return common.PointerString(request)
}
// HTTPRequest implements the OCIRequest interface
func (request ListSqlPlanBaselinesRequest) HTTPRequest(method, path string, binaryRequestBody *common.OCIReadSeekCloser, extraHeaders map[string]string) (http.Request, error) {
_, err := request.ValidateEnumValue()
if err != nil {
return http.Request{}, err
}
return common.MakeDefaultHTTPRequestWithTaggedStructAndExtraHeaders(method, path, request, extraHeaders)
}
// BinaryRequestBody implements the OCIRequest interface
func (request ListSqlPlanBaselinesRequest) BinaryRequestBody() (*common.OCIReadSeekCloser, bool) {
return nil, false
}
// RetryPolicy implements the OCIRetryableRequest interface. This retrieves the specified retry policy.
func (request ListSqlPlanBaselinesRequest) RetryPolicy() *common.RetryPolicy {
return request.RequestMetadata.RetryPolicy
}
// ValidateEnumValue returns an error when providing an unsupported enum value
// This function is being called during constructing API request process
// Not recommended for calling this function directly
func (request ListSqlPlanBaselinesRequest) ValidateEnumValue() (bool, error) {
errMessage := []string{}
if _, ok := GetMappingListSqlPlanBaselinesOriginEnum(string(request.Origin)); !ok && request.Origin != "" {
errMessage = append(errMessage, fmt.Sprintf("unsupported enum value for Origin: %s. Supported values are: %s.", request.Origin, strings.Join(GetListSqlPlanBaselinesOriginEnumStringValues(), ",")))
}
if _, ok := GetMappingListSqlPlanBaselinesSortByEnum(string(request.SortBy)); !ok && request.SortBy != "" {
errMessage = append(errMessage, fmt.Sprintf("unsupported enum value for SortBy: %s. Supported values are: %s.", request.SortBy, strings.Join(GetListSqlPlanBaselinesSortByEnumStringValues(), ",")))
}
if _, ok := GetMappingListSqlPlanBaselinesSortOrderEnum(string(request.SortOrder)); !ok && request.SortOrder != "" {
errMessage = append(errMessage, fmt.Sprintf("unsupported enum value for SortOrder: %s. Supported values are: %s.", request.SortOrder, strings.Join(GetListSqlPlanBaselinesSortOrderEnumStringValues(), ",")))
}
if len(errMessage) > 0 {
return true, fmt.Errorf(strings.Join(errMessage, "\n"))
}
return false, nil
}
// ListSqlPlanBaselinesResponse wrapper for the ListSqlPlanBaselines operation
type ListSqlPlanBaselinesResponse struct {
// The underlying http response
RawResponse *http.Response
// A list of SqlPlanBaselineCollection instances
SqlPlanBaselineCollection `presentIn:"body"`
// Unique Oracle-assigned identifier for the request. If you need to contact
// Oracle about a particular request, please provide the request ID.
OpcRequestId *string `presentIn:"header" name:"opc-request-id"`
// For pagination of a list of items. When paging through a list, if this header appears in the response,
// then a partial list might have been returned. Include this value as the `page` parameter for the
// subsequent GET request to get the next batch of items.
OpcNextPage *string `presentIn:"header" name:"opc-next-page"`
}
func (response ListSqlPlanBaselinesResponse) String() string {
return common.PointerString(response)
}
// HTTPResponse implements the OCIResponse interface
func (response ListSqlPlanBaselinesResponse) HTTPResponse() *http.Response {
return response.RawResponse
}
// ListSqlPlanBaselinesOriginEnum Enum with underlying type: string
type ListSqlPlanBaselinesOriginEnum string
// Set of constants representing the allowable values for ListSqlPlanBaselinesOriginEnum
const (
ListSqlPlanBaselinesOriginAddmSqltune ListSqlPlanBaselinesOriginEnum = "ADDM_SQLTUNE"
ListSqlPlanBaselinesOriginAutoCapture ListSqlPlanBaselinesOriginEnum = "AUTO_CAPTURE"
ListSqlPlanBaselinesOriginAutoSqltune ListSqlPlanBaselinesOriginEnum = "AUTO_SQLTUNE"
ListSqlPlanBaselinesOriginEvolveAutoIndexLoad ListSqlPlanBaselinesOriginEnum = "EVOLVE_AUTO_INDEX_LOAD"
ListSqlPlanBaselinesOriginEvolveCreateFromAdaptive ListSqlPlanBaselinesOriginEnum = "EVOLVE_CREATE_FROM_ADAPTIVE"
ListSqlPlanBaselinesOriginEvolveLoadFromSts ListSqlPlanBaselinesOriginEnum = "EVOLVE_LOAD_FROM_STS"
ListSqlPlanBaselinesOriginEvolveLoadFromAwr ListSqlPlanBaselinesOriginEnum = "EVOLVE_LOAD_FROM_AWR"
ListSqlPlanBaselinesOriginEvolveLoadFromCursorCache ListSqlPlanBaselinesOriginEnum = "EVOLVE_LOAD_FROM_CURSOR_CACHE"
ListSqlPlanBaselinesOriginManualLoad ListSqlPlanBaselinesOriginEnum = "MANUAL_LOAD"
ListSqlPlanBaselinesOriginManualLoadFromAwr ListSqlPlanBaselinesOriginEnum = "MANUAL_LOAD_FROM_AWR"
ListSqlPlanBaselinesOriginManualLoadFromCursorCache ListSqlPlanBaselinesOriginEnum = "MANUAL_LOAD_FROM_CURSOR_CACHE"
ListSqlPlanBaselinesOriginManualLoadFromSts ListSqlPlanBaselinesOriginEnum = "MANUAL_LOAD_FROM_STS"
ListSqlPlanBaselinesOriginManualSqltune ListSqlPlanBaselinesOriginEnum = "MANUAL_SQLTUNE"
ListSqlPlanBaselinesOriginStoredOutline ListSqlPlanBaselinesOriginEnum = "STORED_OUTLINE"
ListSqlPlanBaselinesOriginUnknown ListSqlPlanBaselinesOriginEnum = "UNKNOWN"
)
var mappingListSqlPlanBaselinesOriginEnum = map[string]ListSqlPlanBaselinesOriginEnum{
"ADDM_SQLTUNE": ListSqlPlanBaselinesOriginAddmSqltune,
"AUTO_CAPTURE": ListSqlPlanBaselinesOriginAutoCapture,
"AUTO_SQLTUNE": ListSqlPlanBaselinesOriginAutoSqltune,
"EVOLVE_AUTO_INDEX_LOAD": ListSqlPlanBaselinesOriginEvolveAutoIndexLoad,
"EVOLVE_CREATE_FROM_ADAPTIVE": ListSqlPlanBaselinesOriginEvolveCreateFromAdaptive,
"EVOLVE_LOAD_FROM_STS": ListSqlPlanBaselinesOriginEvolveLoadFromSts,
"EVOLVE_LOAD_FROM_AWR": ListSqlPlanBaselinesOriginEvolveLoadFromAwr,
"EVOLVE_LOAD_FROM_CURSOR_CACHE": ListSqlPlanBaselinesOriginEvolveLoadFromCursorCache,
"MANUAL_LOAD": ListSqlPlanBaselinesOriginManualLoad,
"MANUAL_LOAD_FROM_AWR": ListSqlPlanBaselinesOriginManualLoadFromAwr,
"MANUAL_LOAD_FROM_CURSOR_CACHE": ListSqlPlanBaselinesOriginManualLoadFromCursorCache,
"MANUAL_LOAD_FROM_STS": ListSqlPlanBaselinesOriginManualLoadFromSts,
"MANUAL_SQLTUNE": ListSqlPlanBaselinesOriginManualSqltune,
"STORED_OUTLINE": ListSqlPlanBaselinesOriginStoredOutline,
"UNKNOWN": ListSqlPlanBaselinesOriginUnknown,
}
var mappingListSqlPlanBaselinesOriginEnumLowerCase = map[string]ListSqlPlanBaselinesOriginEnum{
"addm_sqltune": ListSqlPlanBaselinesOriginAddmSqltune,
"auto_capture": ListSqlPlanBaselinesOriginAutoCapture,
"auto_sqltune": ListSqlPlanBaselinesOriginAutoSqltune,
"evolve_auto_index_load": ListSqlPlanBaselinesOriginEvolveAutoIndexLoad,
"evolve_create_from_adaptive": ListSqlPlanBaselinesOriginEvolveCreateFromAdaptive,
"evolve_load_from_sts": ListSqlPlanBaselinesOriginEvolveLoadFromSts,
"evolve_load_from_awr": ListSqlPlanBaselinesOriginEvolveLoadFromAwr,
"evolve_load_from_cursor_cache": ListSqlPlanBaselinesOriginEvolveLoadFromCursorCache,
"manual_load": ListSqlPlanBaselinesOriginManualLoad,
"manual_load_from_awr": ListSqlPlanBaselinesOriginManualLoadFromAwr,
"manual_load_from_cursor_cache": ListSqlPlanBaselinesOriginManualLoadFromCursorCache,
"manual_load_from_sts": ListSqlPlanBaselinesOriginManualLoadFromSts,
"manual_sqltune": ListSqlPlanBaselinesOriginManualSqltune,
"stored_outline": ListSqlPlanBaselinesOriginStoredOutline,
"unknown": ListSqlPlanBaselinesOriginUnknown,
}
// GetListSqlPlanBaselinesOriginEnumValues Enumerates the set of values for ListSqlPlanBaselinesOriginEnum
func GetListSqlPlanBaselinesOriginEnumValues() []ListSqlPlanBaselinesOriginEnum {
values := make([]ListSqlPlanBaselinesOriginEnum, 0)
for _, v := range mappingListSqlPlanBaselinesOriginEnum {
values = append(values, v)
}
return values
}
// GetListSqlPlanBaselinesOriginEnumStringValues Enumerates the set of values in String for ListSqlPlanBaselinesOriginEnum
func GetListSqlPlanBaselinesOriginEnumStringValues() []string {
return []string{
"ADDM_SQLTUNE",
"AUTO_CAPTURE",
"AUTO_SQLTUNE",
"EVOLVE_AUTO_INDEX_LOAD",
"EVOLVE_CREATE_FROM_ADAPTIVE",
"EVOLVE_LOAD_FROM_STS",
"EVOLVE_LOAD_FROM_AWR",
"EVOLVE_LOAD_FROM_CURSOR_CACHE",
"MANUAL_LOAD",
"MANUAL_LOAD_FROM_AWR",
"MANUAL_LOAD_FROM_CURSOR_CACHE",
"MANUAL_LOAD_FROM_STS",
"MANUAL_SQLTUNE",
"STORED_OUTLINE",
"UNKNOWN",
}
}
// GetMappingListSqlPlanBaselinesOriginEnum performs case Insensitive comparison on enum value and return the desired enum
func GetMappingListSqlPlanBaselinesOriginEnum(val string) (ListSqlPlanBaselinesOriginEnum, bool) {
enum, ok := mappingListSqlPlanBaselinesOriginEnumLowerCase[strings.ToLower(val)]
return enum, ok
}
// ListSqlPlanBaselinesSortByEnum Enum with underlying type: string
type ListSqlPlanBaselinesSortByEnum string
// Set of constants representing the allowable values for ListSqlPlanBaselinesSortByEnum
const (
ListSqlPlanBaselinesSortByTimecreated ListSqlPlanBaselinesSortByEnum = "timeCreated"
ListSqlPlanBaselinesSortByTimelastmodified ListSqlPlanBaselinesSortByEnum = "timeLastModified"
ListSqlPlanBaselinesSortByTimelastexecuted ListSqlPlanBaselinesSortByEnum = "timeLastExecuted"
)
var mappingListSqlPlanBaselinesSortByEnum = map[string]ListSqlPlanBaselinesSortByEnum{
"timeCreated": ListSqlPlanBaselinesSortByTimecreated,
"timeLastModified": ListSqlPlanBaselinesSortByTimelastmodified,
"timeLastExecuted": ListSqlPlanBaselinesSortByTimelastexecuted,
}
var mappingListSqlPlanBaselinesSortByEnumLowerCase = map[string]ListSqlPlanBaselinesSortByEnum{
"timecreated": ListSqlPlanBaselinesSortByTimecreated,
"timelastmodified": ListSqlPlanBaselinesSortByTimelastmodified,
"timelastexecuted": ListSqlPlanBaselinesSortByTimelastexecuted,
}
// GetListSqlPlanBaselinesSortByEnumValues Enumerates the set of values for ListSqlPlanBaselinesSortByEnum
func GetListSqlPlanBaselinesSortByEnumValues() []ListSqlPlanBaselinesSortByEnum {
values := make([]ListSqlPlanBaselinesSortByEnum, 0)
for _, v := range mappingListSqlPlanBaselinesSortByEnum {
values = append(values, v)
}
return values
}
// GetListSqlPlanBaselinesSortByEnumStringValues Enumerates the set of values in String for ListSqlPlanBaselinesSortByEnum
func GetListSqlPlanBaselinesSortByEnumStringValues() []string {
return []string{
"timeCreated",
"timeLastModified",
"timeLastExecuted",
}
}
// GetMappingListSqlPlanBaselinesSortByEnum performs case Insensitive comparison on enum value and return the desired enum
func GetMappingListSqlPlanBaselinesSortByEnum(val string) (ListSqlPlanBaselinesSortByEnum, bool) {
enum, ok := mappingListSqlPlanBaselinesSortByEnumLowerCase[strings.ToLower(val)]
return enum, ok
}
// ListSqlPlanBaselinesSortOrderEnum Enum with underlying type: string
type ListSqlPlanBaselinesSortOrderEnum string
// Set of constants representing the allowable values for ListSqlPlanBaselinesSortOrderEnum
const (
ListSqlPlanBaselinesSortOrderAsc ListSqlPlanBaselinesSortOrderEnum = "ASC"
ListSqlPlanBaselinesSortOrderDesc ListSqlPlanBaselinesSortOrderEnum = "DESC"
)
var mappingListSqlPlanBaselinesSortOrderEnum = map[string]ListSqlPlanBaselinesSortOrderEnum{
"ASC": ListSqlPlanBaselinesSortOrderAsc,
"DESC": ListSqlPlanBaselinesSortOrderDesc,
}
var mappingListSqlPlanBaselinesSortOrderEnumLowerCase = map[string]ListSqlPlanBaselinesSortOrderEnum{
"asc": ListSqlPlanBaselinesSortOrderAsc,
"desc": ListSqlPlanBaselinesSortOrderDesc,
}
// GetListSqlPlanBaselinesSortOrderEnumValues Enumerates the set of values for ListSqlPlanBaselinesSortOrderEnum
func GetListSqlPlanBaselinesSortOrderEnumValues() []ListSqlPlanBaselinesSortOrderEnum {
values := make([]ListSqlPlanBaselinesSortOrderEnum, 0)
for _, v := range mappingListSqlPlanBaselinesSortOrderEnum {
values = append(values, v)
}
return values
}
// GetListSqlPlanBaselinesSortOrderEnumStringValues Enumerates the set of values in String for ListSqlPlanBaselinesSortOrderEnum
func GetListSqlPlanBaselinesSortOrderEnumStringValues() []string {
return []string{
"ASC",
"DESC",
}
}
// GetMappingListSqlPlanBaselinesSortOrderEnum performs case Insensitive comparison on enum value and return the desired enum
func GetMappingListSqlPlanBaselinesSortOrderEnum(val string) (ListSqlPlanBaselinesSortOrderEnum, bool) {
enum, ok := mappingListSqlPlanBaselinesSortOrderEnumLowerCase[strings.ToLower(val)]
return enum, ok
}