File: //lib/mysqlsh/lib/python3.8/site-packages/oci/data_integration/models/pivot.py
# coding: utf-8
# Copyright (c) 2016, 2025, 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 .operator import Operator
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 Pivot(Operator):
"""
Pivot operator has one input and one output. Pivot operator takes group by columns, a pivot key with values and aggregations. Output is the pivoted table.
"""
def __init__(self, **kwargs):
"""
Initializes a new Pivot object with values from keyword arguments. The default value of the :py:attr:`~oci.data_integration.models.Pivot.model_type` attribute
of this class is ``PIVOT_OPERATOR`` 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 Pivot.
Allowed values for this property are: "SOURCE_OPERATOR", "FILTER_OPERATOR", "JOINER_OPERATOR", "AGGREGATOR_OPERATOR", "PROJECTION_OPERATOR", "TARGET_OPERATOR", "FLATTEN_OPERATOR", "DISTINCT_OPERATOR", "SORT_OPERATOR", "UNION_OPERATOR", "INTERSECT_OPERATOR", "MINUS_OPERATOR", "MERGE_OPERATOR", "FUNCTION_OPERATOR", "SPLIT_OPERATOR", "START_OPERATOR", "END_OPERATOR", "PIPELINE_OPERATOR", "DECISION_OPERATOR", "TASK_OPERATOR", "EXPRESSION_OPERATOR", "LOOKUP_OPERATOR", "PIVOT_OPERATOR"
:type model_type: str
:param key:
The value to assign to the key property of this Pivot.
:type key: str
:param model_version:
The value to assign to the model_version property of this Pivot.
:type model_version: str
:param parent_ref:
The value to assign to the parent_ref property of this Pivot.
:type parent_ref: oci.data_integration.models.ParentReference
:param name:
The value to assign to the name property of this Pivot.
:type name: str
:param description:
The value to assign to the description property of this Pivot.
:type description: str
:param object_version:
The value to assign to the object_version property of this Pivot.
:type object_version: int
:param input_ports:
The value to assign to the input_ports property of this Pivot.
:type input_ports: list[oci.data_integration.models.InputPort]
:param output_ports:
The value to assign to the output_ports property of this Pivot.
:type output_ports: list[oci.data_integration.models.TypedObject]
:param object_status:
The value to assign to the object_status property of this Pivot.
:type object_status: int
:param identifier:
The value to assign to the identifier property of this Pivot.
:type identifier: str
:param parameters:
The value to assign to the parameters property of this Pivot.
:type parameters: list[oci.data_integration.models.Parameter]
:param op_config_values:
The value to assign to the op_config_values property of this Pivot.
:type op_config_values: oci.data_integration.models.ConfigValues
:param group_by_columns:
The value to assign to the group_by_columns property of this Pivot.
:type group_by_columns: oci.data_integration.models.DynamicProxyField
:param materialized_group_by_columns:
The value to assign to the materialized_group_by_columns property of this Pivot.
:type materialized_group_by_columns: oci.data_integration.models.MaterializedDynamicField
:param pivot_keys:
The value to assign to the pivot_keys property of this Pivot.
:type pivot_keys: oci.data_integration.models.PivotKeys
"""
self.swagger_types = {
'model_type': 'str',
'key': 'str',
'model_version': 'str',
'parent_ref': 'ParentReference',
'name': 'str',
'description': 'str',
'object_version': 'int',
'input_ports': 'list[InputPort]',
'output_ports': 'list[TypedObject]',
'object_status': 'int',
'identifier': 'str',
'parameters': 'list[Parameter]',
'op_config_values': 'ConfigValues',
'group_by_columns': 'DynamicProxyField',
'materialized_group_by_columns': 'MaterializedDynamicField',
'pivot_keys': 'PivotKeys'
}
self.attribute_map = {
'model_type': 'modelType',
'key': 'key',
'model_version': 'modelVersion',
'parent_ref': 'parentRef',
'name': 'name',
'description': 'description',
'object_version': 'objectVersion',
'input_ports': 'inputPorts',
'output_ports': 'outputPorts',
'object_status': 'objectStatus',
'identifier': 'identifier',
'parameters': 'parameters',
'op_config_values': 'opConfigValues',
'group_by_columns': 'groupByColumns',
'materialized_group_by_columns': 'materializedGroupByColumns',
'pivot_keys': 'pivotKeys'
}
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._input_ports = None
self._output_ports = None
self._object_status = None
self._identifier = None
self._parameters = None
self._op_config_values = None
self._group_by_columns = None
self._materialized_group_by_columns = None
self._pivot_keys = None
self._model_type = 'PIVOT_OPERATOR'
@property
def group_by_columns(self):
"""
Gets the group_by_columns of this Pivot.
:return: The group_by_columns of this Pivot.
:rtype: oci.data_integration.models.DynamicProxyField
"""
return self._group_by_columns
@group_by_columns.setter
def group_by_columns(self, group_by_columns):
"""
Sets the group_by_columns of this Pivot.
:param group_by_columns: The group_by_columns of this Pivot.
:type: oci.data_integration.models.DynamicProxyField
"""
self._group_by_columns = group_by_columns
@property
def materialized_group_by_columns(self):
"""
Gets the materialized_group_by_columns of this Pivot.
:return: The materialized_group_by_columns of this Pivot.
:rtype: oci.data_integration.models.MaterializedDynamicField
"""
return self._materialized_group_by_columns
@materialized_group_by_columns.setter
def materialized_group_by_columns(self, materialized_group_by_columns):
"""
Sets the materialized_group_by_columns of this Pivot.
:param materialized_group_by_columns: The materialized_group_by_columns of this Pivot.
:type: oci.data_integration.models.MaterializedDynamicField
"""
self._materialized_group_by_columns = materialized_group_by_columns
@property
def pivot_keys(self):
"""
Gets the pivot_keys of this Pivot.
:return: The pivot_keys of this Pivot.
:rtype: oci.data_integration.models.PivotKeys
"""
return self._pivot_keys
@pivot_keys.setter
def pivot_keys(self, pivot_keys):
"""
Sets the pivot_keys of this Pivot.
:param pivot_keys: The pivot_keys of this Pivot.
:type: oci.data_integration.models.PivotKeys
"""
self._pivot_keys = pivot_keys
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