-
Notifications
You must be signed in to change notification settings - Fork 80
/
load_sql_plan_baselines_from_awr_details.go
126 lines (99 loc) · 4.3 KB
/
load_sql_plan_baselines_from_awr_details.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
// 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.
// Database Management API
//
// Use the Database Management API to monitor and manage resources such as
// Oracle Databases, MySQL Databases, and External Database Systems.
// For more information, see Database Management (https://docs.cloud.oracle.com/iaas/database-management/home.htm).
//
package databasemanagement
import (
"encoding/json"
"fmt"
"github.com/oracle/oci-go-sdk/v65/common"
"strings"
)
// LoadSqlPlanBaselinesFromAwrDetails The details required to load plans from Automatic Workload Repository (AWR).
// It takes either credentials or databaseCredential. It's recommended to provide databaseCredential
type LoadSqlPlanBaselinesFromAwrDetails struct {
// The name of the database job used for loading SQL plan baselines.
JobName *string `mandatory:"true" json:"jobName"`
// The begin snapshot.
BeginSnapshot *int `mandatory:"true" json:"beginSnapshot"`
// The end snapshot.
EndSnapshot *int `mandatory:"true" json:"endSnapshot"`
// The description of the job.
JobDescription *string `mandatory:"false" json:"jobDescription"`
// A filter applied to AWR to select only qualifying plans to be loaded.
// By default all plans in AWR are selected. The filter can take the form of
// any `WHERE` clause predicate that can be specified against the column
// `DBA_HIST_SQLTEXT.SQL_TEXT`. An example is `sql_text like 'SELECT %'`.
SqlTextFilter *string `mandatory:"false" json:"sqlTextFilter"`
// Indicates whether the plans are loaded as fixed plans (`true`) or non-fixed plans (`false`).
// By default, they are loaded as non-fixed plans.
IsFixed *bool `mandatory:"false" json:"isFixed"`
// Indicates whether the loaded plans are enabled (`true`) or not (`false`).
// By default, they are enabled.
IsEnabled *bool `mandatory:"false" json:"isEnabled"`
Credentials ManagedDatabaseCredential `mandatory:"false" json:"credentials"`
DatabaseCredential DatabaseCredentialDetails `mandatory:"false" json:"databaseCredential"`
}
func (m LoadSqlPlanBaselinesFromAwrDetails) String() string {
return common.PointerString(m)
}
// 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 (m LoadSqlPlanBaselinesFromAwrDetails) ValidateEnumValue() (bool, error) {
errMessage := []string{}
if len(errMessage) > 0 {
return true, fmt.Errorf(strings.Join(errMessage, "\n"))
}
return false, nil
}
// UnmarshalJSON unmarshals from json
func (m *LoadSqlPlanBaselinesFromAwrDetails) UnmarshalJSON(data []byte) (e error) {
model := struct {
JobDescription *string `json:"jobDescription"`
SqlTextFilter *string `json:"sqlTextFilter"`
IsFixed *bool `json:"isFixed"`
IsEnabled *bool `json:"isEnabled"`
Credentials manageddatabasecredential `json:"credentials"`
DatabaseCredential databasecredentialdetails `json:"databaseCredential"`
JobName *string `json:"jobName"`
BeginSnapshot *int `json:"beginSnapshot"`
EndSnapshot *int `json:"endSnapshot"`
}{}
e = json.Unmarshal(data, &model)
if e != nil {
return
}
var nn interface{}
m.JobDescription = model.JobDescription
m.SqlTextFilter = model.SqlTextFilter
m.IsFixed = model.IsFixed
m.IsEnabled = model.IsEnabled
nn, e = model.Credentials.UnmarshalPolymorphicJSON(model.Credentials.JsonData)
if e != nil {
return
}
if nn != nil {
m.Credentials = nn.(ManagedDatabaseCredential)
} else {
m.Credentials = nil
}
nn, e = model.DatabaseCredential.UnmarshalPolymorphicJSON(model.DatabaseCredential.JsonData)
if e != nil {
return
}
if nn != nil {
m.DatabaseCredential = nn.(DatabaseCredentialDetails)
} else {
m.DatabaseCredential = nil
}
m.JobName = model.JobName
m.BeginSnapshot = model.BeginSnapshot
m.EndSnapshot = model.EndSnapshot
return
}