Test your AI Agents with the all-new Agent to Agent Testing Platform.Learn More

How to use TransformXml class of NBi.Xml.Items.Alteration.Transform package

Best NBi code snippet using NBi.Xml.Items.Alteration.Transform.TransformXml

ResultSetSystemHelper.cs

Source:ResultSetSystemHelper.cs

...70                switch (alterationXml)71                {72                    case FilterXml x: yield return InstantiateFilter(x); break;73                    case ConvertXml x: yield return InstantiateConvert(x); break;74                    case TransformXml x: yield return InstantiateTransform(x); break;75                    case RenamingXml x: yield return InstantiateRename(x); break;76                    case SummarizeXml x: yield return InstantiateSummarize(x); break;77                    case ExtendXml x: yield return InstantiateExtend(x); break;78                    case UnstackXml x: yield return InstantiateUnstack(x); break;79                    case ProjectAwayXml x: yield return InstantiateProjectAway(x); break;80                    case ProjectXml x: yield return InstantiateProject(x); break;81                    case LookupReplaceXml x: yield return InstantiateLookupReplace(x, resultSetXml.Settings); break;82                    case MergeXml x: yield return InstantiateMerging(x, resultSetXml.Settings); break;83                    case DuplicateXml x: yield return InstantiateDuplicate(x); break;84                    default: throw new ArgumentException();85                }86            }87        }88        private Alter InstantiateFilter(FilterXml filterXml)89        {90            var context = new Context(Variables);91            var factory = new ResultSetFilterFactory(ServiceLocator);92            if (filterXml.Ranking == null && filterXml.Uniqueness == null)93            {94                var expressions = new List<IColumnExpression>();95                if (filterXml.Expression != null)96                    expressions.Add(filterXml.Expression);97                if (filterXml.Predication != null)98                {99                    var helper = new PredicateArgsBuilder(ServiceLocator, context);100                    var args = helper.Execute(filterXml.Predication.ColumnType, filterXml.Predication.Predicate);101                    return factory.Instantiate102                                (103                                    new PredicationArgs(filterXml.Predication.Operand, args)104                                    , context105                                ).Apply;106                }107                if (filterXml.Combination != null)108                {109                    var helper = new PredicateArgsBuilder(ServiceLocator, context);110                    var predicationArgs = new List<PredicationArgs>();111                    foreach (var predication in filterXml.Combination.Predications)112                    {113                        var args = helper.Execute(predication.ColumnType, predication.Predicate);114                        predicationArgs.Add(new PredicationArgs(predication.Operand, args));115                    }116                    return factory.Instantiate117                                (118                                    filterXml.Combination.Operator119                                    , predicationArgs120                                    , context121                                ).Apply;122                }123                throw new ArgumentException();124            }125            else if (filterXml.Ranking != null)126            {127                var groupByArgs = BuildGroupByArgs(filterXml.Ranking.GroupBy, context);128                var groupByFactory = new GroupByFactory();129                var groupBy = groupByFactory.Instantiate(groupByArgs);130                var rankingGroupByArgs = new RankingGroupByArgs(groupBy, filterXml.Ranking.Option, filterXml.Ranking.Count, filterXml.Ranking.Operand, filterXml.Ranking.Type);131                return factory.Instantiate(rankingGroupByArgs, context).Apply;132            }133            else if (filterXml.Uniqueness != null)134            {135                var groupByArgs = BuildGroupByArgs(filterXml.Uniqueness.GroupBy, context);136                var groupByFactory = new GroupByFactory();137                var groupBy = groupByFactory.Instantiate(groupByArgs);138                var uniquenessArgs = new UniquenessArgs(groupBy);139                return factory.Instantiate(uniquenessArgs, context).Apply;140            }141            throw new ArgumentOutOfRangeException();142        }143        private IGroupByArgs BuildGroupByArgs(GroupByXml xml, Context context)144        {145            if (xml == null)146                return new NoneGroupByArgs();147            if ((xml?.Columns?.Count ?? 0) > 0)148                return new ColumnGroupByArgs(xml.Columns, context);149            if ((xml?.Cases?.Count ?? 0) > 0)150            {151                var builder = new PredicateArgsBuilder(ServiceLocator, context);152                var predications = new List<IPredication>();153                foreach (var caseXml in xml.Cases)154                {155                    if (caseXml.Predication is SinglePredicationXml)156                    {157                        var predicationXml = (caseXml.Predication) as SinglePredicationXml;158                        var args = builder.Execute(predicationXml.ColumnType, predicationXml.Predicate);159                        var predicate = new PredicateFactory().Instantiate(args);160                        var predicationFactory = new PredicationFactory();161                        predications.Add(predicationFactory.Instantiate(predicate, predicationXml.Operand));162                    }163                }164                return new CaseGroupByArgs(predications, context);165            }166            throw new ArgumentOutOfRangeException();167        }168        private Alter InstantiateConvert(ConvertXml convertXml)169        {170            var factory = new ConverterFactory();171            var converter = factory.Instantiate(convertXml.Converter.From, convertXml.Converter.To, convertXml.Converter.DefaultValue, convertXml.Converter.Culture);172            var engine = new ConverterEngine(convertXml.Column, converter);173            return engine.Execute;174        }175        private Alter InstantiateRename(RenamingXml renameXml)176        {177            var helper = new ScalarHelper(ServiceLocator, new Context(Variables));178            var newName = helper.InstantiateResolver<string>(renameXml.NewName);179            IMissingColumnStrategy strategy = new FailureMissingColumnStrategy();180            switch (renameXml.Missing.Behavior)181            {182                case alt.Renaming.MissingColumnBehavior.Skip:183                    strategy = new SkipAlterationStrategy();184                    break;185                default:186                    strategy = new FailureMissingColumnStrategy();187                    break;188            }189            var factory = new RenamingFactory();190            var renamer = factory.Instantiate(new NewNameRenamingArgs(renameXml.Identifier, newName, strategy));191            return renamer.Execute;192        }193        private Alter InstantiateMerging(MergeXml mergeXml, SettingsXml settingsXml)194        {195            var innerService = new ResultSetServiceBuilder();196            mergeXml.ResultSet.Settings = settingsXml;197            innerService.Setup(InstantiateResolver(mergeXml.ResultSet));198            innerService.Setup(InstantiateAlterations(mergeXml.ResultSet));199            var factory = new MergingFactory();200            IMergingArgs args;201            switch (mergeXml)202            {203                case UnionXml union: args = new UnionArgs(innerService.GetService(), union.ColumnIdentity); break;204                default: args = new CartesianProductArgs(innerService.GetService()); break;205            }206            var merger = factory.Instantiate(args);207            return merger.Execute;208        }209        private Alter InstantiateTransform(TransformXml transformXml)210        {211            var identifierFactory = new ColumnIdentifierFactory();212            var provider = new TransformationProvider(new ServiceLocator(), new Context(Variables));213            provider.Add(transformXml.Identifier, transformXml);214            return provider.Transform;215        }216        private Alter InstantiateSummarize(SummarizeXml summarizeXml)217        {218            var scalarHelper = new ScalarHelper(ServiceLocator, null);219            var factory = new SummarizationFactory();220            var aggregations = new List<ColumnAggregationArgs>()221                    {222                        new ColumnAggregationArgs(223                            (summarizeXml.Aggregation as ColumnAggregationXml)?.Identifier,...

TransformXmlTest.cs

Source:TransformXmlTest.cs

...16#endregion17namespace NBi.Testing.Xml.Unit.Items.ResultSet18{19    [TestFixture]20    public class TransformXmlTest : BaseXmlTest21    {22        [Test]23        public void Deserialize_CSharp_CSharpAndCode()24        {25            int testNr = 0;26            // Create an instance of the XmlSerializer specifying type and namespace.27            TestSuiteXml ts = DeserializeSample();28            Assert.That(ts.Tests[testNr].Constraints[0], Is.AssignableTo<EqualToXml>());29            var transfo = ((EqualToXml)ts.Tests[testNr].Constraints[0]).ColumnsDef[0].Transformation;30            Assert.That(transfo.Language, Is.EqualTo(LanguageType.CSharp));31            Assert.That(transfo.Code.Trim, Is.EqualTo("value.Trim().ToUpper();"));32        }33        [Test]34        public void Deserialize_Native_NativeAndNativeTransfo()35        {36            int testNr = 1;37            // Create an instance of the XmlSerializer specifying type and namespace.38            TestSuiteXml ts = DeserializeSample();39            Assert.That(ts.Tests[testNr].Constraints[0], Is.AssignableTo<EqualToXml>());40            var transfo = ((EqualToXml)ts.Tests[testNr].Constraints[0]).ColumnsDef[0].Transformation;41            Assert.That(transfo.Language, Is.EqualTo(LanguageType.Native));42            Assert.That(transfo.Code, Is.EqualTo("empty-to-null"));43        }44        [Test]45        public void Deserialize_OldValueTransformation_CorrectlyRead()46        {47            int testNr = 2;48            // Create an instance of the XmlSerializer specifying type and namespace.49            TestSuiteXml ts = DeserializeSample();50            Assert.That(ts.Tests[testNr].Constraints[0], Is.AssignableTo<EqualToXml>());51            var transfo = ((EqualToXml)ts.Tests[testNr].Constraints[0]).ColumnsDef[0].Transformation;52            Assert.That(transfo.Language, Is.EqualTo(LanguageType.Native));53            Assert.That(transfo.Code, Is.EqualTo("empty-to-null"));54        }55        [Test]56        public void Serialize_CSharp_CodeTransfo()57        {58            var def = new ColumnDefinitionXml()59            {60                TransformationInner = new LightTransformXml()61                {62                    Language = LanguageType.CSharp,63                    Code = "value.Trim().ToUpper();"64                }65            };66            var manager = new XmlManager();67            var xml = manager.XmlSerializeFrom<ColumnDefinitionXml>(def);68            Assert.That(xml, Does.Contain(">value.Trim().ToUpper();<"));69            Assert.That(xml, Does.Not.Contain("column-index"));70        }71        [Test]72        public void Serialize_Format_CodeTransfo()73        {74            var def = new ColumnDefinitionXml()75            {76                TransformationInner = new LightTransformXml()77                {78                    Language = LanguageType.Format,79                    Code = "##.000"80                }81            };82            var manager = new XmlManager();83            var xml = manager.XmlSerializeFrom<ColumnDefinitionXml>(def);84            Assert.That(xml, Does.Contain("format"));85            Assert.That(xml, Does.Contain(">##.000<"));86            Assert.That(xml, Does.Not.Contain("column-index"));87        }88        [Test]89        public void Serialize_Native_CodeTransfo()90        {91            var def = new ColumnDefinitionXml()92            {93                TransformationInner = new LightTransformXml()94                {95                    Language = LanguageType.Native,96                    Code = "empty-to-null"97                }98            };99            var manager = new XmlManager();100            var xml = manager.XmlSerializeFrom<ColumnDefinitionXml>(def);101            Assert.That(xml, Does.Contain("native"));102            Assert.That(xml, Does.Contain(">empty-to-null<"));103            Assert.That(xml, Does.Not.Contain("column-index"));104        }105        [Test]106        public void Serialize_AlterTransform_OrdinalCorrect()107        {108            var root = new ResultSetSystemXml()109            {110                Alterations = new List<AlterationXml>()111                {112                    new TransformXml()113                    {114                        Identifier = new ColumnOrdinalIdentifier(2),115                        Language = LanguageType.Native,116                        Code = "empty-to-null"117                    }118                }119            };120            var manager = new XmlManager();121            var xml = manager.XmlSerializeFrom(root);122            Assert.That(xml, Does.Contain("<transform "));123            Assert.That(xml, Does.Contain("column=\"#2\""));124        }125        [Test]126        public void Serialize_AlterTransform_IdentifierCorrect()127        {128            var root = new ResultSetSystemXml()129            {130                Alterations = new List<AlterationXml>()131                {132                    new TransformXml()133                    {134                        Identifier = new ColumnIdentifierFactory().Instantiate("[MyName]"),135                        Language = LanguageType.Native,136                        Code = "empty-to-null"137                    }138                }139            };140            var manager = new XmlManager();141            var xml = manager.XmlSerializeFrom(root);142            Assert.That(xml, Does.Contain("<transform "));143            Assert.That(xml, Does.Contain("column=\"[MyName]\""));144        }145    }146}...

ResultSetSystemXml.cs

Source:ResultSetSystemXml.cs

...108            XmlArrayItem(Type = typeof(RenamingXml), ElementName = "rename"),109            XmlArrayItem(Type = typeof(ExtendXml), ElementName = "extend"),110            XmlArrayItem(Type = typeof(FilterXml), ElementName = "filter"),111            XmlArrayItem(Type = typeof(ConvertXml), ElementName = "convert"),112            XmlArrayItem(Type = typeof(TransformXml), ElementName = "transform"),113            XmlArrayItem(Type = typeof(SummarizeXml), ElementName = "summarize"),114            XmlArrayItem(Type = typeof(UnstackXml), ElementName = "unstack"),115            XmlArrayItem(Type = typeof(ProjectXml), ElementName = "project"),116            XmlArrayItem(Type = typeof(ProjectAwayXml), ElementName = "project-away"),117            XmlArrayItem(Type = typeof(LookupReplaceXml), ElementName = "lookup-replace"),118            XmlArrayItem(Type = typeof(MergeXml), ElementName = "merge"),119            XmlArrayItem(Type = typeof(UnionXml), ElementName = "union"),120            XmlArrayItem(Type = typeof(DuplicateXml), ElementName = "duplicate"),121        ]122        public virtual List<AlterationXml> Alterations { get; set; }123        [XmlIgnore]124        public bool AlterationsSpecified125        {126            get => (Alterations?.Count ?? 0) > 0;...

TransformXml

Using AI Code Generation

1using NBi.Xml.Items.Alteration.Transform;2using NBi.Xml.Items.Alteration;3using NBi.Xml.Items;4using NBi.Xml;5using NBi.NUnit;6using NBi.NUnit.Builder;7using NBi.NUnit.Builder.Xml;8using NBi.NUnit.Builder.Xml.Helper;9using NBi.NUnit.Builder.Xml.Helper.Alteration;10using NBi.NUnit.Builder.Xml.Helper.Alteration.Transform;11using NBi.NUnit.Builder.Xml.Helper.Alteration.Transform.CSharp;12using NBi.NUnit.Builder.Xml.Helper.Alteration.Transform.CSharp.Extension;13using NBi.NUnit.Builder.Xml.Helper.Alteration.Transform.CSharp.Extension.Methods;14using NBi.NUnit.Builder.Xml.Helper.Alteration.Transform.CSharp.Extension.Methods.String;15using NBi.NUnit.Builder.Xml.Helper.Alteration.Transform.CSharp.Extension.Methods.String.Extension;16using NBi.NUnit.Builder.Xml.Helper.Alteration.Transform.CSharp.Extension.Methods.String.Extension.Methods;

TransformXml

Using AI Code Generation

1using NBi.Xml.Items.Alteration.Transform;2using NBi.Xml.Items.Alteration;3using NBi.Xml.Items;4using NBi.Xml;5using NBi.Xml;6using NBi.Core;7using NBi.Core;

TransformXml

Using AI Code Generation

1using NBi.Xml.Items.Alteration.Transform;2using NBi.Xml.Items.Alteration.Transform.Replace;3using NBi.Xml.Items.Alteration.Transform.Replace.Strategy;4using NBi.Xml.Items.Alteration.Transform.Replace.Strategy.WholeWord;5using NBi.Xml.Items.Alteration.Transform.Replace.Strategy.WholeWord.CaseSensitive;6using NBi.Xml.Items.Alteration.Transform.Replace.Strategy.WholeWord.CaseSensitive.Regex;7var transform = new TransformXml()8{9    Replace = new ReplaceXml()10    {11        Strategy = new WholeWordStrategyXml()12        {13            CaseSensitive = new CaseSensitiveStrategyXml()14            {15                Regex = new RegexStrategyXml()16                {17                    Search = @"(?<=\p{Ll})(\p{Lu})",18                }19            }20        }21    }22};23using NBi.Xml.Items.Alteration;24using NBi.Xml.Items.Alteration.Transform;25var alteration = new AlterationXml()26{27};28using NBi.Xml.Items.TestCase;29using NBi.Xml.Items.TestCase.Setting;30using NBi.Xml.Items.TestCase.Setting.CsvProfile;31using NBi.Xml.Items.TestCase.Setting.CsvProfile.Quote;32using NBi.Xml.Items.TestCase.Setting.CsvProfile.Separator;33using NBi.Xml.Items.TestCase.Setting.CsvProfile.Treat;34var testCase = new TestCaseXml()35{36};37using NBi.Xml.Items;

TransformXml

Using AI Code Generation

1var transform = new TransformXml();2transform.Value = "my value";3transform.Type = TransformXml.TransformType.CSharp;4var transform = new TransformXml();5transform.Value = "my value";6transform.Type = TransformXml.TransformType.Xslt;7var transform = new TransformXml();8transform.Value = "my value";9transform.Type = TransformXml.TransformType.Xsl;10var transform = new TransformXml();11transform.Value = "my value";12transform.Type = TransformXml.TransformType.Js;13var transform = new TransformXml();14transform.Value = "my value";15transform.Type = TransformXml.TransformType.R;16var transform = new TransformXml();17transform.Value = "my value";18transform.Type = TransformXml.TransformType.Python;19var transform = new TransformXml();20transform.Value = "my value";21transform.Type = TransformXml.TransformType.Vb;22var transform = new TransformXml();23transform.Value = "my value";24transform.Type = TransformXml.TransformType.Lua;25var transform = new TransformXml();26transform.Value = "my value";27transform.Type = TransformXml.TransformType.Sql;28var transform = new TransformXml();29transform.Value = "my value";30transform.Type = TransformXml.TransformType.Cpp;31var transform = new TransformXml();32transform.Value = "my value";

TransformXml

Using AI Code Generation

1var transform = new TransformXml();2transform.Content = "Select * from [Sheet1$]";3transform.Type = "Excel";4transform.FilePath = @"C:\temp\test.xlsx";5transform.SheetName = "Sheet1";6var alteration = new AlterationXml();7alteration.Type = "transform";8alteration.Content = transform;9var alteration = new AlterationXml();10alteration.Type = "transform";11alteration.Content = transform;12var alteration = new AlterationXml();13alteration.Type = "transform";14alteration.Content = transform;15var alteration = new AlterationXml();16alteration.Type = "transform";17alteration.Content = transform;18var alteration = new AlterationXml();19alteration.Type = "transform";20alteration.Content = transform;21var alteration = new AlterationXml();22alteration.Type = "transform";23alteration.Content = transform;24var alteration = new AlterationXml();25alteration.Type = "transform";26alteration.Content = transform;27var alteration = new AlterationXml();28alteration.Type = "transform";29alteration.Content = transform;30var alteration = new AlterationXml();31alteration.Type = "transform";32alteration.Content = transform;33var alteration = new AlterationXml();34alteration.Type = "transform";35alteration.Content = transform;36var alteration = new AlterationXml();37alteration.Type = "transform";38alteration.Content = transform;39var alteration = new AlterationXml();40alteration.Type = "transform";

TransformXml

Using AI Code Generation

1using NBi.Xml.Items.Alteration.Transform;2using NBi.Xml.Items.Alteration;3using NBi.Xml.Items.Alteration;4using NBi.Xml.Items.Alteration;5using NBi.Xml.Items.Alteration;6using NBi.Xml.Items.Alteration;7using NBi.Xml.Items.Alteration;8using NBi.Xml.Items.Alteration;9using NBi.Xml.Items.Alteration;10using NBi.Xml.Items.Alteration;

Automation Testing Tutorials

Learn to execute automation testing from scratch with LambdaTest Learning Hub. Right from setting up the prerequisites to run your first automation test, to following best practices and diving deeper into advanced test scenarios. LambdaTest Learning Hubs compile a list of step-by-step guides to help you be proficient with different test automation frameworks i.e. Selenium, Cypress, TestNG etc.