use of org.kie.server.api.model.definition.QueryParam in project droolsjbpm-integration by kiegroup.
the class ProcessInstanceQueryFilterSpecBuilderTest method testGetEqualsToAndBetween.
@Test
public void testGetEqualsToAndBetween() {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Date from = null;
Date to = null;
try {
from = sdf.parse("2017-05-10");
to = sdf.parse("2017-05-14");
} catch (ParseException e) {
e.printStackTrace();
}
ProcessInstanceQueryFilterSpec filterSpec = new ProcessInstanceQueryFilterSpecBuilder().equalsTo(ProcessInstanceField.PROCESSID, "test-process").between(ProcessInstanceField.START_DATE, from, to).get();
QueryParam[] params = filterSpec.getParameters();
assertEquals(2, params.length);
QueryParam paramEqualsTo = params[0];
assertEquals(ProcessInstanceField.PROCESSID.toString(), paramEqualsTo.getColumn());
assertEquals("EQUALS_TO", paramEqualsTo.getOperator());
assertEquals("test-process", paramEqualsTo.getValue().stream().findFirst().get());
QueryParam paramBetween = params[1];
assertEquals(ProcessInstanceField.START_DATE.toString(), paramBetween.getColumn());
assertEquals("BETWEEN", paramBetween.getOperator());
List<?> values = paramBetween.getValue();
assertEquals(2, values.size());
assertEquals(from, values.get(0));
assertEquals(to, values.get(1));
}
use of org.kie.server.api.model.definition.QueryParam in project droolsjbpm-integration by kiegroup.
the class TaskQueryFilterSpecBuilderTest method testGetEqualsTo.
@Test
public void testGetEqualsTo() {
TaskQueryFilterSpec filterSpec = new TaskQueryFilterSpecBuilder().equalsTo(TaskField.PROCESSID, "test-process").get();
QueryParam[] params = filterSpec.getParameters();
assertEquals(1, params.length);
QueryParam param = params[0];
assertEquals(TaskField.PROCESSID.toString(), param.getColumn());
assertEquals("EQUALS_TO", param.getOperator());
assertEquals("test-process", param.getValue().stream().findFirst().get());
}
use of org.kie.server.api.model.definition.QueryParam in project droolsjbpm-integration by kiegroup.
the class TaskQueryFilterSpecBuilderTest method testGetEqualsToAndBetween.
@Test
public void testGetEqualsToAndBetween() {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Date from = null;
Date to = null;
try {
from = sdf.parse("2017-05-10");
to = sdf.parse("2017-05-14");
} catch (ParseException e) {
e.printStackTrace();
}
TaskQueryFilterSpec filterSpec = new TaskQueryFilterSpecBuilder().equalsTo(TaskField.PROCESSID, "test-process").between(TaskField.CREATEDON, from, to).get();
QueryParam[] params = filterSpec.getParameters();
assertEquals(2, params.length);
QueryParam paramEqualsTo = params[0];
assertEquals(TaskField.PROCESSID.toString(), paramEqualsTo.getColumn());
assertEquals("EQUALS_TO", paramEqualsTo.getOperator());
assertEquals("test-process", paramEqualsTo.getValue().stream().findFirst().get());
QueryParam paramBetween = params[1];
assertEquals(TaskField.CREATEDON.toString(), paramBetween.getColumn());
assertEquals("BETWEEN", paramBetween.getOperator());
List<?> values = paramBetween.getValue();
assertEquals(2, values.size());
assertEquals(from, values.get(0));
assertEquals(to, values.get(1));
}
use of org.kie.server.api.model.definition.QueryParam in project droolsjbpm-integration by kiegroup.
the class TaskQueryFilterSpecBuilderTest method testGetBetween.
@Test
public void testGetBetween() {
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
Date from = null;
Date to = null;
try {
from = sdf.parse("2017-05-10");
to = sdf.parse("2017-05-14");
} catch (ParseException e) {
e.printStackTrace();
}
TaskQueryFilterSpec filterSpec = new TaskQueryFilterSpecBuilder().between(TaskField.CREATEDON, from, to).get();
QueryParam[] params = filterSpec.getParameters();
assertEquals(1, params.length);
QueryParam param = params[0];
assertEquals(TaskField.CREATEDON.toString(), param.getColumn());
assertEquals("BETWEEN", param.getOperator());
List<?> values = param.getValue();
assertEquals(2, values.size());
assertEquals(from, values.get(0));
assertEquals(to, values.get(1));
}
use of org.kie.server.api.model.definition.QueryParam in project droolsjbpm-integration by kiegroup.
the class QueryDataServiceIntegrationTest method testQueryDataServiceUsingComplexCustomQueryBuilderFilterSpecWithOrderByClause.
@Test
public void testQueryDataServiceUsingComplexCustomQueryBuilderFilterSpecWithOrderByClause() throws Exception {
Map<String, Object> parameters = new HashMap<String, Object>();
parameters.put("stringData", "waiting for signal");
parameters.put("personData", createPersonInstance(USER_JOHN));
List<Long> processInstanceIds = createProcessInstances(parameters);
final QueryDefinition query = getProcessInstanceWithVariablesQueryDefinition();
try {
queryClient.registerQuery(query);
QueryParam expression = or(equalsTo("PROCESSINSTANCEID", processInstanceIds.get(0)), equalsTo("PROCESSINSTANCEID", processInstanceIds.get(1)));
QueryFilterSpec filterSpec = QueryFilterSpec.builder().where(expression).get();
List<ProcessInstance> instances = queryClient.query(query.getName(), QueryServicesClient.QUERY_MAP_PI_WITH_VARS, filterSpec, 0, 10, ProcessInstance.class);
assertNotNull(instances);
assertEquals(2, instances.size());
} finally {
abortProcessInstances(processInstanceIds);
queryClient.unregisterQuery(query.getName());
}
}
Aggregations