public void ExtractQuery_NonExistingDataSetOneExisting_CorrectExceptionReturned() { var request = new DatasetRequest( string.Empty , ReportFileDirectory , "Currency_List" , "Non Existing" ); var parser = new FileParser(); var ex = Assert.Throws <ArgumentException>(() => parser.ExtractQuery(request)); Assert.That(ex.Message, Is.StringContaining("'Currency'")); }
public void ExtractQuery_NonExistingDataSetMoreThanOneExisting_CorrectExceptionReturned() { var request = new DatasetRequest( ConnectionStringReader.GetReportServerDatabase() , "/AdventureWorks Sample Reports/" , "Currency Rates" , "Non Existing" ); var parser = new DatabaseParser(); var ex = Assert.Throws <ArgumentException>(() => parser.ExtractQuery(request)); Assert.That(ex.Message, Is.StringContaining("DataSet1").And.StringContaining("DataSet2")); }
public void ExtractQuery_NonExistingSharedDataSet_CorrectQuery() { var request = new DatasetRequest( ConnectionStringReader.GetReportServerDatabase() , "/AdventureWorks Sample Reports/" , "Employee_Sales_Summary" , "NonExisting" ); var parser = new DatabaseParser(); var ex = Assert.Throws <ArgumentException>(() => parser.ExtractQuery(request)); Assert.That(ex.Message, Is.StringContaining("Quota").And.StringContaining("EmpSalesMonth")); }
public override string GetQuery() { var parser = ParserFactory.GetParser(Source); var request = new DatasetRequest ( Source ?? Settings.BasePath, Path, Name, Dataset ); command = parser.ExtractQuery(request); return(command.Text); }
public void ExtractQuery_SharedDataSetViaReport_CorrectQuery() { var request = new DatasetRequest( ConnectionStringReader.GetReportServerDatabase() , "/AdventureWorks Sample Reports/" , "Employee_Sales_Summary" , "EmpSalesMonth" ); var parser = new DatabaseParser(); var query = parser.ExtractQuery(request); Assert.That(query.Text, Is.StringContaining("SELECT")); Assert.That(query.CommandType, Is.EqualTo(CommandType.Text)); }
public void ExtractQuery_ExistingReportAndDataSet_CorrectQueryReturned() { var request = new DatasetRequest( string.Empty , ReportFileDirectory , "Currency_List" , "Currency" ); var parser = new FileParser(); var query = parser.ExtractQuery(request); Assert.That(query.Text, Is.StringContaining("SELECT").And .StringContaining("[CurrencyAlternateKey]").And .StringContaining("[DimCurrency]")); Assert.That(query.CommandType, Is.EqualTo(CommandType.Text)); }
public void ExtractQuery_ExistingReportAndDataSet_CorrectQueryReturned() { var request = new DatasetRequest( ConnectionStringReader.GetReportServerDatabase() , "/AdventureWorks Sample Reports/" , "Currency_List" , "Currency" ); var parser = new DatabaseParser(); var query = parser.ExtractQuery(request); Assert.That(query.Text, Is.StringContaining("SELECT").And .StringContaining("[CurrencyAlternateKey]").And .StringContaining("[DimCurrency]")); Assert.That(query.CommandType, Is.EqualTo(CommandType.Text)); }
public DatasetResponse Dataset(DatasetRequest req) => MakeRequest <DatasetRequest, DatasetResponse>("dataset", req) as DatasetResponse;