public void TryGetPropertyMap_TypeValid_ReturnsPropertyMap()
{
var type = typeof(TestType);
var propertyMap = TypeRepository.GetPropertyMap(type);
var sheet = MockedSheetFactory.GetMockedSheet(TestType.TableData);
var sheetTable = new SheetTable(sheet);
var res = TypeRepository.TryGetPropertyMap(sheetTable, type, out var map);
Assert.That(res);
Assert.That(propertyMap.Keys.All(k => !String.IsNullOrWhiteSpace(k[0])));
}
public void Indexer_ValidRowAndColumn_ReturnsCellValue()
{
// Arrange:
var sheet = MockedSheetFactory.HeaderTestCases(5, 5).Cast <TestCaseData>().First().Arguments[0] as ISheet;
var sheetTable = new SheetTable(sheet);
// Action:
var res = sheetTable[2, 2];
// Assert:
Assert.That(res, Is.Not.Null);
Assert.That(res.GetType().IsAssignableFrom(typeof(CellValue)));
}
public void Indexer_SheetTableContainsOnlyHeaders_Throws()
{
// Arrange:
var sheet = MockedSheetFactory.HeaderTestCases(5, 5).Cast <TestCaseData>().Where(tc => tc.TestName.Contains("#8"))?.First().Arguments[0] as ISheet;
var sheetTable = new SheetTable(sheet);
// Action:
var ex = Assert.Catch <InvalidOperationException>(() =>
{
var res = sheetTable[0, 0];
});
// Assert:
StringAssert.Contains("Sheet has only headers.", ex.Message);
}
public void Indexer_ColumnOutOfRange_Throws()
{
// Arrange:
var sheet = MockedSheetFactory.HeaderTestCases(5, 5).Cast <TestCaseData>().First().Arguments[0] as ISheet;
var sheetTable = new SheetTable(sheet);
// Action:
var ex = Assert.Catch <IndexOutOfRangeException>(() =>
{
var res = sheetTable[0, -1];
});
// Assert:
StringAssert.Contains("Column was outside the bounds of sheet table.", ex.Message);
}
private SheetTable GetMockedSheetTable(string[,] tableData)
{
return(new SheetTable(MockedSheetFactory.GetMockedSheet(tableData)));
}
