public void CsvComparisonErrorsMissingTest() { var expectedCsv = CsvTable.Parse("SimpleExpected.csv"); var actualCsv = CsvTable.Parse("SimpleActualMissing.csv"); var comparison = new CsvComparison(expectedCsv, actualCsv, Tolerance.Parse("2%;0.001")); var expected = comparison.ExpectedTable; Assert.AreEqual(2, expected.RowCount, "Expected RowCount"); var actual = comparison.ActualTable; Assert.AreEqual(1, actual.RowCount, "Actual RowCount"); Assert.AreEqual(4, comparison.ErrorCount(), "Error Count = 2"); var query = comparison.Query(); var errorRow = query[0] as Collection <object>; Assert.AreEqual("B1", QueryValue(errorRow, "Cell")); Assert.AreEqual("Missing", QueryValue(errorRow, "Issue")); errorRow = query[1] as Collection <object>; Assert.AreEqual("B2", QueryValue(errorRow, "Cell")); Assert.AreEqual("Missing", QueryValue(errorRow, "Issue")); errorRow = query[2] as Collection <object>; Assert.AreEqual("A3", QueryValue(errorRow, "Cell")); Assert.AreEqual("Missing", QueryValue(errorRow, "Issue")); errorRow = query[3] as Collection <object>; Assert.AreEqual("B3", QueryValue(errorRow, "Cell")); Assert.AreEqual("Missing", QueryValue(errorRow, "Issue")); }
public void CsvComparisonDataQueryTest() { Assert.AreEqual(_expectedResult.Count, _csvComparison.ErrorCount(), "Error count"); var i = 0; foreach (Collection <object> row in _csvComparison.Query()) { Assert.AreEqual(_expectedResult[i][0], QueryValue(row, "Cell"), $"Query Entry #{i}.Cell"); Assert.AreEqual(_expectedResult[i][1], QueryValue(row, "Row No"), $"Query Entry #{i}.RowNo"); Assert.AreEqual(_expectedResult[i][2], QueryValue(row, "Row Name"), $"Query Entry #{i}.Row"); Assert.AreEqual(_expectedResult[i][3], QueryValue(row, "Column No"), $"Query Entry #{i}.ColumnNo"); Assert.AreEqual(_expectedResult[i][4], QueryValue(row, "Column Name"), $"Query Entry #{i}.Column"); Assert.AreEqual(_expectedResult[i][5], QueryValue(row, "Value"), $"Query Entry #{i}.Value"); i++; } }
public void CsvComparisonErrorsSurplusTest() { var expectedCsv = CsvTable.Parse("SimpleExpected.csv"); var actualCsv = CsvTable.Parse("SimpleActualSurplus.csv"); var comparison = new CsvComparison(expectedCsv, actualCsv, Tolerance.Parse("2%;0.001")); Assert.AreEqual(3, comparison.ErrorCount(), "Error Count = 3"); var query = comparison.Query(); var errorRow = query[0] as Collection <object>; Assert.AreEqual("C1", QueryValue(errorRow, "Cell")); Assert.AreEqual("Surplus", QueryValue(errorRow, "Issue")); errorRow = query[1] as Collection <object>; Assert.AreEqual("C2", QueryValue(errorRow, "Cell")); Assert.AreEqual("Surplus", QueryValue(errorRow, "Issue")); errorRow = query[2] as Collection <object>; Assert.AreEqual("A4", QueryValue(errorRow, "Cell")); Assert.AreEqual("Surplus", QueryValue(errorRow, "Issue")); }
public void CsvComparisonErrorsStreamDataTest() { var baseCsv = CsvTable.Parse("StreamData1.csv"); Console.WriteLine($"Base: columns={baseCsv.ColumnCount}; rows={baseCsv.RowCount}"); var newCsv = CsvTable.Parse("StreamData2.csv"); Console.WriteLine($"New: columns={newCsv.ColumnCount}; rows={newCsv.RowCount}"); var comparison = new CsvComparison(baseCsv, newCsv, Tolerance.Parse("2%;0.001")); Assert.AreEqual(1, comparison.ErrorCount(), "Error Count = 1"); var query = comparison.Query(); var errorRow = query[0] as Collection <object>; Assert.AreEqual("H2", QueryValue(errorRow, "Cell")); Assert.AreEqual("2", QueryValue(errorRow, "Row No")); Assert.AreEqual("Total Liquid Mole Fraction", QueryValue(errorRow, "Row Name")); Assert.AreEqual("8 (H)", QueryValue(errorRow, "Column No")); Assert.AreEqual("A11", QueryValue(errorRow, "Column Name")); Assert.AreEqual("0.01 != 0", QueryValue(errorRow, "Value")); Assert.AreEqual("0.01", QueryValue(errorRow, "Delta")); Assert.IsTrue(string.IsNullOrEmpty(QueryValue(errorRow, "Delta %").ToString())); }