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.

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

property 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

property 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

property table_name

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

Returns

The table_name of this DataVerificationTableRowCountSummary.

Return type

str

property 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

property 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