protected List<T> query(final OPersistenceSession session, org.camunda.bpm.engine.query.Query<?, ? super T> query, Function<Query, Query> queryManger, String... ignoreFileds) { try { OClass schemaClass = session.getClass(getSchemaClass()); Query q = new Query().from(getSchemaClass()); List<Object> args = new ArrayList<>(); enrichWhereByBean(session, q, schemaClass, query, args, Arrays.asList(ignoreFileds)); if(queryManger!=null) q = queryManger.apply(q); return queryList(session, q.toString(), args.toArray()); } catch (Exception e) { throw new ProcessEngineException("Problems with read method of "+query.getClass().getName(), e); } }
protected void delete(final OPersistenceSession session, org.camunda.bpm.engine.query.Query<?, ? super T> query, Function<Query, Query> queryManger, String... ignoreFileds) { try { OClass schemaClass = session.getClass(getSchemaClass()); Query q = new Query().from(getSchemaClass()); List<Object> args = new ArrayList<>(); enrichWhereByBean(session, q, schemaClass, query, args, Arrays.asList(ignoreFileds)); if(queryManger!=null) q = queryManger.apply(q); command(session, q.toString(), args.toArray()); } catch (Exception e) { throw new ProcessEngineException("Problems with read method of "+query.getClass().getName(), e); } }
protected List<T> query(final OPersistenceSession session, Map<String, ?> query, Function<Query, Query> queryManger, String... ignoreFileds) { OClass schemaClass = session.getClass(getSchemaClass()); Query q = new Query().from(getSchemaClass()); List<Object> args = new ArrayList<>(); enrichWhereByMap(session, q, schemaClass, query, args, Arrays.asList(ignoreFileds)); if(queryManger!=null) q = queryManger.apply(q); return queryList(session, q.toString(), args.toArray()); }
protected void delete(final OPersistenceSession session, Map<String, ?> query, Function<Query, Query> queryManger, String... ignoreFileds) { OClass schemaClass = session.getClass(getSchemaClass()); Query q = new Query().from(getSchemaClass()); List<Object> args = new ArrayList<>(); enrichWhereByMap(session, q, schemaClass, query, args, Arrays.asList(ignoreFileds)); if(queryManger!=null) q = queryManger.apply(q); command(session, q.toString(), args.toArray()); }
@Statement public List<JobEntity> selectJobsByConfiguration(OPersistenceSession session, ListQueryParameterObject query) { Map<String, Object> params = (Map<String, Object>) query.getParameter(); String config = (String) params.get("handlerConfiguration"); String followUpConfig = (String) params.get("handlerConfigurationWithFollowUpJobCreatedProperty"); String type = (String) params.get("handlerType"); List<String> args = new ArrayList<>(); Query q = new Query().from(getSchemaClass()); q.where(Clause.clause("jobHandlerType", Operator.EQ, Parameter.PARAMETER)); args.add(type); Clause eqConfig = Clause.clause("JobHandlerConfigurationRaw", Operator.EQ, Parameter.PARAMETER); if(Strings.isEmpty(followUpConfig)) { q.where(eqConfig); args.add(config); } else { q.where(Clause.or(eqConfig, eqConfig)); args.add(config); args.add(followUpConfig); } return queryList(session, q.toString(), args.toArray()); }
@Statement public List<String> selectHistoricTaskInstanceIdsByParameters(OPersistenceSession session, ListQueryParameterObject parameters) { Map<String, String> params = (Map<String, String>) parameters.getParameter(); Query q = new Query().from(getSchemaClass()); List<Object> args = new ArrayList<>(); enrichWhereByMap(session, q, session.getClass(getSchemaClass()), params, args, null); List<ODocument> docs = session.getDatabase().query(new OSQLSynchQuery<>(q.toString()), args); return docs==null?new ArrayList<String>():(List<String>)Lists.transform(docs, GET_ID_FUNCTION); } }
@Statement public Long selectMeterLogSum(OPersistenceSession session, final ListQueryParameterObject params) { Map<String, Object> map = (Map<String, Object>) params.getParameter(); Query q = new Query().select(ProjectionFunction.count(Projection.projection("value")).as("value")) .from(getSchemaClass()); List<Object> args = new ArrayList<>(); if(map.get("name")!=null) { q.where(Clause.clause("name", Operator.EQ, Parameter.PARAMETER)); args.add(map.get("name")); } if(map.get("reporter")!=null) { q.where(Clause.clause("reporter", Operator.EQ, Parameter.PARAMETER)); args.add(map.get("reporter")); } if(map.get("startDate")!=null) { q.where(Clause.clause("timestamp", Operator.GT, Parameter.PARAMETER)); args.add(map.get("startDate")); } if(map.get("endDate")!=null) { q.where(Clause.clause("timestamp", Operator.LT, Parameter.PARAMETER)); args.add(map.get("endDate")); } ODatabaseDocument db = session.getDatabase(); List<ODocument> ret = db.query(new OSQLSynchQuery<>(q.toString()), args.toArray()); return (Long)(ret!=null && !ret.isEmpty()? ret.get(0).field("value", OType.LONG):null); } }
selectQuery.from(orientDBMapping.getDocumentClass()) .where(projection("_id").eq(Parameter.parameter("key"))); Map<String, Object> params = new HashMap<String, Object>();
params = new HashMap<String, Object>(); Query selectQuery = new Query(); selectQuery.from(orientDBMapping.getDocumentClass()); if ((this.getStartKey() != null) && (this.getEndKey() != null) && this.getStartKey().equals(this.getEndKey())) {