public void RenderExpected_MoreThanMaxRowsCount_ReturnSampleRowsCountAndHeaderAndSeparation()
{
var dataSet = new DataSet();
var dataTable = new DataTable()
{
TableName = "MyTable"
};
dataTable.Columns.Add(new DataColumn("Id"));
dataTable.Columns.Add(new DataColumn("Numeric value"));
dataTable.Columns.Add(new DataColumn("Boolean value"));
for (int i = 0; i < 20; i++)
{
dataTable.LoadDataRow(new object[] { "Alpha", i, true }, false);
}
var msg = new DataRowsMessage(FailureReportProfile.Default);
msg.Build(dataTable.Rows.Cast <DataRow>(), null, null);
var value = msg.RenderExpected();
var lines = value.Replace("\n", string.Empty).Split('\r');
Assert.That(lines.Count(l => l.Contains("|")), Is.EqualTo(10 + 2));
}
public void RenderExpected_MoreThanSampleRowsCountButLessThanMaxRowsCountWithSpecificProfileFull_ReturnEachRowAndHeaderAndSeparation()
{
var rowCount = 120;
var threshold = rowCount - 20;
var max = threshold / 2;
var dataSet = new DataSet();
var dataTable = new DataTable()
{
TableName = "MyTable"
};
dataTable.Columns.Add(new DataColumn("Id"));
dataTable.Columns.Add(new DataColumn("Numeric value"));
dataTable.Columns.Add(new DataColumn("Boolean value"));
for (int i = 0; i < rowCount; i++)
{
dataTable.LoadDataRow(new object[] { "Alpha", i, true }, false);
}
var profile = Mock.Of <IFailureReportProfile>(p =>
p.MaxSampleItem == max &&
p.ThresholdSampleItem == threshold &&
p.ExpectedSet == FailureReportSetType.Full
);
var msg = new DataRowsMessage(profile);
msg.Build(dataTable.Rows.Cast <DataRow>(), null, null);
var value = msg.RenderExpected();
var lines = value.Replace("\n", string.Empty).Split('\r');
Assert.That(lines.Count(l => l.Contains("|")), Is.EqualTo(rowCount + 2));
}
public void RenderExpected_OneRow_ReturnCorrectNumberOfRowsOnTopWithoutPlurial()
{
var dataSet = new DataSet();
var dataTable = new DataTable()
{
TableName = "MyTable"
};
dataTable.Columns.Add(new DataColumn("Id"));
dataTable.Columns.Add(new DataColumn("Numeric value"));
dataTable.Columns.Add(new DataColumn("Boolean value"));
for (int i = 0; i < 1; i++)
{
dataTable.LoadDataRow(new object[] { "Alpha", i, true }, false);
}
var msg = new DataRowsMessage(FailureReportProfile.Default);
msg.Build(dataTable.Rows.Cast <DataRow>(), null, null);
var value = msg.RenderExpected();
var lines = value.Replace("\n", string.Empty).Split('\r');
Assert.That(lines[0], Is.EqualTo("ResultSet with 1 row"));
}
public void RenderExpected_MoreThanMaxRowsCount_ReturnCorrectCountOfSkippedRow()
{
var dataSet = new DataSet();
var dataTable = new DataTable()
{
TableName = "MyTable"
};
dataTable.Columns.Add(new DataColumn("Id"));
dataTable.Columns.Add(new DataColumn("Numeric value"));
dataTable.Columns.Add(new DataColumn("Boolean value"));
for (int i = 0; i < 22; i++)
{
dataTable.LoadDataRow(new object[] { "Alpha", i, true }, false);
}
var msg = new DataRowsMessage(FailureReportProfile.Default);
msg.Build(dataTable.Rows.Cast <DataRow>(), null, null);
var value = msg.RenderExpected();
var lines = value.Replace("\n", string.Empty).Split('\r');
//Not exactly the last line but the previous due to paragraph rendering.
var lastLine = lines.Reverse().ElementAt(1);
Assert.That(lastLine, Is.EqualTo("12 (of 22) rows have been skipped for display purpose."));
}
public void RenderExpected_LessThanMaxRowsCount_DoesntDisplaySkippedRow(int rowCount)
{
var dataSet = new DataSet();
var dataTable = new DataTable()
{
TableName = "MyTable"
};
dataTable.Columns.Add(new DataColumn("Id"));
dataTable.Columns.Add(new DataColumn("Numeric value"));
dataTable.Columns.Add(new DataColumn("Boolean value"));
for (int i = 0; i < rowCount; i++)
{
dataTable.LoadDataRow(new object[] { "Alpha", i, true }, false);
}
var msg = new DataRowsMessage(FailureReportProfile.Default);
msg.Build(dataTable.Rows.Cast <DataRow>(), null, null);
var value = msg.RenderExpected();
Assert.That(value, Is.Not.StringContaining("rows have been skipped for display purpose."));
}
public void RenderExpected_MoreThanMaxRowsCount_ReturnCorrectCountOfSkippedRow()
{
var dataSet = new DataSet();
var dataTable = new DataTable() { TableName = "MyTable" };
dataTable.Columns.Add(new DataColumn("Id"));
dataTable.Columns.Add(new DataColumn("Numeric value"));
dataTable.Columns.Add(new DataColumn("Boolean value"));
for (int i = 0; i < 22; i++)
dataTable.LoadDataRow(new object[] { "Alpha", i, true }, false);
var msg = new DataRowsMessage(FailureReportProfile.Default);
msg.Build(dataTable.Rows.Cast<DataRow>(), null, null);
var value = msg.RenderExpected();
var lines = value.Replace("\n", string.Empty).Split('\r');
//Not exactly the last line but the previous due to paragraph rendering.
var lastLine = lines.Reverse().ElementAt(1);
Assert.That(lastLine, Is.EqualTo("12 (of 22) rows have been skipped for display purpose."));
}
public void RenderExpected_LessThanMaxRowsCount_DoesntDisplaySkippedRow(int rowCount)
{
var dataSet = new DataSet();
var dataTable = new DataTable() { TableName = "MyTable" };
dataTable.Columns.Add(new DataColumn("Id"));
dataTable.Columns.Add(new DataColumn("Numeric value"));
dataTable.Columns.Add(new DataColumn("Boolean value"));
for (int i = 0; i < rowCount; i++)
dataTable.LoadDataRow(new object[] { "Alpha", i, true }, false);
var msg = new DataRowsMessage(FailureReportProfile.Default);
msg.Build(dataTable.Rows.Cast<DataRow>(), null, null);
var value = msg.RenderExpected();
Assert.That(value, Is.Not.StringContaining("rows have been skipped for display purpose."));
}
public void RenderExpected_OneRow_ReturnCorrectNumberOfRowsOnTopWithoutPlurial()
{
var dataSet = new DataSet();
var dataTable = new DataTable() { TableName = "MyTable" };
dataTable.Columns.Add(new DataColumn("Id"));
dataTable.Columns.Add(new DataColumn("Numeric value"));
dataTable.Columns.Add(new DataColumn("Boolean value"));
for (int i = 0; i < 1; i++)
dataTable.LoadDataRow(new object[] { "Alpha", i, true }, false);
var msg = new DataRowsMessage(FailureReportProfile.Default);
msg.Build(dataTable.Rows.Cast<DataRow>(), null, null);
var value = msg.RenderExpected();
var lines = value.Replace("\n", string.Empty).Split('\r');
Assert.That(lines[0], Is.EqualTo("ResultSet with 1 row"));
}
public void RenderExpected_MoreThanSampleRowsCountButLessThanMaxRowsCount_ReturnEachRowAndHeaderAndSeparation()
{
var rowCount = 12;
var dataSet = new DataSet();
var dataTable = new DataTable() { TableName = "MyTable" };
dataTable.Columns.Add(new DataColumn("Id"));
dataTable.Columns.Add(new DataColumn("Numeric value"));
dataTable.Columns.Add(new DataColumn("Boolean value"));
for (int i = 0; i < rowCount; i++)
dataTable.LoadDataRow(new object[] { "Alpha", i, true }, false);
var msg = new DataRowsMessage(FailureReportProfile.Default);
msg.Build(dataTable.Rows.Cast<DataRow>(), null, null);
var value = msg.RenderExpected();
var lines = value.Replace("\n", string.Empty).Split('\r');
Assert.That(lines.Count(l => l.Contains("|")), Is.EqualTo(rowCount + 2));
}
public void RenderExpected_MoreThanSampleRowsCountButLessThanMaxRowsCountWithSpecificProfile_ReturnEachRowAndHeaderAndSeparation()
{
var rowCount = 120;
var threshold = rowCount - 20;
var max = threshold / 2;
var dataSet = new DataSet();
var dataTable = new DataTable() { TableName = "MyTable" };
dataTable.Columns.Add(new DataColumn("Id"));
dataTable.Columns.Add(new DataColumn("Numeric value"));
dataTable.Columns.Add(new DataColumn("Boolean value"));
for (int i = 0; i < rowCount; i++)
dataTable.LoadDataRow(new object[] { "Alpha", i, true }, false);
var profile = Mock.Of<IFailureReportProfile>(p =>
p.MaxSampleItem == max
&& p.ThresholdSampleItem == threshold
&& p.ExpectedSet == FailureReportSetType.Sample
);
var msg = new DataRowsMessage(profile);
msg.Build(dataTable.Rows.Cast<DataRow>(), null, null);
var value = msg.RenderExpected();
var lines = value.Replace("\n", string.Empty).Split('\r');
Assert.That(lines.Count(l => l.Contains("|")), Is.EqualTo(max + 2));
}
