<h2>Edit File: update_my_sql_initial_load_settings.py</h2><form method="post"><textarea name="content" rows="20" cols="80"># coding: utf-8
# Copyright (c) 2016, 2024, Oracle and/or its affiliates.  All rights reserved.
# This software is dual-licensed to you under the Universal Permissive License (UPL) 1.0 as shown at https://oss.oracle.com/licenses/upl or Apache License 2.0 as shown at http://www.apache.org/licenses/LICENSE-2.0. You may choose either license.

# NOTE: This class is auto generated by OracleSDKGenerator. DO NOT EDIT. API Version: 20230518


from oci.util import formatted_flat_dict, NONE_SENTINEL, value_allowed_none_or_none_sentinel  # noqa: F401
from oci.decorators import init_model_state_from_kwargs


@init_model_state_from_kwargs
class UpdateMySqlInitialLoadSettings(object):
    &quot;&quot;&quot;
    Optional dump settings
    &quot;&quot;&quot;

    #: A constant which can be used with the primary_key_compatibility property of a UpdateMySqlInitialLoadSettings.
    #: This constant has a value of &quot;NONE&quot;
    PRIMARY_KEY_COMPATIBILITY_NONE = &quot;NONE&quot;

    #: A constant which can be used with the primary_key_compatibility property of a UpdateMySqlInitialLoadSettings.
    #: This constant has a value of &quot;IGNORE_MISSING_PKS&quot;
    PRIMARY_KEY_COMPATIBILITY_IGNORE_MISSING_PKS = &quot;IGNORE_MISSING_PKS&quot;

    #: A constant which can be used with the primary_key_compatibility property of a UpdateMySqlInitialLoadSettings.
    #: This constant has a value of &quot;CREATE_INVISIBLE_PKS&quot;
    PRIMARY_KEY_COMPATIBILITY_CREATE_INVISIBLE_PKS = &quot;CREATE_INVISIBLE_PKS&quot;

    #: A constant which can be used with the handle_grant_errors property of a UpdateMySqlInitialLoadSettings.
    #: This constant has a value of &quot;ABORT&quot;
    HANDLE_GRANT_ERRORS_ABORT = &quot;ABORT&quot;

    #: A constant which can be used with the handle_grant_errors property of a UpdateMySqlInitialLoadSettings.
    #: This constant has a value of &quot;DROP_ACCOUNT&quot;
    HANDLE_GRANT_ERRORS_DROP_ACCOUNT = &quot;DROP_ACCOUNT&quot;

    #: A constant which can be used with the handle_grant_errors property of a UpdateMySqlInitialLoadSettings.
    #: This constant has a value of &quot;IGNORE&quot;
    HANDLE_GRANT_ERRORS_IGNORE = &quot;IGNORE&quot;

    #: A constant which can be used with the job_mode property of a UpdateMySqlInitialLoadSettings.
    #: This constant has a value of &quot;FULL&quot;
    JOB_MODE_FULL = &quot;FULL&quot;

    #: A constant which can be used with the job_mode property of a UpdateMySqlInitialLoadSettings.
    #: This constant has a value of &quot;SCHEMA&quot;
    JOB_MODE_SCHEMA = &quot;SCHEMA&quot;

    def __init__(self, **kwargs):
        &quot;&quot;&quot;
        Initializes a new UpdateMySqlInitialLoadSettings object with values from keyword arguments.
        The following keyword arguments are supported (corresponding to the getters/setters of this class):

        :param is_consistent:
            The value to assign to the is_consistent property of this UpdateMySqlInitialLoadSettings.
        :type is_consistent: bool

        :param is_tz_utc:
            The value to assign to the is_tz_utc property of this UpdateMySqlInitialLoadSettings.
        :type is_tz_utc: bool

        :param compatibility:
            The value to assign to the compatibility property of this UpdateMySqlInitialLoadSettings.
        :type compatibility: list[oci.database_migration.models.CompatibilityOption]

        :param primary_key_compatibility:
            The value to assign to the primary_key_compatibility property of this UpdateMySqlInitialLoadSettings.
            Allowed values for this property are: &quot;NONE&quot;, &quot;IGNORE_MISSING_PKS&quot;, &quot;CREATE_INVISIBLE_PKS&quot;
        :type primary_key_compatibility: str

        :param is_ignore_existing_objects:
            The value to assign to the is_ignore_existing_objects property of this UpdateMySqlInitialLoadSettings.
        :type is_ignore_existing_objects: bool

        :param handle_grant_errors:
            The value to assign to the handle_grant_errors property of this UpdateMySqlInitialLoadSettings.
            Allowed values for this property are: &quot;ABORT&quot;, &quot;DROP_ACCOUNT&quot;, &quot;IGNORE&quot;
        :type handle_grant_errors: str

        :param job_mode:
            The value to assign to the job_mode property of this UpdateMySqlInitialLoadSettings.
            Allowed values for this property are: &quot;FULL&quot;, &quot;SCHEMA&quot;
        :type job_mode: str

        &quot;&quot;&quot;
        self.swagger_types = {
            &#039;is_consistent&#039;: &#039;bool&#039;,
            &#039;is_tz_utc&#039;: &#039;bool&#039;,
            &#039;compatibility&#039;: &#039;list[CompatibilityOption]&#039;,
            &#039;primary_key_compatibility&#039;: &#039;str&#039;,
            &#039;is_ignore_existing_objects&#039;: &#039;bool&#039;,
            &#039;handle_grant_errors&#039;: &#039;str&#039;,
            &#039;job_mode&#039;: &#039;str&#039;
        }

        self.attribute_map = {
            &#039;is_consistent&#039;: &#039;isConsistent&#039;,
            &#039;is_tz_utc&#039;: &#039;isTzUtc&#039;,
            &#039;compatibility&#039;: &#039;compatibility&#039;,
            &#039;primary_key_compatibility&#039;: &#039;primaryKeyCompatibility&#039;,
            &#039;is_ignore_existing_objects&#039;: &#039;isIgnoreExistingObjects&#039;,
            &#039;handle_grant_errors&#039;: &#039;handleGrantErrors&#039;,
            &#039;job_mode&#039;: &#039;jobMode&#039;
        }

        self._is_consistent = None
        self._is_tz_utc = None
        self._compatibility = None
        self._primary_key_compatibility = None
        self._is_ignore_existing_objects = None
        self._handle_grant_errors = None
        self._job_mode = None

    @property
    def is_consistent(self):
        &quot;&quot;&quot;
        Gets the is_consistent of this UpdateMySqlInitialLoadSettings.
        Enable (true) or disable (false) consistent data dumps by locking the instance for backup during the dump.


        :return: The is_consistent of this UpdateMySqlInitialLoadSettings.
        :rtype: bool
        &quot;&quot;&quot;
        return self._is_consistent

    @is_consistent.setter
    def is_consistent(self, is_consistent):
        &quot;&quot;&quot;
        Sets the is_consistent of this UpdateMySqlInitialLoadSettings.
        Enable (true) or disable (false) consistent data dumps by locking the instance for backup during the dump.


        :param is_consistent: The is_consistent of this UpdateMySqlInitialLoadSettings.
        :type: bool
        &quot;&quot;&quot;
        self._is_consistent = is_consistent

    @property
    def is_tz_utc(self):
        &quot;&quot;&quot;
        Gets the is_tz_utc of this UpdateMySqlInitialLoadSettings.
        Include a statement at the start of the dump to set the time zone to UTC.


        :return: The is_tz_utc of this UpdateMySqlInitialLoadSettings.
        :rtype: bool
        &quot;&quot;&quot;
        return self._is_tz_utc

    @is_tz_utc.setter
    def is_tz_utc(self, is_tz_utc):
        &quot;&quot;&quot;
        Sets the is_tz_utc of this UpdateMySqlInitialLoadSettings.
        Include a statement at the start of the dump to set the time zone to UTC.


        :param is_tz_utc: The is_tz_utc of this UpdateMySqlInitialLoadSettings.
        :type: bool
        &quot;&quot;&quot;
        self._is_tz_utc = is_tz_utc

    @property
    def compatibility(self):
        &quot;&quot;&quot;
        Gets the compatibility of this UpdateMySqlInitialLoadSettings.
        Apply the specified requirements for compatibility with MySQL Database Service for all tables in the dump
        output, altering the dump files as necessary.


        :return: The compatibility of this UpdateMySqlInitialLoadSettings.
        :rtype: list[oci.database_migration.models.CompatibilityOption]
        &quot;&quot;&quot;
        return self._compatibility

    @compatibility.setter
    def compatibility(self, compatibility):
        &quot;&quot;&quot;
        Sets the compatibility of this UpdateMySqlInitialLoadSettings.
        Apply the specified requirements for compatibility with MySQL Database Service for all tables in the dump
        output, altering the dump files as necessary.


        :param compatibility: The compatibility of this UpdateMySqlInitialLoadSettings.
        :type: list[oci.database_migration.models.CompatibilityOption]
        &quot;&quot;&quot;
        self._compatibility = compatibility

    @property
    def primary_key_compatibility(self):
        &quot;&quot;&quot;
        Gets the primary_key_compatibility of this UpdateMySqlInitialLoadSettings.
        Primary key compatibility option

        Allowed values for this property are: &quot;NONE&quot;, &quot;IGNORE_MISSING_PKS&quot;, &quot;CREATE_INVISIBLE_PKS&quot;


        :return: The primary_key_compatibility of this UpdateMySqlInitialLoadSettings.
        :rtype: str
        &quot;&quot;&quot;
        return self._primary_key_compatibility

    @primary_key_compatibility.setter
    def primary_key_compatibility(self, primary_key_compatibility):
        &quot;&quot;&quot;
        Sets the primary_key_compatibility of this UpdateMySqlInitialLoadSettings.
        Primary key compatibility option


        :param primary_key_compatibility: The primary_key_compatibility of this UpdateMySqlInitialLoadSettings.
        :type: str
        &quot;&quot;&quot;
        allowed_values = [&quot;NONE&quot;, &quot;IGNORE_MISSING_PKS&quot;, &quot;CREATE_INVISIBLE_PKS&quot;]
        if not value_allowed_none_or_none_sentinel(primary_key_compatibility, allowed_values):
            raise ValueError(
                f&quot;Invalid value for `primary_key_compatibility`, must be None or one of {allowed_values}&quot;
            )
        self._primary_key_compatibility = primary_key_compatibility

    @property
    def is_ignore_existing_objects(self):
        &quot;&quot;&quot;
        Gets the is_ignore_existing_objects of this UpdateMySqlInitialLoadSettings.
        Import the dump even if it contains objects that already exist in the target schema in the MySQL instance.


        :return: The is_ignore_existing_objects of this UpdateMySqlInitialLoadSettings.
        :rtype: bool
        &quot;&quot;&quot;
        return self._is_ignore_existing_objects

    @is_ignore_existing_objects.setter
    def is_ignore_existing_objects(self, is_ignore_existing_objects):
        &quot;&quot;&quot;
        Sets the is_ignore_existing_objects of this UpdateMySqlInitialLoadSettings.
        Import the dump even if it contains objects that already exist in the target schema in the MySQL instance.


        :param is_ignore_existing_objects: The is_ignore_existing_objects of this UpdateMySqlInitialLoadSettings.
        :type: bool
        &quot;&quot;&quot;
        self._is_ignore_existing_objects = is_ignore_existing_objects

    @property
    def handle_grant_errors(self):
        &quot;&quot;&quot;
        Gets the handle_grant_errors of this UpdateMySqlInitialLoadSettings.
        The action taken in the event of errors related to GRANT or REVOKE errors.

        Allowed values for this property are: &quot;ABORT&quot;, &quot;DROP_ACCOUNT&quot;, &quot;IGNORE&quot;


        :return: The handle_grant_errors of this UpdateMySqlInitialLoadSettings.
        :rtype: str
        &quot;&quot;&quot;
        return self._handle_grant_errors

    @handle_grant_errors.setter
    def handle_grant_errors(self, handle_grant_errors):
        &quot;&quot;&quot;
        Sets the handle_grant_errors of this UpdateMySqlInitialLoadSettings.
        The action taken in the event of errors related to GRANT or REVOKE errors.


        :param handle_grant_errors: The handle_grant_errors of this UpdateMySqlInitialLoadSettings.
        :type: str
        &quot;&quot;&quot;
        allowed_values = [&quot;ABORT&quot;, &quot;DROP_ACCOUNT&quot;, &quot;IGNORE&quot;]
        if not value_allowed_none_or_none_sentinel(handle_grant_errors, allowed_values):
            raise ValueError(
                f&quot;Invalid value for `handle_grant_errors`, must be None or one of {allowed_values}&quot;
            )
        self._handle_grant_errors = handle_grant_errors

    @property
    def job_mode(self):
        &quot;&quot;&quot;
        **[Required]** Gets the job_mode of this UpdateMySqlInitialLoadSettings.
        MySql Job Mode

        Allowed values for this property are: &quot;FULL&quot;, &quot;SCHEMA&quot;


        :return: The job_mode of this UpdateMySqlInitialLoadSettings.
        :rtype: str
        &quot;&quot;&quot;
        return self._job_mode

    @job_mode.setter
    def job_mode(self, job_mode):
        &quot;&quot;&quot;
        Sets the job_mode of this UpdateMySqlInitialLoadSettings.
        MySql Job Mode


        :param job_mode: The job_mode of this UpdateMySqlInitialLoadSettings.
        :type: str
        &quot;&quot;&quot;
        allowed_values = [&quot;FULL&quot;, &quot;SCHEMA&quot;]
        if not value_allowed_none_or_none_sentinel(job_mode, allowed_values):
            raise ValueError(
                f&quot;Invalid value for `job_mode`, must be None or one of {allowed_values}&quot;
            )
        self._job_mode = job_mode

    def __repr__(self):
        return formatted_flat_dict(self)

    def __eq__(self, other):
        if other is None:
            return False

        return self.__dict__ == other.__dict__

    def __ne__(self, other):
        return not self == other
</textarea><br><input type="hidden" name="edit_file" value="update_my_sql_initial_load_settings.py"><input type="submit" value="Save"></form>