@Test public void querySortingDesc() { // exclude definitions without tenant id because of database-specific ordering List<DecisionRequirementsDefinition> DecisionRequirementsDefinitions = repositoryService .createDecisionRequirementsDefinitionQuery() .tenantIdIn(TENANT_ONE, TENANT_TWO) .orderByTenantId() .desc() .list(); assertThat(DecisionRequirementsDefinitions.size(), is(2)); assertThat(DecisionRequirementsDefinitions.get(0).getTenantId(), is(TENANT_TWO)); assertThat(DecisionRequirementsDefinitions.get(1).getTenantId(), is(TENANT_ONE)); }
@Test public void orderByDecisionRequirementsDefinitionCategory() { List<DecisionRequirementsDefinition> decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDecisionRequirementsDefinitionCategory().asc().list(); assertThat(decisionRequirementsDefinitions.size(), is(4)); assertThat(decisionRequirementsDefinitions.get(0).getCategory(), is("test-drd-1")); assertThat(decisionRequirementsDefinitions.get(1).getCategory(), is("test-drd-2")); assertThat(decisionRequirementsDefinitions.get(2).getCategory(), is("test-drd-2")); assertThat(decisionRequirementsDefinitions.get(3).getCategory(), is("xyz_")); decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDecisionRequirementsDefinitionCategory().desc().list(); assertThat(decisionRequirementsDefinitions.get(0).getCategory(), is("xyz_")); assertThat(decisionRequirementsDefinitions.get(1).getCategory(), is("test-drd-2")); assertThat(decisionRequirementsDefinitions.get(2).getCategory(), is("test-drd-2")); assertThat(decisionRequirementsDefinitions.get(3).getCategory(), is("test-drd-1")); }
@Test public void orderByDeploymentId() { List<DecisionRequirementsDefinition> decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDeploymentId().asc().list(); assertThat(decisionRequirementsDefinitions.size(), is(4)); assertThat(decisionRequirementsDefinitions.get(0).getDeploymentId(), is(firstDeploymentId)); assertThat(decisionRequirementsDefinitions.get(1).getDeploymentId(), is(firstDeploymentId)); assertThat(decisionRequirementsDefinitions.get(2).getDeploymentId(), is(secondDeploymentId)); assertThat(decisionRequirementsDefinitions.get(3).getDeploymentId(), is(thirdDeploymentId)); decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDeploymentId().desc().list(); assertThat(decisionRequirementsDefinitions.get(0).getDeploymentId(), is(thirdDeploymentId)); assertThat(decisionRequirementsDefinitions.get(1).getDeploymentId(), is(secondDeploymentId)); assertThat(decisionRequirementsDefinitions.get(2).getDeploymentId(), is(firstDeploymentId)); assertThat(decisionRequirementsDefinitions.get(3).getDeploymentId(), is(firstDeploymentId)); }
@Test public void orderByDecisionRequirementsDefinitionVersion() { List<DecisionRequirementsDefinition> decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDecisionRequirementsDefinitionVersion().asc().list(); assertThat(decisionRequirementsDefinitions.size(), is(4)); assertThat(decisionRequirementsDefinitions.get(0).getVersion(), is(1)); assertThat(decisionRequirementsDefinitions.get(1).getVersion(), is(1)); assertThat(decisionRequirementsDefinitions.get(2).getVersion(), is(1)); assertThat(decisionRequirementsDefinitions.get(3).getVersion(), is(2)); decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDecisionRequirementsDefinitionVersion().desc().list(); assertThat(decisionRequirementsDefinitions.get(0).getVersion(), is(2)); assertThat(decisionRequirementsDefinitions.get(1).getVersion(), is(1)); assertThat(decisionRequirementsDefinitions.get(2).getVersion(), is(1)); }
@Test public void orderByDecisionRequirementsDefinitionKey() { List<DecisionRequirementsDefinition> decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDecisionRequirementsDefinitionKey().asc().list(); assertThat(decisionRequirementsDefinitions.size(), is(4)); assertThat(decisionRequirementsDefinitions.get(0).getKey(), is("dish")); assertThat(decisionRequirementsDefinitions.get(1).getKey(), is("dish")); assertThat(decisionRequirementsDefinitions.get(2).getKey(), is("score")); assertThat(decisionRequirementsDefinitions.get(3).getKey(), is("xyz")); decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDecisionRequirementsDefinitionKey().desc().list(); assertThat(decisionRequirementsDefinitions.get(0).getKey(), is("xyz")); assertThat(decisionRequirementsDefinitions.get(1).getKey(), is("score")); assertThat(decisionRequirementsDefinitions.get(2).getKey(), is("dish")); assertThat(decisionRequirementsDefinitions.get(3).getKey(), is("dish")); }
@Test public void orderByDecisionRequirementsDefinitionName() { List<DecisionRequirementsDefinition> decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDecisionRequirementsDefinitionName().asc().list(); assertThat(decisionRequirementsDefinitions.size(), is(4)); assertThat(decisionRequirementsDefinitions.get(0).getName(), is("Dish")); assertThat(decisionRequirementsDefinitions.get(1).getName(), is("Dish")); assertThat(decisionRequirementsDefinitions.get(2).getName(), is("Score")); assertThat(decisionRequirementsDefinitions.get(3).getName(), is("Xyz")); decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDecisionRequirementsDefinitionName().desc().list(); assertThat(decisionRequirementsDefinitions.get(0).getName(), is("Xyz")); assertThat(decisionRequirementsDefinitions.get(1).getName(), is("Score")); assertThat(decisionRequirementsDefinitions.get(2).getName(), is("Dish")); assertThat(decisionRequirementsDefinitions.get(3).getName(), is("Dish")); }
executeAndVerifySorting("id", "desc", Status.OK); inOrder.verify(mockedQuery).orderByDecisionRequirementsDefinitionId(); inOrder.verify(mockedQuery).desc(); inOrder.verify(mockedQuery).desc(); inOrder.verify(mockedQuery).desc(); inOrder.verify(mockedQuery).desc(); inOrder.verify(mockedQuery).desc(); inOrder.verify(mockedQuery).desc(); inOrder.verify(mockedQuery).desc();
@Test public void orderByDecisionRequirementsDefinitionId() { List<DecisionRequirementsDefinition> decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDecisionRequirementsDefinitionId().asc().list(); assertThat(decisionRequirementsDefinitions.size(), is(4)); assertThat(decisionRequirementsDefinitions.get(0).getId(), startsWith("dish:1")); assertThat(decisionRequirementsDefinitions.get(1).getId(), startsWith("dish:2")); assertThat(decisionRequirementsDefinitions.get(2).getId(), startsWith("score:1")); assertThat(decisionRequirementsDefinitions.get(3).getId(), startsWith("xyz:1")); decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDecisionRequirementsDefinitionId().desc().list(); assertThat(decisionRequirementsDefinitions.get(0).getId(), startsWith("xyz:1")); assertThat(decisionRequirementsDefinitions.get(1).getId(), startsWith("score:1")); assertThat(decisionRequirementsDefinitions.get(2).getId(), startsWith("dish:2")); assertThat(decisionRequirementsDefinitions.get(3).getId(), startsWith("dish:1")); }
@Test public void querySortingDesc() { // exclude definitions without tenant id because of database-specific ordering List<DecisionRequirementsDefinition> DecisionRequirementsDefinitions = repositoryService .createDecisionRequirementsDefinitionQuery() .tenantIdIn(TENANT_ONE, TENANT_TWO) .orderByTenantId() .desc() .list(); assertThat(DecisionRequirementsDefinitions.size(), is(2)); assertThat(DecisionRequirementsDefinitions.get(0).getTenantId(), is(TENANT_TWO)); assertThat(DecisionRequirementsDefinitions.get(1).getTenantId(), is(TENANT_ONE)); }
@Test public void orderByDecisionRequirementsDefinitionName() { List<DecisionRequirementsDefinition> decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDecisionRequirementsDefinitionName().asc().list(); assertThat(decisionRequirementsDefinitions.size(), is(4)); assertThat(decisionRequirementsDefinitions.get(0).getName(), is("Dish")); assertThat(decisionRequirementsDefinitions.get(1).getName(), is("Dish")); assertThat(decisionRequirementsDefinitions.get(2).getName(), is("Score")); assertThat(decisionRequirementsDefinitions.get(3).getName(), is("Xyz")); decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDecisionRequirementsDefinitionName().desc().list(); assertThat(decisionRequirementsDefinitions.get(0).getName(), is("Xyz")); assertThat(decisionRequirementsDefinitions.get(1).getName(), is("Score")); assertThat(decisionRequirementsDefinitions.get(2).getName(), is("Dish")); assertThat(decisionRequirementsDefinitions.get(3).getName(), is("Dish")); }
@Test public void orderByDeploymentId() { List<DecisionRequirementsDefinition> decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDeploymentId().asc().list(); assertThat(decisionRequirementsDefinitions.size(), is(4)); assertThat(decisionRequirementsDefinitions.get(0).getDeploymentId(), is(firstDeploymentId)); assertThat(decisionRequirementsDefinitions.get(1).getDeploymentId(), is(firstDeploymentId)); assertThat(decisionRequirementsDefinitions.get(2).getDeploymentId(), is(secondDeploymentId)); assertThat(decisionRequirementsDefinitions.get(3).getDeploymentId(), is(thirdDeploymentId)); decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDeploymentId().desc().list(); assertThat(decisionRequirementsDefinitions.get(0).getDeploymentId(), is(thirdDeploymentId)); assertThat(decisionRequirementsDefinitions.get(1).getDeploymentId(), is(secondDeploymentId)); assertThat(decisionRequirementsDefinitions.get(2).getDeploymentId(), is(firstDeploymentId)); assertThat(decisionRequirementsDefinitions.get(3).getDeploymentId(), is(firstDeploymentId)); }
@Test public void orderByDecisionRequirementsDefinitionVersion() { List<DecisionRequirementsDefinition> decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDecisionRequirementsDefinitionVersion().asc().list(); assertThat(decisionRequirementsDefinitions.size(), is(4)); assertThat(decisionRequirementsDefinitions.get(0).getVersion(), is(1)); assertThat(decisionRequirementsDefinitions.get(1).getVersion(), is(1)); assertThat(decisionRequirementsDefinitions.get(2).getVersion(), is(1)); assertThat(decisionRequirementsDefinitions.get(3).getVersion(), is(2)); decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDecisionRequirementsDefinitionVersion().desc().list(); assertThat(decisionRequirementsDefinitions.get(0).getVersion(), is(2)); assertThat(decisionRequirementsDefinitions.get(1).getVersion(), is(1)); assertThat(decisionRequirementsDefinitions.get(2).getVersion(), is(1)); }
@Test public void orderByDecisionRequirementsDefinitionKey() { List<DecisionRequirementsDefinition> decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDecisionRequirementsDefinitionKey().asc().list(); assertThat(decisionRequirementsDefinitions.size(), is(4)); assertThat(decisionRequirementsDefinitions.get(0).getKey(), is("dish")); assertThat(decisionRequirementsDefinitions.get(1).getKey(), is("dish")); assertThat(decisionRequirementsDefinitions.get(2).getKey(), is("score")); assertThat(decisionRequirementsDefinitions.get(3).getKey(), is("xyz")); decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDecisionRequirementsDefinitionKey().desc().list(); assertThat(decisionRequirementsDefinitions.get(0).getKey(), is("xyz")); assertThat(decisionRequirementsDefinitions.get(1).getKey(), is("score")); assertThat(decisionRequirementsDefinitions.get(2).getKey(), is("dish")); assertThat(decisionRequirementsDefinitions.get(3).getKey(), is("dish")); }
@Test public void orderByDecisionRequirementsDefinitionCategory() { List<DecisionRequirementsDefinition> decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDecisionRequirementsDefinitionCategory().asc().list(); assertThat(decisionRequirementsDefinitions.size(), is(4)); assertThat(decisionRequirementsDefinitions.get(0).getCategory(), is("test-drd-1")); assertThat(decisionRequirementsDefinitions.get(1).getCategory(), is("test-drd-2")); assertThat(decisionRequirementsDefinitions.get(2).getCategory(), is("test-drd-2")); assertThat(decisionRequirementsDefinitions.get(3).getCategory(), is("xyz_")); decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDecisionRequirementsDefinitionCategory().desc().list(); assertThat(decisionRequirementsDefinitions.get(0).getCategory(), is("xyz_")); assertThat(decisionRequirementsDefinitions.get(1).getCategory(), is("test-drd-2")); assertThat(decisionRequirementsDefinitions.get(2).getCategory(), is("test-drd-2")); assertThat(decisionRequirementsDefinitions.get(3).getCategory(), is("test-drd-1")); }
@Test public void orderByDecisionRequirementsDefinitionId() { List<DecisionRequirementsDefinition> decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDecisionRequirementsDefinitionId().asc().list(); assertThat(decisionRequirementsDefinitions.size(), is(4)); assertThat(decisionRequirementsDefinitions.get(0).getId(), startsWith("dish:1")); assertThat(decisionRequirementsDefinitions.get(1).getId(), startsWith("dish:2")); assertThat(decisionRequirementsDefinitions.get(2).getId(), startsWith("score:1")); assertThat(decisionRequirementsDefinitions.get(3).getId(), startsWith("xyz:1")); decisionRequirementsDefinitions = repositoryService.createDecisionRequirementsDefinitionQuery() .orderByDecisionRequirementsDefinitionId().desc().list(); assertThat(decisionRequirementsDefinitions.get(0).getId(), startsWith("xyz:1")); assertThat(decisionRequirementsDefinitions.get(1).getId(), startsWith("score:1")); assertThat(decisionRequirementsDefinitions.get(2).getId(), startsWith("dish:2")); assertThat(decisionRequirementsDefinitions.get(3).getId(), startsWith("dish:1")); }