public ListQueryParameterObject configureQuery(Object parameters) { ListQueryParameterObject queryObject = new ListQueryParameterObject(); queryObject.setParameter(parameters); return configureQuery(queryObject); }
public List selectList(String statement, ListQueryParameterObject parameter) { return selectListWithRawParameter(statement, parameter, parameter.getFirstResult(), parameter.getMaxResults()); }
@SuppressWarnings("unchecked") public List<Event> findEventsByTaskId(String taskId) { checkHistoryEnabled(); ListQueryParameterObject query = new ListQueryParameterObject(); query.setParameter(taskId); query.getOrderingProperties().add(new QueryOrderingProperty(new QueryPropertyImpl("TIME_"), Direction.DESCENDING)); return getDbEntityManager().selectList("selectEventsByTaskId", query); }
@Test public void shouldUseCfgValue_never() { final ListQueryParameterObject query = new ListQueryParameterObject(); final AuthorizationCheck authCheck = query.getAuthCheck(); // given when(mockedConfiguration.getAuthorizationCheckRevokes()).thenReturn(ProcessEngineConfiguration.AUTHORIZATION_CHECK_REVOKE_NEVER); // if authorizationManager.configureQuery(query); // then assertEquals(false, authCheck.isRevokeAuthorizationCheckEnabled()); verify(mockedEntityManager, never()).selectBoolean(eq("selectRevokeAuthorization"), any()); verifyNoMoreInteractions(mockedEntityManager); }
public DbOperation deleteHistoricDetailsByRemovalTime(Date removalTime, int minuteFrom, int minuteTo, int batchSize) { Map<String, Object> parameters = new HashMap<String, Object>(); parameters.put("removalTime", removalTime); if (minuteTo - minuteFrom + 1 < 60) { parameters.put("minuteFrom", minuteFrom); parameters.put("minuteTo", minuteTo); } parameters.put("batchSize", batchSize); return getDbEntityManager() .deletePreserveOrder(HistoricDetailEventEntity.class, "deleteHistoricDetailsByRemovalTime", new ListQueryParameterObject(parameters, 0, batchSize)); }
public void configureQueryHistoricFinishedInstanceReport(ListQueryParameterObject query, Resource resource) { configureQuery(query); CompositePermissionCheck compositePermissionCheck = new PermissionCheckBuilder() .conjunctive() .atomicCheck(resource, "RES.KEY_", READ) .atomicCheck(resource, "RES.KEY_", READ_HISTORY) .build(); query.getAuthCheck().setPermissionChecks(compositePermissionCheck); }
@SuppressWarnings("unchecked") public List<String> findHistoricBatchIdsForCleanup(Integer batchSize, Map<String, Integer> batchOperationsForHistoryCleanup, int minuteFrom, int minuteTo) { Map<String, Object> queryParameters = new HashMap<String, Object>(); queryParameters.put("currentTimestamp", ClockUtil.getCurrentTime()); queryParameters.put("map", batchOperationsForHistoryCleanup); if (minuteTo - minuteFrom + 1 < 60) { queryParameters.put("minuteFrom", minuteFrom); queryParameters.put("minuteTo", minuteTo); } ListQueryParameterObject parameterObject = new ListQueryParameterObject(queryParameters, 0, batchSize); parameterObject.getOrderingProperties().add(new QueryOrderingProperty(new QueryPropertyImpl("END_TIME_"), Direction.ASCENDING)); return (List<String>) getDbEntityManager().selectList("selectHistoricBatchIdsForCleanup", parameterObject); }
@Statement public List<JobEntity> selectNextJobsToExecute(OPersistenceSession session, ListQueryParameterObject query) { Map<String, Object> params = (Map<String, Object>) query.getParameter(); Date now=(Date) params.get("now"); int maxResults=query.getMaxResults(); String orderBy = query.getOrderBy(); return queryList(session, "select from "+getSchemaClass()+ " where retries > 0" + " and (duedate is null or duedate <= ?)" + " and (lockOwner is null or lockExpirationTime < ?)" + " and suspensionState = 1" + (Strings.isEmpty(orderBy)?" order by "+orderBy:"") + " LIMIT ?", now, now, maxResults); }
@Statement public List<ExternalTaskEntity> selectExternalTasksForTopics(OPersistenceSession session, ListQueryParameterObject query) { Map<String, Object> map = (Map<String, Object>)query.getParameter(); String sql = "select from "+getSchemaClass()+" where " +"(lockExpirationTime is null or lockExpirationTime <= ?) and " +"(suspensionState is null or suspensionState = 1) and " +"topicName in ? limit ?"; return queryList(session, sql, map.get("now"), map.get("topics"), query.getMaxResults()); }
@Override public int getMaxResults() { if (maxResults > DEFAULT_LIMIT_SELECT_INTERVAL) { return DEFAULT_LIMIT_SELECT_INTERVAL; } return super.getMaxResults(); }
@Statement public List<CaseDefinitionEntity> selectCaseDefinitionByKeyVersionAndTenantId(OPersistenceSession session, final ListQueryParameterObject parameter) { Map<String, Object> map = (Map<String, Object>) parameter.getParameter(); String key = map.get("caseDefinitionKey").toString(); Integer version = Integer.getInteger(map.get("caseDefinitionVersion").toString()); String tenantId = map.get("tenantId").toString(); String query = "select from " + getSchemaClass() + " where key=" + key + " and version=" + version; if (tenantId == null) query += " and tenantId is null"; else query += " and tenantid=" + tenantId; return queryList(session, query); }
public ListQueryParameterObject configureQuery(ListQueryParameterObject query) { TenantCheck tenantCheck = query.getTenantCheck(); configureTenantCheck(tenantCheck); return query; }
@Test public void shouldUseCfgValue_always() { final ListQueryParameterObject query = new ListQueryParameterObject(); final AuthorizationCheck authCheck = query.getAuthCheck(); // given when(mockedConfiguration.getAuthorizationCheckRevokes()).thenReturn(ProcessEngineConfiguration.AUTHORIZATION_CHECK_REVOKE_ALWAYS); // if authorizationManager.configureQuery(query); // then assertEquals(true, authCheck.isRevokeAuthorizationCheckEnabled()); verifyNoMoreInteractions(mockedEntityManager); }
public DbOperation deleteHistoricActivityInstancesByRemovalTime(Date removalTime, int minuteFrom, int minuteTo, int batchSize) { Map<String, Object> parameters = new HashMap<String, Object>(); parameters.put("removalTime", removalTime); if (minuteTo - minuteFrom + 1 < 60) { parameters.put("minuteFrom", minuteFrom); parameters.put("minuteTo", minuteTo); } parameters.put("batchSize", batchSize); return getDbEntityManager() .deletePreserveOrder(HistoricActivityInstanceEntity.class, "deleteHistoricActivityInstancesByRemovalTime", new ListQueryParameterObject(parameters, 0, batchSize)); }
public void configureQueryHistoricFinishedInstanceReport(ListQueryParameterObject query, Resource resource) { configureQuery(query); CompositePermissionCheck compositePermissionCheck = new PermissionCheckBuilder() .conjunctive() .atomicCheck(resource, "RES.KEY_", READ) .atomicCheck(resource, "RES.KEY_", READ_HISTORY) .build(); query.getAuthCheck().setPermissionChecks(compositePermissionCheck); }
@SuppressWarnings("unchecked") public List<String> findHistoricBatchIdsForCleanup(Integer batchSize, Map<String, Integer> batchOperationsForHistoryCleanup, int minuteFrom, int minuteTo) { Map<String, Object> queryParameters = new HashMap<String, Object>(); queryParameters.put("currentTimestamp", ClockUtil.getCurrentTime()); queryParameters.put("map", batchOperationsForHistoryCleanup); if (minuteTo - minuteFrom + 1 < 60) { queryParameters.put("minuteFrom", minuteFrom); queryParameters.put("minuteTo", minuteTo); } ListQueryParameterObject parameterObject = new ListQueryParameterObject(queryParameters, 0, batchSize); parameterObject.getOrderingProperties().add(new QueryOrderingProperty(new QueryPropertyImpl("END_TIME_"), Direction.ASCENDING)); return (List<String>) getDbEntityManager().selectList("selectHistoricBatchIdsForCleanup", parameterObject); }
@Statement public List<JobEntity> selectExclusiveJobsToExecute(OPersistenceSession session, ListQueryParameterObject query) { Map<String, Object> params = (Map<String, Object>) query.getParameter(); Date now=(Date) params.get("now"); int maxResults=query.getMaxResults(); return queryList(session, "select from "+getSchemaClass()+ " where retries > 0" + " and (duedate is null or duedate <= ?)" + " and (lockOwner is null or lockExpirationTime < ?)" + " and exclusive = true" + " and suspensionState = 1" + " LIMIT ?", now, now, maxResults); }
@Override public int getMaxResults() { if (maxResults > DEFAULT_LIMIT_SELECT_INTERVAL) { return DEFAULT_LIMIT_SELECT_INTERVAL; } return super.getMaxResults(); }
public CaseDefinitionEntity selectPreviousCaseDefinitionId(OPersistenceSession session, final ListQueryParameterObject parameter) { Map<String, Object> map = (Map<String, Object>) parameter.getParameter(); String key = map.get("key").toString(); Integer version = Integer.getInteger(map.get("version").toString()); String tenantId = map.get("tenantId").toString(); String query = "select distinct res.* from " + getSchemaClass() + " res where res.key = " + key; query += (tenantId != null ? " and tenantId=" + tenantId : " and tenantId is null" ); query += " and res.version = (select max(version) from " + getSchemaClass() + " where key=" + key; query += (tenantId != null ? " and tenantId=" + tenantId : " and tenantId is null" ); query += " and version < " + version + ")"; return querySingle(session, query); }
public ListQueryParameterObject configureQuery(ListQueryParameterObject query) { TenantCheck tenantCheck = query.getTenantCheck(); configureTenantCheck(tenantCheck); return query; }