<h2>Edit File: data_entity_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 .data_entity import DataEntity
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 DataEntityFromSql(DataEntity):
    &quot;&quot;&quot;
    The sql entity data entity details.
    &quot;&quot;&quot;

    #: A constant which can be used with the entity_type property of a DataEntityFromSql.
    #: 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 DataEntityFromSql.
    #: 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 DataEntityFromSql.
    #: 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 DataEntityFromSql.
    #: 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 DataEntityFromSql object with values from keyword arguments. The default value of the :py:attr:`~oci.data_integration.models.DataEntityFromSql.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 DataEntityFromSql.
            Allowed values for this property are: &quot;VIEW_ENTITY&quot;, &quot;TABLE_ENTITY&quot;, &quot;FILE_ENTITY&quot;, &quot;SQL_ENTITY&quot;, &quot;OBJECT_ENTITY&quot;, &quot;DATA_STORE_ENTITY&quot;, &quot;DERIVED_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 DataEntityFromSql.
        :type metadata: oci.data_integration.models.ObjectMetadata

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

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

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

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

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

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

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

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

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

        :param entity_type:
            The value to assign to the entity_type property of this DataEntityFromSql.
            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 DataEntityFromSql.
        :type other_type_label: str

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

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

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

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

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

        :param sql_query:
            The value to assign to the sql_query property of this DataEntityFromSql.
        :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;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;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._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 DataEntityFromSql.
        The object key.


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

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


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

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


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


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

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

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

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

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

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


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

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


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

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


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


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

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


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


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

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

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

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


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


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

    @property
    def entity_type(self):
        &quot;&quot;&quot;
        Gets the entity_type of this DataEntityFromSql.
        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 DataEntityFromSql.
        :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 DataEntityFromSql.
        The entity type.


        :param entity_type: The entity_type of this DataEntityFromSql.
        :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 DataEntityFromSql.
        Specifies other type label.


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


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


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


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


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


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


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


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

    @property
    def object_status(self):
        &quot;&quot;&quot;
        Gets the object_status of this DataEntityFromSql.
        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 DataEntityFromSql.
        :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 DataEntityFromSql.
        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 DataEntityFromSql.
        :type: int
        &quot;&quot;&quot;
        self._object_status = object_status

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

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

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


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


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