generated from pulumi/pulumi-tf-provider-boilerplate
/
getManagedDatabaseSqlTuningAdvisorTasks.go
185 lines (162 loc) · 9.44 KB
/
getManagedDatabaseSqlTuningAdvisorTasks.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
// 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 Tuning Advisor Tasks in Oracle Cloud Infrastructure Database Management service.
//
// Lists the SQL Tuning Advisor tasks for the specified Managed Database.
//
// ## Example Usage
//
// ```go
// package main
//
// import (
//
// "github.com/pulumi/pulumi-oci/sdk/go/oci/DatabaseManagement"
// "github.com/pulumi/pulumi/sdk/v3/go/pulumi"
//
// )
//
// func main() {
// pulumi.Run(func(ctx *pulumi.Context) error {
// _, err := DatabaseManagement.GetManagedDatabaseSqlTuningAdvisorTasks(ctx, &databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksArgs{
// ManagedDatabaseId: testManagedDatabase.Id,
// Name: pulumi.StringRef(managedDatabaseSqlTuningAdvisorTaskName),
// OpcNamedCredentialId: pulumi.StringRef(managedDatabaseSqlTuningAdvisorTaskOpcNamedCredentialId),
// Status: pulumi.StringRef(managedDatabaseSqlTuningAdvisorTaskStatus),
// TimeGreaterThanOrEqualTo: pulumi.StringRef(managedDatabaseSqlTuningAdvisorTaskTimeGreaterThanOrEqualTo),
// TimeLessThanOrEqualTo: pulumi.StringRef(managedDatabaseSqlTuningAdvisorTaskTimeLessThanOrEqualTo),
// }, nil)
// if err != nil {
// return err
// }
// return nil
// })
// }
//
// ```
func GetManagedDatabaseSqlTuningAdvisorTasks(ctx *pulumi.Context, args *GetManagedDatabaseSqlTuningAdvisorTasksArgs, opts ...pulumi.InvokeOption) (*GetManagedDatabaseSqlTuningAdvisorTasksResult, error) {
opts = internal.PkgInvokeDefaultOpts(opts)
var rv GetManagedDatabaseSqlTuningAdvisorTasksResult
err := ctx.Invoke("oci:DatabaseManagement/getManagedDatabaseSqlTuningAdvisorTasks:getManagedDatabaseSqlTuningAdvisorTasks", args, &rv, opts...)
if err != nil {
return nil, err
}
return &rv, nil
}
// A collection of arguments for invoking getManagedDatabaseSqlTuningAdvisorTasks.
type GetManagedDatabaseSqlTuningAdvisorTasksArgs struct {
Filters []GetManagedDatabaseSqlTuningAdvisorTasksFilter `pulumi:"filters"`
// The [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Managed Database.
ManagedDatabaseId string `pulumi:"managedDatabaseId"`
// The optional query parameter to filter the SQL Tuning Advisor task list by name.
Name *string `pulumi:"name"`
// The OCID of the Named Credential.
OpcNamedCredentialId *string `pulumi:"opcNamedCredentialId"`
// The optional query parameter to filter the SQL Tuning Advisor task list by status.
Status *string `pulumi:"status"`
// The optional greater than or equal to query parameter to filter the timestamp.
TimeGreaterThanOrEqualTo *string `pulumi:"timeGreaterThanOrEqualTo"`
// The optional less than or equal to query parameter to filter the timestamp.
TimeLessThanOrEqualTo *string `pulumi:"timeLessThanOrEqualTo"`
}
// A collection of values returned by getManagedDatabaseSqlTuningAdvisorTasks.
type GetManagedDatabaseSqlTuningAdvisorTasksResult struct {
Filters []GetManagedDatabaseSqlTuningAdvisorTasksFilter `pulumi:"filters"`
// The provider-assigned unique ID for this managed resource.
Id string `pulumi:"id"`
ManagedDatabaseId string `pulumi:"managedDatabaseId"`
// The name of the SQL Tuning Advisor task.
Name *string `pulumi:"name"`
OpcNamedCredentialId *string `pulumi:"opcNamedCredentialId"`
// The list of sql_tuning_advisor_task_collection.
SqlTuningAdvisorTaskCollections []GetManagedDatabaseSqlTuningAdvisorTasksSqlTuningAdvisorTaskCollection `pulumi:"sqlTuningAdvisorTaskCollections"`
Status *string `pulumi:"status"`
TimeGreaterThanOrEqualTo *string `pulumi:"timeGreaterThanOrEqualTo"`
TimeLessThanOrEqualTo *string `pulumi:"timeLessThanOrEqualTo"`
}
func GetManagedDatabaseSqlTuningAdvisorTasksOutput(ctx *pulumi.Context, args GetManagedDatabaseSqlTuningAdvisorTasksOutputArgs, opts ...pulumi.InvokeOption) GetManagedDatabaseSqlTuningAdvisorTasksResultOutput {
return pulumi.ToOutputWithContext(context.Background(), args).
ApplyT(func(v interface{}) (GetManagedDatabaseSqlTuningAdvisorTasksResult, error) {
args := v.(GetManagedDatabaseSqlTuningAdvisorTasksArgs)
r, err := GetManagedDatabaseSqlTuningAdvisorTasks(ctx, &args, opts...)
var s GetManagedDatabaseSqlTuningAdvisorTasksResult
if r != nil {
s = *r
}
return s, err
}).(GetManagedDatabaseSqlTuningAdvisorTasksResultOutput)
}
// A collection of arguments for invoking getManagedDatabaseSqlTuningAdvisorTasks.
type GetManagedDatabaseSqlTuningAdvisorTasksOutputArgs struct {
Filters GetManagedDatabaseSqlTuningAdvisorTasksFilterArrayInput `pulumi:"filters"`
// The [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Managed Database.
ManagedDatabaseId pulumi.StringInput `pulumi:"managedDatabaseId"`
// The optional query parameter to filter the SQL Tuning Advisor task list by name.
Name pulumi.StringPtrInput `pulumi:"name"`
// The OCID of the Named Credential.
OpcNamedCredentialId pulumi.StringPtrInput `pulumi:"opcNamedCredentialId"`
// The optional query parameter to filter the SQL Tuning Advisor task list by status.
Status pulumi.StringPtrInput `pulumi:"status"`
// The optional greater than or equal to query parameter to filter the timestamp.
TimeGreaterThanOrEqualTo pulumi.StringPtrInput `pulumi:"timeGreaterThanOrEqualTo"`
// The optional less than or equal to query parameter to filter the timestamp.
TimeLessThanOrEqualTo pulumi.StringPtrInput `pulumi:"timeLessThanOrEqualTo"`
}
func (GetManagedDatabaseSqlTuningAdvisorTasksOutputArgs) ElementType() reflect.Type {
return reflect.TypeOf((*GetManagedDatabaseSqlTuningAdvisorTasksArgs)(nil)).Elem()
}
// A collection of values returned by getManagedDatabaseSqlTuningAdvisorTasks.
type GetManagedDatabaseSqlTuningAdvisorTasksResultOutput struct{ *pulumi.OutputState }
func (GetManagedDatabaseSqlTuningAdvisorTasksResultOutput) ElementType() reflect.Type {
return reflect.TypeOf((*GetManagedDatabaseSqlTuningAdvisorTasksResult)(nil)).Elem()
}
func (o GetManagedDatabaseSqlTuningAdvisorTasksResultOutput) ToGetManagedDatabaseSqlTuningAdvisorTasksResultOutput() GetManagedDatabaseSqlTuningAdvisorTasksResultOutput {
return o
}
func (o GetManagedDatabaseSqlTuningAdvisorTasksResultOutput) ToGetManagedDatabaseSqlTuningAdvisorTasksResultOutputWithContext(ctx context.Context) GetManagedDatabaseSqlTuningAdvisorTasksResultOutput {
return o
}
func (o GetManagedDatabaseSqlTuningAdvisorTasksResultOutput) Filters() GetManagedDatabaseSqlTuningAdvisorTasksFilterArrayOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksResult) []GetManagedDatabaseSqlTuningAdvisorTasksFilter {
return v.Filters
}).(GetManagedDatabaseSqlTuningAdvisorTasksFilterArrayOutput)
}
// The provider-assigned unique ID for this managed resource.
func (o GetManagedDatabaseSqlTuningAdvisorTasksResultOutput) Id() pulumi.StringOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksResult) string { return v.Id }).(pulumi.StringOutput)
}
func (o GetManagedDatabaseSqlTuningAdvisorTasksResultOutput) ManagedDatabaseId() pulumi.StringOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksResult) string { return v.ManagedDatabaseId }).(pulumi.StringOutput)
}
// The name of the SQL Tuning Advisor task.
func (o GetManagedDatabaseSqlTuningAdvisorTasksResultOutput) Name() pulumi.StringPtrOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksResult) *string { return v.Name }).(pulumi.StringPtrOutput)
}
func (o GetManagedDatabaseSqlTuningAdvisorTasksResultOutput) OpcNamedCredentialId() pulumi.StringPtrOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksResult) *string { return v.OpcNamedCredentialId }).(pulumi.StringPtrOutput)
}
// The list of sql_tuning_advisor_task_collection.
func (o GetManagedDatabaseSqlTuningAdvisorTasksResultOutput) SqlTuningAdvisorTaskCollections() GetManagedDatabaseSqlTuningAdvisorTasksSqlTuningAdvisorTaskCollectionArrayOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksResult) []GetManagedDatabaseSqlTuningAdvisorTasksSqlTuningAdvisorTaskCollection {
return v.SqlTuningAdvisorTaskCollections
}).(GetManagedDatabaseSqlTuningAdvisorTasksSqlTuningAdvisorTaskCollectionArrayOutput)
}
func (o GetManagedDatabaseSqlTuningAdvisorTasksResultOutput) Status() pulumi.StringPtrOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksResult) *string { return v.Status }).(pulumi.StringPtrOutput)
}
func (o GetManagedDatabaseSqlTuningAdvisorTasksResultOutput) TimeGreaterThanOrEqualTo() pulumi.StringPtrOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksResult) *string { return v.TimeGreaterThanOrEqualTo }).(pulumi.StringPtrOutput)
}
func (o GetManagedDatabaseSqlTuningAdvisorTasksResultOutput) TimeLessThanOrEqualTo() pulumi.StringPtrOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksResult) *string { return v.TimeLessThanOrEqualTo }).(pulumi.StringPtrOutput)
}
func init() {
pulumi.RegisterOutputType(GetManagedDatabaseSqlTuningAdvisorTasksResultOutput{})
}