public void LoadToFile_ValidData_WritesDateTimeInIsoStandardFormat() { // Arrange var sut = new TidyDataCsvLoader(); var tidyData = ManualArranger.GetTidyDataDerivedFromMockDateTimeObservation(); string dirPath = @"Assets\Output"; // Act string fileName = sut.LoadToFile(tidyData, dirPath, "test"); // Assert string fileContents = File.ReadAllText( Path.Combine(dirPath, fileName)); Assert.Contains("2019-12-01T08:15:00+00:00", fileContents); // Cleanup var files = Directory.GetFiles(dirPath, "test*"); if (files.Length > 0) { foreach (var file in files) { File.Delete(file); } } }
public async void ExtractMeasurementV2FromCosmosTransformToTidyWriteToCsv() { // Arrange string uri = System.Configuration.ConfigurationManager.AppSettings["cosmosUri"]; string key = System.Configuration.ConfigurationManager.AppSettings["cosmosKey"]; string dirPath = @"Output"; string fileName = "test"; var extractor = new CafDbExtractor(uri, key); var transformer = new ManualTidyDataTransformer(); var loader = new TidyDataCsvLoader(); // Act List <MeasurementV2> measurements = await extractor.ExtractMeasurementsV2( "CafMeteorologyEcTower", "CookEast", "ParDensityTsAvg", "2019-12-12", "2019-12-13"); TidyData tidyData = transformer.Transform <ParDataTable>(measurements); loader.LoadToFile(tidyData, dirPath, fileName); // Assert var files = Directory.GetFiles(dirPath, $"{fileName}*"); Assert.Equal(2, files.Length); // Cleanup if (files.Length > 0) { foreach (var file in files) { File.Delete(file); } } }
public void LoadToFile_ValidData_WritesFile() { // Arrange var sut = new TidyDataCsvLoader(); var tidyData = ManualArranger.GetTidyDataDerivedFromActualDataV1(); string dirPath = @"Assets\Output"; // Act sut.LoadToFile(tidyData, dirPath, "test"); // Assert var files = Directory.GetFiles(dirPath, "test*"); Assert.Equal(2, files.Length); // Cleanup if (files.Length > 0) { foreach (var file in files) { File.Delete(file); } } }