Select¶

class oci.data_integration.models.Select(**kwargs)¶

Bases: oci.data_integration.models.push_down_operation.PushDownOperation

The information about the select object.

Attributes

`MODEL_TYPE_FILTER`	str(object=’’) -> str
`MODEL_TYPE_JOIN`	str(object=’’) -> str
`MODEL_TYPE_QUERY`	str(object=’’) -> str
`MODEL_TYPE_SELECT`	str(object=’’) -> str
`MODEL_TYPE_SORT`	str(object=’’) -> str
`is_distinct`	Gets the is_distinct of this Select.
`model_type`	[Required] Gets the model_type of this PushDownOperation.
`select_columns`	Gets the select_columns of this Select.

Methods

`__init__`(**kwargs)	Initializes a new Select 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.

MODEL_TYPE_FILTER = 'FILTER'¶

MODEL_TYPE_JOIN = 'JOIN'¶

MODEL_TYPE_QUERY = 'QUERY'¶

MODEL_TYPE_SELECT = 'SELECT'¶

MODEL_TYPE_SORT = 'SORT'¶

__init__(**kwargs)¶

Initializes a new Select object with values from keyword arguments. The default value of the model_type attribute of this class is SELECT and it should not be changed. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:

model_type (str) – The value to assign to the model_type property of this Select. Allowed values for this property are: “FILTER”, “JOIN”, “SELECT”, “SORT”, “QUERY”
is_distinct (bool) – The value to assign to the is_distinct property of this Select.
select_columns (list[oci.data_integration.models.ShapeField]) – The value to assign to the select_columns property of this Select.

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.

is_distinct¶

Gets the is_distinct of this Select. Specifies whether the object is distinct.

Returns:	The is_distinct of this Select.
Return type:	bool

model_type¶

[Required] Gets the model_type of this PushDownOperation. The type of operation.

Allowed values for this property are: “FILTER”, “JOIN”, “SELECT”, “SORT”, “QUERY”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The model_type of this PushDownOperation.
Return type:	str

select_columns¶

Gets the select_columns of this Select. An array of selected columns.

Returns:	The select_columns of this Select.
Return type:	list[oci.data_integration.models.ShapeField]