/** * The contents of this file are subject to the OpenMRS Public License * Version 1.0 (the "License"); you may not use this file except in * compliance with the License. You may obtain a copy of the License at * http://license.openmrs.org * * Software distributed under the License is distributed on an "AS IS" * basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the * License for the specific language governing rights and limitations * under the License. * * Copyright (C) OpenMRS, LLC. All Rights Reserved. */ package org.openmrs.module.reporting.query.encounter.evaluator; import org.apache.commons.logging.Log; import org.apache.commons.logging.LogFactory; import org.junit.Assert; import org.junit.Before; import org.junit.Test; import org.openmrs.Cohort; import org.openmrs.api.context.Context; import org.openmrs.module.reporting.common.TestUtil; import org.openmrs.module.reporting.evaluation.EvaluationContext; import org.openmrs.module.reporting.evaluation.context.EncounterEvaluationContext; import org.openmrs.module.reporting.query.encounter.EncounterQueryResult; import org.openmrs.module.reporting.query.encounter.definition.SqlEncounterQuery; import org.openmrs.module.reporting.query.encounter.service.EncounterQueryService; import org.openmrs.test.BaseModuleContextSensitiveTest; /** * Test the evaluation of the SqlEncounterQuery */ public class SqlEncounterQueryEvaluatorTest extends BaseModuleContextSensitiveTest { protected static Log log = LogFactory.getLog(SqlEncounterQueryEvaluatorTest.class); @Before public void setup() throws Exception { executeDataSet("org/openmrs/module/reporting/include/" + new TestUtil().getTestDatasetFilename("ReportTestDataset")); } @Test public void evaluate_shouldEvaluateASQLQueryIntoAnEncounterQuery() throws Exception { SqlEncounterQuery d = new SqlEncounterQuery(); d.setQuery("select encounter_id from encounter where location_id = 2"); EncounterQueryResult s = evaluate(d, new EvaluationContext()); Assert.assertEquals(8, s.getSize()); } @Test public void evaluate_shouldFilterResultsGivenABaseEncounterQueryInAnEvaluationContext() throws Exception { EncounterEvaluationContext context = new EncounterEvaluationContext(); EncounterQueryResult baseEncounterIds = new EncounterQueryResult(); baseEncounterIds.add(3, 4, 5, 6, 7, 8); context.setBaseEncounters(baseEncounterIds); SqlEncounterQuery d = new SqlEncounterQuery(); d.setQuery("select encounter_id from encounter where location_id = 2"); Assert.assertEquals(4, evaluate(d, context).getSize()); } @Test public void evaluate_shouldFilterResultsGivenABaseCohortInAnEvaluationContext() throws Exception { EncounterEvaluationContext context = new EncounterEvaluationContext(); EncounterQueryResult baseEncounterIds = new EncounterQueryResult(); baseEncounterIds.add(3, 4, 5, 6, 7, 8); context.setBaseEncounters(baseEncounterIds); Cohort baseCohort = new Cohort("20,21"); context.setBaseCohort(baseCohort); SqlEncounterQuery d = new SqlEncounterQuery(); d.setQuery("select encounter_id from encounter where location_id = 2"); Assert.assertEquals(3, evaluate(d, context).getSize()); } public EncounterQueryResult evaluate(SqlEncounterQuery definition, EvaluationContext context) throws Exception { return Context.getService(EncounterQueryService.class).evaluate(definition, context); } }