TaskSummaryFromSQLTask¶

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

Bases: oci.data_integration.models.task_summary.TaskSummary

The information about the SQL task.

Attributes

`MODEL_TYPE_DATA_LOADER_TASK`	str(object=’’) -> str
`MODEL_TYPE_INTEGRATION_TASK`	str(object=’’) -> str
`MODEL_TYPE_OCI_DATAFLOW_TASK`	str(object=’’) -> str
`MODEL_TYPE_PIPELINE_TASK`	str(object=’’) -> str
`MODEL_TYPE_REST_TASK`	str(object=’’) -> str
`MODEL_TYPE_SQL_TASK`	str(object=’’) -> str
`SQL_SCRIPT_TYPE_SQL_CODE`	A constant which can be used with the sql_script_type property of a TaskSummaryFromSQLTask.
`SQL_SCRIPT_TYPE_STORED_PROCEDURE`	A constant which can be used with the sql_script_type property of a TaskSummaryFromSQLTask.
`config_provider_delegate`	Gets the config_provider_delegate of this TaskSummary.
`description`	Gets the description of this TaskSummary.
`identifier`	Gets the identifier of this TaskSummary.
`input_ports`	Gets the input_ports of this TaskSummary.
`is_concurrent_allowed`	Gets the is_concurrent_allowed of this TaskSummary.
`key`	Gets the key of this TaskSummary.
`key_map`	Gets the key_map of this TaskSummary.
`metadata`	Gets the metadata of this TaskSummary.
`model_type`	Gets the model_type of this TaskSummary.
`model_version`	Gets the model_version of this TaskSummary.
`name`	Gets the name of this TaskSummary.
`object_status`	Gets the object_status of this TaskSummary.
`object_version`	Gets the object_version of this TaskSummary.
`op_config_values`	Gets the op_config_values of this TaskSummary.
`operation`	Gets the operation of this TaskSummaryFromSQLTask.
`output_ports`	Gets the output_ports of this TaskSummary.
`parameters`	Gets the parameters of this TaskSummary.
`parent_ref`	Gets the parent_ref of this TaskSummary.
`script`	Gets the script of this TaskSummaryFromSQLTask.
`sql_script_type`	Gets the sql_script_type of this TaskSummaryFromSQLTask.

Methods

`__init__`(**kwargs)	Initializes a new TaskSummaryFromSQLTask 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_DATA_LOADER_TASK = 'DATA_LOADER_TASK'¶

MODEL_TYPE_INTEGRATION_TASK = 'INTEGRATION_TASK'¶

MODEL_TYPE_OCI_DATAFLOW_TASK = 'OCI_DATAFLOW_TASK'¶

MODEL_TYPE_PIPELINE_TASK = 'PIPELINE_TASK'¶

MODEL_TYPE_REST_TASK = 'REST_TASK'¶

MODEL_TYPE_SQL_TASK = 'SQL_TASK'¶

SQL_SCRIPT_TYPE_SQL_CODE = 'SQL_CODE'¶: A constant which can be used with the sql_script_type property of a TaskSummaryFromSQLTask. This constant has a value of “SQL_CODE”

SQL_SCRIPT_TYPE_STORED_PROCEDURE = 'STORED_PROCEDURE'¶: A constant which can be used with the sql_script_type property of a TaskSummaryFromSQLTask. This constant has a value of “STORED_PROCEDURE”

__init__(**kwargs)¶

Initializes a new TaskSummaryFromSQLTask object with values from keyword arguments. The default value of the model_type attribute of this class is SQL_TASK 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 TaskSummaryFromSQLTask. Allowed values for this property are: “INTEGRATION_TASK”, “DATA_LOADER_TASK”, “PIPELINE_TASK”, “SQL_TASK”, “OCI_DATAFLOW_TASK”, “REST_TASK”
key (str) – The value to assign to the key property of this TaskSummaryFromSQLTask.
model_version (str) – The value to assign to the model_version property of this TaskSummaryFromSQLTask.
parent_ref (oci.data_integration.models.ParentReference) – The value to assign to the parent_ref property of this TaskSummaryFromSQLTask.
name (str) – The value to assign to the name property of this TaskSummaryFromSQLTask.
description (str) – The value to assign to the description property of this TaskSummaryFromSQLTask.
object_version (int) – The value to assign to the object_version property of this TaskSummaryFromSQLTask.
object_status (int) – The value to assign to the object_status property of this TaskSummaryFromSQLTask.
identifier (str) – The value to assign to the identifier property of this TaskSummaryFromSQLTask.
input_ports (list[oci.data_integration.models.InputPort]) – The value to assign to the input_ports property of this TaskSummaryFromSQLTask.
output_ports (list[oci.data_integration.models.OutputPort]) – The value to assign to the output_ports property of this TaskSummaryFromSQLTask.
parameters (list[oci.data_integration.models.Parameter]) – The value to assign to the parameters property of this TaskSummaryFromSQLTask.
op_config_values (oci.data_integration.models.ConfigValues) – The value to assign to the op_config_values property of this TaskSummaryFromSQLTask.
config_provider_delegate (oci.data_integration.models.ConfigProvider) – The value to assign to the config_provider_delegate property of this TaskSummaryFromSQLTask.
is_concurrent_allowed (bool) – The value to assign to the is_concurrent_allowed property of this TaskSummaryFromSQLTask.
metadata (oci.data_integration.models.ObjectMetadata) – The value to assign to the metadata property of this TaskSummaryFromSQLTask.
key_map (dict(str, str)) – The value to assign to the key_map property of this TaskSummaryFromSQLTask.
script (oci.data_integration.models.Script) – The value to assign to the script property of this TaskSummaryFromSQLTask.
sql_script_type (str) – The value to assign to the sql_script_type property of this TaskSummaryFromSQLTask. Allowed values for this property are: “STORED_PROCEDURE”, “SQL_CODE”
operation (object) – The value to assign to the operation property of this TaskSummaryFromSQLTask.

config_provider_delegate¶

Gets the config_provider_delegate of this TaskSummary.

Returns:	The config_provider_delegate of this TaskSummary.
Return type:	oci.data_integration.models.ConfigProvider

description¶

Gets the description of this TaskSummary. Detailed description for the object.

Returns:	The description of this TaskSummary.
Return type:	str

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.

identifier¶

Gets the identifier of this TaskSummary. Value can only contain upper case letters, underscore, and numbers. It should begin with upper case letter or underscore. The value can be modified.

Returns:	The identifier of this TaskSummary.
Return type:	str

input_ports¶

Gets the input_ports of this TaskSummary. An array of input ports.

Returns:	The input_ports of this TaskSummary.
Return type:	list[oci.data_integration.models.InputPort]

is_concurrent_allowed¶

Gets the is_concurrent_allowed of this TaskSummary. Whether the same task can be executed concurrently.

Returns:	The is_concurrent_allowed of this TaskSummary.
Return type:	bool

key¶

Gets the key of this TaskSummary. Generated key that can be used in API calls to identify task. On scenarios where reference to the task is needed, a value can be passed in create.

Returns:	The key of this TaskSummary.
Return type:	str

key_map¶

Gets the key_map of this TaskSummary. A key map. If provided, key is replaced with generated key. This structure provides mapping between user provided key and generated key.

Returns:	The key_map of this TaskSummary.
Return type:	dict(str, str)

metadata¶

Gets the metadata of this TaskSummary.

Returns:	The metadata of this TaskSummary.
Return type:	oci.data_integration.models.ObjectMetadata

model_type¶

Gets the model_type of this TaskSummary. The type of task.

Allowed values for this property are: “INTEGRATION_TASK”, “DATA_LOADER_TASK”, “PIPELINE_TASK”, “SQL_TASK”, “OCI_DATAFLOW_TASK”, “REST_TASK”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

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

model_version¶

Gets the model_version of this TaskSummary. The object’s model version.

Returns:	The model_version of this TaskSummary.
Return type:	str

name¶

Gets the name of this TaskSummary. 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.

Returns:	The name of this TaskSummary.
Return type:	str

object_status¶

Gets the object_status of this TaskSummary. The status of an object that can be set to value 1 for shallow references across objects, other values reserved.

Returns:	The object_status of this TaskSummary.
Return type:	int

object_version¶

Gets the object_version of this TaskSummary. The version of the object that is used to track changes in the object instance.

Returns:	The object_version of this TaskSummary.
Return type:	int

op_config_values¶

Gets the op_config_values of this TaskSummary.

Returns:	The op_config_values of this TaskSummary.
Return type:	oci.data_integration.models.ConfigValues

operation¶

Gets the operation of this TaskSummaryFromSQLTask. Describes the shape of the execution result

Returns:	The operation of this TaskSummaryFromSQLTask.
Return type:	object

output_ports¶

Gets the output_ports of this TaskSummary. An array of output ports.

Returns:	The output_ports of this TaskSummary.
Return type:	list[oci.data_integration.models.OutputPort]

parameters¶

Gets the parameters of this TaskSummary. An array of parameters.

Returns:	The parameters of this TaskSummary.
Return type:	list[oci.data_integration.models.Parameter]

parent_ref¶

Gets the parent_ref of this TaskSummary.

Returns:	The parent_ref of this TaskSummary.
Return type:	oci.data_integration.models.ParentReference

script¶

Gets the script of this TaskSummaryFromSQLTask.

Returns:	The script of this TaskSummaryFromSQLTask.
Return type:	oci.data_integration.models.Script

sql_script_type¶

Gets the sql_script_type of this TaskSummaryFromSQLTask. Indicates whether the task is invoking a custom SQL script or stored procedure.

Allowed values for this property are: “STORED_PROCEDURE”, “SQL_CODE”

Returns:	The sql_script_type of this TaskSummaryFromSQLTask.
Return type:	str