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(new ColumnOrdinalIdentifier(0), transformation)); }
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(new ColumnOrdinalIdentifier(0), transformation); provider.Transform(resultSet); Assert.That(resultSet.Rows[0][0], Is.EqualTo("(null)")); }
public void Transform_NativeTranformationTrim_Correct() { var resultSet = new NBi.Core.ResultSet.ResultSet(); resultSet.Load(" aaaa ;10"); var transformation = Mock.Of <ITransformationInfo> ( t => t.Language == LanguageType.Native && t.OriginalType == NBi.Core.ResultSet.ColumnType.Text && t.Code == "text-to-trim" ); var provider = new TransformationProvider(); provider.Add(0, transformation); provider.Transform(resultSet); Assert.That(resultSet.Rows[0][0], Is.EqualTo("aaaa")); }
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(new ColumnOrdinalIdentifier(0), transformation); provider.Transform(resultSet); Assert.That(resultSet.Rows[0][0], Is.EqualTo("a")); }
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(new ColumnOrdinalIdentifier(0), transformation); provider.Transform(resultSet); Assert.That(resultSet.Rows[0][0], Is.EqualTo(202)); }
public void Transform_NativeTranformationFirstCharWithContext_Correct() { var resultSet = new NBi.Core.ResultSet.ResultSet(); resultSet.Load(new[] { new object[] { "123456789", 6 }, new object[] { "abcdefgh", 2 } }); var transformation = Mock.Of <ITransformationInfo> ( t => t.Language == LanguageType.Native && t.OriginalType == ColumnType.Text && t.Code == "text-to-first-chars(#1)" ); var provider = new TransformationProvider(new ServiceLocator(), Context.None); provider.Add(new ColumnOrdinalIdentifier(0), transformation); provider.Transform(resultSet); Assert.That(resultSet.Rows[0][0], Is.EqualTo("123456")); Assert.That(resultSet.Rows[1][0], Is.EqualTo("ab")); }
public void Transform_SimpleTranformation_CorrectHandlingOfColumnNames() { var resultSet = new NBi.Core.ResultSet.ResultSet(); resultSet.Load("aaaa;10"); resultSet.Columns[0].ColumnName = "MyCol0"; resultSet.Columns[1].ColumnName = "MyCol1"; var transformation = Mock.Of <ITransformationInfo> ( t => t.Language == LanguageType.CSharp && t.OriginalType == ColumnType.Text && t.Code == "value.Substring(0,1)" ); var provider = new TransformationProvider(new ServiceLocator(), Context.None); provider.Add(new ColumnOrdinalIdentifier(0), transformation); provider.Transform(resultSet); Assert.That(resultSet.Columns[0].ColumnName, Is.EqualTo("MyCol0")); Assert.That(resultSet.Columns[1].ColumnName, Is.EqualTo("MyCol1")); Assert.That(resultSet.Columns.Count, Is.EqualTo(2)); }
protected NBiConstraint InstantiateConstraint() { EqualToConstraint ctr = null; if (ConstraintXml.GetCommand() != null) { var commandText = ConstraintXml.GetCommand().CommandText; var connectionString = ConstraintXml.GetCommand().Connection.ConnectionString; var timeout = ((QueryXml)(ConstraintXml.BaseItem)).Timeout; IEnumerable <IQueryParameter> parameters = null; IEnumerable <IQueryTemplateVariable> variables = null; if (ConstraintXml.Query != null) { parameters = ConstraintXml.Query.GetParameters(); variables = ConstraintXml.Query.GetVariables(); } var commandBuilder = new CommandBuilder(); var cmd = commandBuilder.Build(connectionString, commandText, parameters, variables, timeout); ctr = new EqualToConstraint(cmd); } else if (ConstraintXml.ResultSet != null) { if (!string.IsNullOrEmpty(ConstraintXml.ResultSet.File)) { Trace.WriteLineIf(NBiTraceSwitch.TraceVerbose, "ResultSet defined in external file!"); ctr = new EqualToConstraint(ConstraintXml.ResultSet.GetFile()); if (ConstraintXml.Settings.CsvProfile != null) { ctr = ctr.CsvProfile(ConstraintXml.Settings.CsvProfile); } } else if (ConstraintXml.ResultSet.Rows != null) { Trace.WriteLineIf(NBiTraceSwitch.TraceVerbose, "ResultSet defined in embedded resultSet!"); ctr = new EqualToConstraint(ConstraintXml.ResultSet.Rows); } } else if (ConstraintXml.XmlSource != null) { var selects = new List <AbstractSelect>(); var factory = new SelectFactory(); foreach (var select in ConstraintXml.XmlSource.XPath.Selects) { selects.Add(factory.Instantiate(select.Value, select.Attribute, select.Evaluate)); } XPathEngine engine = null; if (ConstraintXml.XmlSource.File != null) { Trace.WriteLineIf(NBiTraceSwitch.TraceVerbose, string.Format("Xml file at '{0}'", ConstraintXml.XmlSource.GetFile())); engine = new XPathFileEngine(ConstraintXml.XmlSource.GetFile(), ConstraintXml.XmlSource.XPath.From.Value, selects); } else if (ConstraintXml.XmlSource.Url != null) { Trace.WriteLineIf(NBiTraceSwitch.TraceVerbose, string.Format("Xml file at '{0}'", ConstraintXml.XmlSource.Url.Value)); engine = new XPathUrlEngine(ConstraintXml.XmlSource.Url.Value, ConstraintXml.XmlSource.XPath.From.Value, selects); } else { throw new ArgumentException("File or Url can't be both empty when declaring an xml-source."); } ctr = new EqualToConstraint(engine); } if (ctr == null) { throw new ArgumentException(); } //Manage settings for comparaison ResultSetComparisonSettings settings = null; if (ConstraintXml.Behavior == EqualToXml.ComparisonBehavior.SingleRow) { ctr = ctr.Using(new SingleRowComparer()); settings = new SingleRowComparisonSettings( ConstraintXml.ValuesDefaultType, new NumericToleranceFactory().Instantiate(ConstraintXml.Tolerance), ConstraintXml.ColumnsDef ); } else { settings = new ResultSetComparisonSettings( ConstraintXml.KeysDef, ConstraintXml.ValuesDef, ConstraintXml.ValuesDefaultType, new NumericToleranceFactory().Instantiate(ConstraintXml.Tolerance), ConstraintXml.ColumnsDef ); } ctr.Using(settings); //Manage transformations var transformationProvider = new TransformationProvider(); foreach (var columnDef in ConstraintXml.ColumnsDef) { if (columnDef.Transformation != null) { transformationProvider.Add(columnDef.Index, columnDef.Transformation); } } ctr = ctr.Using(transformationProvider); //Manage parallelism if (ConstraintXml.ParallelizeQueries) { ctr = ctr.Parallel(); } else { ctr = ctr.Sequential(); } //Manage persistance //EqualToConstraint.PersistanceItems persi = 0; //if (ConstraintXml.GetCommand() != null) // persi += (int)EqualToConstraint.PersistanceItems.actual; //if (SystemUnderTestXml is QueryXml) // persi += (int)EqualToConstraint.PersistanceItems.expected; //if (!(persi==0 || ConstraintXml.Query==null || string.IsNullOrEmpty(ConstraintXml.Test.Name))) // ctr.Persist(ConstraintXml.Persistance, persi, ConstraintXml.Test.Name); return(ctr); }
protected NBiConstraint InstantiateConstraint() { BaseResultSetComparisonConstraint ctr = null; //Manage transformations var transformationProvider = new TransformationProvider(); foreach (var columnDef in ConstraintXml.ColumnsDef) { if (columnDef.Transformation != null) { transformationProvider.Add(columnDef.Index, columnDef.Transformation); } } if (ConstraintXml.GetCommand() != null) { ctr = InstantiateConstraint(((QueryXml)(ConstraintXml.BaseItem)), ConstraintXml.Settings, transformationProvider); } else if (ConstraintXml.ResultSet != null) { ctr = InstantiateConstraint(ConstraintXml.ResultSet, ConstraintXml.Settings, transformationProvider); } else if (ConstraintXml.XmlSource != null) { ctr = InstantiateConstraint(ConstraintXml.XmlSource, ConstraintXml.Settings, transformationProvider); } if (ctr == null) { throw new ArgumentException(); } //Manage settings for comparaison var builder = new SettingsEquivalerBuilder(); if (ConstraintXml.Behavior == EqualToXml.ComparisonBehavior.SingleRow) { builder.Setup(false); builder.Setup(ConstraintXml.ValuesDefaultType, ConstraintXml.Tolerance); builder.Setup(ConstraintXml.ColumnsDef); } else { builder.Setup(ConstraintXml.KeysDef, ConstraintXml.ValuesDef); builder.Setup( ConstraintXml.KeyName?.Replace(" ", "").Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Distinct(), ConstraintXml.ValueName?.Replace(" ", "").Split(new[] { ',' }, StringSplitOptions.RemoveEmptyEntries).Distinct()); builder.Setup(ConstraintXml.ValuesDefaultType, ConstraintXml.Tolerance); builder.Setup(ConstraintXml.ColumnsDef); } builder.Build(); var settings = builder.GetSettings(); var factory = new EquivalerFactory(); var comparer = factory.Instantiate(settings, EquivalenceKind); ctr = ctr.Using(comparer); ctr = ctr.Using(settings); //Manage parallelism if (ConstraintXml.ParallelizeQueries) { ctr = ctr.Parallel(); } else { ctr = ctr.Sequential(); } return(ctr); }
public IEnumerable <Alter> InstantiateAlterations(ResultSetSystemXml resultSetXml) { if (resultSetXml.Alteration == null) { yield break; } if (resultSetXml.Alteration.Filters != null) { foreach (var filterXml in resultSetXml.Alteration.Filters) { var expressions = new List <IColumnExpression>(); if (filterXml.Expression != null) { expressions.Add(filterXml.Expression); } var factory = new PredicateFilterFactory(); if (filterXml.Predication != null) { yield return(factory.Instantiate ( filterXml.Aliases , expressions , filterXml.Predication ).Apply); } if (filterXml.Combination != null) { yield return(factory.Instantiate ( filterXml.Aliases , expressions , filterXml.Combination.Operator , filterXml.Combination.Predicates ).Apply); } } } if (resultSetXml.Alteration.Conversions != null) { foreach (var conversionXml in resultSetXml.Alteration.Conversions) { var factory = new ConverterFactory(); var converter = factory.Instantiate(conversionXml.Converter.From, conversionXml.Converter.To, conversionXml.Converter.DefaultValue, conversionXml.Converter.Culture); var engine = new ConverterEngine(conversionXml.Column, converter); yield return(engine.Execute); } } if (resultSetXml.Alteration.Transformations != null) { var provider = new TransformationProvider(); foreach (var transformationXml in resultSetXml.Alteration.Transformations) { provider.Add(transformationXml.ColumnIndex, transformationXml); } yield return(provider.Transform); } }