How to use RelationalStructureDiscoveryFactory method of NBi.Core.Structure.Relational.RelationalStructureDiscoveryFactory class

Best NBi code snippet using NBi.Core.Structure.Relational.RelationalStructureDiscoveryFactory.RelationalStructureDiscoveryFactory

RelationalStructureDiscoveryFactoryTest.cs

Source:RelationalStructureDiscoveryFactoryTest.cs

...16        [Test]17        public void Execute_Schema_ListStructureContainingManyElements()18        {19            var conn = new SqlConnection(ConnectionStringReader.GetSqlClient());20            var factory = new RelationalStructureDiscoveryFactory(conn);21            var cmd = factory.Instantiate(Target.Perspectives, TargetType.Object,22                new IFilter[] {23                });2425            var structs = cmd.Execute();2627            Assert.That(structs.Count(), Is.EqualTo(18)); //All available schemas28        }2930        [Test]31        public void Execute_SchemaWithDbo_ListStructureContainingManyElements()32        {33            var conn = new SqlConnection(ConnectionStringReader.GetSqlClient());34            var factory = new RelationalStructureDiscoveryFactory(conn);35            var cmd = factory.Instantiate(Target.Perspectives, TargetType.Object,36                new [] {37                        new OwnerFilter("dbo")38                });3940            var structs = cmd.Execute();4142            Assert.That(structs.Count(), Is.EqualTo(6)); //Standards 43        }4445        [Test]46        public void Execute_Table_ListStructureContainingFifteenElements()47        {48            var conn = new SqlConnection(ConnectionStringReader.GetSqlClient());49            var factory = new RelationalStructureDiscoveryFactory(conn);50            var cmd = factory.Instantiate(Target.Tables, TargetType.Object,51                new [] { 52                    new CaptionFilter(Target.Perspectives, "Sales"),53                });5455            var structs = cmd.Execute();5657            Assert.That(structs.Count(), Is.EqualTo(19 + 7));//Tables + Views58        }5960        [Test]61        public void Execute_Column_ListStructureContainingSevenElements()62        {63            var conn = new SqlConnection(ConnectionStringReader.GetSqlClient());64            var factory = new RelationalStructureDiscoveryFactory(conn);65            var cmd = factory.Instantiate(Target.Columns, TargetType.Object,66                new [] {67                    new CaptionFilter(Target.Perspectives,"Sales"),68                    new CaptionFilter(Target.Tables,"Customer"),69                });7071            var structs = cmd.Execute();7273            Assert.That(structs.Count(), Is.EqualTo(7));74        }757677        //[Test]78        //public void Execute_DateDimensionLinkedToElevenMeasureGroups_ListStructureContainingTenElements()79        //{80        //    var disco = new DiscoveryRequestFactory().BuildRelation(81        //                ConnectionStringReader.GetAdomd()82        //                , DiscoveryTarget.MeasureGroups83        //                , new List<IFilter>() { 84        //                    new CaptionFilter("Adventure Works", DiscoveryTarget.Perspectives)85        //                    , new CaptionFilter("Customer", DiscoveryTarget.Dimensions)86        //                });8788        //    var factory = new AdomdDiscoveryCommandFactory();89        //    var cmd = factory.BuildExact(disco);9091        //    var structs = cmd.Execute();9293        //    Assert.That(structs.Count(), Is.EqualTo(10));94        //}9596        [Test]97        public void Execute_Routines_ListStructureContainingThreeElements()98        {99            var conn = new SqlConnection(ConnectionStringReader.GetSqlClient());100            var factory = new RelationalStructureDiscoveryFactory(conn);101            var cmd = factory.Instantiate(Target.Routines, TargetType.Object,102                new [] {103                    new CaptionFilter(Target.Perspectives,"HumanResources")104                });105106            var structs = cmd.Execute();107108            Assert.That(structs.Count(), Is.EqualTo(3));109        }110111        [Test]112        public void Execute_RoutinesWithName_ListStructureContainingThisRoutine()113        {114            var conn = new SqlConnection(ConnectionStringReader.GetSqlClient());115            var factory = new RelationalStructureDiscoveryFactory(conn);116            var cmd = factory.Instantiate(Target.Routines, TargetType.Object,117                new [] {118                    new CaptionFilter(Target.Perspectives,"dbo")119                    , new CaptionFilter(Target.Routines,"ufnGetContactInformation")120                });121122            var structs = cmd.Execute();123124            Assert.That(structs.Count(), Is.EqualTo(1));125        }126127        [Test]128        public void Execute_Parameters_ListStructureContainingFiveElements()129        {130            var conn = new SqlConnection(ConnectionStringReader.GetSqlClient());131            var factory = new RelationalStructureDiscoveryFactory(conn);132            var cmd = factory.Instantiate(Target.Parameters, TargetType.Object,133                new [] {134                    new CaptionFilter(Target.Perspectives,"HumanResources")135                    , new CaptionFilter(Target.Routines,"uspUpdateEmployeePersonalInfo")136                });137138            var structs = cmd.Execute();139140            Assert.That(structs.Count(), Is.EqualTo(5));141        }142143        [Test]144        public void Execute_ParameterWithName_ListStructureContainingThisParameter()145        {146            var conn = new SqlConnection(ConnectionStringReader.GetSqlClient());147            var factory = new RelationalStructureDiscoveryFactory(conn);148            var cmd = factory.Instantiate(Target.Parameters, TargetType.Object,149                new [] {150                    new CaptionFilter(Target.Perspectives,"HumanResources")151                    , new CaptionFilter(Target.Routines,"uspUpdateEmployeePersonalInfo")152                    , new CaptionFilter(Target.Parameters,"BirthDate")153                });154155            var structs = cmd.Execute();156157            Assert.That(structs.Count(), Is.EqualTo(1));158            Assert.That(structs.ElementAt(0), Is.EqualTo("BirthDate"));159        }160161        [Test]162        [TestCase(true, 0)]163        [TestCase(false, 1)]164        public void Execute_ParameterWithNameAndResult_ListStructureContainingThisParameter(bool isResult, int count)165        {166            var conn = new SqlConnection(ConnectionStringReader.GetSqlClient());167            var factory = new RelationalStructureDiscoveryFactory(conn);168            var cmd = factory.Instantiate(Target.Parameters, TargetType.Object,169                new IFilter [] {170                    new CaptionFilter(Target.Perspectives,"HumanResources")171                    , new CaptionFilter(Target.Routines,"uspUpdateEmployeePersonalInfo")172                    , new CaptionFilter(Target.Parameters,"BirthDate")173                    , new IsResultFilter(isResult)174                });175176            var structs = cmd.Execute();177178            Assert.That(structs.Count(), Is.EqualTo(count));179        }180    }181
...

StructureDiscoveryFactoryProvider.cs

Source:StructureDiscoveryFactoryProvider.cs

...33        34        protected virtual void Initialize()35        {36            dico.Add(Olap, typeof(OlapStructureDiscoveryFactory));37            dico.Add(Relational, typeof(RelationalStructureDiscoveryFactory));38            dico.Add(Tabular, typeof(TabularStructureDiscoveryFactory));39        }4041        public IStructureDiscoveryFactory Instantiate(string connectionString)42        {43            var sessionFactory = new ClientProvider();44            var connection = sessionFactory.Instantiate(connectionString).CreateNew() as IDbConnection;45            var dbType = MapConnectionTypeToDatabaseType(connection);4647            if (!dico.Keys.Contains(dbType))48                throw new ArgumentException();4950            var factoryType = dico[dbType];51            var ctor = factoryType.GetConstructor(new Type[]{typeof(IDbConnection)});
...

RelationalStructureDiscoveryFactory.cs

Source:RelationalStructureDiscoveryFactory.cs

...8using System.Threading.Tasks;910namespace NBi.Core.Structure.Relational11{12    class RelationalStructureDiscoveryFactory : IStructureDiscoveryFactory13    {14        private readonly IDbConnection connection;15        public RelationalStructureDiscoveryFactory(IDbConnection connection)16        {17            this.connection = connection as IDbConnection;18        }1920        public StructureDiscoveryCommand Instantiate(Target target, TargetType type, IEnumerable<IFilter> filters)21        {22            var builder = InstantiateBuilder(target);23            builder.Build(filters);2425            var cmd = connection.CreateCommand();26            cmd.CommandText = builder.GetCommandText();27            var postFilters = builder.GetPostFilters();2829            var description = new CommandDescription(target, filters);3031            RelationalCommand command = null;32            command = new RelationalCommand(cmd, postFilters, description);3334            return command;35        }363738        protected virtual IDiscoveryCommandBuilder InstantiateBuilder(Target target)39        {40            switch (target)41            {42                case Target.Perspectives:43                    return new SchemaDiscoveryCommandBuilder();44                case Target.Tables:45                    return new TableDiscoveryCommandBuilder();46                case Target.Columns:47                    return new ColumnDiscoveryCommandBuilder();48                case Target.Routines:49                    return new RoutineDiscoveryCommandBuilder();50                case Target.Parameters:51                    return new RoutineParameterDiscoveryCommandBuilder();52                default:53                    throw new ArgumentOutOfRangeException(string.Format("The value '{0}' is not supported when instantiating with 'RelationalStructureDiscoveryFactory'.", target));54            }55        }5657    }58}
...