ExcelORM/ExcelORM/ExcelORMTests/DynamicReaderTests.cs

using ExcelORM;

namespace ExcelORMTests;

public class DynamicReaderTests
{
    private const string RegularFile = "testFiles/first.xlsx";
    private const string DifferentTypesFile = "testFiles/differentTypes.xlsx";
    private const string MultipleSheetsFile = "testFiles/multipleSheets.xlsx";
    private const string DifficultFile = "testFiles/dynamicDifficult.xlsx";

    [Fact]
    public void Read()
    {
        using var reader = new ExcelDynamicReader(RegularFile);
        var results = reader.Read("Sheet 1").ToArray();
        Assert.NotEmpty(results);
    }

    [Fact]
    public void ReadDifferentTypes()
    {
        using var reader = new ExcelDynamicReader(DifferentTypesFile);
        var results = reader.Read().ToArray();
        Assert.NotEmpty(results);

        var first = results.First();
        Assert.Equal(typeof(string), first[0].Type);
        Assert.Equal(typeof(DateTime), first[1].Type);
        Assert.Equal(typeof(TimeSpan), first[2].Type);
        Assert.Equal(typeof(double), first[3].Type);
        Assert.Equal(typeof(double), first[4].Type);
    }

    [Fact]
    public void ReadAll()
    {
        using var reader = new ExcelDynamicReader(MultipleSheetsFile);
        var results = reader.ReadAll().ToArray();
        Assert.NotEmpty(results);
    }

    [Fact]
    public void ReadDifficult()
    {
        using var reader = new ExcelDynamicReader(DifficultFile);
        var results = reader.Read().ToArray();
        Assert.NotEmpty(results);
        Assert.Equal(results.First().Count, results.Last().Count);
    }
    
    private const string EmptyFileForAppend = "testFiles/emptyForAppend.xlsx";
    
    [Fact]
    public void ReadEmptyFile()
    {
        using var reader = new ExcelDynamicReader(EmptyFileForAppend);
        var results = reader.Read().ToArray();
        Assert.Empty(results);
    } 
}