com.axway.ats.common.dbaccess.snapshot.equality

Class DatabaseEqualityState

java.lang.Object

com.axway.ats.common.dbaccess.snapshot.equality.DatabaseEqualityState

public class DatabaseEqualityState
extends Object

This structure says how equal the snapshots are

Constructor Summary

Constructors

Constructor and Description
DatabaseEqualityState(String firstSnapshotName, String secondSnapshotName)

Method Summary

Modifier and Type	Method and Description
void	addColumnPresentInOneSnapshotOnly(String snapshotName, String table, String column)
void	addDifferentNumberOfRows(String firstSnapshotName, String secondSnapshotName, int firstNumberOfRows, int secondNumberOfRows, String table)
void	addDifferentPrimaryKeys(String firstSnapshotName, String secondSnapshotName, String firstPrimaryKey, String secondPrimaryKey, String table)
void	addIndexPresentInOneSnapshotOnly(String snapshotName, String table, String indexName, String index)
void	addRowPresentInOneSnapshotOnly(String snapshotName, String table, String rowValues)
void	addTablePresentInOneSnapshotOnly(String snapshotName, String table)
List<Map<String,String>>	getColumnsPresentInOneSnapshotOnly(String snapshot, String table) Get a list of unique columns for the given table and snapshot.
List<String>	getColumnsPresentInOneSnapshotOnlyAsStrings(String snapshot, String table) Get a list of unique columns for the given table and snapshot.
Integer	getDifferentNumberOfRows(String snapshot, String table) Get the number of rows for the given table and snapshot.
String	getDifferentPrimaryKeys(String snapshot, String table) Get the different primary keys per table and snapshot.
String	getFirstSnapshotName()
List<Map<String,String>>	getIndexesPresentInOneSnapshotOnly(String snapshot, String table) Get a list of unique indexes for the given table and snapshot.
List<String>	getIndexesPresentInOneSnapshotOnlyAsStrings(String snapshot, String table) Get a list of unique indexes for the given table and snapshot.
List<Map<String,String>>	getRowsPresentInOneSnapshotOnly(String snapshot, String table) Get a list of unique rows for the given table and snapshot.
List<String>	getRowsPresentInOneSnapshotOnlyAsStrings(String snapshot, String table) Get a list of unique rows for the given table and snapshot.
String	getSecondSnapshotName()
List<String>	getTablesPresentInOneSnapshotOnly(String snapshot)
List<String>	getTablesWithColumnsPresentInOneSnapshotOnly(String snapshot) Get list of tables with unique columns
List<String>	getTablesWithDifferentNumberOfRows(String snapshot) Get list of tables with different number of rows Note that the list of tables is the same for both snapshots
List<String>	getTablesWithDifferentPrimaryKeys(String snapshot) Get list of tables with different primary keys Note that the list of tables is the same for both snapshots
List<String>	getTablesWithIndexesPresentInOneSnapshotOnly(String snapshot) Get list of tables with unique indexes
List<String>	getTablesWithRowsPresentInOneSnapshotOnly(String snapshot) Get list of tables with unique rows
boolean	hasDifferences()

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DatabaseEqualityState

public DatabaseEqualityState(String firstSnapshotName,
                             String secondSnapshotName)

Method Detail

getFirstSnapshotName

public String getFirstSnapshotName()

Returns:

the name of the first snapshot

getSecondSnapshotName

public String getSecondSnapshotName()

Returns:

the name of the second snapshot

hasDifferences

public boolean hasDifferences()

Returns:

whether some differences are found

getTablesPresentInOneSnapshotOnly

public List<String> getTablesPresentInOneSnapshotOnly(String snapshot)

Parameters:

snapshot - snapshot name

Returns:

tables present in one snapshot only

addTablePresentInOneSnapshotOnly

public void addTablePresentInOneSnapshotOnly(String snapshotName,
                                             String table)

getTablesWithDifferentPrimaryKeys

public List<String> getTablesWithDifferentPrimaryKeys(String snapshot)

Get list of tables with different primary keys
Note that the list of tables is the same for both snapshots

Parameters:

snapshot - snapshot name

Returns:

tables with different primary keys

getDifferentPrimaryKeys

public String getDifferentPrimaryKeys(String snapshot,
                                      String table)

Get the different primary keys per table and snapshot.
Note that we currently do not support more than one primary key difference

Parameters:

snapshot - snapshot name

table - table name

Returns:

the different primary keys

addDifferentPrimaryKeys

public void addDifferentPrimaryKeys(String firstSnapshotName,
                                    String secondSnapshotName,
                                    String firstPrimaryKey,
                                    String secondPrimaryKey,
                                    String table)

getTablesWithDifferentNumberOfRows

public List<String> getTablesWithDifferentNumberOfRows(String snapshot)

Get list of tables with different number of rows
Note that the list of tables is the same for both snapshots

Parameters:

snapshot - snapshot name

Returns:

tables with different number of rows

getDifferentNumberOfRows

public Integer getDifferentNumberOfRows(String snapshot,
                                        String table)

Get the number of rows for the given table and snapshot.

Parameters:

snapshot - snapshot name

table - table name

Returns:

number of rows

addDifferentNumberOfRows

public void addDifferentNumberOfRows(String firstSnapshotName,
                                     String secondSnapshotName,
                                     int firstNumberOfRows,
                                     int secondNumberOfRows,
                                     String table)

getTablesWithColumnsPresentInOneSnapshotOnly

public List<String> getTablesWithColumnsPresentInOneSnapshotOnly(String snapshot)

Get list of tables with unique columns

Parameters:

snapshot - snapshot name

Returns:

tables with unique columns

getColumnsPresentInOneSnapshotOnly

public List<Map<String,String>> getColumnsPresentInOneSnapshotOnly(String snapshot,
                                                                   String table)

Get a list of unique columns for the given table and snapshot.
We return a list each item of which represents a column description. The list contains a map where the key is a column attribute name while the value is a column attribute value.

Parameters:

snapshot - snapshot name

table - table name

Returns:

list of unique columns

getColumnsPresentInOneSnapshotOnlyAsStrings

public List<String> getColumnsPresentInOneSnapshotOnlyAsStrings(String snapshot,
                                                                String table)

Get a list of unique columns for the given table and snapshot.
We return a list each item of which is a String describing a column.

Parameters:

snapshot - snapshot name

table - table name

Returns:

list of unique columns

addColumnPresentInOneSnapshotOnly

public void addColumnPresentInOneSnapshotOnly(String snapshotName,
                                              String table,
                                              String column)

getTablesWithIndexesPresentInOneSnapshotOnly

public List<String> getTablesWithIndexesPresentInOneSnapshotOnly(String snapshot)

Get list of tables with unique indexes

Parameters:

snapshot - snapshot name

Returns:

tables with unique indexes

getIndexesPresentInOneSnapshotOnly

public List<Map<String,String>> getIndexesPresentInOneSnapshotOnly(String snapshot,
                                                                   String table)

Get a list of unique indexes for the given table and snapshot.
We return a list each item of which represents an index description. The list contains a map where the key is an index attribute name while the value is an index attribute value.

Parameters:

snapshot - snapshot name

table - table name

Returns:

list of unique indexes

getIndexesPresentInOneSnapshotOnlyAsStrings

public List<String> getIndexesPresentInOneSnapshotOnlyAsStrings(String snapshot,
                                                                String table)

Get a list of unique indexes for the given table and snapshot.
We return a list each item of which is a String describing an index.

Parameters:

snapshot - snapshot name

table - table name

Returns:

list of unique indexes

addIndexPresentInOneSnapshotOnly

public void addIndexPresentInOneSnapshotOnly(String snapshotName,
                                             String table,
                                             String indexName,
                                             String index)

getTablesWithRowsPresentInOneSnapshotOnly

public List<String> getTablesWithRowsPresentInOneSnapshotOnly(String snapshot)

Get list of tables with unique rows

Parameters:

snapshot - snapshot name

Returns:

tables with unique rows

getRowsPresentInOneSnapshotOnly

public List<Map<String,String>> getRowsPresentInOneSnapshotOnly(String snapshot,
                                                                String table)

Get a list of unique rows for the given table and snapshot.
We return a list each item of which represents a row. The list contains a map where the key is a column name while the value is a value at that column of the row.

Parameters:

snapshot - snapshot name

table - table name

Returns:

list of unique rows

getRowsPresentInOneSnapshotOnlyAsStrings

public List<String> getRowsPresentInOneSnapshotOnlyAsStrings(String snapshot,
                                                             String table)

Get a list of unique rows for the given table and snapshot.
We return a list each item of which is a String describing the row content.

Parameters:

snapshot - snapshot name

table - table name

Returns:

list of unique indexes

addRowPresentInOneSnapshotOnly

public void addRowPresentInOneSnapshotOnly(String snapshotName,
                                           String table,
                                           String rowValues)