SqlUpdateQueryProperties

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

Bases: MetricExtensionUpdateQueryProperties

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 MetricExtensionUpdateQueryProperties.

COLLECTION_METHOD_JMX

A constant which can be used with the collection_method property of a MetricExtensionUpdateQueryProperties.

COLLECTION_METHOD_OS_COMMAND

A constant which can be used with the collection_method property of a MetricExtensionUpdateQueryProperties.

COLLECTION_METHOD_SQL

A constant which can be used with the collection_method property of a MetricExtensionUpdateQueryProperties.

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'

A constant which can be used with the collection_method property of a MetricExtensionUpdateQueryProperties. This constant has a value of “HTTP”

COLLECTION_METHOD_JMX = 'JMX'

A constant which can be used with the collection_method property of a MetricExtensionUpdateQueryProperties. 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 MetricExtensionUpdateQueryProperties. 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 MetricExtensionUpdateQueryProperties. 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 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.

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

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

property 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

property sql_details

Gets the sql_details of this SqlUpdateQueryProperties.

Returns

The sql_details of this SqlUpdateQueryProperties.

Return type

oci.stack_monitoring.models.SqlDetails

property 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