public void testQuerySortingAsc() { // exclude historic case instances without tenant id because of database-specific ordering List<HistoricCaseInstance> historicCaseInstances = historyService.createHistoricCaseInstanceQuery() .tenantIdIn(TENANT_ONE, TENANT_TWO) .orderByTenantId() .asc() .list(); assertThat(historicCaseInstances.size(), is(2)); assertThat(historicCaseInstances.get(0).getTenantId(), is(TENANT_ONE)); assertThat(historicCaseInstances.get(1).getTenantId(), is(TENANT_TWO)); }
executeAndVerifySorting("instanceId", "asc", Status.OK); inOrder.verify(mockedQuery).orderByCaseInstanceId(); inOrder.verify(mockedQuery).asc(); executeAndVerifySorting("definitionId", "asc", Status.OK); inOrder.verify(mockedQuery).orderByCaseDefinitionId(); inOrder.verify(mockedQuery).asc(); executeAndVerifySorting("businessKey", "asc", Status.OK); inOrder.verify(mockedQuery).orderByCaseInstanceBusinessKey(); inOrder.verify(mockedQuery).asc(); executeAndVerifySorting("createTime", "asc", Status.OK); inOrder.verify(mockedQuery).orderByCaseInstanceCreateTime(); inOrder.verify(mockedQuery).asc(); executeAndVerifySorting("closeTime", "asc", Status.OK); inOrder.verify(mockedQuery).orderByCaseInstanceCloseTime(); inOrder.verify(mockedQuery).asc(); executeAndVerifySorting("duration", "asc", Status.OK); inOrder.verify(mockedQuery).orderByCaseInstanceDuration(); inOrder.verify(mockedQuery).asc(); executeAndVerifySorting("tenantId", "asc", Status.OK); inOrder.verify(mockedQuery).orderByTenantId(); inOrder.verify(mockedQuery).asc();
@Test public void testSecondarySortingAsPost() { InOrder inOrder = Mockito.inOrder(mockedQuery); Map<String, Object> json = new HashMap<String, Object>(); json.put("sorting", OrderingBuilder.create() .orderBy("businessKey").desc() .orderBy("closeTime").asc() .getJson()); given().contentType(POST_JSON_CONTENT_TYPE).body(json) .header("accept", MediaType.APPLICATION_JSON) .then().expect().statusCode(Status.OK.getStatusCode()) .when().post(HISTORIC_CASE_INSTANCE_RESOURCE_URL); inOrder.verify(mockedQuery).orderByCaseInstanceBusinessKey(); inOrder.verify(mockedQuery).desc(); inOrder.verify(mockedQuery).orderByCaseInstanceCloseTime(); inOrder.verify(mockedQuery).asc(); }
Collections.sort(sortedList); List<HistoricCaseInstance> instances = historicQuery().orderByCaseInstanceId().asc().list(); assertEquals(2, instances.size()); assertThat(instances, contains( Collections.sort(sortedList); instances = historicQuery().orderByCaseDefinitionId().asc().list(); assertEquals(2, instances.size()); assertThat(instances, contains( instances = historicQuery().orderByCaseInstanceBusinessKey().asc().list(); assertEquals(2, instances.size()); assertThat(instances, contains( instances = historicQuery().orderByCaseInstanceCreateTime().asc().list(); assertEquals(2, instances.size()); assertThat(instances, contains( instances = historicQuery().orderByCaseInstanceCloseTime().asc().list(); assertEquals(2, instances.size()); assertThat(instances, contains( instances = historicQuery().orderByCaseInstanceDuration().asc().list(); assertEquals(2, instances.size()); assertThat(instances, contains(
public void testInvalidSorting() { try { historicQuery().asc(); fail("Exception expected"); } catch (ProcessEngineException e) { // expected } try { historicQuery().desc(); fail("Exception expected"); } catch (ProcessEngineException e) { // expected } try { historicQuery().orderByCaseInstanceId().count(); fail("Exception expected"); } catch (ProcessEngineException e) { // expected } }
public void testQuerySortingAsc() { // exclude historic case instances without tenant id because of database-specific ordering List<HistoricCaseInstance> historicCaseInstances = historyService.createHistoricCaseInstanceQuery() .tenantIdIn(TENANT_ONE, TENANT_TWO) .orderByTenantId() .asc() .list(); assertThat(historicCaseInstances.size(), is(2)); assertThat(historicCaseInstances.get(0).getTenantId(), is(TENANT_ONE)); assertThat(historicCaseInstances.get(1).getTenantId(), is(TENANT_TWO)); }
Collections.sort(sortedList); List<HistoricCaseInstance> instances = historicQuery().orderByCaseInstanceId().asc().list(); assertEquals(2, instances.size()); assertThat(instances, contains( Collections.sort(sortedList); instances = historicQuery().orderByCaseDefinitionId().asc().list(); assertEquals(2, instances.size()); assertThat(instances, contains( instances = historicQuery().orderByCaseInstanceBusinessKey().asc().list(); assertEquals(2, instances.size()); assertThat(instances, contains( instances = historicQuery().orderByCaseInstanceCreateTime().asc().list(); assertEquals(2, instances.size()); assertThat(instances, contains( instances = historicQuery().orderByCaseInstanceCloseTime().asc().list(); assertEquals(2, instances.size()); assertThat(instances, contains( instances = historicQuery().orderByCaseInstanceDuration().asc().list(); assertEquals(2, instances.size()); assertThat(instances, contains(
public void testInvalidSorting() { try { historicQuery().asc(); fail("Exception expected"); } catch (ProcessEngineException e) { // expected } try { historicQuery().desc(); fail("Exception expected"); } catch (ProcessEngineException e) { // expected } try { historicQuery().orderByCaseInstanceId().count(); fail("Exception expected"); } catch (ProcessEngineException e) { // expected } }