Esempio n. 1
0
        public void ExtractQuery_NonExistingReport_CorrectExceptionReturned()
        {
            var request = new NBi.Core.Report.DatabaseRequest(
                    ConnectionStringReader.GetReportServerDatabase()
                    , "/AdventureWorks Sample Reports/"
                    , "Not Existing"
                    , "DataSet1"
                );

            var parser = new DatabaseParser();
            var ex = Assert.Throws<ArgumentException>(() => parser.ExtractQuery(request));
            Assert.That(ex.Message, Is.StringContaining("No report found"));
        }
Esempio n. 2
0
        public void ExtractQuery_ExistingReportAndDataSet_CorrectQueryReturned()
        {
            var request = new NBi.Core.Report.DatabaseRequest(
                    ConnectionStringReader.GetReportServerDatabase()
                    , "/AdventureWorks Sample Reports/"
                    , "Currency_List"
                    ,"Currency"
                );

            var parser = new DatabaseParser();
            var query = parser.ExtractQuery(request);

            Assert.That(query,
                Is.StringContaining("SELECT").And
                .StringContaining("[CurrencyAlternateKey]").And
                .StringContaining("[DimCurrency]"));
        }