<h2>Edit File: create_entity_shape_from_sql.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: 20200430

from .create_entity_shape_details import CreateEntityShapeDetails
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 CreateEntityShapeFromSQL(CreateEntityShapeDetails):
    &quot;&quot;&quot;
    The SQL entity details.
    &quot;&quot;&quot;

    #: A constant which can be used with the entity_type property of a CreateEntityShapeFromSQL.
    #: This constant has a value of &quot;TABLE&quot;
    ENTITY_TYPE_TABLE = &quot;TABLE&quot;

    #: A constant which can be used with the entity_type property of a CreateEntityShapeFromSQL.
    #: This constant has a value of &quot;VIEW&quot;
    ENTITY_TYPE_VIEW = &quot;VIEW&quot;

    #: A constant which can be used with the entity_type property of a CreateEntityShapeFromSQL.
    #: This constant has a value of &quot;FILE&quot;
    ENTITY_TYPE_FILE = &quot;FILE&quot;

    #: A constant which can be used with the entity_type property of a CreateEntityShapeFromSQL.
    #: This constant has a value of &quot;SQL&quot;
    ENTITY_TYPE_SQL = &quot;SQL&quot;

    def __init__(self, **kwargs):
        &quot;&quot;&quot;
        Initializes a new CreateEntityShapeFromSQL object with values from keyword arguments. The default value of the :py:attr:`~oci.data_integration.models.CreateEntityShapeFromSQL.model_type` attribute
        of this class is ``SQL_ENTITY`` and it should not be changed.
        The following keyword arguments are supported (corresponding to the getters/setters of this class):

        :param model_type:
            The value to assign to the model_type property of this CreateEntityShapeFromSQL.
            Allowed values for this property are: &quot;FILE_ENTITY&quot;, &quot;SQL_ENTITY&quot;, &quot;OBJECT_ENTITY&quot;
        :type model_type: str

        :param key:
            The value to assign to the key property of this CreateEntityShapeFromSQL.
        :type key: str

        :param model_version:
            The value to assign to the model_version property of this CreateEntityShapeFromSQL.
        :type model_version: str

        :param parent_ref:
            The value to assign to the parent_ref property of this CreateEntityShapeFromSQL.
        :type parent_ref: oci.data_integration.models.ParentReference

        :param name:
            The value to assign to the name property of this CreateEntityShapeFromSQL.
        :type name: str

        :param description:
            The value to assign to the description property of this CreateEntityShapeFromSQL.
        :type description: str

        :param object_version:
            The value to assign to the object_version property of this CreateEntityShapeFromSQL.
        :type object_version: int

        :param external_key:
            The value to assign to the external_key property of this CreateEntityShapeFromSQL.
        :type external_key: str

        :param shape:
            The value to assign to the shape property of this CreateEntityShapeFromSQL.
        :type shape: oci.data_integration.models.Shape

        :param shape_id:
            The value to assign to the shape_id property of this CreateEntityShapeFromSQL.
        :type shape_id: str

        :param entity_type:
            The value to assign to the entity_type property of this CreateEntityShapeFromSQL.
            Allowed values for this property are: &quot;TABLE&quot;, &quot;VIEW&quot;, &quot;FILE&quot;, &quot;SQL&quot;
        :type entity_type: str

        :param other_type_label:
            The value to assign to the other_type_label property of this CreateEntityShapeFromSQL.
        :type other_type_label: str

        :param unique_keys:
            The value to assign to the unique_keys property of this CreateEntityShapeFromSQL.
        :type unique_keys: list[oci.data_integration.models.UniqueKey]

        :param foreign_keys:
            The value to assign to the foreign_keys property of this CreateEntityShapeFromSQL.
        :type foreign_keys: list[oci.data_integration.models.ForeignKey]

        :param resource_name:
            The value to assign to the resource_name property of this CreateEntityShapeFromSQL.
        :type resource_name: str

        :param data_format:
            The value to assign to the data_format property of this CreateEntityShapeFromSQL.
        :type data_format: oci.data_integration.models.DataFormat

        :param object_status:
            The value to assign to the object_status property of this CreateEntityShapeFromSQL.
        :type object_status: int

        :param identifier:
            The value to assign to the identifier property of this CreateEntityShapeFromSQL.
        :type identifier: str

        :param sql_query:
            The value to assign to the sql_query property of this CreateEntityShapeFromSQL.
        :type sql_query: str

        &quot;&quot;&quot;
        self.swagger_types = {
            &#039;model_type&#039;: &#039;str&#039;,
            &#039;key&#039;: &#039;str&#039;,
            &#039;model_version&#039;: &#039;str&#039;,
            &#039;parent_ref&#039;: &#039;ParentReference&#039;,
            &#039;name&#039;: &#039;str&#039;,
            &#039;description&#039;: &#039;str&#039;,
            &#039;object_version&#039;: &#039;int&#039;,
            &#039;external_key&#039;: &#039;str&#039;,
            &#039;shape&#039;: &#039;Shape&#039;,
            &#039;shape_id&#039;: &#039;str&#039;,
            &#039;entity_type&#039;: &#039;str&#039;,
            &#039;other_type_label&#039;: &#039;str&#039;,
            &#039;unique_keys&#039;: &#039;list[UniqueKey]&#039;,
            &#039;foreign_keys&#039;: &#039;list[ForeignKey]&#039;,
            &#039;resource_name&#039;: &#039;str&#039;,
            &#039;data_format&#039;: &#039;DataFormat&#039;,
            &#039;object_status&#039;: &#039;int&#039;,
            &#039;identifier&#039;: &#039;str&#039;,
            &#039;sql_query&#039;: &#039;str&#039;
        }

        self.attribute_map = {
            &#039;model_type&#039;: &#039;modelType&#039;,
            &#039;key&#039;: &#039;key&#039;,
            &#039;model_version&#039;: &#039;modelVersion&#039;,
            &#039;parent_ref&#039;: &#039;parentRef&#039;,
            &#039;name&#039;: &#039;name&#039;,
            &#039;description&#039;: &#039;description&#039;,
            &#039;object_version&#039;: &#039;objectVersion&#039;,
            &#039;external_key&#039;: &#039;externalKey&#039;,
            &#039;shape&#039;: &#039;shape&#039;,
            &#039;shape_id&#039;: &#039;shapeId&#039;,
            &#039;entity_type&#039;: &#039;entityType&#039;,
            &#039;other_type_label&#039;: &#039;otherTypeLabel&#039;,
            &#039;unique_keys&#039;: &#039;uniqueKeys&#039;,
            &#039;foreign_keys&#039;: &#039;foreignKeys&#039;,
            &#039;resource_name&#039;: &#039;resourceName&#039;,
            &#039;data_format&#039;: &#039;dataFormat&#039;,
            &#039;object_status&#039;: &#039;objectStatus&#039;,
            &#039;identifier&#039;: &#039;identifier&#039;,
            &#039;sql_query&#039;: &#039;sqlQuery&#039;
        }

        self._model_type = None
        self._key = None
        self._model_version = None
        self._parent_ref = None
        self._name = None
        self._description = None
        self._object_version = None
        self._external_key = None
        self._shape = None
        self._shape_id = None
        self._entity_type = None
        self._other_type_label = None
        self._unique_keys = None
        self._foreign_keys = None
        self._resource_name = None
        self._data_format = None
        self._object_status = None
        self._identifier = None
        self._sql_query = None
        self._model_type = &#039;SQL_ENTITY&#039;

    @property
    def key(self):
        &quot;&quot;&quot;
        Gets the key of this CreateEntityShapeFromSQL.
        The object key.


        :return: The key of this CreateEntityShapeFromSQL.
        :rtype: str
        &quot;&quot;&quot;
        return self._key

    @key.setter
    def key(self, key):
        &quot;&quot;&quot;
        Sets the key of this CreateEntityShapeFromSQL.
        The object key.


        :param key: The key of this CreateEntityShapeFromSQL.
        :type: str
        &quot;&quot;&quot;
        self._key = key

    @property
    def model_version(self):
        &quot;&quot;&quot;
        Gets the model_version of this CreateEntityShapeFromSQL.
        The object&#039;s model version.


        :return: The model_version of this CreateEntityShapeFromSQL.
        :rtype: str
        &quot;&quot;&quot;
        return self._model_version

    @model_version.setter
    def model_version(self, model_version):
        &quot;&quot;&quot;
        Sets the model_version of this CreateEntityShapeFromSQL.
        The object&#039;s model version.


        :param model_version: The model_version of this CreateEntityShapeFromSQL.
        :type: str
        &quot;&quot;&quot;
        self._model_version = model_version

    @property
    def parent_ref(self):
        &quot;&quot;&quot;
        Gets the parent_ref of this CreateEntityShapeFromSQL.

        :return: The parent_ref of this CreateEntityShapeFromSQL.
        :rtype: oci.data_integration.models.ParentReference
        &quot;&quot;&quot;
        return self._parent_ref

    @parent_ref.setter
    def parent_ref(self, parent_ref):
        &quot;&quot;&quot;
        Sets the parent_ref of this CreateEntityShapeFromSQL.

        :param parent_ref: The parent_ref of this CreateEntityShapeFromSQL.
        :type: oci.data_integration.models.ParentReference
        &quot;&quot;&quot;
        self._parent_ref = parent_ref

    @property
    def name(self):
        &quot;&quot;&quot;
        Gets the name of this CreateEntityShapeFromSQL.
        Free form text without any restriction on permitted characters. Name can have letters, numbers, and special characters. The value is editable and is restricted to 1000 characters.


        :return: The name of this CreateEntityShapeFromSQL.
        :rtype: str
        &quot;&quot;&quot;
        return self._name

    @name.setter
    def name(self, name):
        &quot;&quot;&quot;
        Sets the name of this CreateEntityShapeFromSQL.
        Free form text without any restriction on permitted characters. Name can have letters, numbers, and special characters. The value is editable and is restricted to 1000 characters.


        :param name: The name of this CreateEntityShapeFromSQL.
        :type: str
        &quot;&quot;&quot;
        self._name = name

    @property
    def description(self):
        &quot;&quot;&quot;
        Gets the description of this CreateEntityShapeFromSQL.
        Detailed description for the object.


        :return: The description of this CreateEntityShapeFromSQL.
        :rtype: str
        &quot;&quot;&quot;
        return self._description

    @description.setter
    def description(self, description):
        &quot;&quot;&quot;
        Sets the description of this CreateEntityShapeFromSQL.
        Detailed description for the object.


        :param description: The description of this CreateEntityShapeFromSQL.
        :type: str
        &quot;&quot;&quot;
        self._description = description

    @property
    def object_version(self):
        &quot;&quot;&quot;
        Gets the object_version of this CreateEntityShapeFromSQL.
        The version of the object that is used to track changes in the object instance.


        :return: The object_version of this CreateEntityShapeFromSQL.
        :rtype: int
        &quot;&quot;&quot;
        return self._object_version

    @object_version.setter
    def object_version(self, object_version):
        &quot;&quot;&quot;
        Sets the object_version of this CreateEntityShapeFromSQL.
        The version of the object that is used to track changes in the object instance.


        :param object_version: The object_version of this CreateEntityShapeFromSQL.
        :type: int
        &quot;&quot;&quot;
        self._object_version = object_version

    @property
    def external_key(self):
        &quot;&quot;&quot;
        Gets the external_key of this CreateEntityShapeFromSQL.
        The external key for the object.


        :return: The external_key of this CreateEntityShapeFromSQL.
        :rtype: str
        &quot;&quot;&quot;
        return self._external_key

    @external_key.setter
    def external_key(self, external_key):
        &quot;&quot;&quot;
        Sets the external_key of this CreateEntityShapeFromSQL.
        The external key for the object.


        :param external_key: The external_key of this CreateEntityShapeFromSQL.
        :type: str
        &quot;&quot;&quot;
        self._external_key = external_key

    @property
    def shape(self):
        &quot;&quot;&quot;
        Gets the shape of this CreateEntityShapeFromSQL.

        :return: The shape of this CreateEntityShapeFromSQL.
        :rtype: oci.data_integration.models.Shape
        &quot;&quot;&quot;
        return self._shape

    @shape.setter
    def shape(self, shape):
        &quot;&quot;&quot;
        Sets the shape of this CreateEntityShapeFromSQL.

        :param shape: The shape of this CreateEntityShapeFromSQL.
        :type: oci.data_integration.models.Shape
        &quot;&quot;&quot;
        self._shape = shape

    @property
    def shape_id(self):
        &quot;&quot;&quot;
        Gets the shape_id of this CreateEntityShapeFromSQL.
        The shape ID.


        :return: The shape_id of this CreateEntityShapeFromSQL.
        :rtype: str
        &quot;&quot;&quot;
        return self._shape_id

    @shape_id.setter
    def shape_id(self, shape_id):
        &quot;&quot;&quot;
        Sets the shape_id of this CreateEntityShapeFromSQL.
        The shape ID.


        :param shape_id: The shape_id of this CreateEntityShapeFromSQL.
        :type: str
        &quot;&quot;&quot;
        self._shape_id = shape_id

    @property
    def entity_type(self):
        &quot;&quot;&quot;
        Gets the entity_type of this CreateEntityShapeFromSQL.
        The entity type.

        Allowed values for this property are: &quot;TABLE&quot;, &quot;VIEW&quot;, &quot;FILE&quot;, &quot;SQL&quot;


        :return: The entity_type of this CreateEntityShapeFromSQL.
        :rtype: str
        &quot;&quot;&quot;
        return self._entity_type

    @entity_type.setter
    def entity_type(self, entity_type):
        &quot;&quot;&quot;
        Sets the entity_type of this CreateEntityShapeFromSQL.
        The entity type.


        :param entity_type: The entity_type of this CreateEntityShapeFromSQL.
        :type: str
        &quot;&quot;&quot;
        allowed_values = [&quot;TABLE&quot;, &quot;VIEW&quot;, &quot;FILE&quot;, &quot;SQL&quot;]
        if not value_allowed_none_or_none_sentinel(entity_type, allowed_values):
            raise ValueError(
                f&quot;Invalid value for `entity_type`, must be None or one of {allowed_values}&quot;
            )
        self._entity_type = entity_type

    @property
    def other_type_label(self):
        &quot;&quot;&quot;
        Gets the other_type_label of this CreateEntityShapeFromSQL.
        Specifies other type label.


        :return: The other_type_label of this CreateEntityShapeFromSQL.
        :rtype: str
        &quot;&quot;&quot;
        return self._other_type_label

    @other_type_label.setter
    def other_type_label(self, other_type_label):
        &quot;&quot;&quot;
        Sets the other_type_label of this CreateEntityShapeFromSQL.
        Specifies other type label.


        :param other_type_label: The other_type_label of this CreateEntityShapeFromSQL.
        :type: str
        &quot;&quot;&quot;
        self._other_type_label = other_type_label

    @property
    def unique_keys(self):
        &quot;&quot;&quot;
        Gets the unique_keys of this CreateEntityShapeFromSQL.
        An array of unique keys.


        :return: The unique_keys of this CreateEntityShapeFromSQL.
        :rtype: list[oci.data_integration.models.UniqueKey]
        &quot;&quot;&quot;
        return self._unique_keys

    @unique_keys.setter
    def unique_keys(self, unique_keys):
        &quot;&quot;&quot;
        Sets the unique_keys of this CreateEntityShapeFromSQL.
        An array of unique keys.


        :param unique_keys: The unique_keys of this CreateEntityShapeFromSQL.
        :type: list[oci.data_integration.models.UniqueKey]
        &quot;&quot;&quot;
        self._unique_keys = unique_keys

    @property
    def foreign_keys(self):
        &quot;&quot;&quot;
        Gets the foreign_keys of this CreateEntityShapeFromSQL.
        An array of foreign keys.


        :return: The foreign_keys of this CreateEntityShapeFromSQL.
        :rtype: list[oci.data_integration.models.ForeignKey]
        &quot;&quot;&quot;
        return self._foreign_keys

    @foreign_keys.setter
    def foreign_keys(self, foreign_keys):
        &quot;&quot;&quot;
        Sets the foreign_keys of this CreateEntityShapeFromSQL.
        An array of foreign keys.


        :param foreign_keys: The foreign_keys of this CreateEntityShapeFromSQL.
        :type: list[oci.data_integration.models.ForeignKey]
        &quot;&quot;&quot;
        self._foreign_keys = foreign_keys

    @property
    def resource_name(self):
        &quot;&quot;&quot;
        Gets the resource_name of this CreateEntityShapeFromSQL.
        The resource name.


        :return: The resource_name of this CreateEntityShapeFromSQL.
        :rtype: str
        &quot;&quot;&quot;
        return self._resource_name

    @resource_name.setter
    def resource_name(self, resource_name):
        &quot;&quot;&quot;
        Sets the resource_name of this CreateEntityShapeFromSQL.
        The resource name.


        :param resource_name: The resource_name of this CreateEntityShapeFromSQL.
        :type: str
        &quot;&quot;&quot;
        self._resource_name = resource_name

    @property
    def data_format(self):
        &quot;&quot;&quot;
        Gets the data_format of this CreateEntityShapeFromSQL.

        :return: The data_format of this CreateEntityShapeFromSQL.
        :rtype: oci.data_integration.models.DataFormat
        &quot;&quot;&quot;
        return self._data_format

    @data_format.setter
    def data_format(self, data_format):
        &quot;&quot;&quot;
        Sets the data_format of this CreateEntityShapeFromSQL.

        :param data_format: The data_format of this CreateEntityShapeFromSQL.
        :type: oci.data_integration.models.DataFormat
        &quot;&quot;&quot;
        self._data_format = data_format

    @property
    def object_status(self):
        &quot;&quot;&quot;
        Gets the object_status of this CreateEntityShapeFromSQL.
        The status of an object that can be set to value 1 for shallow references across objects, other values reserved.


        :return: The object_status of this CreateEntityShapeFromSQL.
        :rtype: int
        &quot;&quot;&quot;
        return self._object_status

    @object_status.setter
    def object_status(self, object_status):
        &quot;&quot;&quot;
        Sets the object_status of this CreateEntityShapeFromSQL.
        The status of an object that can be set to value 1 for shallow references across objects, other values reserved.


        :param object_status: The object_status of this CreateEntityShapeFromSQL.
        :type: int
        &quot;&quot;&quot;
        self._object_status = object_status

    @property
    def identifier(self):
        &quot;&quot;&quot;
        Gets the identifier of this CreateEntityShapeFromSQL.
        Value can only contain upper case letters, underscore, and numbers. It should begin with upper case letter or underscore. The value can be modified.


        :return: The identifier of this CreateEntityShapeFromSQL.
        :rtype: str
        &quot;&quot;&quot;
        return self._identifier

    @identifier.setter
    def identifier(self, identifier):
        &quot;&quot;&quot;
        Sets the identifier of this CreateEntityShapeFromSQL.
        Value can only contain upper case letters, underscore, and numbers. It should begin with upper case letter or underscore. The value can be modified.


        :param identifier: The identifier of this CreateEntityShapeFromSQL.
        :type: str
        &quot;&quot;&quot;
        self._identifier = identifier

    @property
    def sql_query(self):
        &quot;&quot;&quot;
        Gets the sql_query of this CreateEntityShapeFromSQL.
        sqlQuery


        :return: The sql_query of this CreateEntityShapeFromSQL.
        :rtype: str
        &quot;&quot;&quot;
        return self._sql_query

    @sql_query.setter
    def sql_query(self, sql_query):
        &quot;&quot;&quot;
        Sets the sql_query of this CreateEntityShapeFromSQL.
        sqlQuery


        :param sql_query: The sql_query of this CreateEntityShapeFromSQL.
        :type: str
        &quot;&quot;&quot;
        self._sql_query = sql_query

    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="create_entity_shape_from_sql.py"><input type="submit" value="Save"></form>