# 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).
require 'date'
require 'oci'
# Create a default config using DEFAULT profile in default location
# Refer to https://docs.cloud.oracle.com/en-us/iaas/Content/API/Concepts/sdkconfig.htm#SDK_and_CLI_Configuration_File for more info
config = OCI::ConfigFileLoader.load_config
# Initialize service client with default config file
database_tools_client =
OCI::DatabaseTools::DatabaseToolsClient.new(config: config)
# Send the request to service, some parameters are not required, see API doc for more info
create_database_tools_mcp_toolset_response =
database_tools_client.create_database_tools_mcp_toolset(
OCI::DatabaseTools::Models::CreateDatabaseToolsMcpToolsetCustomizableReportingToolsDetails
.new(
type: 'CUSTOMIZABLE_REPORTING_TOOLS',
version: 482,
compartment_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-compartmentId-Value',
display_name: 'EXAMPLE-displayName-Value',
database_tools_mcp_server_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-databaseToolsMcpServerId-Value',
reports: [
OCI::DatabaseTools::Models::DatabaseToolsMcpToolsetCustomizableReportingToolsReport
.new(
database_tools_sql_report_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-databaseToolsSqlReportId-Value',
allowed_roles: %w[EXAMPLE--Value]
)
],
description: 'EXAMPLE-description-Value',
defined_tags: {
'EXAMPLE_KEY_oTrgm' => { 'EXAMPLE_KEY_cnNIZ' => 'EXAMPLE--Value' }
},
freeform_tags: {
'EXAMPLE_KEY_CV7Ek' => 'EXAMPLE_VALUE_2wkyeG2X97Iisxb2EK3Q'
},
locks: [
OCI::DatabaseTools::Models::ResourceLock.new(
type: 'DELETE',
related_resource_id:
'ocid1.test.oc1..<unique_ID>EXAMPLE-relatedResourceId-Value',
message: 'EXAMPLE-message-Value',
time_created: DateTime.parse('2014-07-25T11:17:42.192Z')
)
],
tools: [
OCI::DatabaseTools::Models::CreateDatabaseToolsMcpToolsetToolDetails
.new(
name: 'EXAMPLE-name-Value',
status: 'DISABLED',
allowed_roles: %w[EXAMPLE--Value]
)
],
default_execution_type: 'SYNCHRONOUS'
)
)
# Get the data from response
puts "#{create_database_tools_mcp_toolset_response.data}"