public void CompareDataTables_ThrowsExcepton_WhenActualHasMoreRows()
{
var expected = Common.CreateDataTable("Expected", new[] { 0, 2 });
Common.AddDataRow(expected, "Text one.", 42, 2.00, 2.00m);
Common.AddDataRow(expected, "Text two.", 42, 3.00, 3.00m);
Common.AddDataRow(expected, "Text three.", 43, 4.00, 4.00m);
var actual = Common.CreateDataTable("Actual", expected.PrimaryKey);
Common.AddDataRow(actual, "Text one.", 42, 2.00, 2.00m);
Common.AddDataRow(actual, "Text two.", 42, 3.00, 3.00m);
Common.AddDataRow(actual, "Text three.", 43, 4.00, 4.00m);
Common.AddDataRow(actual, "Text four.", 43, 5.00, 5.00m);
var ex = Assert.Throws <ArgumentException>(() => DataTableHelper.CompareDataTables(expected, actual));
}
public void CompareDataTables_ReturnsNull_WhenTablesIdentical()
{
var expected = Common.CreateDataTable("Expected", new[] { 0, 2 });
Common.AddDataRow(expected, "Text one.", 42, 2.00, 2.00m);
Common.AddDataRow(expected, "Text two.", 42, 3.00, 3.00m);
Common.AddDataRow(expected, "Text three.", 43, 4.00, 4.00m);
var actual = Common.CreateDataTable("Actual", expected.PrimaryKey);
Common.AddDataRow(actual, "Text one.", 42, 2.00, 2.00m);
Common.AddDataRow(actual, "Text two.", 42, 3.00, 3.00m);
Common.AddDataRow(actual, "Text three.", 43, 4.00, 4.00m);
var diffs = DataTableHelper.CompareDataTables(expected, actual);
Assert.That(diffs, Is.Null);
}
public void ExecuteDataTableFromTextFile_ShouldImport_WhenCsv()
{
const string query = @"SELECT * FROM [Test#csv]";
var path = Path.Combine(TestContext.CurrentContext.WorkDirectory, "Data", "Test.csv");
var file = new FileInfo(path);
var expected = Common.CreateDataTable("Expected", new[] { 0, 2 });
Common.AddDataRow(expected, "Text one.", 42, 2.00d, 2.00m);
Common.AddDataRow(expected, "Text two.", 42, 3.00d, 3.00m);
Common.AddDataRow(expected, "Text three.", 43, 4.00d, 4.00m);
Common.AddDataRow(expected, "Text four.", 43, 5.00d, 5.00m);
var actual = ImportFileHelper.ExecuteDataTableFromTextFile(query, file, expected.PrimaryKey);
var diffs = DataTableHelper.CompareDataTables(expected, actual);
Assert.That(diffs, Is.Null);
}
public void CompareDataTables_ReturnsDiffs_WhenTablesAreDifferent()
{
var expected = Common.CreateDataTable("Expected", new[] { 0, 2 });
Common.AddDataRow(expected, "Text one.", 42, 2.00, 2.00m);
Common.AddDataRow(expected, "Text two.", 42, 3.00, 3.00m);
Common.AddDataRow(expected, "Text three.", 43, 4.00, 4.00m);
Common.AddDataRow(expected, "Text four.", 43, 5.00, 5.00m);
var actual = Common.CreateDataTable("Actual", expected.PrimaryKey);
Common.AddDataRow(actual, "Text one.", 42, 2.00, 2.00m);
Common.AddDataRow(actual, "Text four.", 42, 5.00, 5.00m);
Common.AddDataRow(actual, "Text three.", 43, 4.00, 4.00m);
var diffs = DataTableHelper.CompareDataTables(expected, actual);
Assert.That(diffs.Rows.Count, Is.EqualTo(10));
}
