public void QueryGeneration_WithLinkedCohort_WHERECHIIN() { var csqb = new CohortSummaryQueryBuilder(acDataset, acCohort); var ex = Assert.Throws <NotSupportedException>(() => csqb.GetAdjustedAggregateBuilder(CohortSummaryAdjustment.WhereExtractionIdentifiersIn)); Assert.AreEqual("No Query Caching Server configured", ex.Message); }
public void QueryGeneration_BothHaveWHEREContainerAndParameters() { CreateParameters("'bob'", "'fish'"); var global = new AnyTableSqlParameter(CatalogueRepository, cic, "DECLARE @bob AS varchar(50);"); global.Value = "'zomber'"; global.SaveToDatabase(); try { ((IDeleteable)parama1).DeleteInDatabase(); var csqb = new CohortSummaryQueryBuilder(acDataset, acCohort); var builder = csqb.GetAdjustedAggregateBuilder(CohortSummaryAdjustment.WhereRecordsIn); Assert.AreEqual(CollapseWhitespace(@"DECLARE @bob AS varchar(50); SET @bob='zomber'; /*Agg2_Dataset*/ SELECT Year, count(*) AS MyCount FROM MyTable WHERE ( ( /*Filter2*/ @bob = 'fish' ) AND ( /*Filter1*/ @bob = 'bob' ) ) group by Year order by Year"), CollapseWhitespace(builder.SQL)); } finally { global.DeleteInDatabase(); DestroyParameters(); } }
public void QueryGeneration_NoCohortWhereLogic() { var csqb = new CohortSummaryQueryBuilder(acDataset, acCohort); var builder = csqb.GetAdjustedAggregateBuilder(CohortSummaryAdjustment.WhereRecordsIn); Assert.AreEqual(@"/*Agg2_Dataset*/ SELECT Year, count(*) AS MyCount FROM MyTable group by Year order by Year", builder.SQL); }
public void QueryGeneration_Parameters_DifferentValues_WHERECHIIN() { CreateParameters("'bob'", "'fish'"); try { var csqb = new CohortSummaryQueryBuilder(acDataset, acCohort); var ex = Assert.Throws <NotSupportedException>(() => csqb.GetAdjustedAggregateBuilder(CohortSummaryAdjustment.WhereExtractionIdentifiersIn)); Assert.AreEqual("No Query Caching Server configured", ex.Message); } finally { DestroyParameters(); } }