Example 6 with IN
use of org.hisp.dhis.common.QueryOperator.IN in project dhis2-core by dhis2.
the class EventsAnalyticsManagerTest method verifyGetEventsWithMissingValueAndNumericValuesInFilter.
@Test
void verifyGetEventsWithMissingValueAndNumericValuesInFilter() {
String numericValues = String.join(OPTION_SEP, "10", "11", "12");
String expected = "(ax.\"fWIAEtYVEGk\" in (" + String.join(",", numericValues.split(OPTION_SEP)) + ") or ax.\"fWIAEtYVEGk\" is null )";
testIt(IN, numericValues + OPTION_SEP + NV, Collections.singleton((capturedSql) -> assertThat(capturedSql, containsString(expected))));
}
Also used :
CoreMatchers.is(org.hamcrest.CoreMatchers.is)
ListGrid(org.hisp.dhis.system.grid.ListGrid)
BeforeEach(org.junit.jupiter.api.BeforeEach)
ValueType(org.hisp.dhis.common.ValueType)
DataType(org.hisp.dhis.analytics.DataType)
ExtendWith(org.junit.jupiter.api.extension.ExtendWith)
DhisConvenienceTest.createProgramIndicator(org.hisp.dhis.DhisConvenienceTest.createProgramIndicator)
DhisConvenienceTest.createProgram(org.hisp.dhis.DhisConvenienceTest.createProgram)
Period(org.hisp.dhis.period.Period)
MockitoExtension(org.mockito.junit.jupiter.MockitoExtension)
CoreMatchers.containsString(org.hamcrest.CoreMatchers.containsString)
EventQueryParams(org.hisp.dhis.analytics.event.EventQueryParams)
PERIOD_DIM_ID(org.hisp.dhis.common.DimensionalObject.PERIOD_DIM_ID)
Collection(java.util.Collection)
DimensionType(org.hisp.dhis.common.DimensionType)
Test(org.junit.jupiter.api.Test)
DhisConvenienceTest.createOrganisationUnit(org.hisp.dhis.DhisConvenienceTest.createOrganisationUnit)
NV(org.hisp.dhis.analytics.QueryKey.NV)
DhisConvenienceTest.createDataElement(org.hisp.dhis.DhisConvenienceTest.createDataElement)
DataQueryParams(org.hisp.dhis.analytics.DataQueryParams)
ProgramType(org.hisp.dhis.program.ProgramType)
QueryFilter(org.hisp.dhis.common.QueryFilter)
ProgramIndicator(org.hisp.dhis.program.ProgramIndicator)
ProgramIndicatorService(org.hisp.dhis.program.ProgramIndicatorService)
Mockito.mock(org.mockito.Mockito.mock)
Strictness(org.mockito.quality.Strictness)
ORGUNIT_DIM_ID(org.hisp.dhis.common.DimensionalObject.ORGUNIT_DIM_ID)
QueryItem(org.hisp.dhis.common.QueryItem)
MockitoSettings(org.mockito.junit.jupiter.MockitoSettings)
Mock(org.mockito.Mock)
CoreMatchers.not(org.hamcrest.CoreMatchers.not)
PostgreSQLStatementBuilder(org.hisp.dhis.jdbc.statementbuilder.PostgreSQLStatementBuilder)
Captor(org.mockito.Captor)
Program(org.hisp.dhis.program.Program)
JdbcTemplate(org.springframework.jdbc.core.JdbcTemplate)
DataElement(org.hisp.dhis.dataelement.DataElement)
NE(org.hisp.dhis.common.QueryOperator.NE)
ArgumentCaptor(org.mockito.ArgumentCaptor)
QuarterlyPeriodType(org.hisp.dhis.period.QuarterlyPeriodType)
ImmutableList(com.google.common.collect.ImmutableList)
DefaultProgramIndicatorSubqueryBuilder(org.hisp.dhis.analytics.event.data.programindicator.DefaultProgramIndicatorSubqueryBuilder)
GridHeader(org.hisp.dhis.common.GridHeader)
AnalyticsAggregationType(org.hisp.dhis.analytics.AnalyticsAggregationType)
DATA_X_DIM_ID(org.hisp.dhis.common.DimensionalObject.DATA_X_DIM_ID)
DimensionalObjectUtils.getList(org.hisp.dhis.common.DimensionalObjectUtils.getList)
Matchers.hasSize(org.hamcrest.Matchers.hasSize)
MatcherAssert.assertThat(org.hamcrest.MatcherAssert.assertThat)
IN(org.hisp.dhis.common.QueryOperator.IN)
ExecutionPlanStore(org.hisp.dhis.analytics.analyze.ExecutionPlanStore)
EQ(org.hisp.dhis.common.QueryOperator.EQ)
QueryOperator(org.hisp.dhis.common.QueryOperator)
AggregationType(org.hisp.dhis.analytics.AggregationType)
OPTION_SEP(org.hisp.dhis.common.DimensionalObject.OPTION_SEP)
Mockito.when(org.mockito.Mockito.when)
StatementBuilder(org.hisp.dhis.jdbc.StatementBuilder)
BaseDimensionalObject(org.hisp.dhis.common.BaseDimensionalObject)
Grid(org.hisp.dhis.common.Grid)
Mockito.verify(org.mockito.Mockito.verify)
Consumer(java.util.function.Consumer)
OrganisationUnit(org.hisp.dhis.organisationunit.OrganisationUnit)
PeriodType(org.hisp.dhis.period.PeriodType)
Collections(java.util.Collections)
ArgumentMatchers.anyString(org.mockito.ArgumentMatchers.anyString)
CoreMatchers.containsString(org.hamcrest.CoreMatchers.containsString)
ArgumentMatchers.anyString(org.mockito.ArgumentMatchers.anyString)
Test(org.junit.jupiter.api.Test)
Aggregations
ImmutableList (com.google.common.collect.ImmutableList)6
Collection (java.util.Collection)6
Collections (java.util.Collections)6
Consumer (java.util.function.Consumer)6
CoreMatchers.containsString (org.hamcrest.CoreMatchers.containsString)6
CoreMatchers.is (org.hamcrest.CoreMatchers.is)6
CoreMatchers.not (org.hamcrest.CoreMatchers.not)6
MatcherAssert.assertThat (org.hamcrest.MatcherAssert.assertThat)6
DhisConvenienceTest.createProgram (org.hisp.dhis.DhisConvenienceTest.createProgram)6
DhisConvenienceTest.createProgramIndicator (org.hisp.dhis.DhisConvenienceTest.createProgramIndicator)6
NV (org.hisp.dhis.analytics.QueryKey.NV)6
ExecutionPlanStore (org.hisp.dhis.analytics.analyze.ExecutionPlanStore)6
EventQueryParams (org.hisp.dhis.analytics.event.EventQueryParams)6
DefaultProgramIndicatorSubqueryBuilder (org.hisp.dhis.analytics.event.data.programindicator.DefaultProgramIndicatorSubqueryBuilder)6
OPTION_SEP (org.hisp.dhis.common.DimensionalObject.OPTION_SEP)6
QueryItem (org.hisp.dhis.common.QueryItem)6
QueryOperator (org.hisp.dhis.common.QueryOperator)6
EQ (org.hisp.dhis.common.QueryOperator.EQ)6
IN (org.hisp.dhis.common.QueryOperator.IN)6
NE (org.hisp.dhis.common.QueryOperator.NE)6
