public TableComparison(Table leftTable, Table rightTable)
{
LeftTable = leftTable;
RightTable = rightTable;
}
/// <summary>
/// Compares the schema (currently, by using field names only) of the left and right profiles,
/// and
/// </summary>
/// <param name="leftProfile"></param>
/// <param name="rightProfile"></param>
/// <param name="tableFoundDelegate">A delegate that is invoked whenever a table comparison has completed. Useful for tracking progress.</param>
/// <returns>TableComparison objects that explain the differences found between both profiles.</returns>
public static List<TableComparison> CompareSchema(Profile leftProfile, Profile rightProfile, Action<double, TableComparison> tableFoundDelegate)
{
List<TableComparison> tables = new List<TableComparison>();
DbConnection leftConnection = new DbConnection(leftProfile.Host, leftProfile.Port, leftProfile.UserName, leftProfile.Password, leftProfile.Schema);
DbConnection rightConnection = new DbConnection(rightProfile.Host, rightProfile.Port, rightProfile.UserName, rightProfile.Password, rightProfile.Schema);
if (leftConnection.Open())
{
if (rightConnection.Open())
{
List<string> leftTables = DbTableDescriptions.GetTables(leftConnection);
List<string> rightTables = DbTableDescriptions.GetTables(rightConnection);
int leftTableCount = leftTables.Count;
int currentTableCount = 0;
foreach (string leftTable in leftTables)
{
currentTableCount++;
double progress = ((double)currentTableCount / (double)leftTableCount) * 100;
// Look for this table in the collection of right tables
if (!rightTables.Contains(leftTable))
{
Table missingTable = new Table(leftTable);
// Get the properties of this table
List<TableProperty> missingProperties = DbTableDescriptions.GetFieldsForTable(leftTable, leftConnection);
missingTable.Properties = missingProperties;
missingTable.CreateStatement = DbTableDescriptions.GetCreateTableStatement(leftTable, leftConnection);
TableComparison tableComp = new TableComparison(missingTable, null);
// Use the supplied delegate to inform the consumer that we've found another table
tableFoundDelegate(progress, tableComp);
tables.Add(tableComp);
}
else
{
// Compare the properties of this table with those of the right table
List<TableProperty> leftProperties = DbTableDescriptions.GetFieldsForTable(leftTable, leftConnection);
List<TableProperty> rightProperties = DbTableDescriptions.GetFieldsForTable(leftTable, rightConnection); // Note: Not a typo. Using "leftTable" as a convenience, since they should be identical.
List<TableProperty> leftMissingProperties = new List<TableProperty>();
List<TableProperty> rightMissingProperties = new List<TableProperty>();
// Search for properties in the left table that are missing from the right
foreach (TableProperty prop in leftProperties)
{
bool propFound = false;
foreach (TableProperty rightProp in rightProperties)
{
if (rightProp.Name == prop.Name)
{
propFound = true;
}
}
if (!propFound)
{
leftMissingProperties.Add(prop);
}
}
// Search for properties in the right table that are missing from the left
foreach (TableProperty prop in rightProperties)
{
bool propFound = false;
foreach (TableProperty leftProp in leftProperties)
{
if (leftProp.Name == prop.Name)
{
propFound = true;
}
}
if (!propFound)
{
rightMissingProperties.Add(prop);
}
}
if (leftMissingProperties.Count > 0 || rightMissingProperties.Count > 0)
{
TableComparison tableComp = new TableComparison();
if (leftMissingProperties.Count > 0)
{
Table tableWithMissingProps = new Table(leftTable);
tableWithMissingProps.Properties = leftMissingProperties;
tableComp.LeftTable = tableWithMissingProps;
}
if (rightMissingProperties.Count > 0)
{
Table tableWithMissingProps = new Table(leftTable);
tableWithMissingProps.Properties = rightMissingProperties;
tableComp.RightTable = tableWithMissingProps;
}
tables.Add(tableComp);
tableFoundDelegate(progress, tableComp);
}
else
{
tableFoundDelegate(progress, null);
}
}
}
rightConnection.Close();
}
else
{
throw new Exception("Right connection error.");
}
leftConnection.Close();
}
else
{
throw new Exception("Left connection error.");
}
return tables;
}
public TableComparison(Table leftTable)
: this(leftTable, null)
{
}