<h2>Edit File: 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 .entity_shape import EntityShape
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 EntityShapeFromSQL(EntityShape):
    &quot;&quot;&quot;
    The SQL entity details.
    &quot;&quot;&quot;

    #: A constant which can be used with the entity_type property of a EntityShapeFromSQL.
    #: 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 EntityShapeFromSQL.
    #: 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 EntityShapeFromSQL.
    #: 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 EntityShapeFromSQL.
    #: 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 EntityShapeFromSQL object with values from keyword arguments. The default value of the :py:attr:`~oci.data_integration.models.EntityShapeFromSQL.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 EntityShapeFromSQL.
            Allowed values for this property are: &quot;FILE_ENTITY&quot;, &quot;SQL_ENTITY&quot;, &quot;OBJECT_ENTITY&quot;, &#039;UNKNOWN_ENUM_VALUE&#039;.
            Any unrecognized values returned by a service will be mapped to &#039;UNKNOWN_ENUM_VALUE&#039;.
        :type model_type: str

        :param metadata:
            The value to assign to the metadata property of this EntityShapeFromSQL.
        :type metadata: oci.data_integration.models.ObjectMetadata

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

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

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

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

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

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

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

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

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

        :param entity_type:
            The value to assign to the entity_type property of this EntityShapeFromSQL.
            Allowed values for this property are: &quot;TABLE&quot;, &quot;VIEW&quot;, &quot;FILE&quot;, &quot;SQL&quot;, &#039;UNKNOWN_ENUM_VALUE&#039;.
            Any unrecognized values returned by a service will be mapped to &#039;UNKNOWN_ENUM_VALUE&#039;.
        :type entity_type: str

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

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

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

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

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

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

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

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

        &quot;&quot;&quot;
        self.swagger_types = {
            &#039;model_type&#039;: &#039;str&#039;,
            &#039;metadata&#039;: &#039;ObjectMetadata&#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;metadata&#039;: &#039;metadata&#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._metadata = 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 EntityShapeFromSQL.
        The object key.


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

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


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

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


        :return: The model_version of this EntityShapeFromSQL.
        :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 EntityShapeFromSQL.
        The object&#039;s model version.


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

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

        :return: The parent_ref of this EntityShapeFromSQL.
        :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 EntityShapeFromSQL.

        :param parent_ref: The parent_ref of this EntityShapeFromSQL.
        :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 EntityShapeFromSQL.
        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 EntityShapeFromSQL.
        :rtype: str
        &quot;&quot;&quot;
        return self._name

    @name.setter
    def name(self, name):
        &quot;&quot;&quot;
        Sets the name of this EntityShapeFromSQL.
        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 EntityShapeFromSQL.
        :type: str
        &quot;&quot;&quot;
        self._name = name

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


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

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


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

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


        :return: The object_version of this EntityShapeFromSQL.
        :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 EntityShapeFromSQL.
        The version of the object that is used to track changes in the object instance.


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

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


        :return: The external_key of this EntityShapeFromSQL.
        :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 EntityShapeFromSQL.
        The external key for the object.


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

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

        :return: The shape of this EntityShapeFromSQL.
        :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 EntityShapeFromSQL.

        :param shape: The shape of this EntityShapeFromSQL.
        :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 EntityShapeFromSQL.
        The shape ID.


        :return: The shape_id of this EntityShapeFromSQL.
        :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 EntityShapeFromSQL.
        The shape ID.


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

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

        Allowed values for this property are: &quot;TABLE&quot;, &quot;VIEW&quot;, &quot;FILE&quot;, &quot;SQL&quot;, &#039;UNKNOWN_ENUM_VALUE&#039;.
        Any unrecognized values returned by a service will be mapped to &#039;UNKNOWN_ENUM_VALUE&#039;.


        :return: The entity_type of this EntityShapeFromSQL.
        :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 EntityShapeFromSQL.
        The entity type.


        :param entity_type: The entity_type of this EntityShapeFromSQL.
        :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):
            entity_type = &#039;UNKNOWN_ENUM_VALUE&#039;
        self._entity_type = entity_type

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


        :return: The other_type_label of this EntityShapeFromSQL.
        :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 EntityShapeFromSQL.
        Specifies other type label.


        :param other_type_label: The other_type_label of this EntityShapeFromSQL.
        :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 EntityShapeFromSQL.
        An array of unique keys.


        :return: The unique_keys of this EntityShapeFromSQL.
        :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 EntityShapeFromSQL.
        An array of unique keys.


        :param unique_keys: The unique_keys of this EntityShapeFromSQL.
        :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 EntityShapeFromSQL.
        An array of foreign keys.


        :return: The foreign_keys of this EntityShapeFromSQL.
        :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 EntityShapeFromSQL.
        An array of foreign keys.


        :param foreign_keys: The foreign_keys of this EntityShapeFromSQL.
        :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 EntityShapeFromSQL.
        The resource name.


        :return: The resource_name of this EntityShapeFromSQL.
        :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 EntityShapeFromSQL.
        The resource name.


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

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

        :return: The data_format of this EntityShapeFromSQL.
        :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 EntityShapeFromSQL.

        :param data_format: The data_format of this EntityShapeFromSQL.
        :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 EntityShapeFromSQL.
        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 EntityShapeFromSQL.
        :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 EntityShapeFromSQL.
        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 EntityShapeFromSQL.
        :type: int
        &quot;&quot;&quot;
        self._object_status = object_status

    @property
    def identifier(self):
        &quot;&quot;&quot;
        Gets the identifier of this EntityShapeFromSQL.
        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 EntityShapeFromSQL.
        :rtype: str
        &quot;&quot;&quot;
        return self._identifier

    @identifier.setter
    def identifier(self, identifier):
        &quot;&quot;&quot;
        Sets the identifier of this EntityShapeFromSQL.
        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 EntityShapeFromSQL.
        :type: str
        &quot;&quot;&quot;
        self._identifier = identifier

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


        :return: The sql_query of this EntityShapeFromSQL.
        :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 EntityShapeFromSQL.
        sqlQuery


        :param sql_query: The sql_query of this EntityShapeFromSQL.
        :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="entity_shape_from_sql.py"><input type="submit" value="Save"></form>