generated from pulumi/pulumi-tf-provider-boilerplate
/
getManagedDatabaseSqlTuningAdvisorTasksRecommendations.go
182 lines (160 loc) · 10.3 KB
/
getManagedDatabaseSqlTuningAdvisorTasksRecommendations.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
// 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 Recommendations in Oracle Cloud Infrastructure Database Management service.
//
// Gets the findings and possible actions for a given object in a SQL tuning task.
// The task ID and object ID are used to retrieve the findings and recommendations.
//
// ## 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.GetManagedDatabaseSqlTuningAdvisorTasksRecommendations(ctx, &databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs{
// ExecutionId: testExecution.Id,
// ManagedDatabaseId: testManagedDatabase.Id,
// SqlObjectId: testObject.Id,
// SqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.Id,
// OpcNamedCredentialId: pulumi.StringRef(managedDatabaseSqlTuningAdvisorTasksRecommendationOpcNamedCredentialId),
// }, nil)
// if err != nil {
// return err
// }
// return nil
// })
// }
//
// ```
func GetManagedDatabaseSqlTuningAdvisorTasksRecommendations(ctx *pulumi.Context, args *GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs, opts ...pulumi.InvokeOption) (*GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult, error) {
opts = internal.PkgInvokeDefaultOpts(opts)
var rv GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult
err := ctx.Invoke("oci:DatabaseManagement/getManagedDatabaseSqlTuningAdvisorTasksRecommendations:getManagedDatabaseSqlTuningAdvisorTasksRecommendations", args, &rv, opts...)
if err != nil {
return nil, err
}
return &rv, nil
}
// A collection of arguments for invoking getManagedDatabaseSqlTuningAdvisorTasksRecommendations.
type GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs struct {
// The execution ID for an execution of a SQL tuning task. This is not the [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm).
ExecutionId string `pulumi:"executionId"`
Filters []GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilter `pulumi:"filters"`
// 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"`
// The SQL object ID for the SQL tuning task. This is not the [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm).
SqlObjectId string `pulumi:"sqlObjectId"`
// The SQL tuning task identifier. This is not the [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm).
SqlTuningAdvisorTaskId string `pulumi:"sqlTuningAdvisorTaskId"`
}
// A collection of values returned by getManagedDatabaseSqlTuningAdvisorTasksRecommendations.
type GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult struct {
ExecutionId string `pulumi:"executionId"`
Filters []GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilter `pulumi:"filters"`
// The provider-assigned unique ID for this managed resource.
Id string `pulumi:"id"`
ManagedDatabaseId string `pulumi:"managedDatabaseId"`
OpcNamedCredentialId *string `pulumi:"opcNamedCredentialId"`
SqlObjectId string `pulumi:"sqlObjectId"`
// The unique identifier of the task. This is not the [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm).
SqlTuningAdvisorTaskId string `pulumi:"sqlTuningAdvisorTaskId"`
// The list of sql_tuning_advisor_task_recommendation_collection.
SqlTuningAdvisorTaskRecommendationCollections []GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsSqlTuningAdvisorTaskRecommendationCollection `pulumi:"sqlTuningAdvisorTaskRecommendationCollections"`
}
func GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsOutput(ctx *pulumi.Context, args GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsOutputArgs, opts ...pulumi.InvokeOption) GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResultOutput {
return pulumi.ToOutputWithContext(context.Background(), args).
ApplyT(func(v interface{}) (GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult, error) {
args := v.(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs)
r, err := GetManagedDatabaseSqlTuningAdvisorTasksRecommendations(ctx, &args, opts...)
var s GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult
if r != nil {
s = *r
}
return s, err
}).(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResultOutput)
}
// A collection of arguments for invoking getManagedDatabaseSqlTuningAdvisorTasksRecommendations.
type GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsOutputArgs struct {
// The execution ID for an execution of a SQL tuning task. This is not the [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm).
ExecutionId pulumi.StringInput `pulumi:"executionId"`
Filters GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilterArrayInput `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 OCID of the Named Credential.
OpcNamedCredentialId pulumi.StringPtrInput `pulumi:"opcNamedCredentialId"`
// The SQL object ID for the SQL tuning task. This is not the [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm).
SqlObjectId pulumi.StringInput `pulumi:"sqlObjectId"`
// The SQL tuning task identifier. This is not the [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm).
SqlTuningAdvisorTaskId pulumi.StringInput `pulumi:"sqlTuningAdvisorTaskId"`
}
func (GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsOutputArgs) ElementType() reflect.Type {
return reflect.TypeOf((*GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsArgs)(nil)).Elem()
}
// A collection of values returned by getManagedDatabaseSqlTuningAdvisorTasksRecommendations.
type GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResultOutput struct{ *pulumi.OutputState }
func (GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResultOutput) ElementType() reflect.Type {
return reflect.TypeOf((*GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult)(nil)).Elem()
}
func (o GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResultOutput) ToGetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResultOutput() GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResultOutput {
return o
}
func (o GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResultOutput) ToGetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResultOutputWithContext(ctx context.Context) GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResultOutput {
return o
}
func (o GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResultOutput) ExecutionId() pulumi.StringOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult) string { return v.ExecutionId }).(pulumi.StringOutput)
}
func (o GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResultOutput) Filters() GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilterArrayOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult) []GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilter {
return v.Filters
}).(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsFilterArrayOutput)
}
// The provider-assigned unique ID for this managed resource.
func (o GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResultOutput) Id() pulumi.StringOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult) string { return v.Id }).(pulumi.StringOutput)
}
func (o GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResultOutput) ManagedDatabaseId() pulumi.StringOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult) string {
return v.ManagedDatabaseId
}).(pulumi.StringOutput)
}
func (o GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResultOutput) OpcNamedCredentialId() pulumi.StringPtrOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult) *string {
return v.OpcNamedCredentialId
}).(pulumi.StringPtrOutput)
}
func (o GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResultOutput) SqlObjectId() pulumi.StringOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult) string { return v.SqlObjectId }).(pulumi.StringOutput)
}
// The unique identifier of the task. This is not the [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm).
func (o GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResultOutput) SqlTuningAdvisorTaskId() pulumi.StringOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult) string {
return v.SqlTuningAdvisorTaskId
}).(pulumi.StringOutput)
}
// The list of sql_tuning_advisor_task_recommendation_collection.
func (o GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResultOutput) SqlTuningAdvisorTaskRecommendationCollections() GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsSqlTuningAdvisorTaskRecommendationCollectionArrayOutput {
return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResult) []GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsSqlTuningAdvisorTaskRecommendationCollection {
return v.SqlTuningAdvisorTaskRecommendationCollections
}).(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsSqlTuningAdvisorTaskRecommendationCollectionArrayOutput)
}
func init() {
pulumi.RegisterOutputType(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationsResultOutput{})
}