public void Transform_NativeTranformationUnknown_Exception() { var resultSet = new NBi.Core.ResultSet.ResultSet(); resultSet.Load("\t;10"); var transformation = Mock.Of <ITransformationInfo> ( t => t.Language == LanguageType.Native && t.OriginalType == NBi.Core.ResultSet.ColumnType.Text && t.Code == "unknown" ); var provider = new TransformationProvider(); Assert.Throws <NotImplementedTransformationException>(() => provider.Add(0, transformation)); }
public void Transform_SimpleTranformation_Correct() { var resultSet = new NBi.Core.ResultSet.ResultSet(); resultSet.Load("aaaa;10"); var transformation = Mock.Of <ITransformationInfo> ( t => t.Language == LanguageType.CSharp && t.OriginalType == NBi.Core.ResultSet.ColumnType.Text && t.Code == "value.Substring(0,1)" ); var provider = new TransformationProvider(); provider.Add(0, transformation); provider.Transform(resultSet); Assert.That(resultSet.Rows[0][0], Is.EqualTo("a")); }
public void Transform_NativeTranformationBlankToNull_Correct() { var resultSet = new NBi.Core.ResultSet.ResultSet(); resultSet.Load("\t;10"); var transformation = Mock.Of <ITransformationInfo> ( t => t.Language == LanguageType.Native && t.OriginalType == NBi.Core.ResultSet.ColumnType.Text && t.Code == "blank-to-null" ); var provider = new TransformationProvider(); provider.Add(0, transformation); provider.Transform(resultSet); Assert.That(resultSet.Rows[0][0], Is.EqualTo("(null)")); }
public void Transform_TypeSwitch_Correct() { var resultSet = new NBi.Core.ResultSet.ResultSet(); var obj = new object[] { new DateTime(2016, 10, 1) }; resultSet.Load(Enumerable.Repeat(obj, 1)); var transformation = Mock.Of <ITransformationInfo> ( t => t.Language == LanguageType.CSharp && t.OriginalType == NBi.Core.ResultSet.ColumnType.DateTime && t.Code == "value.Month + (value.Year-2000)*12" ); var provider = new TransformationProvider(); provider.Add(0, transformation); provider.Transform(resultSet); Assert.That(resultSet.Rows[0][0], Is.EqualTo(202)); }