SqlTypeDetails¶

class oci.opsi.models.SqlTypeDetails(**kwargs)¶

Bases: oci.opsi.models.related_object_type_details.RelatedObjectTypeDetails

SQL details

Attributes

`TYPE_DATABASE_PARAMETER`	str(object=’’) -> str
`TYPE_SCHEMA_OBJECT`	str(object=’’) -> str
`TYPE_SQL`	str(object=’’) -> str
`is_sql_text_truncated`	[Required] Gets the is_sql_text_truncated of this SqlTypeDetails.
`sql_command`	[Required] Gets the sql_command of this SqlTypeDetails.
`sql_id`	[Required] Gets the sql_id of this SqlTypeDetails.
`sql_text`	[Required] Gets the sql_text of this SqlTypeDetails.
`type`	[Required] Gets the type of this RelatedObjectTypeDetails.

Methods

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

TYPE_DATABASE_PARAMETER = 'DATABASE_PARAMETER'¶

TYPE_SCHEMA_OBJECT = 'SCHEMA_OBJECT'¶

TYPE_SQL = 'SQL'¶

__init__(**kwargs)¶

Initializes a new SqlTypeDetails object with values from keyword arguments. The default value of the type 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:

type (str) – The value to assign to the type property of this SqlTypeDetails. Allowed values for this property are: “SCHEMA_OBJECT”, “SQL”, “DATABASE_PARAMETER”
sql_id (str) – The value to assign to the sql_id property of this SqlTypeDetails.
sql_text (str) – The value to assign to the sql_text property of this SqlTypeDetails.
is_sql_text_truncated (bool) – The value to assign to the is_sql_text_truncated property of this SqlTypeDetails.
sql_command (str) – The value to assign to the sql_command property of this SqlTypeDetails.

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.

is_sql_text_truncated¶

[Required] Gets the is_sql_text_truncated of this SqlTypeDetails. SQL identifier

Returns:	The is_sql_text_truncated of this SqlTypeDetails.
Return type:	bool

sql_command¶

[Required] Gets the sql_command of this SqlTypeDetails. SQL command name (such as SELECT, INSERT)

Returns:	The sql_command of this SqlTypeDetails.
Return type:	str

sql_id¶

[Required] Gets the sql_id of this SqlTypeDetails. SQL identifier

Returns:	The sql_id of this SqlTypeDetails.
Return type:	str

sql_text¶

[Required] Gets the sql_text of this SqlTypeDetails. First 3800 characters of the SQL text

Returns:	The sql_text of this SqlTypeDetails.
Return type:	str

type¶

[Required] Gets the type of this RelatedObjectTypeDetails. Type of related object

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

Returns:	The type of this RelatedObjectTypeDetails.
Return type:	str