How to use SumXml class of NBi.Xml.Items.Alteration.Summarization package

Best NBi code snippet using NBi.Xml.Items.Alteration.Summarization.SumXml

ResultSetSystemXmlTest.cs

Source:ResultSetSystemXmlTest.cs

...226            Assert.That(rs.Alterations[0], Is.Not.Null);227            Assert.That(rs.Alterations[0], Is.TypeOf<SummarizeXml>());228            var summerize = rs.Alterations[0] as SummarizeXml;229            Assert.That(summerize.Aggregation, Is.Not.Null);230            Assert.That(summerize.Aggregation, Is.TypeOf<SumXml>());231            Assert.That(summerize.Aggregation.ColumnType, Is.EqualTo(ColumnType.Numeric));232        }233        [Test]234        public void Deserialize_SampleFile_AlterationUnstack()235        {236            int testNr = 14;237            // Create an instance of the XmlSerializer specifying type and namespace.238            var ts = DeserializeSample();239            // Check the properties of the object.240            Assert.That(ts.Tests[testNr].Systems[0], Is.AssignableTo<ResultSetSystemXml>());241            var rs = ts.Tests[testNr].Systems[0] as ResultSetSystemXml;242            Assert.That(rs.Alterations, Is.Not.Null);243            Assert.That(rs.Alterations, Has.Count.EqualTo(1));244            Assert.That(rs.Alterations[0], Is.Not.Null);245            Assert.That(rs.Alterations[0], Is.TypeOf<UnstackXml>());246            var unstack = rs.Alterations[0] as UnstackXml;247            Assert.That(unstack.Header, Is.Not.Null);248            Assert.That(unstack.Header, Is.TypeOf<HeaderXml>());249            Assert.That(unstack.GroupBy, Is.TypeOf<GroupByXml>());250        }251        [Test]252        public void Deserialize_SampleFile_AlterationProject()253        {254            int testNr = 15;255            // Create an instance of the XmlSerializer specifying type and namespace.256            var ts = DeserializeSample();257            // Check the properties of the object.258            Assert.That(ts.Tests[testNr].Systems[0], Is.AssignableTo<ResultSetSystemXml>());259            var rs = ts.Tests[testNr].Systems[0] as ResultSetSystemXml;260            Assert.That(rs.Alterations, Is.Not.Null);261            Assert.That(rs.Alterations, Has.Count.EqualTo(1));262            Assert.That(rs.Alterations[0], Is.Not.Null);263            Assert.That(rs.Alterations[0], Is.TypeOf<ProjectXml>());264            var project = rs.Alterations[0] as ProjectXml;265            Assert.That(project.Columns, Is.Not.Null);266            Assert.That(project.Columns.Count, Is.EqualTo(2));267        }268        [Test]269        public void Deserialize_SampleFile_AlterationProjectAway()270        {271            int testNr = 16;272            // Create an instance of the XmlSerializer specifying type and namespace.273            var ts = DeserializeSample();274            // Check the properties of the object.275            Assert.That(ts.Tests[testNr].Systems[0], Is.AssignableTo<ResultSetSystemXml>());276            var rs = ts.Tests[testNr].Systems[0] as ResultSetSystemXml;277            Assert.That(rs.Alterations, Is.Not.Null);278            Assert.That(rs.Alterations, Has.Count.EqualTo(1));279            Assert.That(rs.Alterations[0], Is.Not.Null);280            Assert.That(rs.Alterations[0], Is.TypeOf<ProjectAwayXml>());281            var projectAway = rs.Alterations[0] as ProjectAwayXml;282            Assert.That(projectAway.Columns, Is.Not.Null);283            Assert.That(projectAway.Columns.Count, Is.EqualTo(2));284        }285        [Test]286        public void Deserialize_SampleFile_AlterationLookupReplace()287        {288            int testNr = 17;289            // Create an instance of the XmlSerializer specifying type and namespace.290            var ts = DeserializeSample();291            // Check the properties of the object.292            Assert.That(ts.Tests[testNr].Systems[0], Is.AssignableTo<ResultSetSystemXml>());293            var rs = ts.Tests[testNr].Systems[0] as ResultSetSystemXml;294            Assert.That(rs.Alterations, Is.Not.Null);295            Assert.That(rs.Alterations, Has.Count.EqualTo(1));296            Assert.That(rs.Alterations[0], Is.Not.Null);297            Assert.That(rs.Alterations[0], Is.TypeOf<LookupReplaceXml>());298            var lookup = rs.Alterations[0] as LookupReplaceXml;299            Assert.That(lookup.Missing, Is.Not.Null);300            Assert.That(lookup.Missing.Behavior, Is.EqualTo(Behavior.Failure));301            Assert.That(lookup.Join, Is.Not.Null);302            Assert.That(lookup.ResultSet, Is.Not.Null);303            Assert.That(lookup.Replacement, Is.Not.Null);304            Assert.That(lookup.Replacement.Identifier.Label, Is.EqualTo("#1"));305        }306        [Test]307        public void Deserialize_SampleFile_AlterationUnion()308        {309            int testNr = 18;310            // Create an instance of the XmlSerializer specifying type and namespace.311            var ts = DeserializeSample();312            // Check the properties of the object.313            Assert.That(ts.Tests[testNr].Systems[0], Is.AssignableTo<ResultSetSystemXml>());314            var rs = ts.Tests[testNr].Systems[0] as ResultSetSystemXml;315            Assert.That(rs.Alterations, Is.Not.Null);316            Assert.That(rs.Alterations, Has.Count.EqualTo(1));317            Assert.That(rs.Alterations[0], Is.Not.Null);318            Assert.That(rs.Alterations[0], Is.TypeOf<UnionXml>());319            var union = rs.Alterations[0] as UnionXml;320            Assert.That(union.ResultSet, Is.Not.Null);321            Assert.That(union.ColumnIdentity, Is.EqualTo(ColumnIdentity.Name));322        }323        [Test]324        public void Deserialize_SampleFile_AlterationDuplicate()325        {326            int testNr = 19;327            // Create an instance of the XmlSerializer specifying type and namespace.328            var ts = DeserializeSample();329            // Check the properties of the object.330            Assert.That(ts.Tests[testNr].Systems[0], Is.AssignableTo<ResultSetSystemXml>());331            var rs = ts.Tests[testNr].Systems[0] as ResultSetSystemXml;332            Assert.That(rs.Alterations, Is.Not.Null);333            Assert.That(rs.Alterations, Has.Count.EqualTo(1));334            Assert.That(rs.Alterations[0], Is.Not.Null);335            Assert.That(rs.Alterations[0], Is.TypeOf<DuplicateXml>());336            var duplicate = rs.Alterations[0] as DuplicateXml;337            Assert.That(duplicate.Predication, Is.Not.Null);338            Assert.That(duplicate.Predication, Is.TypeOf<SinglePredicationXml>());339            Assert.That(duplicate.Times, Is.Not.Null);340            Assert.That(duplicate.Times, Is.EqualTo("@myVar"));341            Assert.That(duplicate.Outputs, Is.Not.Null);342            Assert.That(duplicate.Outputs.Count, Is.EqualTo(6));343            Assert.That(duplicate.Outputs[0].Identifier.Label, Is.EqualTo("[myIndex]"));344            Assert.That(duplicate.Outputs[0].Class, Is.EqualTo(OutputClass.Index));345            Assert.That(duplicate.Outputs[1].Identifier.Label, Is.EqualTo("[myTotal]"));346            Assert.That(duplicate.Outputs[1].Class, Is.EqualTo(OutputClass.Total));347            Assert.That(duplicate.Outputs[2].Identifier.Label, Is.EqualTo("[myOriginal]"));348            Assert.That(duplicate.Outputs[2].Class, Is.EqualTo(OutputClass.IsOriginal));349            Assert.That(duplicate.Outputs[3].Identifier.Label, Is.EqualTo("[myDuplicable]"));350            Assert.That(duplicate.Outputs[3].Class, Is.EqualTo(OutputClass.IsDuplicable));351            Assert.That(duplicate.Outputs[4].Identifier.Label, Is.EqualTo("[myValue]"));352            Assert.That(duplicate.Outputs[4].Class, Is.EqualTo(OutputClass.Script));353            Assert.That(duplicate.Outputs[4].Script, Is.Not.Null);354            Assert.That(duplicate.Outputs[4].Script.Language, Is.EqualTo(LanguageType.NCalc));355            Assert.That(duplicate.Outputs[4].Script.Code, Does.Contain("[myValue] / [myTotal] * ([myIndex] + 1)"));356            Assert.That(duplicate.Outputs[5].Class, Is.EqualTo(OutputClass.Static));357            Assert.That(duplicate.Outputs[5].Value, Is.EqualTo("Monthly"));358        }359        [Test]360        public void Deserialize_SampleFile_EmptyResultSet()361        {362            int testNr = 20;363            // Create an instance of the XmlSerializer specifying type and namespace.364            var ts = DeserializeSample();365            // Check the properties of the object.366            Assert.That(ts.Tests[testNr].Systems[0], Is.AssignableTo<ResultSetSystemXml>());367            var rs = ts.Tests[testNr].Systems[0] as ResultSetSystemXml;368            Assert.That(rs.Empty, Is.Not.Null);369            Assert.That(rs.Empty, Is.TypeOf<EmptyResultSetXml>());370            var empty = rs.Empty as EmptyResultSetXml;371            Assert.That(empty.ColumnCount, Is.EqualTo("4"));372            Assert.That(empty.Columns, Has.Count.EqualTo(2));373            Assert.That(empty.Columns.Any(x => x.Identifier.Label == "[myFirstColumn]"));374            Assert.That(empty.Columns.Any(x => x.Identifier.Label == "[mySecondColumn]"));375        }376        [Test]377        public void Deserialize_SampleFile_IfUnavailable()378        {379            int testNr = 21;380            // Create an instance of the XmlSerializer specifying type and namespace.381            var ts = DeserializeSample();382            // Check the properties of the object.383            Assert.That(ts.Tests[testNr].Systems[0], Is.AssignableTo<ResultSetSystemXml>());384            var rs = ts.Tests[testNr].Systems[0] as ResultSetSystemXml;385            Assert.That(rs.IfUnavailable, Is.Not.Null);386            Assert.That(rs.IfUnavailable.ResultSet, Is.Not.Null);387            Assert.That(rs.IfUnavailable.ResultSet.Empty, Is.Not.Null);388        }389        [Test]390        public void Deserialize_SampleFile_Iteration()391        {392            int testNr = 22;393            // Create an instance of the XmlSerializer specifying type and namespace.394            var ts = DeserializeSample();395            // Check the properties of the object.396            Assert.That(ts.Tests[testNr].Systems[0], Is.AssignableTo<ResultSetSystemXml>());397            var rs = ts.Tests[testNr].Systems[0] as ResultSetSystemXml;398            Assert.That(rs.Iteration, Is.Not.Null);399            Assert.That(rs.Iteration.Sequence, Is.Not.Null);400            Assert.That(rs.NestedResultSet, Is.Not.Null);401        }402        [Test]403        public void Serialize_FileAndParser_Correct()404        {405            var root = new ResultSetSystemXml()406            {407                File = new FileXml()408                {409                    Path = "myFile.csv",410                    Parser = new ParserXml()411                    {412                        Name = "myParser",413                    }414                }415            };416            var manager = new XmlManager();417            var xml = manager.XmlSerializeFrom(root);418            Assert.That(xml, Does.Contain("<file>"));419            Assert.That(xml, Does.Contain("<path>myFile.csv</path>"));420            Assert.That(xml, Does.Contain("<parser name=\"myParser\" />"));421            Assert.That(xml, Does.Contain("</file>"));422        }423        [Test]424        public void Serialize_InlineFileAndParser_Correct()425        {426            var root = new ResultSetSystemXml()427            {428#pragma warning disable 0618429                FilePath = "myFile.csv!myParser",430#pragma warning restore 0618431            };432            var manager = new XmlManager();433            var xml = manager.XmlSerializeFrom(root);434            Assert.That(xml, Does.Contain("<file>"));435            Assert.That(xml, Does.Contain("<path>myFile.csv</path>"));436            Assert.That(xml, Does.Contain("<parser name=\"myParser\" />"));437            Assert.That(xml, Does.Contain("</file>"));438        }439        [Test]440        public void Serialize_InlineFileWithoutParser_Correct()441        {442            var root = new ResultSetSystemXml()443            {444#pragma warning disable 0618445                FilePath = "myFile.csv",446#pragma warning restore 0618447            };448            var manager = new XmlManager();449            var xml = manager.XmlSerializeFrom(root);450            Assert.That(xml, Does.Contain("<file>"));451            Assert.That(xml, Does.Contain("<path>myFile.csv</path>"));452            Assert.That(xml, Does.Not.Contain("<parser"));453            Assert.That(xml, Does.Contain("</file>"));454        }455        [Test]456        public void Serialize_Renaming_Correct()457        {458            var root = new ResultSetSystemXml()459            {460                File = new FileXml() { Path = @"C:\Temp\foo.txt" },461                Alterations = new List<AlterationXml>()462                {463                    new RenamingXml()464                        { Identifier= new ColumnOrdinalIdentifier(5), NewName = "myNewName" }465                }466            };467            var manager = new XmlManager();468            var xml = manager.XmlSerializeFrom(root);469            Assert.That(xml, Does.Contain("<rename"));470            Assert.That(xml, Does.Contain("#5"));471            Assert.That(xml, Does.Contain("myNewName"));472        }473        [Test]474        [TestCase(typeof(CountRowsXml), "count")]475        public void Serialize_CountAggregation_Correct(Type aggregationType, string serialization)476        {477            var root = new SummarizeXml()478            {479                Aggregation = (AggregationXml)Activator.CreateInstance(aggregationType)480            };481            root.Aggregation.ColumnType = ColumnType.DateTime;482            var manager = new XmlManager();483            var xml = manager.XmlSerializeFrom(root);484            Assert.That(xml, Does.Contain($"<{serialization}"));485            Assert.That(xml, Does.Contain("dateTime"));486        }487        [Test]488        [TestCase(typeof(SumXml), "sum")]489        [TestCase(typeof(AverageXml), "average")]490        [TestCase(typeof(MaxXml), "max")]491        [TestCase(typeof(MinXml), "min")]492        public void Serialize_SimpleAggregation_Correct(Type aggregationType, string serialization)493        {494            var root = new SummarizeXml()495            {496                Aggregation = (ColumnAggregationXml)Activator.CreateInstance(aggregationType)497            };498            root.Aggregation.ColumnType = ColumnType.DateTime;499            (root.Aggregation as ColumnAggregationXml).Identifier = new ColumnOrdinalIdentifier(2);500            var manager = new XmlManager();501            var xml = manager.XmlSerializeFrom(root);502            Assert.That(xml, Does.Contain($"<{serialization}"));...

ColumnAggregationXml.cs

Source:ColumnAggregationXml.cs

...34            get => new ColumnIdentifierFactory().Instantiate(IdentifierSerializer);35            set => IdentifierSerializer = value.Label;36        }37    }38    public class SumXml : ColumnAggregationXml39    {40        public SumXml() : base(AggregationFunctionType.Sum) { }41    }42    public class AverageXml : ColumnAggregationXml43    {44        public AverageXml() : base(AggregationFunctionType.Average) { }45    }46    public class MaxXml : ColumnAggregationXml47    {48        public MaxXml() : base(AggregationFunctionType.Max) { }49    }50    public class MinXml : ColumnAggregationXml51    {52        public MinXml() : base(AggregationFunctionType.Min) { }53    }54    public class CountRowsXml : AggregationXml...

SummarizeXml.cs

Source:SummarizeXml.cs

...8namespace NBi.Xml.Items.Alteration.Summarization9{10    public class SummarizeXml : AlterationXml11    {12        [XmlElement(Type = typeof(SumXml), ElementName = "sum"),13            XmlElement(Type = typeof(MinXml), ElementName = "min"),14            XmlElement(Type = typeof(MaxXml), ElementName = "max"),15            XmlElement(Type = typeof(AverageXml), ElementName = "average"),16            XmlElement(Type = typeof(CountRowsXml), ElementName = "count"),17            XmlElement(Type = typeof(ConcatenationXml), ElementName = "concatenation"),18        ]19        public AggregationXml Aggregation { get; set; }20        [XmlElement(ElementName = "group-by")]21        public GroupByXml GroupBy { get; set; }22    }23}...

SumXml

Using AI Code Generation

1using NBi.Xml.Items.Alteration.Summarization;2using NBi.Xml.Items.Alteration.Summarization;3using NBi.Xml.Items.Alteration.Summarization;4using NBi.Xml.Items.Alteration.Summarization;5using NBi.Xml.Items.Alteration.Summarization;6using NBi.Xml.Items.Alteration.Summarization;7using NBi.Xml.Items.Alteration.Summarization;8using NBi.Xml.Items.Alteration.Summarization;9using NBi.Xml.Items.Alteration.Summarization;10using NBi.Xml.Items.Alteration.Summarization;11using NBi.Xml.Items.Alteration.Summarization;12using NBi.Xml.Items.Alteration.Summarization;13using NBi.Xml.Items.Alteration.Summarization;14using NBi.Xml.Items.Alteration.Summarization;15using NBi.Xml.Items.Alteration.Summarization;16using NBi.Xml.Items.Alteration.Summarization;17using NBi.Xml.Items.Alteration.Summarization;

SumXml

Using AI Code Generation

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

SumXml

Using AI Code Generation

1using NBi.Xml.Items.Alteration.Summarization;2using NBi.NUnit.Builder;3using NBi.Xml.Items.Alteration.Summarization;4using NBi.NUnit.Builder;5using NBi.Xml.Items.Alteration.Summarization;6using NBi.NUnit.Builder;7using NBi.Xml.Items.Alteration.Summarization;8using NBi.NUnit.Builder;9using NBi.Xml.Items.Alteration.Summarization;10using NBi.NUnit.Builder;11using NBi.Xml.Items.Alteration.Summarization;12using NBi.NUnit.Builder;13using NBi.Xml.Items.Alteration.Summarization;14using NBi.NUnit.Builder;15using NBi.Xml.Items.Alteration.Summarization;16using NBi.NUnit.Builder;17using NBi.Xml.Items.Alteration.Summarization;

SumXml

Using AI Code Generation

1using NBi.Xml.Items.Alteration.Summarization;2using System.Xml.Serialization;3using System.IO;4using System.Text;5{6    [XmlRoot("summarization")]7    {8        [XmlAttribute("column")]9        public string Column { get; set; }10        [XmlAttribute("function")]11        public string Function { get; set; }12        [XmlAttribute("alias")]13        public string Alias { get; set; }14        [XmlAttribute("scope")]

SumXml

Using AI Code Generation

1var sum = new SumXml();2sum.Column = "MyColumn";3sum.Name = "MySum";4var sum = new SumXml();5sum.Column = "MyColumn";6sum.Name = "MySum";7var sum = new SumXml();8sum.Column = "MyColumn";9sum.Name = "MySum";10var sum = new SumXml();11sum.Column = "MyColumn";12sum.Name = "MySum";13var sum = new SumXml();14sum.Column = "MyColumn";15sum.Name = "MySum";16var sum = new SumXml();17sum.Column = "MyColumn";18sum.Name = "MySum";19var sum = new SumXml();20sum.Column = "MyColumn";21sum.Name = "MySum";22var sum = new SumXml();23sum.Column = "MyColumn";24sum.Name = "MySum";25var sum = new SumXml();26sum.Column = "MyColumn";27sum.Name = "MySum";28var sum = new SumXml();29sum.Column = "MyColumn";30sum.Name = "MySum";31var sum = new SumXml();32sum.Column = "MyColumn";33sum.Name = "MySum";

SumXml

Using AI Code Generation

1var sumXml = new SumXml();2sumXml.Column = "Column1";3sumXml.Alias = "Alias1";4var sumXml = new SumXml();5sumXml.Column = "Column1";6sumXml.Alias = "Alias1";7sumXml.Format = "Format1";8var sumXml = new SumXml();9sumXml.Column = "Column1";10sumXml.Alias = "Alias1";11sumXml.Format = "Format1";12sumXml.Filter = "Filter1";13var sumXml = new SumXml();14sumXml.Column = "Column1";15sumXml.Alias = "Alias1";16sumXml.Format = "Format1";17sumXml.Filter = "Filter1";18sumXml.FilterOn = "FilterOn1";19var sumXml = new SumXml();20sumXml.Column = "Column1";21sumXml.Alias = "Alias1";22sumXml.Format = "Format1";23sumXml.Filter = "Filter1";24sumXml.FilterOn = "FilterOn1";25sumXml.IgnoreMissing = true;26var sumXml = new SumXml();27sumXml.Column = "Column1";28sumXml.Alias = "Alias1";29sumXml.Format = "Format1";30sumXml.Filter = "Filter1";31sumXml.FilterOn = "FilterOn1";32sumXml.IgnoreMissing = true;33sumXml.IgnoreFilter = true;34var sumXml = new SumXml();35sumXml.Column = "Column1";36sumXml.Alias = "Alias1";37sumXml.Format = "Format1";38sumXml.Filter = "Filter1";39sumXml.FilterOn = "FilterOn1";40sumXml.IgnoreMissing = true;41sumXml.IgnoreFilter = true;

SumXml

Using AI Code Generation

1var sum = new SumXml();2sum.Column = "MyColumn";3sum.Alias = "MyAlias";4var count = new CountXml();5count.Column = "MyColumn";6count.Alias = "MyAlias";7var average = new AverageXml();8average.Column = "MyColumn";9average.Alias = "MyAlias";10var min = new MinXml();11min.Column = "MyColumn";12min.Alias = "MyAlias";13var max = new MaxXml();14max.Column = "MyColumn";15max.Alias = "MyAlias";16var variance = new VarianceXml();17variance.Column = "MyColumn";18variance.Alias = "MyAlias";19var standardDeviation = new StandardDeviationXml();20standardDeviation.Column = "MyColumn";21standardDeviation.Alias = "MyAlias";22var median = new MedianXml();23median.Column = "MyColumn";24median.Alias = "MyAlias";25var mode = new ModeXml();26mode.Column = "MyColumn";27mode.Alias = "MyAlias";28var summarization = new SummarizationXml();29summarization.Summaries.Add(sum);30summarization.Summaries.Add(count);31summarization.Summaries.Add(average);32summarization.Summaries.Add(min);

SumXml

Using AI Code Generation

1var sumXml = new SumXml();2sumXml.Column = "MyColumn";3sumXml.Alias = "MyAlias";4sumXml.Scope = "MyScope";5sumXml.ScopeColumn = "MyScopeColumn";6var sumXml = new SumXml();7sumXml.Column = "MyColumn";8sumXml.Alias = "MyAlias";9sumXml.Scope = "MyScope";10sumXml.ScopeColumn = "MyScopeColumn";11var sumXml = new SumXml();12sumXml.Column = "MyColumn";13sumXml.Alias = "MyAlias";14sumXml.Scope = "MyScope";15sumXml.ScopeColumn = "MyScopeColumn";16var sumXml = new SumXml();17sumXml.Column = "MyColumn";18sumXml.Alias = "MyAlias";19sumXml.Scope = "MyScope";20sumXml.ScopeColumn = "MyScopeColumn";21var sumXml = new SumXml();22sumXml.Column = "MyColumn";23sumXml.Alias = "MyAlias";24sumXml.Scope = "MyScope";25sumXml.ScopeColumn = "MyScopeColumn";26var sumXml = new SumXml();27sumXml.Column = "MyColumn";28sumXml.Alias = "MyAlias";29sumXml.Scope = "MyScope";30sumXml.ScopeColumn = "MyScopeColumn";31var sumXml = new SumXml();32sumXml.Column = "MyColumn";33sumXml.Alias = "MyAlias";34sumXml.Scope = "MyScope";35sumXml.ScopeColumn = "MyScopeColumn";36var sumXml = new SumXml();

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.