public void ThenTheViewFilteredToIdShouldBePopulatedWithData(string viewName, int id, Table table)
{
var expected = new CollectionPopulatedTableData(table.Header, table.Rows.Select(x => x.Values));
var actual = LoadTableDataFromSql(string.Format("SELECT * FROM {0} WHERE Id = {1}", viewName, id));
expected.VerifyMatch(actual, TableDataComparers.UnorderedRowNamedColumn);
}
public void ThenTheTableShouldBePopulatedWithData(string tableName, Table table)
{
var expected = new CollectionPopulatedTableData(table.Header, table.Rows.Select(x => x.Values));
var actual = LoadTableDataFromSql(string.Format("SELECT * FROM {0}", tableName));
expected.VerifyMatch(actual, TableDataComparers.UnorderedRowNamedColumn);
}
public void CollectionPopulatedTableDataObjectValues()
{
var expectedColumnNames = new List<string> { "a", "b" };
var expectedRows = new List<IList<object>> { new List<object> { "1", "2" } };
var sourceRows = new List<List<object>> { new List<object> { "1", "2" } };
var tableData = new CollectionPopulatedTableData(columnNames, sourceRows);
Assert.IsTrue(expectedColumnNames.SequenceEqual(tableData.ColumnNames));
Assert.IsTrue(expectedRows[0].SequenceEqual(tableData.Rows[0]));
}
public void CollectionPopulatedTableDataNullValueTransformer()
{
var expectedColumnNames = new List<string> { "a", "b"};
var expectedRows = new List<IList<object>> { new List<object> { DBNull.Value, "2" } };
var sourceRows = new List<List<object>> { new List<object> { "NULL", "2" } };
var tableData = new CollectionPopulatedTableData(columnNames, sourceRows);
tableData.TransformData(new TableDataNullValueTransformer());
Assert.IsTrue(expectedColumnNames.SequenceEqual(tableData.ColumnNames));
Assert.IsTrue(expectedRows[0].SequenceEqual(tableData.Rows[0]));
}
public void ThenTheTableShouldBePopulatedWithIdAndDates(string tableName, Table table)
{
var expected = new CollectionPopulatedTableData(table.Header, table.Rows.Select(x => x.Values));
foreach (var row in expected.Rows)
{
if (row[1].ToString() == "NULL")
row[1] = DBNull.Value;
}
var actual = LoadTableDataFromSql(string.Format("SELECT * FROM {0}", tableName));
expected.VerifyMatch(actual, TableDataComparers.UnorderedRowNamedColumn);
}
public void WhenTableIsPopulatedSupportingNullValues(string tableName, Table table)
{
var tableActions = new TableActions(database.ConnectionString);
var tableData = new CollectionPopulatedTableData(table.Header, table.Rows.Select(x => x.Values));
tableData.TransformData(new TableDataNullValueTransformer());
tableActions.Insert(DatabaseObjectName.FromName(tableName), tableData);
}
