Example #1
0
        public void ParseXmlaResponse_Tabular_GetCorrectServerMode(string serverMode)
        {
            var xml = ""
                      + "<Server xmlns=\"http://schemas.microsoft.com/analysisservices/2003/engine\">                                                                                                    "
                      + "            <Name>XXX\\SQL2014</Name>                                                                           "
                      + "            <ID>XXX\\SQL2014</ID>                                                                               "
                      + "            <CreatedTimestamp>2015-07-02T21:56:04.076667</CreatedTimestamp>                                         "
                      + "            <LastSchemaUpdate>2015-07-02T21:56:04.093333</LastSchemaUpdate>                                         "
                      + "            <Version>12.0.2000.8</Version>                                                                          "
                      + "            <Edition>Developer64</Edition>                                                                          "
                      + "            <EditionID>2176971986</EditionID>                                                                       "
                      + "            <ddl300:ServerMode xmlns:ddl300=\"http://schemas.microsoft.com/analysisservices/2011/engine/300\">$value$</ddl300:ServerMode>"
                      + "            <ddl400:ServerLocation xmlns:ddl400=\"http://schemas.microsoft.com/analysisservices/2012/engine/400\">OnPremise</ddl400:ServerLocation>"
                      + "            <ddl400:DefaultCompatibilityLevel xmlns:ddl400=\"http://schemas.microsoft.com/analysisservices/2012/engine/400\">1100</ddl400:DefaultCompatibilityLevel>"
                      + "</Server>                                                                                                   ";

            xml = xml.Replace("$value$", serverMode);
            var doc = new XmlDocument();

            doc.LoadXml(xml);
            var provider         = new FakeStructureDiscoveryFactoryProvider(null);
            var parsedServerMode = provider.ParseXmlaResponse(doc);

            Assert.That(parsedServerMode, Is.EqualTo(serverMode));
        }
        public void InquireFurtherAnalysisService_Tabular_ReturnCorrectServerMode()
        {
            var connectionString = ConnectionStringReader.GetAdomdTabular();

            var provider = new FakeStructureDiscoveryFactoryProvider();
            var serverMode = provider.InquireFurtherAnalysisService(connectionString);
            Assert.That(serverMode, Is.EqualTo("tabular"));
        }
        public void Instantiate_AdomdConnectionTabular_GetDatabaseStructureDiscoveryFactory()
        {
            var connectionString = ConnectionStringReader.GetAdomd();

            var provider = new FakeStructureDiscoveryFactoryProvider(StructureDiscoveryFactoryProvider.Tabular);
            var factory = provider.Instantiate(connectionString);
            Assert.That(factory, Is.TypeOf<TabularStructureDiscoveryFactory>());
        }
Example #4
0
        public void Instantiate_AdomdConnectionTabular_GetDatabaseStructureDiscoveryFactory()
        {
            var connectionString = ConnectionStringReader.GetAdomd();

            var provider = new FakeStructureDiscoveryFactoryProvider(StructureDiscoveryFactoryProvider.Tabular);
            var factory  = provider.Instantiate(connectionString);

            Assert.That(factory, Is.TypeOf <TabularStructureDiscoveryFactory>());
        }
        public void InquireFurtherAnalysisService_Tabular_ReturnCorrectServerMode()
        {
            var connectionString = ConnectionStringReader.GetAdomdTabular();

            var provider   = new FakeStructureDiscoveryFactoryProvider();
            var serverMode = provider.InquireFurtherAnalysisService(connectionString);

            Assert.That(serverMode, Is.EqualTo("tabular"));
        }
Example #6
0
        public void ParseXmlaResponse_VersionAfter11_ThrowExceptionImpossibleToGuess(string version)
        {
            var xml = ""
                      + "<Server xmlns=\"http://schemas.microsoft.com/analysisservices/2003/engine\">                                                                                                    "
                      + "            <Name>XXX\\SQL2014</Name>                                                                           "
                      + "            <ID>XXX\\SQL2014</ID>                                                                               "
                      + "            <CreatedTimestamp>2015-07-02T21:56:04.076667</CreatedTimestamp>                                         "
                      + "            <LastSchemaUpdate>2015-07-02T21:56:04.093333</LastSchemaUpdate>                                         "
                      + "            <Version>$value$</Version>                                                                          "
                      + "            <Edition>Developer64</Edition>                                                                          "
                      + "            <EditionID>2176971986</EditionID>                                                                       "
                      + "</Server>                                                                                                   ";

            xml = xml.Replace("$value$", version);
            var doc = new XmlDocument();

            doc.LoadXml(xml);
            var provider = new FakeStructureDiscoveryFactoryProvider(null);

            Assert.Throws <ArgumentException>(delegate { provider.ParseXmlaResponse(doc); });
        }
Example #7
0
        public void ParseXmlaResponse_VersionBefore11_GetCorrectServerMode(string version)
        {
            var xml = ""
                      + "<Server xmlns=\"http://schemas.microsoft.com/analysisservices/2003/engine\">                                                                                                    "
                      + "            <Name>XXX\\SQL2014</Name>                                                                           "
                      + "            <ID>XXX\\SQL2014</ID>                                                                               "
                      + "            <CreatedTimestamp>2015-07-02T21:56:04.076667</CreatedTimestamp>                                         "
                      + "            <LastSchemaUpdate>2015-07-02T21:56:04.093333</LastSchemaUpdate>                                         "
                      + "            <Version>$value$</Version>                                                                          "
                      + "            <Edition>Developer64</Edition>                                                                          "
                      + "            <EditionID>2176971986</EditionID>                                                                       "
                      + "</Server>                                                                                                   ";

            xml = xml.Replace("$value$", version);
            var doc = new XmlDocument();

            doc.LoadXml(xml);
            var provider         = new FakeStructureDiscoveryFactoryProvider(null);
            var parsedServerMode = provider.ParseXmlaResponse(doc);

            Assert.That(parsedServerMode, Is.EqualTo("Multidimensional"));
        }
        public void ParseXmlaResponse_Tabular_GetCorrectServerMode(string serverMode)
        {
            var xml = ""
                        + "<Server xmlns=\"http://schemas.microsoft.com/analysisservices/2003/engine\">                                                                                                    "
                        + "            <Name>XXX\\SQL2014</Name>                                                                           "
                        + "            <ID>XXX\\SQL2014</ID>                                                                               "
                        + "            <CreatedTimestamp>2015-07-02T21:56:04.076667</CreatedTimestamp>                                         "
                        + "            <LastSchemaUpdate>2015-07-02T21:56:04.093333</LastSchemaUpdate>                                         "
                        + "            <Version>12.0.2000.8</Version>                                                                          "
                        + "            <Edition>Developer64</Edition>                                                                          "
                        + "            <EditionID>2176971986</EditionID>                                                                       "
                        + "            <ddl300:ServerMode xmlns:ddl300=\"http://schemas.microsoft.com/analysisservices/2011/engine/300\">$value$</ddl300:ServerMode>"
                        + "            <ddl400:ServerLocation xmlns:ddl400=\"http://schemas.microsoft.com/analysisservices/2012/engine/400\">OnPremise</ddl400:ServerLocation>"
                        + "            <ddl400:DefaultCompatibilityLevel xmlns:ddl400=\"http://schemas.microsoft.com/analysisservices/2012/engine/400\">1100</ddl400:DefaultCompatibilityLevel>"
                        + "</Server>                                                                                                   ";
            xml = xml.Replace("$value$", serverMode);
            var doc = new XmlDocument();

            doc.LoadXml(xml);
            var provider = new FakeStructureDiscoveryFactoryProvider(null);
            var parsedServerMode = provider.ParseXmlaResponse(doc);
            Assert.That(parsedServerMode, Is.EqualTo(serverMode));
        }
        public void ParseXmlaResponse_VersionAfter11_ThrowExceptionImpossibleToGuess(string version)
        {
            var xml = ""
                        + "<Server xmlns=\"http://schemas.microsoft.com/analysisservices/2003/engine\">                                                                                                    "
                        + "            <Name>XXX\\SQL2014</Name>                                                                           "
                        + "            <ID>XXX\\SQL2014</ID>                                                                               "
                        + "            <CreatedTimestamp>2015-07-02T21:56:04.076667</CreatedTimestamp>                                         "
                        + "            <LastSchemaUpdate>2015-07-02T21:56:04.093333</LastSchemaUpdate>                                         "
                        + "            <Version>$value$</Version>                                                                          "
                        + "            <Edition>Developer64</Edition>                                                                          "
                        + "            <EditionID>2176971986</EditionID>                                                                       "
                        + "</Server>                                                                                                   ";
            xml = xml.Replace("$value$", version);
            var doc = new XmlDocument();

            doc.LoadXml(xml);
            var provider = new FakeStructureDiscoveryFactoryProvider(null);
            Assert.Throws<ArgumentException>(delegate { provider.ParseXmlaResponse(doc); });
        }
        public void ParseXmlaResponse_VersionBefore11_GetCorrectServerMode(string version)
        {
            var xml = ""
                        + "<Server xmlns=\"http://schemas.microsoft.com/analysisservices/2003/engine\">                                                                                                    "
                        + "            <Name>XXX\\SQL2014</Name>                                                                           "
                        + "            <ID>XXX\\SQL2014</ID>                                                                               "
                        + "            <CreatedTimestamp>2015-07-02T21:56:04.076667</CreatedTimestamp>                                         "
                        + "            <LastSchemaUpdate>2015-07-02T21:56:04.093333</LastSchemaUpdate>                                         "
                        + "            <Version>$value$</Version>                                                                          "
                        + "            <Edition>Developer64</Edition>                                                                          "
                        + "            <EditionID>2176971986</EditionID>                                                                       "
                        + "</Server>                                                                                                   ";
            xml = xml.Replace("$value$", version);
            var doc = new XmlDocument();

            doc.LoadXml(xml);
            var provider = new FakeStructureDiscoveryFactoryProvider(null);
            var parsedServerMode = provider.ParseXmlaResponse(doc);
            Assert.That(parsedServerMode, Is.EqualTo("Multidimensional"));
        }