public async void MergeBlobs_ChangeParameterValue_UpdatesParamValueOnly()
{
// Arrange
Mock <IBlobExtractor> extractor = new Mock <IBlobExtractor>();
extractor.Setup(l => l.ExtractBlobAsync(It.IsAny <string>()))
.Returns((string input) => Task.FromResult <MemoryStream>(
GetMemoryStreamFromFile(input)));
int expectedParamValue = 4;
string expectedNonParamValue = "CE1_GP_2019_WW_Bio";
// Has change in parameter value and observation value, should only update parameter
var det = await extractor.Object.ExtractBlobAsync(
"Assets/Harvest01_2019_GP-ART-Lime_INT_YYYYMMDD_20190802_updateParam.xlsm");
var master = await extractor.Object.ExtractBlobAsync(
"Assets/Harvest01_2019_GP-ART-Lime_INT_YYYYMMDD_20190802.xlsm");
BlobTransformer sut = new BlobTransformer();
// Act
MemoryStream ms = sut.MergeBlobs(det, master, 7);
// Assert
using (ExcelPackage package = new ExcelPackage(ms))
{
ExcelWorksheet ws = package.Workbook.Worksheets[1];
Assert.True(
ws.Cells[2, 2].GetValue <int>() == expectedParamValue);
Assert.True(
ws.Cells[8, 2].GetValue <string>() == expectedNonParamValue);
}
}
public async void MergeBlobs_ValidInput_CorrectlyMergeValues()
{
// Arrange
Mock <IBlobExtractor> extractor = new Mock <IBlobExtractor>();
extractor.Setup(l => l.ExtractBlobAsync(It.IsAny <string>()))
.Returns((string input) => Task.FromResult <MemoryStream>(
GetMemoryStreamFromFile(input)));
var det = await extractor.Object.ExtractBlobAsync(
"Assets/SoilDryingGrinding01_GridPointSurvey_BC_20190418_fromSomeValues.xlsx");
var master = await extractor.Object.ExtractBlobAsync(
"Assets/SoilDryingGrinding01_GridPointSurvey_IN_YYYYMMDD_someValues.xlsx");
BlobTransformer sut = new BlobTransformer();
// Act
MemoryStream ms = sut.MergeBlobs(det, master, 6);
// Assert
using (ExcelPackage package = new ExcelPackage(ms))
{
ExcelWorksheet ws = package.Workbook.Worksheets[1];
Assert.True(ws.Cells[8, 2].GetValue <string>().Length > 0);
Assert.True(ws.Cells[8, 10].GetValue <string>().Length > 0);
Assert.True(ws.Cells[311, 5].GetValue <string>().Length > 0);
}
}
public async void MergeBlobs_ChangeValues_UpdatesValues()
{
// Arrange
Mock <IBlobExtractor> extractor = new Mock <IBlobExtractor>();
extractor.Setup(l => l.ExtractBlobAsync(It.IsAny <string>()))
.Returns((string input) => Task.FromResult <MemoryStream>(
GetMemoryStreamFromFile(input)));
string expectedDate = "08/05/2019";
string expectedTotalWeight = "20";
string expectedInitials = "brc";
string expectedAvgBagMass = "1.0";
string expectedSecondBagMass = "N/A";
string expectedAvgEmptyBagMass = "2.0";
string expectedBiomass = "19";
string expectedComment = "Foo";
// Has change in parameter value and observation value, should only update parameter
var det = await extractor.Object.ExtractBlobAsync(
"Assets/Harvest01_2019_GP-ART-Lime_INT_YYYYMMDD_20190802_updateValues.xlsm");
var master = await extractor.Object.ExtractBlobAsync(
"Assets/Harvest01_2019_GP-ART-Lime_INT_YYYYMMDD_20190802.xlsm");
BlobTransformer sut = new BlobTransformer();
// Act
MemoryStream ms = sut.MergeBlobs(det, master, 7);
// Assert
using (ExcelPackage package = new ExcelPackage(ms))
{
ExcelWorksheet ws = package.Workbook.Worksheets[1];
Assert.True(
ws.Cells[8, 3].GetValue <string>() == expectedDate);
Assert.True(
ws.Cells[10, 3].GetValue <string>() == expectedDate);
Assert.True(
ws.Cells[12, 3].GetValue <string>() == expectedDate);
Assert.True(
ws.Cells[830, 3].GetValue <string>() == expectedDate);
Assert.True(
ws.Cells[10, 4].GetValue <string>() == expectedTotalWeight);
Assert.True(
ws.Cells[10, 5].GetValue <string>() == expectedInitials);
Assert.True(
ws.Cells[10, 6].GetValue <string>() == expectedAvgBagMass);
Assert.True(
ws.Cells[10, 7].GetValue <string>() == expectedSecondBagMass);
Assert.True(
ws.Cells[10, 8].GetValue <string>() == expectedAvgEmptyBagMass);
Assert.True(
ws.Cells[10, 9].GetValue <string>() == expectedBiomass);
Assert.True(
ws.Cells[830, 70].GetValue <string>() == expectedComment);
}
}
public static async Task <IActionResult> Run(
[HttpTrigger(AuthorizationLevel.Function, "get", "post", Route = null)]
HttpRequest req,
ILogger log)
{
log.LogInformation("C# HTTP trigger function processed a request.");
// Get Config info
var config = new ConfigurationBuilder()
.SetBasePath(Environment.CurrentDirectory)
.AddJsonFile("local.settings.json", optional: true, reloadOnChange: true)
.AddEnvironmentVariables()
.Build();
string connectionString = config["BlobStorageConnection"] ??
config["Values:BlobStorageConnection"];
// Get request body, parse json to get paths to blob files
string requestBody = await new StreamReader(req.Body).ReadToEndAsync();
dynamic data = JsonConvert.DeserializeObject(requestBody);
string uriDet = data?.det;
string uriMaster = data?.master;
int headerRow = data?.headerRow;
string masterBlobContainerName = data?.masterBlobContainerName;
string masterBlobPath = data?.masterBlobPath;
log.LogInformation($"det: {uriDet}, master: {uriMaster}");
log.LogInformation($"headerRow: {headerRow}");
log.LogInformation($"masterBlobContainerName: {masterBlobContainerName}");
log.LogInformation($"masterBlobPath: {masterBlobPath}");
// Get blobs as MemoryStream
BlobExtractor blobLoader = new BlobExtractor(connectionString);
MemoryStream detStream =
await blobLoader.ExtractBlobAsync(uriDet);
MemoryStream masterStream =
await blobLoader.ExtractBlobAsync(uriMaster);
BlobTransformer merger = new BlobTransformer();
MemoryStream updatedBlob = merger.MergeBlobs(
detStream, masterStream, 6);
BlobLoader uploader = new BlobLoader(connectionString);
bool isSuccess = await uploader.LoadBlobAsync(
updatedBlob, masterBlobContainerName, masterBlobPath);
return(isSuccess
? (ActionResult) new OkObjectResult("Master template updated")
: new BadRequestObjectResult("Something bad happened"));
}
public async void MergeBlobs_DetDifferentThanMaster_ThrowsException()
{
// Arrange
Mock <IBlobExtractor> extractor = new Mock <IBlobExtractor>();
extractor.Setup(l => l.ExtractBlobAsync(It.IsAny <string>()))
.Returns((string input) => Task.FromResult <MemoryStream>(
GetMemoryStreamFromFile(input)));
var det = await extractor.Object.ExtractBlobAsync(
"Assets/SoilBulkDensity01_GridPointSurvey_BC_20190201.xlsx");
var master = await extractor.Object.ExtractBlobAsync(
"Assets/SoilDryingGrinding01_GridPointSurvey_IN_YYYYMMDD_empty.xlsx");
BlobTransformer sut = new BlobTransformer();
// Act
var ex = Assert.Throws <ArgumentException>(() => sut.MergeBlobs(det, master, 6));
// Assert
Assert.Equal("DET file does not match Master file", ex.Message);
}
public async void TransformBlobs_NoData_ThrowsException()
{
// Arrange
Mock <IBlobExtractor> extractor = new Mock <IBlobExtractor>();
extractor.Setup(l => l.ExtractBlobAsync(It.IsAny <string>()))
.Returns(Task.FromResult <MemoryStream>(new MemoryStream()));
var blob1 = await extractor.Object.ExtractBlobAsync("");
var blob2 = await extractor.Object.ExtractBlobAsync("");
BlobTransformer sut = new BlobTransformer();
// Act
var ex = Assert.Throws <ArgumentException>(
() => sut.MergeBlobs(blob1, blob2, 6));
// Assert
Assert.Equal(
"One or more input blobs do not have data",
ex.Message);
}
