public void testGetTableNameAsCamundaAdmin() { // given identityService.setAuthentication(userId, Collections.singletonList(Groups.CAMUNDA_ADMIN)); String tablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); // when String tableName = managementService.getTableName(ProcessDefinitionEntity.class); // then assertEquals(tablePrefix + "ACT_RE_PROCDEF", tableName); }
String databaseTablePrefix = commandContext.getProcessEngineConfiguration().getDatabaseTablePrefix().trim();
public void testTableCount() { Map<String, Long> tableCount = managementService.getTableCount(); String tablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); //commenting out this assertion as there is no much sense to check the quantity of records, not the presence/absence of specific ones //when additional row was added within CAM-7539, the test started failing when testing old engine (7.6) with new database (7.7) //assertEquals(new Long(5), tableCount.get(tablePrefix + "ACT_GE_PROPERTY")); assertEquals(new Long(0), tableCount.get(tablePrefix + "ACT_GE_BYTEARRAY")); assertEquals(new Long(0), tableCount.get(tablePrefix + "ACT_RE_DEPLOYMENT")); assertEquals(new Long(0), tableCount.get(tablePrefix + "ACT_RU_EXECUTION")); assertEquals(new Long(0), tableCount.get(tablePrefix + "ACT_ID_GROUP")); assertEquals(new Long(0), tableCount.get(tablePrefix + "ACT_ID_MEMBERSHIP")); assertEquals(new Long(0), tableCount.get(tablePrefix + "ACT_ID_USER")); assertEquals(new Long(0), tableCount.get(tablePrefix + "ACT_RE_PROCDEF")); assertEquals(new Long(0), tableCount.get(tablePrefix + "ACT_RU_TASK")); assertEquals(new Long(0), tableCount.get(tablePrefix + "ACT_RU_IDENTITYLINK")); }
public void testTableNames() { String tablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); assertThat(managementService.getTableName(HistoricDecisionInstance.class), is(tablePrefix +"ACT_HI_DECINST")); assertThat(managementService.getTableName(HistoricDecisionInstanceEntity.class), is(tablePrefix + "ACT_HI_DECINST")); }
@Before public void setUp() throws Exception { processEngineConfiguration = engineRule.getProcessEngineConfiguration(); processEngineConfiguration.setDbMetricsReporterActivate(true); databaseTablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); }
@Deployment(resources = { DECISION_PROCESS, DECISION_SINGLE_OUTPUT_DMN }) public void testNativeQueryPaging() { startProcessInstanceAndEvaluateDecision(); startProcessInstanceAndEvaluateDecision(); String tablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); NativeHistoricDecisionInstanceQuery nativeQuery = historyService.createNativeHistoricDecisionInstanceQuery() .sql("SELECT * FROM " + tablePrefix + "ACT_HI_DECINST"); assertThat(nativeQuery.listPage(0, 2).size(), is(2)); assertThat(nativeQuery.listPage(1, 1).size(), is(1)); }
public void testTablePageQueryAsCamundaAdmin() { // given identityService.setAuthentication(userId, Collections.singletonList(Groups.CAMUNDA_ADMIN)); String tablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); // when TablePage page = managementService.createTablePageQuery().tableName(tablePrefix + "ACT_RE_PROCDEF").listPage(0, Integer.MAX_VALUE); // then assertNotNull(page); }
@Deployment(resources = { DECISION_PROCESS, DECISION_SINGLE_OUTPUT_DMN }) public void testNativeCountQuery() { startProcessInstanceAndEvaluateDecision(); String tablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); NativeHistoricDecisionInstanceQuery nativeQuery = historyService .createNativeHistoricDecisionInstanceQuery().sql("SELECT count(*) FROM " + tablePrefix + "ACT_HI_DECINST"); assertThat(nativeQuery.count(), is(1L)); }
@Deployment(resources = { DECISION_PROCESS, DECISION_SINGLE_OUTPUT_DMN }) public void testNativeQuery() { startProcessInstanceAndEvaluateDecision(); String tablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); NativeHistoricDecisionInstanceQuery nativeQuery = historyService .createNativeHistoricDecisionInstanceQuery().sql("SELECT * FROM " + tablePrefix + "ACT_HI_DECINST"); assertThat(nativeQuery.list().size(), is(1)); NativeHistoricDecisionInstanceQuery nativeQueryWithParameter = historyService .createNativeHistoricDecisionInstanceQuery() .sql("SELECT * FROM " + tablePrefix + "ACT_HI_DECINST H WHERE H.DEC_DEF_KEY_ = #{decisionDefinitionKey}"); assertThat(nativeQueryWithParameter.parameter("decisionDefinitionKey", DECISION_DEFINITION_KEY).list().size(), is(1)); assertThat(nativeQueryWithParameter.parameter("decisionDefinitionKey", "other decision").list().size(), is(0)); }
public void testNativeQueryPaging() { String tablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); assertEquals(tablePrefix + "ACT_RU_FILTER", managementService.getTableName(Filter.class)); assertEquals(tablePrefix + "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()); }
public void testNativeQueryPaging() { String tablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); assertEquals(tablePrefix + "ACT_RU_TASK", managementService.getTableName(Task.class)); assertEquals(tablePrefix + "ACT_RU_TASK", managementService.getTableName(TaskEntity.class)); assertEquals(5, taskService.createNativeTaskQuery().sql("SELECT * FROM " + managementService.getTableName(Task.class)).listPage(0, 5).size()); assertEquals(2, taskService.createNativeTaskQuery().sql("SELECT * FROM " + managementService.getTableName(Task.class)).listPage(10, 12).size()); }
public void testNativeQuery() { String tablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); // just test that the query will be constructed and executed, details are tested in the TaskQueryTest assertEquals(tablePrefix + "ACT_ID_USER", managementService.getTableName(UserEntity.class)); long userCount = identityService.createUserQuery().count(); assertEquals(userCount, identityService.createNativeUserQuery().sql("SELECT * FROM " + managementService.getTableName(UserEntity.class)).list().size()); assertEquals(userCount, identityService.createNativeUserQuery().sql("SELECT count(*) FROM " + managementService.getTableName(UserEntity.class)).count()); }
public void testNativeQuery() { String tablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); // just test that the query will be constructed and executed, details are tested in the TaskQueryTest assertEquals(tablePrefix + "ACT_RU_EXECUTION", managementService.getTableName(Execution.class)); long executionCount = runtimeService.createExecutionQuery().count(); assertEquals(executionCount, runtimeService.createNativeExecutionQuery().sql("SELECT * FROM " + managementService.getTableName(Execution.class)).list().size()); assertEquals(executionCount, runtimeService.createNativeExecutionQuery().sql("SELECT count(*) FROM " + managementService.getTableName(Execution.class)).count()); }
@Test public void testNativeQuery() { String tablePrefix = engineRule.getProcessEngineConfiguration().getDatabaseTablePrefix(); // just test that the query will be constructed and executed, details are tested in the TaskQueryTest assertEquals(tablePrefix + "ACT_RU_EXECUTION", managementService.getTableName(ProcessInstance.class)); long piCount = runtimeService.createProcessInstanceQuery().count(); assertEquals(piCount, runtimeService.createNativeProcessInstanceQuery().sql("SELECT * FROM " + managementService.getTableName(ProcessInstance.class)).list().size()); assertEquals(piCount, runtimeService.createNativeProcessInstanceQuery().sql("SELECT count(*) FROM " + managementService.getTableName(ProcessInstance.class)).count()); }
public void testGetTablePage() { String tablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); List<String> taskIds = generateDummyTasks(20); TablePage tablePage = managementService.createTablePageQuery() .tableName(tablePrefix + "ACT_RU_TASK") .listPage(0, 5); assertEquals(0, tablePage.getFirstResult()); assertEquals(5, tablePage.getSize()); assertEquals(5, tablePage.getRows().size()); assertEquals(20, tablePage.getTotal()); tablePage = managementService.createTablePageQuery() .tableName(tablePrefix + "ACT_RU_TASK") .listPage(14, 10); assertEquals(14, tablePage.getFirstResult()); assertEquals(6, tablePage.getSize()); assertEquals(6, tablePage.getRows().size()); assertEquals(20, tablePage.getTotal()); taskService.deleteTasks(taskIds, true); }
public void testGetSortedTablePage() { String tablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); List<String> taskIds = generateDummyTasks(15); // With an ascending sort TablePage tablePage = managementService.createTablePageQuery() .tableName(tablePrefix + "ACT_RU_TASK") .orderAsc("NAME_") .listPage(1, 7); String[] expectedTaskNames = new String[]{"B", "C", "D", "E", "F", "G", "H"}; verifyTaskNames(expectedTaskNames, tablePage.getRows()); // With a descending sort tablePage = managementService.createTablePageQuery() .tableName(tablePrefix + "ACT_RU_TASK") .orderDesc("NAME_") .listPage(6, 8); expectedTaskNames = new String[]{"I", "H", "G", "F", "E", "D", "C", "B"}; verifyTaskNames(expectedTaskNames, tablePage.getRows()); taskService.deleteTasks(taskIds, true); }
public void testNativeQuery() { String tablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); assertEquals(tablePrefix + "ACT_RU_FILTER", managementService.getTableName(Filter.class)); assertEquals(tablePrefix + "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 " + tablePrefix + "ACT_RU_FILTER F1, " + tablePrefix + "ACT_RU_FILTER F2").count()); // select with distinct assertEquals(4, taskService.createNativeTaskQuery().sql("SELECT F1.* FROM "+ tablePrefix + "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()); }
@Deployment(resources = {"org/camunda/bpm/engine/test/api/cmmn/oneTaskCase.cmmn"}) public void testNativeQuery() { createCaseInstance(); createCaseInstance(); createCaseInstance(); createCaseInstance(); String instanceId = caseService.createCaseExecutionQuery().activityId("PI_HumanTask_1").list().get(0).getId(); String tablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); String tableName = managementService.getTableName(HistoricCaseActivityInstance.class); assertEquals(tablePrefix + "ACT_HI_CASEACTINST", tableName); assertEquals(tableName, managementService.getTableName(HistoricCaseActivityInstanceEntity.class)); assertEquals(4, historyService.createNativeHistoricCaseActivityInstanceQuery().sql("SELECT * FROM " + tableName).list().size()); assertEquals(4, historyService.createNativeHistoricCaseActivityInstanceQuery().sql("SELECT count(*) FROM " + tableName).count()); assertEquals(16, historyService.createNativeHistoricCaseActivityInstanceQuery().sql("SELECT count(*) FROM " + tableName + " H1, " + tableName + " H2").count()); // select with distinct assertEquals(4, historyService.createNativeHistoricCaseActivityInstanceQuery().sql("SELECT DISTINCT * FROM " + tableName).list().size()); assertEquals(1, historyService.createNativeHistoricCaseActivityInstanceQuery().sql("SELECT count(*) FROM " + tableName + " H WHERE H.ID_ = '" + instanceId + "'").count()); assertEquals(1, historyService.createNativeHistoricCaseActivityInstanceQuery().sql("SELECT * FROM " + tableName + " H WHERE H.ID_ = '" + instanceId + "'").list().size()); // use parameters assertEquals(1, historyService.createNativeHistoricCaseActivityInstanceQuery().sql("SELECT count(*) FROM " + tableName + " H WHERE H.ID_ = #{caseActivityInstanceId}").parameter("caseActivityInstanceId", instanceId).count()); }
public void testNativeQuery() { String tablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); assertEquals(tablePrefix + "ACT_RU_TASK", managementService.getTableName(Task.class)); assertEquals(tablePrefix + "ACT_RU_TASK", managementService.getTableName(TaskEntity.class)); assertEquals(12, taskService.createNativeTaskQuery().sql("SELECT * FROM " + managementService.getTableName(Task.class)).list().size()); assertEquals(12, taskService.createNativeTaskQuery().sql("SELECT count(*) FROM " + managementService.getTableName(Task.class)).count()); assertEquals(144, taskService.createNativeTaskQuery().sql("SELECT count(*) FROM " + tablePrefix + "ACT_RU_TASK T1, " + tablePrefix + "ACT_RU_TASK T2").count()); // join task and variable instances assertEquals(1, taskService.createNativeTaskQuery().sql("SELECT count(*) FROM " + managementService.getTableName(Task.class) + " T1, "+managementService.getTableName(VariableInstanceEntity.class)+" V1 WHERE V1.TASK_ID_ = T1.ID_").count()); List<Task> tasks = taskService.createNativeTaskQuery().sql("SELECT T1.* FROM " + managementService.getTableName(Task.class) + " T1, "+managementService.getTableName(VariableInstanceEntity.class)+" V1 WHERE V1.TASK_ID_ = T1.ID_").list(); assertEquals(1, tasks.size()); assertEquals("gonzo_Task", tasks.get(0).getName()); // select with distinct assertEquals(12, taskService.createNativeTaskQuery().sql("SELECT DISTINCT T1.* FROM " + tablePrefix + "ACT_RU_TASK T1").list().size()); assertEquals(1, taskService.createNativeTaskQuery().sql("SELECT count(*) FROM " + managementService.getTableName(Task.class) + " T WHERE T.NAME_ = 'gonzo_Task'").count()); assertEquals(1, taskService.createNativeTaskQuery().sql("SELECT * FROM " + managementService.getTableName(Task.class) + " T WHERE T.NAME_ = 'gonzo_Task'").list().size()); // use parameters assertEquals(1, taskService.createNativeTaskQuery().sql("SELECT count(*) FROM " + managementService.getTableName(Task.class) + " T WHERE T.NAME_ = #{taskName}").parameter("taskName", "gonzo_Task").count()); }
@Deployment(resources = {"org/camunda/bpm/engine/test/api/cmmn/oneTaskCase.cmmn"}) public void testNativeQuery() { String id = createCaseInstance().getId(); createCaseInstance(); createCaseInstance(); createCaseInstance(); String tablePrefix = processEngineConfiguration.getDatabaseTablePrefix(); String tableName = managementService.getTableName(HistoricCaseInstance.class); assertEquals(tablePrefix + "ACT_HI_CASEINST", tableName); assertEquals(tableName, managementService.getTableName(HistoricCaseInstanceEntity.class)); assertEquals(4, historyService.createNativeHistoricCaseInstanceQuery().sql("SELECT * FROM " + tableName).list().size()); assertEquals(4, historyService.createNativeHistoricCaseInstanceQuery().sql("SELECT count(*) FROM " + tableName).count()); assertEquals(16, historyService.createNativeHistoricCaseInstanceQuery().sql("SELECT count(*) FROM " + tableName + " H1, " + tableName + " H2").count()); // select with distinct assertEquals(4, historyService.createNativeHistoricCaseInstanceQuery().sql("SELECT DISTINCT * FROM " + tableName).list().size()); assertEquals(1, historyService.createNativeHistoricCaseInstanceQuery().sql("SELECT count(*) FROM " + tableName + " H WHERE H.ID_ = '" + id + "'").count()); assertEquals(1, historyService.createNativeHistoricCaseInstanceQuery().sql("SELECT * FROM " + tableName + " H WHERE H.ID_ = '" + id + "'").list().size()); // use parameters assertEquals(1, historyService.createNativeHistoricCaseInstanceQuery().sql("SELECT count(*) FROM " + tableName + " H WHERE H.ID_ = #{caseInstanceId}").parameter("caseInstanceId", id).count()); }