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

How to use Execute method of NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer class

Best NBi code snippet using NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer.Execute

LookupMatchesAnalyzerTest.cs

Source:LookupMatchesAnalyzerTest.cs

...52                mappings.Add(new ColumnMapping(new ColumnOrdinalIdentifier(i + shift), new ColumnOrdinalIdentifier(i + shift), columnType));53            return mappings;54        }55        [Test]56        public void Execute_ReferenceLargerThanCandidateMatchingValue_NoViolation()57        {58            var candidate = BuildDataTable(new[] { "Key0", "Key1" }, new object[] { 0, 1 });59            var reference = BuildDataTable(new[] { "Key0", "Key1", "Key2" }, new object[] { 0, 1, 1 });60            var analyzer = new LookupMatchesAnalyzer(BuildColumnMapping(1), BuildColumnMapping(1,1));61            var violations = analyzer.Execute(candidate, reference);62            Assert.That(violations.Count(), Is.EqualTo(0));63        }64        [Test]65        public void Execute_ReferenceLargerThanCandidateMatchingValueWhenNoToleranceApplied_OneViolation()66        {67            var candidate = BuildDataTable(new[] { "Key0", "Key1" }, new object[] { 0, 1 });68            var reference = BuildDataTable(new[] { "Key0", "Key1", "Key2" }, new object[] { 0, 2, 1 });69            var analyzer = new LookupMatchesAnalyzer(BuildColumnMapping(1), BuildColumnMapping(1, 1, ColumnType.Numeric));70            var violations = analyzer.Execute(candidate, reference);71            Assert.That(violations.Count(), Is.EqualTo(1));72        }73        [Test]74        public void Execute_ReferenceLargerThanCandidateMatchingValueWhenToleranceApplied_NoViolation()75        {76            var candidate = BuildDataTable(new[] { "Key0", "Key1" }, new object[] { 0, 1 });77            var reference = BuildDataTable(new[] { "Key0", "Key1", "Key2" }, new object[] { 0, 2, 1 });78            var tolerances = new Dictionary<IColumnIdentifier, Tolerance>() { { new ColumnIdentifierFactory().Instantiate("#1"), new NumericAbsoluteTolerance(1, SideTolerance.Both) } };79 80            var analyzer = new LookupMatchesAnalyzer(BuildColumnMapping(1), BuildColumnMapping(1, 1, ColumnType.Numeric), tolerances);81            var violations = analyzer.Execute(candidate, reference);82            Assert.That(violations.Count(), Is.EqualTo(0));83        }84        [Test]85        public void Execute_ReferenceLargerThanCandidateDuplicateKeys_NoViolation()86        {87            var candidate = BuildDataTable(new[] { "Key0", "Key1" }, new object[] { 0, 1 });88            var reference = BuildDataTable(new[] { "Key0", "Key1", "Key2", "Key1", "Key2" }, new object[] { 0, 2, 3, 1, 3 });89            var analyzer = new LookupMatchesAnalyzer(BuildColumnMapping(1), BuildColumnMapping(1, 1));90            var violations = analyzer.Execute(candidate, reference);91            Assert.That(violations.Count(), Is.EqualTo(0));92        }93        [Test]94        public void Execute_MissingKeyInReference_OneViolation()95        {96            var candidate = BuildDataTable(new[] { "Key0", "Key1" }, new object[] { 0, 1 });97            var reference = BuildDataTable(new[] { "Key0", "Key2", "Key2", "Key0", "Key2" }, new object[] { 0, 1, 1, 1, 1 });98            var analyzer = new LookupMatchesAnalyzer(BuildColumnMapping(1), BuildColumnMapping(1, 1));99            var violations = analyzer.Execute(candidate, reference);100            Assert.That(violations.Count(), Is.EqualTo(1));101        }102        [Test]103        public void Execute_NotMatchValueInReference_OneViolation()104        {105            var candidate = BuildDataTable(new[] { "Key0", "Key1" }, new object[] { 0, 1 });106            var reference = BuildDataTable(new[] { "Key0", "Key1", "Key1", "Key0", "Key2" }, new object[] { 0, 2, 3, 4, 5 });107            var analyzer = new LookupMatchesAnalyzer(BuildColumnMapping(1), BuildColumnMapping(1, 1));108            var violations = analyzer.Execute(candidate, reference);109            Assert.That(violations.Count(), Is.EqualTo(1));110        }111        [Test]112        public void Execute_MultipleKeysreferenceLargerThanCandidateDuplicateKeys_NoViolation()113        {114            var candidate = BuildDataTable(new[] { "Key0", "Key1" }, new[] { "Foo", "Bar" }, new object[] { 0, 1 });115            var reference = BuildDataTable(new[] { "Key0", "Key1", "Key2" }, new[] { "Foo", "Bar", "Bar" }, new object[] { 0, 1, 2 });116            var referencer = new LookupMatchesAnalyzer(BuildColumnMapping(2), BuildColumnMapping(1, 2));117            var violations = referencer.Execute(candidate, reference);118            Assert.That(violations.Count(), Is.EqualTo(0));119        }120        121        [Test]122        [TestCase(1000)]123        [TestCase(10000)]124        [TestCase(100000)]125        [TestCase(1000000)]126        [Retry(3)]127        [Parallelizable(ParallelScope.Self)]128        public void Execute_LargeVolumeReference_Fast(int maxItem)129        {130            var candidate = BuildDataTable(new[] { "Key0", "Key1", "Key0" }, new[] { "Foo", "Bar", "Foo" }, new object[] { 1, 2, 3 });131            var reference = new DataTable();132            var idColumn = reference.Columns.Add("id");133            var valueColumn = reference.Columns.Add("value");134            var randomizer = new Random();135            for (int i = 0; i < maxItem; i++)136            {137                var dr = reference.NewRow();138                dr.SetField<object>(idColumn, i);139                dr.SetField<object>(valueColumn, randomizer.Next().ToString());140                reference.Rows.Add(dr);141            }142            reference.AcceptChanges();143            var mappingKey = new ColumnMappingCollection144            {145                new ColumnMapping(new ColumnNameIdentifier("two"), new ColumnNameIdentifier("id"), ColumnType.Numeric)146            };147            var mappingValue = new ColumnMappingCollection148            {149                new ColumnMapping(new ColumnNameIdentifier("one"), new ColumnNameIdentifier("value"), ColumnType.Text)150            };151            var analyzer = new LookupMatchesAnalyzer(mappingKey, mappingValue);152            var stopWatch = new Stopwatch();153            stopWatch.Start();154            analyzer.Execute(candidate, reference);155            stopWatch.Stop();156            Assert.That(stopWatch.Elapsed.TotalSeconds, Is.LessThan(20));157        }158        [Test]159        [TestCase(1000)]160        [TestCase(10000)]161        [TestCase(100000)]162        [TestCase(1000000)]163        [Retry(3)]164        [Parallelizable(ParallelScope.Self)]165        public void Execute_LargeVolumeCandidate_Fast(int maxItem)166        {167            var reference = BuildDataTable(new[] { "Key0", "Key1", "Key0" }, new[] { "Foo", "Bar", "Foo" }, new object[] { 1, 2, 3 });168            var candidate = new DataTable();169            var idColumn = candidate.Columns.Add("id");170            var valueColumn = candidate.Columns.Add("value");171            var randomizer = new Random();172            for (int i = 0; i < maxItem; i++)173            {174                var dr = candidate.NewRow();175                dr.SetField<object>(idColumn, i);176                dr.SetField<object>(valueColumn, randomizer.Next().ToString());177                candidate.Rows.Add(dr);178            }179            candidate.AcceptChanges();180            var mappingKey = new ColumnMappingCollection181            {182                new ColumnMapping(new ColumnNameIdentifier("id"), new ColumnNameIdentifier("two"), ColumnType.Numeric)183            };184            var mappingValue = new ColumnMappingCollection185            {186                new ColumnMapping(new ColumnNameIdentifier("value"), new ColumnNameIdentifier("one"), ColumnType.Text)187            };188            var analyzer = new LookupMatchesAnalyzer(mappingKey, mappingValue);189            var stopWatch = new Stopwatch();190            stopWatch.Start();191            var violations = analyzer.Execute(candidate, reference);192            stopWatch.Stop();193            Assert.That(stopWatch.Elapsed.TotalSeconds, Is.LessThan(7));194        }195    }196}...

LookupMatchesAnalyzer.cs

Source:LookupMatchesAnalyzer.cs

...23        {24            Values = values;25            Tolerances = tolerances ?? new Dictionary<IColumnIdentifier, Tolerance>();26        }27        protected override LookupViolationCollection Execute(DataTable candidate, DataTable reference)28        {29            var stopWatch = new Stopwatch();30            stopWatch.Start();31            var referenceKeyRetriever = BuildColumnsRetriever(Keys, x => x.ReferenceColumn);32            var referenceValueRetriever = BuildColumnsRetriever(Values, x => x.ReferenceColumn);33            var references = BuildReferenceIndex(reference, referenceKeyRetriever, referenceValueRetriever);34            Trace.WriteLineIf(Extensibility.NBiTraceSwitch.TraceInfo, $"Building the index (including value columns) for keys from the reference table containing {references.Count} rows [{stopWatch.Elapsed:d'.'hh':'mm':'ss'.'fff'ms'}]");35            stopWatch.Restart();36            var candidateKeyBuilder = BuildColumnsRetriever(Keys, x => x.CandidateColumn);37            var candidateValueRetriever = BuildColumnsRetriever(Values, x => x.CandidateColumn);38            var violations = ExtractLookupViolation(candidate, candidateKeyBuilder, candidateValueRetriever, references, Tolerances);39            Trace.WriteLineIf(Extensibility.NBiTraceSwitch.TraceInfo, $"Analyzing potential lookup violations (based on keys and values) for the {candidate.Rows.Count} rows from candidate table [{stopWatch.Elapsed:d'.'hh':'mm':'ss'.'fff'ms'}]");40            return violations;41        }...

Execute

Using AI Code Generation

1NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer analyzer = new NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer();2analyzer.Setup(new NBi.Core.ResultSet.Lookup.LookupMatchesArgs("3", "2", "3"));3analyzer.Execute(new NBi.Core.ResultSet.ResultSet(lookupTable), new NBi.Core.ResultSet.ResultSet(mainTable));4NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer analyzer = new NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer();5analyzer.Setup(new NBi.Core.ResultSet.Lookup.LookupMatchesArgs("1", "2", "3"));6analyzer.Execute(new NBi.Core.ResultSet.ResultSet(lookupTable), new NBi.Core.ResultSet.ResultSet(mainTable));7NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer analyzer = new NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer();8analyzer.Setup(new NBi.Core.ResultSet.Lookup.LookupMatchesArgs("1", "2", "3"));9analyzer.Execute(new NBi.Core.ResultSet.ResultSet(lookupTable), new NBi.Core.ResultSet.ResultSet(mainTable));10NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer analyzer = new NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer();11analyzer.Setup(new NBi.Core.ResultSet.Lookup.LookupMatchesArgs("1", "2", "3"));12analyzer.Execute(new NBi.Core.ResultSet.ResultSet(lookupTable), new NBi.Core.ResultSet.ResultSet(mainTable));13NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer analyzer = new NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer();14analyzer.Setup(new NBi.Core.ResultSet.Lookup.LookupMatchesArgs("1", "2", "3"));15analyzer.Execute(new NBi.Core.ResultSet.ResultSet(lookupTable), new NBi.Core.ResultSet.ResultSet(mainTable));16NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer analyzer = new NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer();17analyzer.Setup(new NBi.Core.ResultSet.Lookup.LookupMatchesArgs("1", "2", "3"));18analyzer.Execute(new NBi.Core.ResultSet.ResultSet(lookupTable), new NBi.Core.ResultSet.ResultSet(mainTable));

Execute

Using AI Code Generation

1using NBi.Core.ResultSet.Lookup;2using NBi.Core.ResultSet;3using NBi.Core;4using NBi.Core.Calculation;5var analyzer = new LookupMatchesAnalyzer(6    new ResultSet(new List<IColumnDefinition>()7    {8        new ColumnOrdinalIdentifier(0),9        new ColumnOrdinalIdentifier(1)10    },11    new List<IRow>() {12        new Row(new List<object>() { 1, "A" }),13        new Row(new List<object>() { 2, "B" })14    }),15    new ResultSet(new List<IColumnDefinition>()16    {17        new ColumnOrdinalIdentifier(0),18        new ColumnOrdinalIdentifier(1)19    },20    new List<IRow>() {21        new Row(new List<object>() { 1, "A" }),22        new Row(new List<object>() { 2, "B" })23    }),24    new List<IColumnDefinition>() {25        new ColumnOrdinalIdentifier(0),26        new ColumnOrdinalIdentifier(1)27    },28    new List<IColumnDefinition>() {29        new ColumnOrdinalIdentifier(0),30        new ColumnOrdinalIdentifier(1)31    },32    new List<IColumnIdentifier>() {33        new ColumnOrdinalIdentifier(0),34        new ColumnOrdinalIdentifier(1)35    },36    new List<IColumnIdentifier>() {37        new ColumnOrdinalIdentifier(0),38        new ColumnOrdinalIdentifier(1)39    },40    new List<IColumnIdentifier>() {41        new ColumnOrdinalIdentifier(0),42        new ColumnOrdinalIdentifier(1)43    },44    new List<IColumnIdentifier>() {45        new ColumnOrdinalIdentifier(0),46        new ColumnOrdinalIdentifier(1)47    },48    new List<IColumnIdentifier>() {49        new ColumnOrdinalIdentifier(0),50        new ColumnOrdinalIdentifier(1)51    },52    new List<IColumnIdentifier>() {53        new ColumnOrdinalIdentifier(0),54        new ColumnOrdinalIdentifier(1)55    },56    new List<IColumnIdentifier>() {57        new ColumnOrdinalIdentifier(0),58        new ColumnOrdinalIdentifier(1)59    },60    new List<IColumnIdentifier>() {61        new ColumnOrdinalIdentifier(0),62        new ColumnOrdinalIdentifier(1)63    },64    new List<IColumnIdentifier>() {65        new ColumnOrdinalIdentifier(0),66        new ColumnOrdinalIdentifier(1)67    },68    new List<IColumnIdentifier>() {69        new ColumnOrdinalIdentifier(0),70        new ColumnOrdinalIdentifier(1)71    },

Execute

Using AI Code Generation

1var analyzer = new LookupMatchesAnalyzer();2var result = analyzer.Execute(lookup, reference, settings);3var analyzer = new LookupMatchesAnalyzer();4var result = analyzer.Execute(lookup, reference, settings);5var analyzer = new LookupMatchesAnalyzer();6var result = analyzer.Execute(lookup, reference, settings);7var analyzer = new LookupMatchesAnalyzer();8var result = analyzer.Execute(lookup, reference, settings);9var analyzer = new LookupMatchesAnalyzer();10var result = analyzer.Execute(lookup, reference, settings);11var analyzer = new LookupMatchesAnalyzer();12var result = analyzer.Execute(lookup, reference, settings);13var analyzer = new LookupMatchesAnalyzer();14var result = analyzer.Execute(lookup, reference, settings);15var analyzer = new LookupMatchesAnalyzer();16var result = analyzer.Execute(lookup, reference, settings);

Execute

Using AI Code Generation

1var result = new NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer(lookup).Execute();2var writer = new NBi.Core.ResultSet.Lookup.LookupMatchesWriter(result);3writer.WriteToConsole();4var result = new NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer(lookup).Execute();5var writer = new NBi.Core.ResultSet.Lookup.LookupMatchesWriter(result);6writer.WriteToConsole();7var result = new NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer(lookup).Execute();8var writer = new NBi.Core.ResultSet.Lookup.LookupMatchesWriter(result);9writer.WriteToConsole();10var result = new NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer(lookup).Execute();11var writer = new NBi.Core.ResultSet.Lookup.LookupMatchesWriter(result);12writer.WriteToConsole();13var result = new NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer(lookup).Execute();14var writer = new NBi.Core.ResultSet.Lookup.LookupMatchesWriter(result);15writer.WriteToConsole();16var result = new NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer(lookup).Execute();17var writer = new NBi.Core.ResultSet.Lookup.LookupMatchesWriter(result);18writer.WriteToConsole();

Execute

Using AI Code Generation

1var analyzer = new LookupMatchesAnalyzer();2var result = analyzer.Execute(lookup, reference, settings);3var analyzer = new LookupMatchesAnalyzer();4var result = analyzer.Execute(lookup, reference, settings);5var analyzer = new LookupMatchesAnalyzer();6var result = analyzer.Execute(lookup, reference, settings);7var analyzer = new LookupMatchesAnalyzer();8var result = analyzer.Execute(lookup, reference, settings);9var analyzer = new LookupMatchesAnalyzer();10var result = analyzer.Execute(lookup, reference, settings);11var analyzer = new LookupMatchesAnalyzer();12var result = analyzer.Execute(lookup, reference, settings);13var analyzer = new LookupMatchesAnalyzer();14var result = analyzer.Execute(lookup, reference, settings);15var analyzer = new LookupMatchesAnalyzer();16var result = analyzer.Execute(lookup, reference, settings);

Execute

Using AI Code Generation

1var result = new NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer(lookup).Execute();2var writer = new NBi.Core.ResultSet.Lookup.LookupMatchesWriter(result);3writer.WriteToConsole();4var result = new NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer(lookup).Execute();5var writer = new NBi.Core.ResultSet.Lookup.LookupMatchesWriter(result);6writer.WriteToConsole();7var result = new NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer(lookup).Execute();8var writer = new NBi.Core.ResultSet.Lookup.LookupMatchesWriter(result);9writer.WriteToConsole();10var result = new NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer(lookup).Execute();11var writer = new NBi.Core.ResultSet.Lookup.LookupMatchesWriter(result);12writer.WriteToConsole();13var result = new NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer(lookup).Execute();14var writer = new NBi.Core.ResultSet.Lookup.LookupMatchesWriter(result);15writer.WriteToConsole();16var result = new NBi.Core.ResultSet.Lookup.LookupMatchesAnalyzer(lookup).Execute();17var writer = new NBi.Core.ResultSet.Lookup.LookupMatchesWriter(result);18writer.WriteToConsole();

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.