Select

class oci.data_connectivity.models.Select(**kwargs)

Bases: oci.data_connectivity.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 [Required] 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_connectivity.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”

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

[Required] Gets the select_columns of this Select. An array of selected columns.

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