generated from pulumi/pulumi-tf-provider-boilerplate
/
getManagedDatabaseSqlPlanBaselines.go
230 lines (199 loc) · 12.7 KB
/
getManagedDatabaseSqlPlanBaselines.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
// Code generated by the Pulumi Terraform Bridge (tfgen) Tool DO NOT EDIT.
// *** WARNING: Do not edit by hand unless you're certain you know what you are doing! ***
package databasemanagement
import (
"context"
"reflect"
"github.com/pulumi/pulumi-oci/sdk/go/oci/internal"
"github.com/pulumi/pulumi/sdk/v3/go/pulumi"
)
// This data source provides the list of Managed Database Sql Plan Baselines in Oracle Cloud Infrastructure Database Management service.
//
// Lists the SQL plan baselines for the specified Managed Database.
func GetManagedDatabaseSqlPlanBaselines(ctx *pulumi.Context, args *GetManagedDatabaseSqlPlanBaselinesArgs, opts ...pulumi.InvokeOption) (*GetManagedDatabaseSqlPlanBaselinesResult, error) {
opts = internal.PkgInvokeDefaultOpts(opts)
var rv GetManagedDatabaseSqlPlanBaselinesResult
err := ctx.Invoke("oci:DatabaseManagement/getManagedDatabaseSqlPlanBaselines:getManagedDatabaseSqlPlanBaselines", args, &rv, opts...)
if err != nil {
return nil, err
}
return &rv, nil
}
// A collection of arguments for invoking getManagedDatabaseSqlPlanBaselines.
type GetManagedDatabaseSqlPlanBaselinesArgs struct {
Filters []GetManagedDatabaseSqlPlanBaselinesFilter `pulumi:"filters"`
// 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 `pulumi:"isAccepted"`
// 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 `pulumi:"isAdaptive"`
// 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 `pulumi:"isAutoPurged"`
// 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 `pulumi:"isEnabled"`
// 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 `pulumi:"isFixed"`
// A filter to return only SQL plan baselines that are not executed till now. By default, all SQL plan baselines are returned.
IsNeverExecuted *bool `pulumi:"isNeverExecuted"`
// 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 `pulumi:"isReproduced"`
Limit *int `pulumi:"limit"`
// The [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Managed Database.
ManagedDatabaseId string `pulumi:"managedDatabaseId"`
// The OCID of the Named Credential.
OpcNamedCredentialId *string `pulumi:"opcNamedCredentialId"`
// A filter to return all the SQL plan baselines that match the origin.
Origin *string `pulumi:"origin"`
// A filter to return only SQL plan baselines that match the plan name.
PlanName *string `pulumi:"planName"`
// A filter to return all the SQL plan baselines for the specified SQL handle.
SqlHandle *string `pulumi:"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 `pulumi:"sqlText"`
}
// A collection of values returned by getManagedDatabaseSqlPlanBaselines.
type GetManagedDatabaseSqlPlanBaselinesResult struct {
Filters []GetManagedDatabaseSqlPlanBaselinesFilter `pulumi:"filters"`
// The provider-assigned unique ID for this managed resource.
Id string `pulumi:"id"`
IsAccepted *bool `pulumi:"isAccepted"`
IsAdaptive *bool `pulumi:"isAdaptive"`
IsAutoPurged *bool `pulumi:"isAutoPurged"`
IsEnabled *bool `pulumi:"isEnabled"`
IsFixed *bool `pulumi:"isFixed"`
IsNeverExecuted *bool `pulumi:"isNeverExecuted"`
IsReproduced *bool `pulumi:"isReproduced"`
Limit *int `pulumi:"limit"`
ManagedDatabaseId string `pulumi:"managedDatabaseId"`
OpcNamedCredentialId *string `pulumi:"opcNamedCredentialId"`
// The origin of the SQL plan baseline.
Origin *string `pulumi:"origin"`
// The unique plan identifier.
PlanName *string `pulumi:"planName"`
// The unique SQL identifier.
SqlHandle *string `pulumi:"sqlHandle"`
// The list of sql_plan_baseline_collection.
SqlPlanBaselineCollections []GetManagedDatabaseSqlPlanBaselinesSqlPlanBaselineCollection `pulumi:"sqlPlanBaselineCollections"`
// The SQL text.
SqlText *string `pulumi:"sqlText"`
}
func GetManagedDatabaseSqlPlanBaselinesOutput(ctx *pulumi.Context, args GetManagedDatabaseSqlPlanBaselinesOutputArgs, opts ...pulumi.InvokeOption) GetManagedDatabaseSqlPlanBaselinesResultOutput {
return pulumi.ToOutputWithContext(context.Background(), args).
ApplyT(func(v interface{}) (GetManagedDatabaseSqlPlanBaselinesResult, error) {
args := v.(GetManagedDatabaseSqlPlanBaselinesArgs)
r, err := GetManagedDatabaseSqlPlanBaselines(ctx, &args, opts...)
var s GetManagedDatabaseSqlPlanBaselinesResult
if r != nil {
s = *r
}
return s, err
}).(GetManagedDatabaseSqlPlanBaselinesResultOutput)
}
// A collection of arguments for invoking getManagedDatabaseSqlPlanBaselines.
type GetManagedDatabaseSqlPlanBaselinesOutputArgs struct {
Filters GetManagedDatabaseSqlPlanBaselinesFilterArrayInput `pulumi:"filters"`
// A filter to return only SQL plan baselines that are either accepted or not accepted. By default, all SQL plan baselines are returned.
IsAccepted pulumi.BoolPtrInput `pulumi:"isAccepted"`
// A filter to return only SQL plan baselines that are either adaptive or not adaptive. By default, all SQL plan baselines are returned.
IsAdaptive pulumi.BoolPtrInput `pulumi:"isAdaptive"`
// 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 pulumi.BoolPtrInput `pulumi:"isAutoPurged"`
// A filter to return only SQL plan baselines that are either enabled or not enabled. By default, all SQL plan baselines are returned.
IsEnabled pulumi.BoolPtrInput `pulumi:"isEnabled"`
// A filter to return only SQL plan baselines that are either fixed or not fixed. By default, all SQL plan baselines are returned.
IsFixed pulumi.BoolPtrInput `pulumi:"isFixed"`
// A filter to return only SQL plan baselines that are not executed till now. By default, all SQL plan baselines are returned.
IsNeverExecuted pulumi.BoolPtrInput `pulumi:"isNeverExecuted"`
// 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 pulumi.BoolPtrInput `pulumi:"isReproduced"`
Limit pulumi.IntPtrInput `pulumi:"limit"`
// The [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Managed Database.
ManagedDatabaseId pulumi.StringInput `pulumi:"managedDatabaseId"`
// The OCID of the Named Credential.
OpcNamedCredentialId pulumi.StringPtrInput `pulumi:"opcNamedCredentialId"`
// A filter to return all the SQL plan baselines that match the origin.
Origin pulumi.StringPtrInput `pulumi:"origin"`
// A filter to return only SQL plan baselines that match the plan name.
PlanName pulumi.StringPtrInput `pulumi:"planName"`
// A filter to return all the SQL plan baselines for the specified SQL handle.
SqlHandle pulumi.StringPtrInput `pulumi:"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 pulumi.StringPtrInput `pulumi:"sqlText"`
}
func (GetManagedDatabaseSqlPlanBaselinesOutputArgs) ElementType() reflect.Type {
return reflect.TypeOf((*GetManagedDatabaseSqlPlanBaselinesArgs)(nil)).Elem()
}
// A collection of values returned by getManagedDatabaseSqlPlanBaselines.
type GetManagedDatabaseSqlPlanBaselinesResultOutput struct{ *pulumi.OutputState }
func (GetManagedDatabaseSqlPlanBaselinesResultOutput) ElementType() reflect.Type {
return reflect.TypeOf((*GetManagedDatabaseSqlPlanBaselinesResult)(nil)).Elem()
}
func (o GetManagedDatabaseSqlPlanBaselinesResultOutput) ToGetManagedDatabaseSqlPlanBaselinesResultOutput() GetManagedDatabaseSqlPlanBaselinesResultOutput {
return o
}
func (o GetManagedDatabaseSqlPlanBaselinesResultOutput) ToGetManagedDatabaseSqlPlanBaselinesResultOutputWithContext(ctx context.Context) GetManagedDatabaseSqlPlanBaselinesResultOutput {
return o
}
func (o GetManagedDatabaseSqlPlanBaselinesResultOutput) Filters() GetManagedDatabaseSqlPlanBaselinesFilterArrayOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlPlanBaselinesResult) []GetManagedDatabaseSqlPlanBaselinesFilter {
return v.Filters
}).(GetManagedDatabaseSqlPlanBaselinesFilterArrayOutput)
}
// The provider-assigned unique ID for this managed resource.
func (o GetManagedDatabaseSqlPlanBaselinesResultOutput) Id() pulumi.StringOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlPlanBaselinesResult) string { return v.Id }).(pulumi.StringOutput)
}
func (o GetManagedDatabaseSqlPlanBaselinesResultOutput) IsAccepted() pulumi.BoolPtrOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlPlanBaselinesResult) *bool { return v.IsAccepted }).(pulumi.BoolPtrOutput)
}
func (o GetManagedDatabaseSqlPlanBaselinesResultOutput) IsAdaptive() pulumi.BoolPtrOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlPlanBaselinesResult) *bool { return v.IsAdaptive }).(pulumi.BoolPtrOutput)
}
func (o GetManagedDatabaseSqlPlanBaselinesResultOutput) IsAutoPurged() pulumi.BoolPtrOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlPlanBaselinesResult) *bool { return v.IsAutoPurged }).(pulumi.BoolPtrOutput)
}
func (o GetManagedDatabaseSqlPlanBaselinesResultOutput) IsEnabled() pulumi.BoolPtrOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlPlanBaselinesResult) *bool { return v.IsEnabled }).(pulumi.BoolPtrOutput)
}
func (o GetManagedDatabaseSqlPlanBaselinesResultOutput) IsFixed() pulumi.BoolPtrOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlPlanBaselinesResult) *bool { return v.IsFixed }).(pulumi.BoolPtrOutput)
}
func (o GetManagedDatabaseSqlPlanBaselinesResultOutput) IsNeverExecuted() pulumi.BoolPtrOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlPlanBaselinesResult) *bool { return v.IsNeverExecuted }).(pulumi.BoolPtrOutput)
}
func (o GetManagedDatabaseSqlPlanBaselinesResultOutput) IsReproduced() pulumi.BoolPtrOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlPlanBaselinesResult) *bool { return v.IsReproduced }).(pulumi.BoolPtrOutput)
}
func (o GetManagedDatabaseSqlPlanBaselinesResultOutput) Limit() pulumi.IntPtrOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlPlanBaselinesResult) *int { return v.Limit }).(pulumi.IntPtrOutput)
}
func (o GetManagedDatabaseSqlPlanBaselinesResultOutput) ManagedDatabaseId() pulumi.StringOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlPlanBaselinesResult) string { return v.ManagedDatabaseId }).(pulumi.StringOutput)
}
func (o GetManagedDatabaseSqlPlanBaselinesResultOutput) OpcNamedCredentialId() pulumi.StringPtrOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlPlanBaselinesResult) *string { return v.OpcNamedCredentialId }).(pulumi.StringPtrOutput)
}
// The origin of the SQL plan baseline.
func (o GetManagedDatabaseSqlPlanBaselinesResultOutput) Origin() pulumi.StringPtrOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlPlanBaselinesResult) *string { return v.Origin }).(pulumi.StringPtrOutput)
}
// The unique plan identifier.
func (o GetManagedDatabaseSqlPlanBaselinesResultOutput) PlanName() pulumi.StringPtrOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlPlanBaselinesResult) *string { return v.PlanName }).(pulumi.StringPtrOutput)
}
// The unique SQL identifier.
func (o GetManagedDatabaseSqlPlanBaselinesResultOutput) SqlHandle() pulumi.StringPtrOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlPlanBaselinesResult) *string { return v.SqlHandle }).(pulumi.StringPtrOutput)
}
// The list of sql_plan_baseline_collection.
func (o GetManagedDatabaseSqlPlanBaselinesResultOutput) SqlPlanBaselineCollections() GetManagedDatabaseSqlPlanBaselinesSqlPlanBaselineCollectionArrayOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlPlanBaselinesResult) []GetManagedDatabaseSqlPlanBaselinesSqlPlanBaselineCollection {
return v.SqlPlanBaselineCollections
}).(GetManagedDatabaseSqlPlanBaselinesSqlPlanBaselineCollectionArrayOutput)
}
// The SQL text.
func (o GetManagedDatabaseSqlPlanBaselinesResultOutput) SqlText() pulumi.StringPtrOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlPlanBaselinesResult) *string { return v.SqlText }).(pulumi.StringPtrOutput)
}
func init() {
pulumi.RegisterOutputType(GetManagedDatabaseSqlPlanBaselinesResultOutput{})
}