SqlQueryProperties¶

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

Bases: oci.stack_monitoring.models.metric_extension_query_properties.MetricExtensionQueryProperties

Query Properties applicable to SQL type of collection method

Attributes

`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 SqlQueryProperties.
`SQL_TYPE_STATEMENT`	A constant which can be used with the sql_type property of a SqlQueryProperties.
`collection_method`	[Required] Gets the collection_method of this MetricExtensionQueryProperties.
`in_param_details`	Gets the in_param_details of this SqlQueryProperties.
`out_param_details`	Gets the out_param_details of this SqlQueryProperties.
`sql_details`	[Required] Gets the sql_details of this SqlQueryProperties.
`sql_type`	[Required] Gets the sql_type of this SqlQueryProperties.

Methods

`__init__`(**kwargs)	Initializes a new SqlQueryProperties 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_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 SqlQueryProperties. 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 SqlQueryProperties. This constant has a value of “STATEMENT”

__init__(**kwargs)¶

Initializes a new SqlQueryProperties 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 SqlQueryProperties. Allowed values for this property are: “OS_COMMAND”, “SQL”, “JMX”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
sql_type (str) – The value to assign to the sql_type property of this SqlQueryProperties. Allowed values for this property are: “STATEMENT”, “SQL_SCRIPT”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
sql_details (oci.stack_monitoring.models.SqlDetails) – The value to assign to the sql_details property of this SqlQueryProperties.
in_param_details (list[oci.stack_monitoring.models.SqlInParamDetails]) – The value to assign to the in_param_details property of this SqlQueryProperties.
out_param_details (oci.stack_monitoring.models.SqlOutParamDetails) – The value to assign to the out_param_details property of this SqlQueryProperties.

collection_method¶

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

Allowed values for this property are: “OS_COMMAND”, “SQL”, “JMX”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

Returns:	The collection_method of this MetricExtensionQueryProperties.
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 SqlQueryProperties. List of values and position of PL/SQL procedure IN parameters

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

out_param_details¶

Gets the out_param_details of this SqlQueryProperties.

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

sql_details¶

[Required] Gets the sql_details of this SqlQueryProperties.

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

sql_type¶

[Required] Gets the sql_type of this SqlQueryProperties. Type of SQL data collection method i.e. either a Statement or SQL Script File

Allowed values for this property are: “STATEMENT”, “SQL_SCRIPT”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.

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