DataVerificationTableRowCountSummary¶

class oci.database_migration.models.DataVerificationTableRowCountSummary(**kwargs)¶

Bases: object

Table row count comparison result line.

Attributes

`DATABASE_COMBINATION_MYSQL`	A constant which can be used with the database_combination property of a DataVerificationTableRowCountSummary.
`DATABASE_COMBINATION_ORACLE`	A constant which can be used with the database_combination property of a DataVerificationTableRowCountSummary.
`database_combination`	[Required] Gets the database_combination of this DataVerificationTableRowCountSummary.
`owner`	Gets the owner of this DataVerificationTableRowCountSummary.
`source_row_count`	[Required] Gets the source_row_count of this DataVerificationTableRowCountSummary.
`table_name`	[Required] Gets the table_name of this DataVerificationTableRowCountSummary.
`target_row_count`	[Required] Gets the target_row_count of this DataVerificationTableRowCountSummary.
`variance_percent`	[Required] Gets the variance_percent of this DataVerificationTableRowCountSummary.

Methods

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

DATABASE_COMBINATION_MYSQL = 'MYSQL'¶: A constant which can be used with the database_combination property of a DataVerificationTableRowCountSummary. This constant has a value of “MYSQL”

DATABASE_COMBINATION_ORACLE = 'ORACLE'¶: A constant which can be used with the database_combination property of a DataVerificationTableRowCountSummary. This constant has a value of “ORACLE”

__init__(**kwargs)¶

Initializes a new DataVerificationTableRowCountSummary object with values from keyword arguments. This class has the following subclasses and if you are using this class as input to a service operations then you should favor using a subclass over the base class:

The following keyword arguments are supported (corresponding to the getters/setters of this class):

Parameters:

database_combination (str) – The value to assign to the database_combination property of this DataVerificationTableRowCountSummary. Allowed values for this property are: “MYSQL”, “ORACLE”, ‘UNKNOWN_ENUM_VALUE’. Any unrecognized values returned by a service will be mapped to ‘UNKNOWN_ENUM_VALUE’.
owner (str) – The value to assign to the owner property of this DataVerificationTableRowCountSummary.
table_name (str) – The value to assign to the table_name property of this DataVerificationTableRowCountSummary.
source_row_count (int) – The value to assign to the source_row_count property of this DataVerificationTableRowCountSummary.
target_row_count (int) – The value to assign to the target_row_count property of this DataVerificationTableRowCountSummary.
variance_percent (float) – The value to assign to the variance_percent property of this DataVerificationTableRowCountSummary.

database_combination¶

[Required] Gets the database_combination of this DataVerificationTableRowCountSummary. The combination of source and target databases participating in a migration. Example: ORACLE means the migration is meant for migrating Oracle source and target databases.

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

Returns:	The database_combination of this DataVerificationTableRowCountSummary.
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.

owner¶

Gets the owner of this DataVerificationTableRowCountSummary. Schema/owner name.

This field is omitted (null/empty depending on backend serialization) for database-wide object types that are not schema-scoped.

Oracle non-schema-scoped object types: USER, ROLE, PROFILE, TABLESPACE, DATABASE_LINK, CONTROLFILE, DATAFILE, REDO_LOG, DIRECTORY, LIBRARY, CONTEXT.

MySQL non-schema-scoped object types: USER, ROLE, SERVER, TABLESPACE, LOGFILE_GROUP.

Returns:	The owner of this DataVerificationTableRowCountSummary.
Return type:	str

source_row_count¶

[Required] Gets the source_row_count of this DataVerificationTableRowCountSummary. Row count in source.

Returns:	The source_row_count of this DataVerificationTableRowCountSummary.
Return type:	int

table_name¶

[Required] Gets the table_name of this DataVerificationTableRowCountSummary. Table name.

Returns:	The table_name of this DataVerificationTableRowCountSummary.
Return type:	str

target_row_count¶

[Required] Gets the target_row_count of this DataVerificationTableRowCountSummary. Row count in target.

Returns:	The target_row_count of this DataVerificationTableRowCountSummary.
Return type:	int

variance_percent¶

[Required] Gets the variance_percent of this DataVerificationTableRowCountSummary. Percentage variance between source and target row counts. This value is expected to be non-negative.

A negative value indicates that the target has rows not present in the source, which should be treated as an inconsistency (i.e., a failed comparison/report result).

Returns:	The variance_percent of this DataVerificationTableRowCountSummary.
Return type:	float