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")); }
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]")); }