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