private void AssertRowsInternal(IDAC dac, string tableName, IEnumerable <IEnumerable <object> > expectedRows, bool anyOrder) { var tableRows = dac.Select(tableName).Rows.Cast <DataRow>().Select(r => r.ItemArray as IEnumerable <object>); if (anyOrder) { expectedRows = expectedRows.OrderByAll(); tableRows = tableRows.OrderByAll(); } NUnitTool.AssertSame2DArrays(expectedRows, tableRows, tableName); }
private void AssertSameTableDataInternal(IDAC source, IDAC dest, string tableName, bool primaryKeyMustMatch) { var sourceTableSchema = source.GetSchemaCached()[tableName]; var destTableSchema = dest.GetSchemaCached()[tableName]; Assert.AreNotEqual(DBKeyType.None, sourceTableSchema.PrimaryKey.KeyType, "Tables without primary keys are not supported"); Assert.AreEqual(sourceTableSchema.PrimaryKey.KeyType, destTableSchema.PrimaryKey.KeyType, "Table primary key types do not match"); var sourceData = source.Select(tableName).Rows.Cast <DataRow>().Select(r => r.ItemArray.Select(Object.SanitizeObject).ToArray()).ToArray(); var destData = dest.Select(tableName).Rows.Cast <DataRow>().Select(r => r.ItemArray.Select(Object.SanitizeObject).ToArray()).ToArray(); var primaryKeysNotInDest = new IEnumerable <object> [0]; var primaryKeysNotInSource = new IEnumerable <object> [0]; // Validate data by primary keys if (primaryKeyMustMatch) { // Gather data into primary key look up var sourceDataDict = sourceTableSchema.ConvertDataToMultiKeyDictionary(sourceData); var destDataDict = destTableSchema.ConvertDataToMultiKeyDictionary(destData); // Validate that primary keys map exactly primaryKeysNotInDest = sourceDataDict.Keys.Except(destDataDict.Keys, new EnumerableSequenceEqualComparer <object>()).ToArray(); primaryKeysNotInSource = destDataDict.Keys.Except(sourceDataDict.Keys, new EnumerableSequenceEqualComparer <object>()).ToArray(); // Print data missing from dest (by PK) if (primaryKeysNotInDest.Any()) { Console.WriteLine("Primary key missing from dest:"); foreach (var key in primaryKeysNotInDest.Select(k => k.ToArray())) { Console.WriteLine("\tPK:({0}) Data:{1}".FormatWith(key.ToDelimittedString(", "), sourceDataDict[key].ToDelimittedString(", "))); } } Console.WriteLine(); // Print data missing from source (by PK) if (primaryKeysNotInSource.Any()) { Console.WriteLine("Primary key missing from source:"); foreach (var key in primaryKeysNotInSource.Select(k => k.ToArray())) { Console.WriteLine("\tPK:({0}) Data:{1}".FormatWith(key.ToDelimittedString(", "), sourceDataDict[key].ToDelimittedString(", "))); } } Console.WriteLine(); } var primaryKeyColCount = sourceTableSchema.PrimaryKeyColumns.Length; var sourceDataToCompare = primaryKeyMustMatch ? sourceData : sourceData.Select(rowArr => rowArr.Skip(primaryKeyColCount).ToArray()).ToArray(); var destDataToCompare = primaryKeyMustMatch ? destData : destData.Select(rowArr => rowArr.Skip(primaryKeyColCount).ToArray()).ToArray(); // print missing data var rowsNotInDestByValue = sourceDataToCompare.Except(destDataToCompare, new EnumerableSequenceEqualComparer <object>()).ToArray(); var rowsNotInSourceByValue = destDataToCompare.Except(sourceDataToCompare, new EnumerableSequenceEqualComparer <object>()).ToArray(); // Print data missing from dest if (rowsNotInDestByValue.Any()) { Console.WriteLine(NUnitTool.Convert2DArrayToString("Data missing from Dest", rowsNotInDestByValue)); } Console.WriteLine(); // Print data missing from source if (rowsNotInSourceByValue.Any()) { Console.WriteLine(NUnitTool.Convert2DArrayToString("Data missing from Source", rowsNotInSourceByValue)); } Console.WriteLine(); // Assert primary keys are present in both if (primaryKeyMustMatch) { NUnitTool.IsEmpty(primaryKeysNotInDest, "Dest missing primary keys"); NUnitTool.IsEmpty(primaryKeysNotInSource, "Source missing primary keys"); } NUnitTool.IsEmpty(rowsNotInDestByValue, "Dest missing data"); NUnitTool.IsEmpty(rowsNotInSourceByValue, "Source missing data"); }