ChannelTargetDbSystem

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

Bases: oci.mysql.models.channel_target.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 str(object=’’) -> str
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'
__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.
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
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
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
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
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.

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
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