Join the 1-day Testing & QA Summit featuring 15+ Expert Speakers.Register for FREE! Join TestMu Conference

Automation Advisor
NBi
NBi.Core.Structure
StructureDiscoveryFactoryProvider

How to use StructureDiscoveryFactoryProvider class of NBi.Core.Structure package

Best NBi code snippet using NBi.Core.Structure.StructureDiscoveryFactoryProvider

StructureDiscoveryFactoryProviderTest.cs

Source:StructureDiscoveryFactoryProviderTest.cs

...11using System.Threading.Tasks;12using System.Xml;13namespace NBi.Testing.Core.Structure14{15    public class StructureDiscoveryFactoryProviderTest16    {17        private class FakeStructureDiscoveryFactoryProvider : StructureDiscoveryFactoryProvider18        {19            private readonly string result;20            public FakeStructureDiscoveryFactoryProvider(string result)21                : base()22            {23                this.result = result;24            }25            protected override string InquireFurtherAnalysisService(string connectionString)26            {27                return result;28            }29            public new string ParseXmlaResponse(XmlDocument doc)30            {31                return base.ParseXmlaResponse(doc);32            }33        }34        [Test]35        public void Instantiate_EmptyConnectionString_GetDatabaseStructureDiscoveryFactory()36        {37            var connectionString = string.Empty;38            var provider = new StructureDiscoveryFactoryProvider();39            Assert.Throws<ArgumentNullException>(() => provider.Instantiate(connectionString));40        }41        [Test]42        public void Instantiate_SqlConnection_GetDatabaseStructureDiscoveryFactory()43        {44            var connectionString = ConnectionStringReader.GetSqlClient();45            46            var provider = new StructureDiscoveryFactoryProvider();47            var factory = provider.Instantiate(connectionString);48            Assert.That(factory, Is.TypeOf<RelationalStructureDiscoveryFactory>());49        }50        [Test]51        public void Instantiate_AdomdConnectionOlap_GetDatabaseStructureDiscoveryFactory()52        {53            var connectionString = ConnectionStringReader.GetAdomd();54            var provider = new FakeStructureDiscoveryFactoryProvider(StructureDiscoveryFactoryProvider.Olap);55            var factory = provider.Instantiate(connectionString);56            Assert.That(factory, Is.TypeOf<OlapStructureDiscoveryFactory>());57        }58        [Test]59        public void Instantiate_AdomdConnectionTabular_GetDatabaseStructureDiscoveryFactory()60        {61            var connectionString = ConnectionStringReader.GetAdomd();62            var provider = new FakeStructureDiscoveryFactoryProvider(StructureDiscoveryFactoryProvider.Tabular);63            var factory = provider.Instantiate(connectionString);64            Assert.That(factory, Is.TypeOf<TabularStructureDiscoveryFactory>());65        }66        67        [Test]68        [TestCase("Multidimensional")]69        [TestCase("Tabular")]70        [TestCase("Sharepoint")]71        [TestCase("Default")]72        public void ParseXmlaResponse_Tabular_GetCorrectServerMode(string serverMode)73        {74            var xml = ""75                        + "<Server xmlns=\"http://schemas.microsoft.com/analysisservices/2003/engine\">                                                                                                    "76                        + "            <Name>XXX\\SQL2014</Name>                                                                           "77                        + "            <ID>XXX\\SQL2014</ID>                                                                               "78                        + "            <CreatedTimestamp>2015-07-02T21:56:04.076667</CreatedTimestamp>                                         "79                        + "            <LastSchemaUpdate>2015-07-02T21:56:04.093333</LastSchemaUpdate>                                         "80                        + "            <Version>12.0.2000.8</Version>                                                                          "81                        + "            <Edition>Developer64</Edition>                                                                          "82                        + "            <EditionID>2176971986</EditionID>                                                                       "83                        + "            <ddl300:ServerMode xmlns:ddl300=\"http://schemas.microsoft.com/analysisservices/2011/engine/300\">$value$</ddl300:ServerMode>"84                        + "            <ddl400:ServerLocation xmlns:ddl400=\"http://schemas.microsoft.com/analysisservices/2012/engine/400\">OnPremise</ddl400:ServerLocation>"85                        + "            <ddl400:DefaultCompatibilityLevel xmlns:ddl400=\"http://schemas.microsoft.com/analysisservices/2012/engine/400\">1100</ddl400:DefaultCompatibilityLevel>"86                        + "</Server>                                                                                                   ";87            xml = xml.Replace("$value$", serverMode);88            var doc = new XmlDocument();89            90            doc.LoadXml(xml);91            var provider = new FakeStructureDiscoveryFactoryProvider(null);92            var parsedServerMode = provider.ParseXmlaResponse(doc);93            Assert.That(parsedServerMode, Is.EqualTo(serverMode));94        }95        [Test]96        [TestCase("10.0.200.12")]97        [TestCase("9.1.200")]98        public void ParseXmlaResponse_VersionBefore11_GetCorrectServerMode(string version)99        {100            var xml = ""101                        + "<Server xmlns=\"http://schemas.microsoft.com/analysisservices/2003/engine\">                                                                                                    "102                        + "            <Name>XXX\\SQL2014</Name>                                                                           "103                        + "            <ID>XXX\\SQL2014</ID>                                                                               "104                        + "            <CreatedTimestamp>2015-07-02T21:56:04.076667</CreatedTimestamp>                                         "105                        + "            <LastSchemaUpdate>2015-07-02T21:56:04.093333</LastSchemaUpdate>                                         "106                        + "            <Version>$value$</Version>                                                                          "107                        + "            <Edition>Developer64</Edition>                                                                          "108                        + "            <EditionID>2176971986</EditionID>                                                                       "109                        + "</Server>                                                                                                   ";110            xml = xml.Replace("$value$", version);111            var doc = new XmlDocument();112            doc.LoadXml(xml);113            var provider = new FakeStructureDiscoveryFactoryProvider(null);114            var parsedServerMode = provider.ParseXmlaResponse(doc);115            Assert.That(parsedServerMode, Is.EqualTo("Multidimensional"));116        }117        [Test]118        [TestCase("12.0.200.12")]119        [TestCase("11.1.200")]120        public void ParseXmlaResponse_VersionAfter11_ThrowExceptionImpossibleToGuess(string version)121        {122            var xml = ""123                        + "<Server xmlns=\"http://schemas.microsoft.com/analysisservices/2003/engine\">                                                                                                    "124                        + "            <Name>XXX\\SQL2014</Name>                                                                           "125                        + "            <ID>XXX\\SQL2014</ID>                                                                               "126                        + "            <CreatedTimestamp>2015-07-02T21:56:04.076667</CreatedTimestamp>                                         "127                        + "            <LastSchemaUpdate>2015-07-02T21:56:04.093333</LastSchemaUpdate>                                         "128                        + "            <Version>$value$</Version>                                                                          "129                        + "            <Edition>Developer64</Edition>                                                                          "130                        + "            <EditionID>2176971986</EditionID>                                                                       "131                        + "</Server>                                                                                                   ";132            xml = xml.Replace("$value$", version);133            var doc = new XmlDocument();134            doc.LoadXml(xml);135            var provider = new FakeStructureDiscoveryFactoryProvider(null);136            Assert.Throws<ArgumentException>(delegate { provider.ParseXmlaResponse(doc); });137        }138    }139}...

EquivalentToConstraintTest.cs

Source:EquivalentToConstraintTest.cs

...4546        [Test, Category("Olap cube")]47        public void Matches_ActualEqualToExpectation_Success()48        {49            var provider = new StructureDiscoveryFactoryProvider();50            var factory = provider.Instantiate(ConnectionStringReader.GetAdomd());51            var discovery = factory.Instantiate(52                        Target.Perspectives53                        , TargetType.Object54                        , new CaptionFilter[]{});5556            var expected = new string[] { "Adventure Works", "Channel Sales", "Direct Sales", "Finance", "Sales Summary", "Sales Targets" };57            var ctr = new EquivalentToConstraint(expected);5859            //Method under test60            Assert.That(discovery, ctr);61        }6263        [Test, Category("Olap cube")]64        public void Matches_ActualEqualToExpectationButCaseNonMatching_Success()65        {66            var provider = new StructureDiscoveryFactoryProvider();67            var factory = provider.Instantiate(ConnectionStringReader.GetAdomd());68            var discovery = factory.Instantiate(69                        Target.Perspectives70                        , TargetType.Object71                        , new CaptionFilter[] { });7273            var expected = new string[] { "Adventure Works".ToLower(), "Channel Sales".ToUpper(), "Direct Sales", "Finance", "Sales Summary", "Sales Targets" };74            var ctr = new EquivalentToConstraint(expected);75            ctr = ctr.IgnoreCase;7677            //Method under test78            Assert.That(discovery, ctr);7980        }8182        [Test, Category("Olap cube")]83        public void Matches_ActualEqualToExpectationButCaseNonMatching_Failure()84        {85            var provider = new StructureDiscoveryFactoryProvider();86            var factory = provider.Instantiate(ConnectionStringReader.GetAdomd());87            var discovery = factory.Instantiate(88                        Target.Perspectives89                        , TargetType.Object90                        , new CaptionFilter[] { });9192            var expected = new string[] { "Adventure Works".ToLower(), "Channel Sales".ToUpper(), "Direct Sales", "Finance", "Mined Customers", "Sales Summary", "Sales Targets" };93            var ctr = new EquivalentToConstraint(expected);9495            //Method under test96            Assert.That(ctr.Matches(discovery), Is.False);9798        }99100        [Test, Category("Olap cube")]101        public void Matches_ActualMoreThanExpectation_Failure()102        {103            var provider = new StructureDiscoveryFactoryProvider();104            var factory = provider.Instantiate(ConnectionStringReader.GetAdomd());105            var discovery = factory.Instantiate(106                        Target.Perspectives107                        , TargetType.Object108                        , new CaptionFilter[] { });109110            var expectedStrings = new string[] { "Adventure Works", "Channel Sales", "Direct Sales", "Finance", "Mined Customers", "Sales Summary", "Sales Targets" };111            var expected = new List<string>();112            expected.AddRange(expectedStrings);113            expected.RemoveAt(0);114            var ctr = new EquivalentToConstraint(expected);115116            //Method under test117            Assert.That(ctr.Matches(discovery), Is.False);118119        }120121        [Test, Category("Olap cube")]122        public void Matches_ActualSubsetOfExpectation_Failure()123        {124            var provider = new StructureDiscoveryFactoryProvider();125            var factory = provider.Instantiate(ConnectionStringReader.GetAdomd());126            var discovery = factory.Instantiate(127                        Target.Perspectives128                        , TargetType.Object129                        , new CaptionFilter[] { });130131            var expectedStrings = new string[] { "Adventure Works", "Channel Sales", "Direct Sales", "Finance", "Mined Customers", "Sales Summary", "Sales Targets" };132            var expected = new List<string>();133            expected.AddRange(expectedStrings);134            expected.Add("New perspective");135            var ctr = new EquivalentToConstraint(expected);136137            //Method under test138            Assert.That(ctr.Matches(discovery), Is.False);
...

SubsetOfConstraintTest.cs

Source:SubsetOfConstraintTest.cs

...4142        [Test, Category("Olap cube")]43        public void Matches_ActualEqualToExpectation_Success()44        {45            var provider = new StructureDiscoveryFactoryProvider();46            var factory = provider.Instantiate(ConnectionStringReader.GetAdomd());47            var discovery = factory.Instantiate(48                        Target.Perspectives49                        , TargetType.Object50                        , new CaptionFilter[] { });5152            var expected = new string[] { "Adventure Works", "Channel Sales", "Direct Sales", "Finance", "Mined Customers", "Sales Summary", "Sales Targets" };53            var ctr = new ContainedInConstraint(expected);5455            //Method under test56            Assert.That(discovery, ctr);5758        }5960        [Test, Category("Olap cube")]61        public void Matches_ActualEqualToExpectationCaseNonMatching_Success()62        {63            var provider = new StructureDiscoveryFactoryProvider();64            var factory = provider.Instantiate(ConnectionStringReader.GetAdomd());65            var discovery = factory.Instantiate(66                        Target.Perspectives67                        , TargetType.Object68                        , new CaptionFilter[] { });6970            var expected = new string[] { "Adventure Works".ToUpper(), "Channel Sales".ToLower(), "Direct Sales", "Finance", "Mined Customers", "Sales Summary", "Sales Targets" };71            var ctr = new ContainedInConstraint(expected);72            ctr = ctr.IgnoreCase;7374            //Method under test75            Assert.That(discovery, ctr);7677        }7879        [Test, Category("Olap cube")]80        public void Matches_ActualMoreThanExpectation_Failure()81        {82            var provider = new StructureDiscoveryFactoryProvider();83            var factory = provider.Instantiate(ConnectionStringReader.GetAdomd());84            var discovery = factory.Instantiate(85                        Target.Perspectives86                        , TargetType.Object87                        , new CaptionFilter[] { });8889            var expectedStrings = new string[] { "Adventure Works", "Channel Sales", "Direct Sales", "Finance", "Mined Customers", "Sales Summary", "Sales Targets" };90            var expected = new List<string>();91            expected.AddRange(expectedStrings);92            expected.RemoveAt(0);93            var ctr = new ContainedInConstraint(expected);9495            //Method under test96            Assert.That(ctr.Matches(discovery), Is.False);9798        }99100        [Test, Category("Olap cube")]101        public void Matches_ActualSubsetOfExpectation_Sucess()102        {103            var provider = new StructureDiscoveryFactoryProvider();104            var factory = provider.Instantiate(ConnectionStringReader.GetAdomd());105            var discovery = factory.Instantiate(106                        Target.Perspectives107                        , TargetType.Object108                        , new CaptionFilter[] { });109110            var expectedStrings = new string[] { "Adventure Works", "Channel Sales", "Direct Sales", "Finance", "Mined Customers", "Sales Summary", "Sales Targets" };111            var expected = new List<string>();112            expected.AddRange(expectedStrings);113            expected.Add("New perspective");114            var ctr = new ContainedInConstraint(expected);115116            //Method under test117            Assert.That(ctr.Matches(discovery), Is.True);
...