public void TestDataSourceLoadsNoColumnHeaderColumnsHappyPath()
{
var dataFileName = System.IO.Path.GetFullPath(@"Data\Beers_NoHeader.csv");
var columns = new[] { "Column 1", "Column 2" };
var systemUnderTest = new CsvFileDataSource
{
FileName = dataFileName,
FirstRowAsColumnNames = false
};
Assert.That(systemUnderTest.State, Is.EqualTo(LoadState.NotLoaded));
var result = systemUnderTest.LoadData();
Assert.That(result, Is.True, systemUnderTest.GetLoadingLog().ToString());
Assert.That(systemUnderTest.LastLoadDate.Value.ToDateTimeUnspecified(), Is.GreaterThanOrEqualTo(DateTime.Now.Subtract(new TimeSpan(0, 0, 10, 0))));
Assert.That(systemUnderTest.CreatedBy, Is.Not.Empty);
Assert.That(systemUnderTest.State, Is.EqualTo(LoadState.Loaded));
Assert.That(systemUnderTest.Columns.Length, Is.EqualTo(2));
for (var i = 0; i < columns.Length; i++)
{
Assert.That(systemUnderTest.Columns[i], Is.EqualTo(columns[i]));
}
Assert.That(systemUnderTest.RowCount, Is.EqualTo(4));
var loadinglog = systemUnderTest.GetLoadingLog();
Assert.That(loadinglog, Is.Not.Empty);
Console.Write("Approximate size: {0}", systemUnderTest.ApproximateSizeInBytes());
Console.Write(loadinglog);
}
public void TestDataSourceLoadsColumnsHappyPath()
{
var dataFileName = System.IO.Path.GetFullPath(@"Data\Beers.csv");
var secondDataFile = System.IO.Path.GetFullPath(@"Data\BeersDrinkingHistory.csv");
var leftFile = new CsvFileDataSource
{
FileName = dataFileName,
FirstRowAsColumnNames = true
};
var rightFile = new CsvFileDataSource
{
FileName = secondDataFile,
FirstRowAsColumnNames = true
};
var systemUnderTest = new MergedDataSource
{
Left = leftFile,
Right = rightFile,
JoinOn = "Beer ID"
};
systemUnderTest.LoadData();
Assert.That(systemUnderTest.RowCount, Is.EqualTo(4));
Assert.That(systemUnderTest.Data.Select("[Beer ID] = 1").Count(), Is.EqualTo(0));
Assert.That(systemUnderTest.Data.Select("[Beer ID] = 3").Count(), Is.EqualTo(2));
}
