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.

property 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

property 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

property sql_command

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

Returns

The sql_command of this SqlText.

Return type

str

property 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

property 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

property 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

property version

Gets the version of this SqlText. Version Example: 1

Returns

The version of this SqlText.

Return type

float