@Override public String getAssignment() { return toString(); } }
@Override public String getAssignment() { return toString(); }
public static Target nested(Query query) { return new Target("(" + query.toString() + ")"); }
public static Target nested(Query query) { return new Target(j.join("(", query.toString(), ")")); }
public static Projection nested(Query query) { return new CompositeProjection("( %s )", Projection.projection(query.toString())); }
public static Projection nested(Query query) { return new CompositeProjection("( %s )", projection(query.toString())); }
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); } }
Map<String, Object> params = new HashMap<String, Object>(); params.put("key", key); OSQLSynchQuery<ODocument> query = new OSQLSynchQuery<ODocument>(selectQuery.toString());
dbQuery = new OSQLSynchQuery<ODocument>(selectQuery.toString()); return dbQuery;