SqlUpdateQueryProperties¶

class oci.stack_monitoring.models.SqlUpdateQueryProperties(**kwargs)¶

Bases: oci.stack_monitoring.models.metric_extension_update_query_properties.MetricExtensionUpdateQueryProperties

Query Properties applicable to SQL type of collection method

Attributes

`COLLECTION_METHOD_HTTP`	str(object=’’) -> str
`COLLECTION_METHOD_JMX`	str(object=’’) -> str
`COLLECTION_METHOD_OS_COMMAND`	str(object=’’) -> str
`COLLECTION_METHOD_SQL`	str(object=’’) -> str
`SQL_TYPE_SQL_SCRIPT`	A constant which can be used with the sql_type property of a SqlUpdateQueryProperties.
`SQL_TYPE_STATEMENT`	A constant which can be used with the sql_type property of a SqlUpdateQueryProperties.
`collection_method`	[Required] Gets the collection_method of this MetricExtensionUpdateQueryProperties.
`in_param_details`	Gets the in_param_details of this SqlUpdateQueryProperties.
`out_param_details`	Gets the out_param_details of this SqlUpdateQueryProperties.
`sql_details`	Gets the sql_details of this SqlUpdateQueryProperties.
`sql_type`	Gets the sql_type of this SqlUpdateQueryProperties.

Methods

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

COLLECTION_METHOD_HTTP = 'HTTP'¶

COLLECTION_METHOD_JMX = 'JMX'¶

COLLECTION_METHOD_OS_COMMAND = 'OS_COMMAND'¶

COLLECTION_METHOD_SQL = 'SQL'¶

SQL_TYPE_SQL_SCRIPT = 'SQL_SCRIPT'¶: A constant which can be used with the sql_type property of a SqlUpdateQueryProperties. This constant has a value of “SQL_SCRIPT”

SQL_TYPE_STATEMENT = 'STATEMENT'¶: A constant which can be used with the sql_type property of a SqlUpdateQueryProperties. This constant has a value of “STATEMENT”

__init__(**kwargs)¶

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

Parameters:

collection_method (str) – The value to assign to the collection_method property of this SqlUpdateQueryProperties. Allowed values for this property are: “OS_COMMAND”, “SQL”, “JMX”, “HTTP”
sql_type (str) – The value to assign to the sql_type property of this SqlUpdateQueryProperties. Allowed values for this property are: “STATEMENT”, “SQL_SCRIPT”
sql_details (oci.stack_monitoring.models.SqlDetails) – The value to assign to the sql_details property of this SqlUpdateQueryProperties.
in_param_details (list[oci.stack_monitoring.models.SqlInParamDetails]) – The value to assign to the in_param_details property of this SqlUpdateQueryProperties.
out_param_details (oci.stack_monitoring.models.SqlOutParamDetails) – The value to assign to the out_param_details property of this SqlUpdateQueryProperties.

collection_method¶

[Required] Gets the collection_method of this MetricExtensionUpdateQueryProperties. Type of possible collection methods.

Allowed values for this property are: “OS_COMMAND”, “SQL”, “JMX”, “HTTP”

Returns:	The collection_method of this MetricExtensionUpdateQueryProperties.
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.

in_param_details¶

Gets the in_param_details of this SqlUpdateQueryProperties. List of values and position of PL/SQL procedure IN parameters

Returns:	The in_param_details of this SqlUpdateQueryProperties.
Return type:	list[oci.stack_monitoring.models.SqlInParamDetails]

out_param_details¶

Gets the out_param_details of this SqlUpdateQueryProperties.

Returns:	The out_param_details of this SqlUpdateQueryProperties.
Return type:	oci.stack_monitoring.models.SqlOutParamDetails

sql_details¶

Gets the sql_details of this SqlUpdateQueryProperties.

Returns:	The sql_details of this SqlUpdateQueryProperties.
Return type:	oci.stack_monitoring.models.SqlDetails

sql_type¶

Gets the sql_type of this SqlUpdateQueryProperties. Type of SQL data collection method i.e. either a Statement or SQL Script File

Allowed values for this property are: “STATEMENT”, “SQL_SCRIPT”

Returns:	The sql_type of this SqlUpdateQueryProperties.
Return type:	str