# 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 '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
mysql_client = OCI::Mysql::ChannelsClient.new(config: config)
# Send the request to service, some parameters are not required, see API doc for more info
update_channel_response =
mysql_client.update_channel(
'ocid1.test.oc1..<unique_ID>EXAMPLE-channelId-Value',
OCI::Mysql::Models::UpdateChannelDetails.new(
source:
OCI::Mysql::Models::UpdateChannelSourceFromMysqlDetails.new(
source_type: 'MYSQL',
hostname: 'EXAMPLE-hostname-Value',
port: 60_397,
username: 'EXAMPLE-username-Value',
password: 'EXAMPLE-password-Value',
ssl_mode: 'REQUIRED',
ssl_ca_certificate:
OCI::Mysql::Models::PemCaCertificate.new(
certificate_type: 'PEM', contents: 'EXAMPLE-contents-Value'
),
anonymous_transactions_handling:
OCI::Mysql::Models::AssignTargetUuidHandling.new(
policy: 'ASSIGN_TARGET_UUID',
last_configured_log_filename:
'EXAMPLE-lastConfiguredLogFilename-Value',
last_configured_log_offset: 3_228_183_572
)
),
target:
OCI::Mysql::Models::UpdateChannelTargetFromDbSystemDetails.new(
target_type: 'DBSYSTEM',
channel_name: 'EXAMPLE-channelName-Value',
applier_username: 'EXAMPLE-applierUsername-Value',
filters: [
OCI::Mysql::Models::ChannelFilter.new(
type: 'REPLICATE_REWRITE_DB', value: 'EXAMPLE-value-Value'
)
],
tables_without_primary_key_handling: 'RAISE_ERROR',
delay_in_seconds: 572_049_762
),
display_name: 'EXAMPLE-displayName-Value',
is_enabled: false,
description: 'EXAMPLE-description-Value',
freeform_tags: {
'EXAMPLE_KEY_EW2QR' => 'EXAMPLE_VALUE_n6sPUFPwXbgO83qMAJLJ'
},
defined_tags: {
'EXAMPLE_KEY_2BCAu' => { 'EXAMPLE_KEY_imFde' => 'EXAMPLE--Value' }
}
)
)
# Get the data from response
puts "#{update_channel_response.headers}"