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)); }