# 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: 34_918,
          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::ErrorOnAnonymousHandling.new(
              policy: 'ERROR_ON_ANONYMOUS'
            )
        ),
      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_DO_TABLE', value: 'EXAMPLE-value-Value'
            )
          ],
          tables_without_primary_key_handling: 'RAISE_ERROR',
          delay_in_seconds: 1_704_210_908
        ),
      display_name: 'EXAMPLE-displayName-Value',
      is_enabled: false,
      description: 'EXAMPLE-description-Value',
      freeform_tags: {
        'EXAMPLE_KEY_2Fuql' => 'EXAMPLE_VALUE_ii15xQXJ8S1p1mMSnFet'
      },
      defined_tags: {
        'EXAMPLE_KEY_K2i3X' => { 'EXAMPLE_KEY_4TTSh' => 'EXAMPLE--Value' }
      }
    )
  )

# Get the data from response
puts "#{update_channel_response.headers}"