ChannelTargetDbSystem

class oci.mysql.models.ChannelTargetDbSystem(**kwargs)

Bases: ChannelTarget

Core properties of a DB System Channel target.

Attributes:

TABLES_WITHOUT_PRIMARY_KEY_HANDLING_ALLOW

A constant which can be used with the tables_without_primary_key_handling property of a ChannelTargetDbSystem.

TABLES_WITHOUT_PRIMARY_KEY_HANDLING_GENERATE_IMPLICIT_PRIMARY_KEY

A constant which can be used with the tables_without_primary_key_handling property of a ChannelTargetDbSystem.

TABLES_WITHOUT_PRIMARY_KEY_HANDLING_RAISE_ERROR

A constant which can be used with the tables_without_primary_key_handling property of a ChannelTargetDbSystem.

TARGET_TYPE_DBSYSTEM

A constant which can be used with the target_type property of a ChannelTarget.

applier_username

[Required] Gets the applier_username of this ChannelTargetDbSystem.

channel_name

[Required] Gets the channel_name of this ChannelTargetDbSystem.

db_system_id

[Required] Gets the db_system_id of this ChannelTargetDbSystem.

delay_in_seconds

[Required] Gets the delay_in_seconds of this ChannelTargetDbSystem.

filters

Gets the filters of this ChannelTargetDbSystem.

tables_without_primary_key_handling

[Required] Gets the tables_without_primary_key_handling of this ChannelTargetDbSystem.

target_type

[Required] Gets the target_type of this ChannelTarget.

Methods:

__init__(**kwargs)

Initializes a new ChannelTargetDbSystem object with values from keyword arguments.

get_subtype(object_dictionary)

Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.

TABLES_WITHOUT_PRIMARY_KEY_HANDLING_ALLOW = 'ALLOW'

A constant which can be used with the tables_without_primary_key_handling property of a ChannelTargetDbSystem. This constant has a value of “ALLOW”

TABLES_WITHOUT_PRIMARY_KEY_HANDLING_GENERATE_IMPLICIT_PRIMARY_KEY = 'GENERATE_IMPLICIT_PRIMARY_KEY'

A constant which can be used with the tables_without_primary_key_handling property of a ChannelTargetDbSystem. This constant has a value of “GENERATE_IMPLICIT_PRIMARY_KEY”

TABLES_WITHOUT_PRIMARY_KEY_HANDLING_RAISE_ERROR = 'RAISE_ERROR'

A constant which can be used with the tables_without_primary_key_handling property of a ChannelTargetDbSystem. This constant has a value of “RAISE_ERROR”

TARGET_TYPE_DBSYSTEM = 'DBSYSTEM'

A constant which can be used with the target_type property of a ChannelTarget. This constant has a value of “DBSYSTEM”

__init__(**kwargs)

Initializes a new ChannelTargetDbSystem object with values from keyword arguments. The default value of the target_type attribute of this class is DBSYSTEM and it should not be changed. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters
  • target_type (str) – The value to assign to the target_type property of this ChannelTargetDbSystem. Allowed values for this property are: “DBSYSTEM”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

  • db_system_id (str) – The value to assign to the db_system_id property of this ChannelTargetDbSystem.

  • channel_name (str) – The value to assign to the channel_name property of this ChannelTargetDbSystem.

  • applier_username (str) – The value to assign to the applier_username property of this ChannelTargetDbSystem.

  • filters (list[oci.mysql.models.ChannelFilter]) – The value to assign to the filters property of this ChannelTargetDbSystem.

  • tables_without_primary_key_handling (str) – The value to assign to the tables_without_primary_key_handling property of this ChannelTargetDbSystem. Allowed values for this property are: “RAISE_ERROR”, “ALLOW”, “GENERATE_IMPLICIT_PRIMARY_KEY”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

  • delay_in_seconds (int) – The value to assign to the delay_in_seconds property of this ChannelTargetDbSystem.

property applier_username

[Required] Gets the applier_username of this ChannelTargetDbSystem. The username for the replication applier of the target MySQL DB System.

Returns

The applier_username of this ChannelTargetDbSystem.

Return type

str

property channel_name

[Required] Gets the channel_name of this ChannelTargetDbSystem. The case-insensitive name that identifies the replication channel. Channel names must follow the rules defined for MySQL identifiers. The names of non-Deleted Channels must be unique for each DB System.

Returns

The channel_name of this ChannelTargetDbSystem.

Return type

str

property db_system_id

[Required] Gets the db_system_id of this ChannelTargetDbSystem. The OCID of the source DB System.

Returns

The db_system_id of this ChannelTargetDbSystem.

Return type

str

property delay_in_seconds

[Required] Gets the delay_in_seconds of this ChannelTargetDbSystem. Specifies the amount of time, in seconds, that the channel waits before applying a transaction received from the source.

Returns

The delay_in_seconds of this ChannelTargetDbSystem.

Return type

int

property filters

Gets the filters of this ChannelTargetDbSystem. Replication filter rules to be applied at the DB System Channel target.

Returns

The filters of this ChannelTargetDbSystem.

Return type

list[oci.mysql.models.ChannelFilter]

static get_subtype(object_dictionary)

Given the hash representation of a subtype of this class, use the info in the hash to return the class of the subtype.

property tables_without_primary_key_handling

[Required] Gets the tables_without_primary_key_handling of this ChannelTargetDbSystem. Specifies how a replication channel handles the creation and alteration of tables that do not have a primary key.

Allowed values for this property are: “RAISE_ERROR”, “ALLOW”, “GENERATE_IMPLICIT_PRIMARY_KEY”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns

The tables_without_primary_key_handling of this ChannelTargetDbSystem.

Return type

str

property target_type

[Required] Gets the target_type of this ChannelTarget. The specific target identifier.

Allowed values for this property are: “DBSYSTEM”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns

The target_type of this ChannelTarget.

Return type

str