How to use SequenceCombinationResultSetResolver class of NBi.Core.ResultSet.Resolver package

Best NBi code snippet using NBi.Core.ResultSet.Resolver.SequenceCombinationResultSetResolver

SequenceCombinationResultSetResolverTest.cs

Source:SequenceCombinationResultSetResolverTest.cs

...23                    new LiteralScalarResolver<string>("2016-01-01"),24                    new LiteralScalarResolver<string>("2017-01-01"),25                })26            );27            var args = new SequenceCombinationResultSetResolverArgs(new[] { sequenceResolver });28            var factory = new ResultSetResolverFactory(new ServiceLocator());29            var resolver = factory.Instantiate(args);30            Assert.That(resolver, Is.TypeOf<SequenceCombinationResultSetResolver>());31        }32        [Test()]33        public void Execute_OneSequence_Initialize()34        {35            var args = new SequenceCombinationResultSetResolverArgs(new[] {36                new ListSequenceResolver<DateTime>(37                    new ListSequenceResolverArgs(new[] {38                        new LiteralScalarResolver<string>("2015-01-01"),39                        new LiteralScalarResolver<string>("2016-01-01"),40                        new LiteralScalarResolver<string>("2017-01-01"),41                    })42                )43            });44            var resolver = new SequenceCombinationResultSetResolver(args);45            var rs = resolver.Execute();46            Assert.That(rs.Columns.Count, Is.EqualTo(1));47            Assert.That(rs.Rows.Count, Is.EqualTo(3));48            Assert.That(rs.Rows[0][0], Is.EqualTo(new DateTime(2015, 1, 1)));49            Assert.That(rs.Rows[1][0], Is.EqualTo(new DateTime(2016, 1, 1)));50            Assert.That(rs.Rows[2][0], Is.EqualTo(new DateTime(2017, 1, 1)));51        }52        [Test()]53        public void Execute_TwoSequences_CartesianProduct()54        {55            var resolver = new SequenceCombinationResultSetResolver(56                new SequenceCombinationResultSetResolverArgs(new ISequenceResolver[] {57                    new ListSequenceResolver<DateTime>(58                        new ListSequenceResolverArgs(new[] {59                            new LiteralScalarResolver<string>("2015-01-01"),60                            new LiteralScalarResolver<string>("2016-01-01"),61                            new LiteralScalarResolver<string>("2017-01-01"),62                        })63                    ),64                    new ListSequenceResolver<string>(65                        new ListSequenceResolverArgs(new[] {66                            new LiteralScalarResolver<string>("fr"),67                            new LiteralScalarResolver<string>("be"),68                        })69                    ),70                })71            );72            var rs = resolver.Execute();73            Assert.That(rs.Columns.Count, Is.EqualTo(2));74            Assert.That(rs.Rows.Count, Is.EqualTo(6));75            Assert.That(rs.Rows[0][0], Is.EqualTo(new DateTime(2015, 1, 1)));76            Assert.That(rs.Rows[1][0], Is.EqualTo(new DateTime(2016, 1, 1)));77            Assert.That(rs.Rows[2][0], Is.EqualTo(new DateTime(2017, 1, 1)));78            Assert.That(rs.Rows[3][0], Is.EqualTo(new DateTime(2015, 1, 1)));79            Assert.That(rs.Rows[4][0], Is.EqualTo(new DateTime(2016, 1, 1)));80            Assert.That(rs.Rows[5][0], Is.EqualTo(new DateTime(2017, 1, 1)));81            Assert.That(rs.Rows[0][1], Is.EqualTo("fr"));82            Assert.That(rs.Rows[1][1], Is.EqualTo("fr"));83            Assert.That(rs.Rows[2][1], Is.EqualTo("fr"));84            Assert.That(rs.Rows[3][1], Is.EqualTo("be"));85            Assert.That(rs.Rows[4][1], Is.EqualTo("be"));86            Assert.That(rs.Rows[5][1], Is.EqualTo("be"));87        }88        [Test()]89        public void Execute_ThreeSequences_CartesianProduct()90        {91            var resolver = new SequenceCombinationResultSetResolver(92                new SequenceCombinationResultSetResolverArgs(new ISequenceResolver[] {93                    new ListSequenceResolver<decimal>(94                        new ListSequenceResolverArgs(new[] {95                            new LiteralScalarResolver<decimal>(1),96                            new LiteralScalarResolver<decimal>(2),97                        })98                    ),99                    new ListSequenceResolver<DateTime>(100                        new ListSequenceResolverArgs(new[] {101                            new LiteralScalarResolver<string>("2015-01-01"),102                            new LiteralScalarResolver<string>("2016-01-01"),103                            new LiteralScalarResolver<string>("2017-01-01"),104                        })105                    ),106                    new ListSequenceResolver<string>(107                        new ListSequenceResolverArgs(new[] {108                            new LiteralScalarResolver<string>("fr"),109                            new LiteralScalarResolver<string>("be"),110                        })111                    ),112                })113            );114            var rs = resolver.Execute();115            Assert.That(rs.Columns.Count, Is.EqualTo(3));116            Assert.That(rs.Rows.Count, Is.EqualTo(12));117            Assert.That(rs.Rows.Cast<DataRow>().Count(x => x.Field<decimal>(0) == 1), Is.EqualTo(6));118            Assert.That(rs.Rows.Cast<DataRow>().Count(x => x.Field<decimal>(0) == 2), Is.EqualTo(6));119            Assert.That(rs.Rows.Cast<DataRow>().Count(x => x.Field<DateTime>(1).Year == 2015), Is.EqualTo(4));120            Assert.That(rs.Rows.Cast<DataRow>().Count(x => x.Field<DateTime>(1).Year == 2016), Is.EqualTo(4));121            Assert.That(rs.Rows.Cast<DataRow>().Count(x => x.Field<DateTime>(1).Year == 2017), Is.EqualTo(4));122            Assert.That(rs.Rows.Cast<DataRow>().Count(x => x.Field<string>(2) == "fr"), Is.EqualTo(6));123            Assert.That(rs.Rows.Cast<DataRow>().Count(x => x.Field<string>(2) == "be"), Is.EqualTo(6));124        }125        [Test()]126        public void Execute_UniqueSequence_CorrectResult()127        {128            var resolver = new SequenceCombinationResultSetResolver(129                new SequenceResultSetResolverArgs(130                    new ListSequenceResolver<decimal>(131                        new ListSequenceResolverArgs(new[] {132                            new LiteralScalarResolver<decimal>(1),133                            new LiteralScalarResolver<decimal>(2),134                        })135                    )136                )137            );138            var rs = resolver.Execute();139            Assert.That(rs.Columns.Count, Is.EqualTo(1));140            Assert.That(rs.Rows.Count, Is.EqualTo(2));141            Assert.That(rs.Rows.Cast<DataRow>().Count(x => x.Field<decimal>(0) == 1), Is.EqualTo(1));142            Assert.That(rs.Rows.Cast<DataRow>().Count(x => x.Field<decimal>(0) == 2), Is.EqualTo(1));...

ResultSetResolverFactory.cs

Source:ResultSetResolverFactory.cs

...32                case QueryResultSetResolverArgs x: return new QueryResultSetResolver(x, serviceLocator);33                case FlatFileResultSetResolverArgs x: return new FlatFileResultSetResolver(x, serviceLocator);34                case DataSerializationResultSetResolverArgs x: return new DataSerializationResultSetResolver(x);35                case ObjectsResultSetResolverArgs x: return new ObjectsResultSetResolver(x);36                case SequenceCombinationResultSetResolverArgs x: return new SequenceCombinationResultSetResolver(x);37                case EmptyResultSetResolverArgs x: return new EmptyResultSetResolver(x);38                case IfUnavailableResultSetResolverArgs x: return new IfUnavailableResultSetResolver(x);39                default: throw new ArgumentOutOfRangeException($"Type '{args.GetType().Name}' is not expected when building a result-set");40            }41        }42    }43}...

SequenceCombinationResultSetResolver.cs

Source:SequenceCombinationResultSetResolver.cs

...8using System.Text;9using System.Threading.Tasks;10namespace NBi.Core.ResultSet.Resolver11{12    class SequenceCombinationResultSetResolver : IResultSetResolver13    {14        private SequenceCombinationResultSetResolverArgs Args { get; }15        public SequenceCombinationResultSetResolver(SequenceCombinationResultSetResolverArgs args)16            => Args = args;17        public IResultSet Execute()18        {19            if (Args.Resolvers.Count() == 0)20                throw new InvalidOperationException();21            var rs = Initialize(Args.Resolvers.First());22            foreach (var resolver in Args.Resolvers.Skip(1))23            {24                var cartesianProduct = new CartesianProductSequenceCombination(resolver);25                cartesianProduct.Execute(rs);26            }27            return rs;28        }29        ...