# 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
create_channel_response =
  mysql_client.create_channel(
    OCI::Mysql::Models::CreateChannelDetails.new(
      source:
        OCI::Mysql::Models::CreateChannelSourceFromMysqlDetails.new(
          source_type: 'MYSQL',
          hostname: 'EXAMPLE-hostname-Value',
          username: 'EXAMPLE-username-Value',
          password: 'EXAMPLE-password-Value',
          ssl_mode: 'VERIFY_CA',
          port: 51_947,
          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: 907_155_302
            )
        ),
      target:
        OCI::Mysql::Models::CreateChannelTargetFromDbSystemDetails.new(
          target_type: 'DBSYSTEM',
          db_system_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-dbSystemId-Value',
          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: 169_042_371
        ),
      compartment_id: 'ocid1.test.oc1..<unique_ID>EXAMPLE-compartmentId-Value',
      display_name: 'EXAMPLE-displayName-Value',
      is_enabled: false,
      description: 'EXAMPLE-description-Value',
      freeform_tags: {
        'EXAMPLE_KEY_iBHfS' => 'EXAMPLE_VALUE_O9cD4SkORzRcCWisRrRT'
      },
      defined_tags: {
        'EXAMPLE_KEY_b2F0w' => { 'EXAMPLE_KEY_2xbyr' => 'EXAMPLE--Value' }
      }
    )
  )

# Get the data from response
puts "#{create_channel_response.data}"