getManagedDatabaseSqlTuningAdvisorTasksRecommendation.go

// 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 details about a specific Managed Database Sql Tuning Advisor Tasks Recommendation resource 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.GetManagedDatabaseSqlTuningAdvisorTasksRecommendation(ctx, &databasemanagement.GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs{
//				ExecutionId:            testExecution.Id,
//				ManagedDatabaseId:      testManagedDatabase.Id,
//				SqlObjectId:            testObject.Id,
//				SqlTuningAdvisorTaskId: testSqlTuningAdvisorTask.Id,
//			}, nil)
//			if err != nil {
//				return err
//			}
//			return nil
//		})
//	}
//
// ```
func GetManagedDatabaseSqlTuningAdvisorTasksRecommendation(ctx *pulumi.Context, args *GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs, opts ...pulumi.InvokeOption) (*GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult, error) {
	opts = internal.PkgInvokeDefaultOpts(opts)
	var rv GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult
	err := ctx.Invoke("oci:DatabaseManagement/getManagedDatabaseSqlTuningAdvisorTasksRecommendation:getManagedDatabaseSqlTuningAdvisorTasksRecommendation", args, &rv, opts...)
	if err != nil {
		return nil, err
	}
	return &rv, nil
}

// A collection of arguments for invoking getManagedDatabaseSqlTuningAdvisorTasksRecommendation.
type GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs 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"`
	// The [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Managed Database.
	ManagedDatabaseId string `pulumi:"managedDatabaseId"`
	// 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 getManagedDatabaseSqlTuningAdvisorTasksRecommendation.
type GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult struct {
	ExecutionId string `pulumi:"executionId"`
	// The provider-assigned unique ID for this managed resource.
	Id string `pulumi:"id"`
	// A list of SQL Tuning Advisor recommendations.
	Items             []GetManagedDatabaseSqlTuningAdvisorTasksRecommendationItem `pulumi:"items"`
	ManagedDatabaseId string                                                      `pulumi:"managedDatabaseId"`
	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"`
}

func GetManagedDatabaseSqlTuningAdvisorTasksRecommendationOutput(ctx *pulumi.Context, args GetManagedDatabaseSqlTuningAdvisorTasksRecommendationOutputArgs, opts ...pulumi.InvokeOption) GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResultOutput {
	return pulumi.ToOutputWithContext(context.Background(), args).
		ApplyT(func(v interface{}) (GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult, error) {
			args := v.(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs)
			r, err := GetManagedDatabaseSqlTuningAdvisorTasksRecommendation(ctx, &args, opts...)
			var s GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult
			if r != nil {
				s = *r
			}
			return s, err
		}).(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResultOutput)
}

// A collection of arguments for invoking getManagedDatabaseSqlTuningAdvisorTasksRecommendation.
type GetManagedDatabaseSqlTuningAdvisorTasksRecommendationOutputArgs 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"`
	// The [OCID](https://docs.cloud.oracle.com/iaas/Content/General/Concepts/identifiers.htm) of the Managed Database.
	ManagedDatabaseId pulumi.StringInput `pulumi:"managedDatabaseId"`
	// 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 (GetManagedDatabaseSqlTuningAdvisorTasksRecommendationOutputArgs) ElementType() reflect.Type {
	return reflect.TypeOf((*GetManagedDatabaseSqlTuningAdvisorTasksRecommendationArgs)(nil)).Elem()
}

// A collection of values returned by getManagedDatabaseSqlTuningAdvisorTasksRecommendation.
type GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResultOutput struct{ *pulumi.OutputState }

func (GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResultOutput) ElementType() reflect.Type {
	return reflect.TypeOf((*GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult)(nil)).Elem()
}

func (o GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResultOutput) ToGetManagedDatabaseSqlTuningAdvisorTasksRecommendationResultOutput() GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResultOutput {
	return o
}

func (o GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResultOutput) ToGetManagedDatabaseSqlTuningAdvisorTasksRecommendationResultOutputWithContext(ctx context.Context) GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResultOutput {
	return o
}

func (o GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResultOutput) ExecutionId() pulumi.StringOutput {
	return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult) string { return v.ExecutionId }).(pulumi.StringOutput)
}

// The provider-assigned unique ID for this managed resource.
func (o GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResultOutput) Id() pulumi.StringOutput {
	return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult) string { return v.Id }).(pulumi.StringOutput)
}

// A list of SQL Tuning Advisor recommendations.
func (o GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResultOutput) Items() GetManagedDatabaseSqlTuningAdvisorTasksRecommendationItemArrayOutput {
	return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult) []GetManagedDatabaseSqlTuningAdvisorTasksRecommendationItem {
		return v.Items
	}).(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationItemArrayOutput)
}

func (o GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResultOutput) ManagedDatabaseId() pulumi.StringOutput {
	return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult) string { return v.ManagedDatabaseId }).(pulumi.StringOutput)
}

func (o GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResultOutput) SqlObjectId() pulumi.StringOutput {
	return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult) 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 GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResultOutput) SqlTuningAdvisorTaskId() pulumi.StringOutput {
	return o.ApplyT(func(v GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResult) string {
		return v.SqlTuningAdvisorTaskId
	}).(pulumi.StringOutput)
}

func init() {
	pulumi.RegisterOutputType(GetManagedDatabaseSqlTuningAdvisorTasksRecommendationResultOutput{})
}