// This is an automatically generated code sample.
// To make this code sample work in your Oracle Cloud tenancy,
// please replace the values for any parameters whose current values do not fit
// your use case (such as resource IDs, strings containing ‘EXAMPLE’ or ‘unique_id’, and
// boolean, number, and enum parameters with values not fitting your use case).

package main

import (
	"context"
	"fmt"
	"time"

	"github.com/oracle/oci-go-sdk/v65/common"
	"github.com/oracle/oci-go-sdk/v65/databasetools"
	"github.com/oracle/oci-go-sdk/v65/example/helpers"
)

func ExampleCreateDatabaseToolsSqlReport() {
	// Create a default authentication provider that uses the DEFAULT
	// profile in the configuration file.
	// Refer to <see href="https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File>the public documentation</see> on how to prepare a configuration file.
	client, err := databasetools.NewDatabaseToolsClientWithConfigurationProvider(common.DefaultConfigProvider())
	helpers.FatalIfError(err)

	// Create a request and dependent object(s).

	req := databasetools.CreateDatabaseToolsSqlReportRequest{CreateDatabaseToolsSqlReportDetails: databasetools.CreateDatabaseToolsSqlReportOracleDatabaseDetails{DisplayName: common.String("EXAMPLE-displayName-Value"),
		Instructions: common.String("EXAMPLE-instructions-Value"),
		Locks: []databasetools.ResourceLock{databasetools.ResourceLock{Message: common.String("EXAMPLE-message-Value"),
			RelatedResourceId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-relatedResourceId-Value"),
			TimeCreated:       &common.SDKTime{Time: time.Now()}}},
		Source: common.String("EXAMPLE-source-Value"),
		Variables: []databasetools.DatabaseToolsSqlReportVariable{databasetools.DatabaseToolsSqlReportVariable{Description: common.String("EXAMPLE-description-Value"),
			Name: common.String("EXAMPLE-name-Value")}},
		CompartmentId: common.String("ocid1.test.oc1..<unique_ID>EXAMPLE-compartmentId-Value"),
		DefinedTags:   map[string]map[string]interface{}{"EXAMPLE_KEY_sHbuN": map[string]interface{}{"EXAMPLE_KEY_xY5ra": "EXAMPLE--Value"}},
		FreeformTags:  map[string]string{"EXAMPLE_KEY_TsrSq": "EXAMPLE_VALUE_twZRztEcNsOkhXvfSzVc"},
		Purpose:       common.String("EXAMPLE-purpose-Value"),
		Columns: []databasetools.DatabaseToolsSqlReportColumn{databasetools.DatabaseToolsSqlReportColumn{Description: common.String("EXAMPLE-description-Value"),
			Name: common.String("EXAMPLE-name-Value")}},
		Description: common.String("EXAMPLE-description-Value")},
		OpcRequestId:  common.String("8EMXLQWDOVJ81DQ4SLXM<unique_ID>"),
		OpcRetryToken: common.String("EXAMPLE-opcRetryToken-Value")}

	// Send the request using the service client
	resp, err := client.CreateDatabaseToolsSqlReport(context.Background(), req)
	helpers.FatalIfError(err)

	// Retrieve value from the response.
	fmt.Println(resp)
}