SqlQueryProperties¶

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

Bases: MetricExtensionQueryProperties

Query Properties applicable to SQL type of collection method

Attributes:

`COLLECTION_METHOD_HTTP`	A constant which can be used with the collection_method property of a MetricExtensionQueryProperties.
`COLLECTION_METHOD_JMX`	A constant which can be used with the collection_method property of a MetricExtensionQueryProperties.
`COLLECTION_METHOD_OS_COMMAND`	A constant which can be used with the collection_method property of a MetricExtensionQueryProperties.
`COLLECTION_METHOD_SQL`	A constant which can be used with the collection_method property of a MetricExtensionQueryProperties.
`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_HTTP = 'HTTP'¶: A constant which can be used with the collection_method property of a MetricExtensionQueryProperties. This constant has a value of “HTTP”

COLLECTION_METHOD_JMX = 'JMX'¶: A constant which can be used with the collection_method property of a MetricExtensionQueryProperties. This constant has a value of “JMX”

COLLECTION_METHOD_OS_COMMAND = 'OS_COMMAND'¶: A constant which can be used with the collection_method property of a MetricExtensionQueryProperties. This constant has a value of “OS_COMMAND”

COLLECTION_METHOD_SQL = 'SQL'¶: A constant which can be used with the collection_method property of a MetricExtensionQueryProperties. This constant has a value of “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”, “HTTP”, ‘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.

property 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”, “HTTP”, ‘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.

property 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]

property 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

property sql_details¶

[Required] Gets the sql_details of this SqlQueryProperties.

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

property 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