/* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package org.camunda.bpm.engine.test.api.filter;
import static org.hamcrest.Matchers.contains;
import static org.hamcrest.Matchers.equalTo;
import static org.hamcrest.beans.HasPropertyWithValue.hasProperty;
import java.util.ArrayList;
import java.util.Collections;
import java.util.List;
import org.camunda.bpm.engine.EntityTypes;
import org.camunda.bpm.engine.ProcessEngineException;
import org.camunda.bpm.engine.filter.Filter;
import org.camunda.bpm.engine.filter.FilterQuery;
import org.camunda.bpm.engine.impl.persistence.entity.FilterEntity;
import org.camunda.bpm.engine.impl.test.PluggableProcessEngineTestCase;
import org.junit.Assert;
/**
* @author Sebastian Menski
*/
public class FilterQueryTest extends PluggableProcessEngineTestCase {
protected List<String> filterIds = new ArrayList<String>();
public void setUp() {
saveFilter("b", "b");
saveFilter("d", "d");
saveFilter("a", "a");
saveFilter("c", "c");
}
protected void saveFilter(String name, String owner) {
Filter filter = filterService.newTaskFilter()
.setName(name)
.setOwner(owner);
filterService.saveFilter(filter);
filterIds.add(filter.getId());
}
public void tearDown() {
// delete all filters
for (Filter filter : filterService.createFilterQuery().list()) {
filterService.deleteFilter(filter.getId());
}
}
public void testQueryNoCriteria() {
FilterQuery query = filterService.createFilterQuery();
assertEquals(4, query.count());
assertEquals(4, query.list().size());
try {
query.singleResult();
fail("Exception expected");
}
catch (ProcessEngineException e) {
// expected
}
}
public void testQueryByFilterId() {
FilterQuery query = filterService.createFilterQuery().filterId(filterIds.get(0));
assertNotNull(query.singleResult());
assertEquals(1, query.list().size());
assertEquals(1, query.count());
}
public void testQueryByInvalidFilterId() {
FilterQuery query = filterService.createFilterQuery().filterId("invalid");
assertNull(query.singleResult());
assertEquals(0, query.list().size());
assertEquals(0, query.count());
try {
filterService.createFilterQuery().filterId(null);
fail("Exception expected");
}
catch (ProcessEngineException e) {
// expected
}
}
public void testQueryByResourceType() {
FilterQuery query = filterService.createFilterQuery().filterResourceType(EntityTypes.TASK);
try {
query.singleResult();
fail("Exception expected");
}
catch (ProcessEngineException e) {
// expected
}
assertEquals(4, query.list().size());
assertEquals(4, query.count());
}
public void testQueryByInvalidResourceType() {
FilterQuery query = filterService.createFilterQuery().filterResourceType("invalid");
assertNull(query.singleResult());
assertEquals(0, query.list().size());
assertEquals(0, query.count());
try {
filterService.createFilterQuery().filterResourceType(null);
fail("Exception expected");
}
catch (ProcessEngineException e) {
// expected
}
}
public void testQueryByName() {
FilterQuery query = filterService.createFilterQuery().filterName("a");
assertNotNull(query.singleResult());
assertEquals(1, query.list().size());
assertEquals(1, query.count());
}
public void testQueryByInvalidName() {
FilterQuery query = filterService.createFilterQuery().filterName("invalid");
assertNull(query.singleResult());
assertEquals(0, query.list().size());
assertEquals(0, query.count());
try {
filterService.createFilterQuery().filterName(null);
fail("Exception expected");
}
catch (ProcessEngineException e) {
// expected
}
}
public void testQueryByOwner() {
FilterQuery query = filterService.createFilterQuery().filterOwner("a");
assertNotNull(query.singleResult());
assertEquals(1, query.list().size());
assertEquals(1, query.count());
}
public void testQueryByInvalidOwner() {
FilterQuery query = filterService.createFilterQuery().filterOwner("invalid");
assertNull(query.singleResult());
assertEquals(0, query.list().size());
assertEquals(0, query.count());
try {
filterService.createFilterQuery().filterOwner(null);
fail("Exception expected");
}
catch (ProcessEngineException e) {
// expected
}
}
public void testQueryPaging() {
FilterQuery query = filterService.createFilterQuery();
assertEquals(4, query.listPage(0, Integer.MAX_VALUE).size());
// Verifying the un-paged results
assertEquals(4, query.count());
assertEquals(4, query.list().size());
// Verifying paged results
assertEquals(2, query.listPage(0, 2).size());
assertEquals(2, query.listPage(2, 2).size());
assertEquals(1, query.listPage(3, 1).size());
// Verifying odd usages
assertEquals(0, query.listPage(-1, -1).size());
assertEquals(0, query.listPage(4, 2).size()); // 4 is the last index with a result
assertEquals(4, query.listPage(0, 15).size()); // there are only 4 tasks
}
@SuppressWarnings("unchecked")
public void testQuerySorting() {
List<String> sortedIds = new ArrayList<String>(filterIds);
Collections.sort(sortedIds);
assertEquals(4, filterService.createFilterQuery().orderByFilterId().asc().list().size());
Assert.assertThat(filterService.createFilterQuery().orderByFilterId().asc().list(),
contains(hasProperty("id", equalTo(sortedIds.get(0))),
hasProperty("id", equalTo(sortedIds.get(1))),
hasProperty("id", equalTo(sortedIds.get(2))),
hasProperty("id", equalTo(sortedIds.get(3)))));
assertEquals(4, filterService.createFilterQuery().orderByFilterResourceType().asc().list().size());
Assert.assertThat(filterService.createFilterQuery().orderByFilterResourceType().asc().list(),
contains(hasProperty("resourceType", equalTo(EntityTypes.TASK)),
hasProperty("resourceType", equalTo(EntityTypes.TASK)),
hasProperty("resourceType", equalTo(EntityTypes.TASK)),
hasProperty("resourceType", equalTo(EntityTypes.TASK))));
assertEquals(4, filterService.createFilterQuery().orderByFilterName().asc().list().size());
Assert.assertThat(filterService.createFilterQuery().orderByFilterName().asc().list(),
contains(hasProperty("name", equalTo("a")),
hasProperty("name", equalTo("b")),
hasProperty("name", equalTo("c")),
hasProperty("name", equalTo("d"))));
assertEquals(4, filterService.createFilterQuery().orderByFilterOwner().asc().list().size());
Assert.assertThat(filterService.createFilterQuery().orderByFilterOwner().asc().list(),
contains(hasProperty("owner", equalTo("a")),
hasProperty("owner", equalTo("b")),
hasProperty("owner", equalTo("c")),
hasProperty("owner", equalTo("d"))));
assertEquals(4, filterService.createFilterQuery().orderByFilterId().desc().list().size());
Assert.assertThat(filterService.createFilterQuery().orderByFilterId().desc().list(),
contains(hasProperty("id", equalTo(sortedIds.get(3))),
hasProperty("id", equalTo(sortedIds.get(2))),
hasProperty("id", equalTo(sortedIds.get(1))),
hasProperty("id", equalTo(sortedIds.get(0)))));
assertEquals(4, filterService.createFilterQuery().orderByFilterResourceType().desc().list().size());
Assert.assertThat(filterService.createFilterQuery().orderByFilterResourceType().desc().list(),
contains(hasProperty("resourceType", equalTo(EntityTypes.TASK)),
hasProperty("resourceType", equalTo(EntityTypes.TASK)),
hasProperty("resourceType", equalTo(EntityTypes.TASK)),
hasProperty("resourceType", equalTo(EntityTypes.TASK))));
assertEquals(4, filterService.createFilterQuery().orderByFilterName().desc().list().size());
Assert.assertThat(filterService.createFilterQuery().orderByFilterName().desc().list(),
contains(hasProperty("name", equalTo("d")),
hasProperty("name", equalTo("c")),
hasProperty("name", equalTo("b")),
hasProperty("name", equalTo("a"))));
assertEquals(4, filterService.createFilterQuery().orderByFilterOwner().desc().list().size());
Assert.assertThat(filterService.createFilterQuery().orderByFilterOwner().desc().list(),
contains(hasProperty("name", equalTo("d")),
hasProperty("name", equalTo("c")),
hasProperty("name", equalTo("b")),
hasProperty("name", equalTo("a"))));
assertEquals(1, filterService.createFilterQuery().orderByFilterId().filterName("a").asc().list().size());
assertEquals(1, filterService.createFilterQuery().orderByFilterId().filterName("a").desc().list().size());
}
public void testNativeQuery() {
assertEquals("ACT_RU_FILTER", managementService.getTableName(Filter.class));
assertEquals("ACT_RU_FILTER", managementService.getTableName(FilterEntity.class));
assertEquals(4, taskService.createNativeTaskQuery().sql("SELECT * FROM " + managementService.getTableName(Filter.class)).list().size());
assertEquals(4, taskService.createNativeTaskQuery().sql("SELECT count(*) FROM " + managementService.getTableName(Filter.class)).count());
assertEquals(16, taskService.createNativeTaskQuery().sql("SELECT count(*) FROM ACT_RU_FILTER F1, ACT_RU_FILTER F2").count());
// select with distinct
assertEquals(4, taskService.createNativeTaskQuery().sql("SELECT F1.* FROM ACT_RU_FILTER F1").list().size());
assertEquals(1, taskService.createNativeTaskQuery().sql("SELECT count(*) FROM " + managementService.getTableName(Filter.class) + " F WHERE F.NAME_ = 'a'").count());
assertEquals(1, taskService.createNativeTaskQuery().sql("SELECT * FROM " + managementService.getTableName(Filter.class) + " F WHERE F.NAME_ = 'a'").list().size());
// use parameters
assertEquals(1, taskService.createNativeTaskQuery().sql("SELECT count(*) FROM " + managementService.getTableName(Filter.class) + " F WHERE F.NAME_ = #{filterName}").parameter("filterName", "a").count());
}
public void testNativeQueryPaging() {
assertEquals("ACT_RU_FILTER", managementService.getTableName(Filter.class));
assertEquals("ACT_RU_FILTER", managementService.getTableName(FilterEntity.class));
assertEquals(3, taskService.createNativeTaskQuery().sql("SELECT * FROM " + managementService.getTableName(Filter.class)).listPage(0, 3).size());
assertEquals(2, taskService.createNativeTaskQuery().sql("SELECT * FROM " + managementService.getTableName(Filter.class)).listPage(2, 2).size());
}
}