SqlText¶

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

Bases: object

SQL Text type object.

Methods

__init__(**kwargs) Initializes a new SqlText object with values from keyword arguments.

Attributes

`exact_matching_signature`	Gets the exact_matching_signature of this SqlText.
`force_matching_signature`	Gets the force_matching_signature of this SqlText.
`sql_command`	[Required] Gets the sql_command of this SqlText.
`sql_full_text`	[Required] Gets the sql_full_text of this SqlText.
`sql_identifier`	[Required] Gets the sql_identifier of this SqlText.
`time_collected`	[Required] Gets the time_collected of this SqlText.
`version`	Gets the version of this SqlText.

__init__(**kwargs)¶

Initializes a new SqlText object with values from keyword arguments. The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:

version (float) – The value to assign to the version property of this SqlText.
sql_identifier (str) – The value to assign to the sql_identifier property of this SqlText.
time_collected (datetime) – The value to assign to the time_collected property of this SqlText.
sql_command (str) – The value to assign to the sql_command property of this SqlText.
exact_matching_signature (str) – The value to assign to the exact_matching_signature property of this SqlText.
force_matching_signature (str) – The value to assign to the force_matching_signature property of this SqlText.
sql_full_text (str) – The value to assign to the sql_full_text property of this SqlText.

exact_matching_signature¶

Gets the exact_matching_signature of this SqlText. Exact matching signature Example: “18067345456756876713”

Returns:	The exact_matching_signature of this SqlText.
Return type:	str

force_matching_signature¶

Gets the force_matching_signature of this SqlText. Force matching signature Example: “18067345456756876713”

Returns:	The force_matching_signature of this SqlText.
Return type:	str

sql_command¶

[Required] Gets the sql_command of this SqlText. SQL command Example: “SELECT”

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

sql_full_text¶

[Required] Gets the sql_full_text of this SqlText. Full SQL Text Example: “SELECT username,profile,default_tablespace,temporary_tablespace FROM dba_users” Disclaimer: SQL text being uploaded explicitly via APIs is not masked. Any sensitive literals contained in the sqlFullText column should be masked prior to ingestion.

Returns:	The sql_full_text of this SqlText.
Return type:	str

sql_identifier¶

[Required] Gets the sql_identifier of this SqlText. Unique SQL_ID for a SQL Statement.

Returns:	The sql_identifier of this SqlText.
Return type:	str

time_collected¶

[Required] Gets the time_collected of this SqlText. Collection timestamp Example: “2020-05-06T00:00:00.000Z”

Returns:	The time_collected of this SqlText.
Return type:	datetime

version¶

Gets the version of this SqlText. Version Example: 1

Returns:	The version of this SqlText.
Return type:	float