use of org.hisp.dhis.common.QueryOperator.EQ in project dhis2-core by dhis2.
the class EventsAnalyticsManagerTest method verifyGetEventsWithMissingValueEqFilter.
@Test
void verifyGetEventsWithMissingValueEqFilter() {
String expected = "ax.\"fWIAEtYVEGk\" is null";
testIt(EQ, NV, Collections.singleton((capturedSql) -> assertThat(capturedSql, containsString(expected))));
}
use of org.hisp.dhis.common.QueryOperator.EQ in project dhis2-core by dhis2.
the class EnrollmentAnalyticsManagerTest method verifyGetEnrollmentsWithMissingValueEqFilter.
@Test
void verifyGetEnrollmentsWithMissingValueEqFilter() {
String subSelect = "(select \"fWIAEtYVEGk\" from analytics_event_" + programA.getUid() + " where analytics_event_" + programA.getUid() + ".pi = ax.pi and \"fWIAEtYVEGk\" is not null and ps = '" + programStage.getUid() + "' order by executiondate desc limit 1 )";
String expected = subSelect + " is null";
testIt(EQ, NV, Collections.singleton((capturedSql) -> assertThat(capturedSql, containsString(expected))));
}
Aggregations