/// <summary>
/// Determinate two group unique column equal or not
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public override bool Equals(object obj)
{
//
// Initialize result
bool result = false;
//
// Cast type and check
if (obj is GroupUniqueColumnSnapshot)
{
GroupUniqueColumnSnapshot groupUniqueColumn = obj as GroupUniqueColumnSnapshot;
if (groupUniqueColumn.ConstraintName.Equals(this._constraintName) && groupUniqueColumn.NumberOfUniqueColumn == this.NumberOfUniqueColumn)
{
//
// Make sure, all of unqiue column are equal
// If only one unique column is different
// Return false immediately
result = true;
foreach (UniqueColumnSnapshot uniqueColumn in groupUniqueColumn._listUniqueColumnSnapshot)
{
if (this._listUniqueColumnSnapshot.Any(x => x.Equals(uniqueColumn)) == false)
{
result = false;
break;
}
}
}
}
//
// Return result
return(result);
}
/// <summary>
/// Get tablesnapshot by name
/// </summary>
/// <param name="tableName"></param>
/// <returns></returns>
public TableSnapshot GetTableSnapshot(string tableName)
{
//
// Initialize result
TableSnapshot result = new TableSnapshot(tableName);
//
// Get list of primary keys
// For each primary key
// Try to get it's properties in entity
// Then add to hasTable
DbSet dbSet = this._mapDatabase.GetTable(tableName);
dbSet.Load();
List <string> listPrimaryKeys = this._mapDatabase.GetPrimaryKeyName(tableName);
List <GroupUniqueColumnInformation> listGroupUniqueInformation = this._mapDatabase.GetGroupUniqueColumnInformation(tableName);
TypeAccessor typeAccessor = this._mapDatabase.GetTableTypeAccessor(tableName);
//
// Foreach record in database
// Try to get RecordSnapshot
foreach (object record in dbSet)
{
RecordSnapshot recordSnapshot = new RecordSnapshot();
//
// Get primary key value
foreach (string primaryKey in listPrimaryKeys)
{
PrimaryKeySnapshot primaryKeySnapshot = new PrimaryKeySnapshot(primaryKey, typeAccessor[record, primaryKey]);
recordSnapshot.Add(primaryKeySnapshot);
}
//
// Get unqiue column value
foreach (GroupUniqueColumnInformation groupUnique in listGroupUniqueInformation)
{
GroupUniqueColumnSnapshot groupUniqueSnapshot = new GroupUniqueColumnSnapshot(groupUnique.ConstraintName);
foreach (UniqueColumnInformation uniqueColumnInfo in groupUnique.ListUniqueColumn)
{
UniqueColumnSnapshot uniqueColumnSnapshot = new UniqueColumnSnapshot(uniqueColumnInfo.ColumnName, typeAccessor[record, uniqueColumnInfo.ColumnName]);
groupUniqueSnapshot.Add(uniqueColumnSnapshot);
}
recordSnapshot.Add(groupUniqueSnapshot);
}
result.Add(recordSnapshot);
}
//
// Return result
return(result);
}
/// <summary>
/// Add new groupuniquecolumn snapshot
/// </summary>
/// <param name="groupUniqueColumnSnapshot"></param>
public void Add(GroupUniqueColumnSnapshot groupUniqueColumnSnapshot)
{
this._listGroupUniqueColumnSnapshot.Add(groupUniqueColumnSnapshot);
}
/// <summary>
/// Add new groupuniquecolumn snapshot
/// </summary>
/// <param name="groupUniqueColumnSnapshot"></param>
public void Add(GroupUniqueColumnSnapshot groupUniqueColumnSnapshot)
{
this._listGroupUniqueColumnSnapshot.Add(groupUniqueColumnSnapshot);
}
/// <summary>
/// Get tablesnapshot by name
/// </summary>
/// <param name="tableName"></param>
/// <returns></returns>
public TableSnapshot GetTableSnapshot(string tableName)
{
//
// Initialize result
TableSnapshot result = new TableSnapshot(tableName);
//
// Get list of primary keys
// For each primary key
// Try to get it's properties in entity
// Then add to hasTable
DbSet dbSet = this._mapDatabase.GetTable(tableName);
dbSet.Load();
List<string> listPrimaryKeys = this._mapDatabase.GetPrimaryKeyName(tableName);
List<GroupUniqueColumnInformation> listGroupUniqueInformation = this._mapDatabase.GetGroupUniqueColumnInformation(tableName);
TypeAccessor typeAccessor = this._mapDatabase.GetTableTypeAccessor(tableName);
//
// Foreach record in database
// Try to get RecordSnapshot
foreach (object record in dbSet)
{
RecordSnapshot recordSnapshot = new RecordSnapshot();
//
// Get primary key value
foreach (string primaryKey in listPrimaryKeys)
{
PrimaryKeySnapshot primaryKeySnapshot = new PrimaryKeySnapshot(primaryKey, typeAccessor[record, primaryKey]);
recordSnapshot.Add(primaryKeySnapshot);
}
//
// Get unqiue column value
foreach (GroupUniqueColumnInformation groupUnique in listGroupUniqueInformation)
{
GroupUniqueColumnSnapshot groupUniqueSnapshot = new GroupUniqueColumnSnapshot(groupUnique.ConstraintName);
foreach (UniqueColumnInformation uniqueColumnInfo in groupUnique.ListUniqueColumn)
{
UniqueColumnSnapshot uniqueColumnSnapshot = new UniqueColumnSnapshot(uniqueColumnInfo.ColumnName, typeAccessor[record, uniqueColumnInfo.ColumnName]);
groupUniqueSnapshot.Add(uniqueColumnSnapshot);
}
recordSnapshot.Add(groupUniqueSnapshot);
}
result.Add(recordSnapshot);
}
//
// Return result
return result;
}
