public void MultirowScriptMappingWorksCorrectly()
{
ScriptMapping script = new ScriptMapping("return Get-Date ([datetime]::ParseExact($inputValues.WeirdDate,'ddMMyyyy_HHmmss',$null)) -Format 'yyyy-mm-dd'");
Dictionary <string, object> inputRow1 = new Dictionary <string, object>();
inputRow1.Add("WeirdDate", "24122014_022257");
string expected1 = "2014-22-24";
string actual1 = (string)script.GetValue(inputRow1);
Dictionary <string, object> inputRow2 = new Dictionary <string, object>();
inputRow2.Add("WeirdDate", "24122017_022257");
string expected2 = "2017-22-24";
string actual2 = (string)script.GetValue(inputRow2);
Dictionary <string, object> inputRow3 = new Dictionary <string, object>();
inputRow3.Add("WeirdDate", "24122020_022257");
string expected3 = "2020-22-24";
string actual3 = (string)script.GetValue(inputRow3);
CollectionAssert.AreEqual(
new string[] { expected1, expected2, expected3 },
new string[] { actual1, actual2, actual3 },
"Wrong values parsed out for multi row script mapping"
);
}
public void ComplexScriptMappingWorksCorrectly()
{
ScriptMapping script = new ScriptMapping("return Get-Date ([datetime]::ParseExact($inputValues.WeirdDate,'ddMMyyyy_HHmmss',$null)) -Format 'yyyy-mm-dd'");
Dictionary <string, object> inputRow = new Dictionary <string, object>();
inputRow.Add("WeirdDate", "24122014_022257");
string expected = "2014-22-24";
object actual = script.GetValue(inputRow);
Assert.AreEqual(expected, actual, "Complex script mapping work correctly");
}
public void ScriptMappingWorksCorrectly()
{
ScriptMapping script = new ScriptMapping("return \"hello \" + $inputValues.A");
Dictionary <string, object> inputRow = new Dictionary <string, object>();
inputRow.Add("A", "C");
object expected = "hello C";
object actual = script.GetValue(inputRow);
Assert.AreEqual(expected, actual, "Script mapping work correctly");
}
