/** * Call setEntity() on a cacheable query - see FORGE-265 */ public List listEventsOfOrganizer(Person organizer) { Session session = sessionFactory.getCurrentSession(); session.beginTransaction(); Query query = session.createQuery("from Event ev where ev.organizer = :organizer"); query.setCacheable(true); query.setEntity("organizer", organizer); List result = query.list(); session.getTransaction().commit(); return result; }
/** * Call setEntity() on a cacheable query - see FORGE-265 */ public List listEventsOfOrganizer(Person organizer) { Session session = sessionFactory.getCurrentSession(); session.beginTransaction(); Query query = session.createQuery("from Event ev where ev.organizer = :organizer"); query.setCacheable(true); query.setEntity("organizer", organizer); List result = query.list(); session.getTransaction().commit(); return result; }
/** * @see org.openmrs.api.db.ProgramWorkflowDAO#getProgramsByConcept(org.openmrs.Concept) */ @Override public List<Program> getProgramsByConcept(Concept concept) { String pq = "select distinct p from Program p where p.concept = :concept"; Query pquery = sessionFactory.getCurrentSession().createQuery(pq); pquery.setEntity("concept", concept); return pquery.list(); }
/** * @see org.openmrs.api.db.FormDAO#getFormsContainingConcept(org.openmrs.Concept) */ @Override @SuppressWarnings("unchecked") public List<Form> getFormsContainingConcept(Concept c) throws DAOException { String q = "select distinct ff.form from FormField ff where ff.field.concept = :concept"; Query query = sessionFactory.getCurrentSession().createQuery(q); query.setEntity("concept", c); return query.list(); }
/** * @see org.openmrs.api.db.FormDAO#getFormFieldsByField(Field) */ @Override @SuppressWarnings("unchecked") public List<FormField> getFormFieldsByField(Field field) { return sessionFactory.getCurrentSession().createQuery("from FormField f where f.field = :field").setEntity("field", field).list(); }
/** * @see org.openmrs.api.db.ProgramWorkflowDAO#getProgramWorkflowsByConcept(org.openmrs.Concept) */ @Override public List<ProgramWorkflow> getProgramWorkflowsByConcept(Concept concept) { String wq = "select distinct w from ProgramWorkflow w where w.concept = :concept"; Query wquery = sessionFactory.getCurrentSession().createQuery(wq); wquery.setEntity("concept", concept); return wquery.list(); }
/** * @see org.openmrs.api.db.ProgramWorkflowDAO#getProgramWorkflowStatesByConcept(org.openmrs.Concept) */ @Override public List<ProgramWorkflowState> getProgramWorkflowStatesByConcept(Concept concept) { String sq = "select distinct s from ProgramWorkflowState s where s.concept = :concept"; Query squery = sessionFactory.getCurrentSession().createQuery(sq); squery.setEntity("concept", concept); return squery.list(); }
/** * returns a list of n-generations of parents of a concept in a concept set * * @param Concept current * @return List<Concept> * @throws DAOException */ @SuppressWarnings("unchecked") private List<Concept> getParents(Concept current) throws DAOException { List<Concept> parents = new ArrayList<>(); if (current != null) { Query query = sessionFactory.getCurrentSession().createQuery( "from Concept c join c.conceptSets sets where sets.concept = ?").setEntity(0, current); List<Concept> immedParents = query.list(); for (Concept c : immedParents) { parents.addAll(getParents(c)); } parents.add(current); if (log.isDebugEnabled()) { log.debug("parents found: "); for (Concept c : parents) { log.debug("id: " + c.getConceptId()); } } } return parents; }
public List<Program> findBySubscriber(Subscriber subscriber) { String hql = "select p " + "from Program p " + " join p.subscribers s " + "where s = :sub" ; Query q = getSession().createQuery(hql); q.setEntity("sub", subscriber); List<Program> l = q.list(); return l; }
public void setParameterInto(final Query query) { if (type.equals(Hibernate.OBJECT)) { query.setEntity(name, value); } else if (type.equals(DETERMINE)) { query.setParameter(name, value); } else { query.setParameter(name, value, type); } }
private void deleteLogs(ProcessInstance processInstance) { List logs = session.getNamedQuery("GraphSession.findLogsForProcessInstance") .setEntity("processInstance", processInstance) .list(); for (Iterator i = logs.iterator(); i.hasNext();) { session.delete(i.next()); } }
@Override public OnmsLocationSpecificStatus doInHibernate(final Session session) throws HibernateException, SQLException { return (OnmsLocationSpecificStatus)session.createQuery("from OnmsLocationSpecificStatus status where status.locationMonitor = :locationMonitor and status.monitoredService = :monitoredService order by status.pollResult.timestamp desc") .setEntity("locationMonitor", locationMonitor) .setEntity("monitoredService", monSvc) .setMaxResults(1) .uniqueResult(); }
private List findReferencingProcessStates(ProcessDefinition subProcessDefinition) { return session.getNamedQuery("GraphSession.findReferencingProcessStates") .setEntity("subProcessDefinition", subProcessDefinition) .list(); }
private void deleteSubProcesses(ProcessInstance processInstance) { List subProcessInstances = session.getNamedQuery("GraphSession.findSubProcessInstances") .setEntity("processInstance", processInstance) .list(); for (Iterator i = subProcessInstances.iterator(); i.hasNext();) { ProcessInstance subProcessInstance = (ProcessInstance) i.next(); deleteProcessInstance(subProcessInstance); } }
public Facility facilityFor(Patient patient) { return (Facility) sessionFactory.getCurrentSession().createQuery( "from " + Facility.class.getName() + " f where :patient in elements(f.patients)") .setEntity("patient", patient).uniqueResult(); }
@Override @Hidden public List<ExpenseItem> findExpenseItemsOfType(final Employee employee, final ExpenseType type) { // example query implementation final Query query = hibernateHelper.createEntityQuery("o.expenseType = ? and o.claim.claimant = ?", AbstractExpenseItem.class); query.setEntity(0, type); query.setEntity(1, employee); return hibernateHelper.findByQuery(query, ExpenseItem.class); } }
private void deleteJobs(ProcessInstance processInstance) { session.getNamedQuery("GraphSession.deleteJobsForProcessInstance") .setEntity("processInstance", processInstance) .executeUpdate(); }
public List findActiveNodesByProcessInstance(ProcessInstance processInstance) { try { return session.getNamedQuery("GraphSession.findActiveNodesByProcessInstance") .setEntity("processInstance", processInstance) .list(); } catch (HibernateException e) { handle(e); throw new JbpmPersistenceException("could not find active nodes for " + processInstance, e); } }
public List<JobImpl<?>> findExclusiveJobs(Execution processInstance) { // query definition can be found at the bottom of resource org/jbpm/pvm/hibernate.job.hbm.xml Query query = session.getNamedQuery("findExclusiveJobs"); query.setTimestamp("now", Clock.getCurrentTime()); query.setEntity("processInstance", processInstance); return query.list(); }
private GradebookAssignment getExternalAssignment(final String gradebookUid, final String externalId) throws GradebookNotFoundException { final Gradebook gradebook = getGradebook(gradebookUid); final HibernateCallback<GradebookAssignment> hc = session -> (GradebookAssignment) session .createQuery("from GradebookAssignment as asn where asn.gradebook = :gradebook and asn.externalId = :externalid") .setEntity("gradebook", gradebook) .setString("externalid", externalId) .uniqueResult(); return getHibernateTemplate().execute(hc); }