public void testQuerySortingDesc() { // exclude historic case instances without tenant id because of database-specific ordering List<HistoricCaseInstance> historicCaseInstances = historyService.createHistoricCaseInstanceQuery() .tenantIdIn(TENANT_ONE, TENANT_TWO) .orderByTenantId() .desc() .list(); assertThat(historicCaseInstances.size(), is(2)); assertThat(historicCaseInstances.get(0).getTenantId(), is(TENANT_TWO)); assertThat(historicCaseInstances.get(1).getTenantId(), is(TENANT_ONE)); }
executeAndVerifySorting("instanceId", "desc", Status.OK); inOrder.verify(mockedQuery).orderByCaseInstanceId(); inOrder.verify(mockedQuery).desc(); executeAndVerifySorting("definitionId", "desc", Status.OK); inOrder.verify(mockedQuery).orderByCaseDefinitionId(); inOrder.verify(mockedQuery).desc(); executeAndVerifySorting("businessKey", "desc", Status.OK); inOrder.verify(mockedQuery).orderByCaseInstanceBusinessKey(); inOrder.verify(mockedQuery).desc(); executeAndVerifySorting("createTime", "desc", Status.OK); inOrder.verify(mockedQuery).orderByCaseInstanceCreateTime(); inOrder.verify(mockedQuery).desc(); executeAndVerifySorting("closeTime", "desc", Status.OK); inOrder.verify(mockedQuery).orderByCaseInstanceCloseTime(); inOrder.verify(mockedQuery).desc(); executeAndVerifySorting("duration", "desc", Status.OK); inOrder.verify(mockedQuery).orderByCaseInstanceDuration(); inOrder.verify(mockedQuery).desc(); executeAndVerifySorting("tenantId", "desc", Status.OK); inOrder.verify(mockedQuery).orderByTenantId(); inOrder.verify(mockedQuery).desc();
@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(); }
)); instances = historicQuery().orderByCaseInstanceId().desc().list(); assertEquals(2, instances.size()); assertThat(instances, contains( )); instances = historicQuery().orderByCaseDefinitionId().desc().list(); assertEquals(2, instances.size()); assertThat(instances, contains( instances = historicQuery().orderByCaseInstanceBusinessKey().desc().list(); assertEquals(2, instances.size()); assertThat(instances, contains( instances = historicQuery().orderByCaseInstanceCreateTime().desc().list(); assertEquals(2, instances.size()); assertThat(instances, contains( instances = historicQuery().orderByCaseInstanceCloseTime().desc().list(); assertEquals(2, instances.size()); assertThat(instances, contains( instances = historicQuery().orderByCaseInstanceDuration().desc().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 testQuerySortingDesc() { // exclude historic case instances without tenant id because of database-specific ordering List<HistoricCaseInstance> historicCaseInstances = historyService.createHistoricCaseInstanceQuery() .tenantIdIn(TENANT_ONE, TENANT_TWO) .orderByTenantId() .desc() .list(); assertThat(historicCaseInstances.size(), is(2)); assertThat(historicCaseInstances.get(0).getTenantId(), is(TENANT_TWO)); assertThat(historicCaseInstances.get(1).getTenantId(), is(TENANT_ONE)); }
)); instances = historicQuery().orderByCaseInstanceId().desc().list(); assertEquals(2, instances.size()); assertThat(instances, contains( )); instances = historicQuery().orderByCaseDefinitionId().desc().list(); assertEquals(2, instances.size()); assertThat(instances, contains( instances = historicQuery().orderByCaseInstanceBusinessKey().desc().list(); assertEquals(2, instances.size()); assertThat(instances, contains( instances = historicQuery().orderByCaseInstanceCreateTime().desc().list(); assertEquals(2, instances.size()); assertThat(instances, contains( instances = historicQuery().orderByCaseInstanceCloseTime().desc().list(); assertEquals(2, instances.size()); assertThat(instances, contains( instances = historicQuery().orderByCaseInstanceDuration().desc().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 } }