@SuppressWarnings({"unchecked"}) public List<Modification> getModificationsForPipelineRange(final String pipelineName, final Integer fromCounter, final Integer toCounter) { return (List<Modification>) getHibernateTemplate().execute((HibernateCallback) session -> { final List<Long> fromInclusiveModificationList = fromInclusiveModificationsForPipelineRange(session, pipelineName, fromCounter, toCounter); final Set<Long> fromModifications = new TreeSet<>(fromInclusiveModificationsForPipelineRange(session, pipelineName, fromCounter, fromCounter)); final Set<Long> fromExclusiveModificationList = new HashSet<>(); for (Long modification : fromInclusiveModificationList) { if (fromModifications.contains(modification)) { fromModifications.remove(modification); } else { fromExclusiveModificationList.add(modification); } } SQLQuery query = session.createSQLQuery("SELECT * FROM modifications WHERE id IN (:ids) ORDER BY materialId ASC, id DESC"); query.addEntity(Modification.class); query.setParameterList("ids", fromExclusiveModificationList.isEmpty() ? fromInclusiveModificationList : fromExclusiveModificationList); return query.list(); }); }
@Override public EventClassFamily findByEcfvId(String ecfvId) { LOG.debug("Searching event class family by ecfv id [{}]", ecfvId); Query query = getSession().createSQLQuery( "select ecf.*" + " from " + EVENT_CLASS_FAMILY_TABLE_NAME + " as ecf" + " join " + EVENT_CLASS_FAMILY_VERSION_TABLE_NAME + " as ecfv" + " on ecf.id = ecfv." + EVENT_CLASS_FAMILY_ID + " where ecfv.id = :id").addEntity(getEntityClass()); query.setLong("id", Long.valueOf(ecfvId)); EventClassFamily eventClassFamily = (EventClassFamily) query.uniqueResult(); LOG.debug("[{}] Search result: {}.", ecfvId, eventClassFamily); return eventClassFamily; }
@SuppressWarnings("unchecked") public List<MatchedRevision> findRevisionsMatching(final MaterialConfig materialConfig, final String searchString) { return (List<MatchedRevision>) getHibernateTemplate().execute((HibernateCallback) session -> { String sql = "SELECT m.*" + " FROM modifications AS m" + " INNER JOIN materials mat ON mat.id = m.materialId" + " WHERE mat.fingerprint = :finger_print" + " AND (m.revision || ' ' || COALESCE(m.username, '') || ' ' || COALESCE(m.comment, '') LIKE :search_string OR m.pipelineLabel LIKE :search_string)" + " ORDER BY m.id DESC" + " LIMIT 5"; SQLQuery query = session.createSQLQuery(sql); query.addEntity("m", Modification.class); Material material = materialConfigConverter.toMaterial(materialConfig); query.setString("finger_print", material.getFingerprint()); query.setString("search_string", "%" + searchString + "%"); final List<MatchedRevision> list = new ArrayList<>(); for (Modification mod : (List<Modification>) query.list()) { list.add(material.createMatchedRevision(mod, searchString)); } return list; }); }
addEntity("mods", Modification.class). addScalar("pmrPipelineId", new LongType()). addScalar("pmrPipelineName", new StringType()).
@SuppressWarnings("unchecked") public <T> List<T> findBySql(String sql, int page, int rows, Class<T> clazz) { SQLQuery sqlQuery = this.getCurrentSession().createSQLQuery(sql); sqlQuery.addEntity(clazz); return sqlQuery.list(); }
@SuppressWarnings("unchecked") public <T> List<T> findBySql(String sql, Class<T> clazz) { SQLQuery sqlQuery = this.getCurrentSession().createSQLQuery(sql); sqlQuery.addEntity(clazz); return sqlQuery.list(); }
/** * @see org.openmrs.api.db.ConceptDAO#getSavedConceptDatatype(org.openmrs.Concept) */ @Override public ConceptDatatype getSavedConceptDatatype(Concept concept) { SQLQuery sql = sessionFactory.getCurrentSession().createSQLQuery( "select datatype.* from " + "concept_datatype datatype, " + "concept concept " + "where " + "datatype.concept_datatype_id = concept.datatype_id " + "and concept.concept_id=:conceptId") .addEntity(ConceptDatatype.class); sql.setInteger("conceptId", concept.getConceptId()); return (ConceptDatatype) sql.uniqueResult(); }
private List<PersonAttribute> getPersonAttributeList(String queryString) { Query query = sessionFactory.getCurrentSession().createSQLQuery(queryString).addEntity(PersonAttribute.class); return query.list(); }
@SuppressWarnings("unchecked") public <T> List<T> findBySql(String sql, Map<String, Object> params, Class<T> clazz) { SQLQuery sqlQuery = this.getCurrentSession().createSQLQuery(sql); sqlQuery=getSqlQueryByMap(sqlQuery,params); sqlQuery.addEntity(clazz); return sqlQuery.list(); }
@SuppressWarnings("unchecked") public <T> List<T> findBySql(String sql, Map<String, Object> params, int page, int rows, Class<T> clazz) { SQLQuery sqlQuery = this.getCurrentSession().createSQLQuery(sql); sqlQuery=getSqlQueryByMap(sqlQuery,params); sqlQuery.addEntity(clazz); return sqlQuery.setFirstResult((page - 1) * rows).setMaxResults(rows).list(); }
SQLQuery query = sess.createSQLQuery("SELECT * FROM ? WHERE ? = '?'"); query .addEntity(klass) .setParameter(0, table) .setParameter(1, field) .setParameter(2, value) .uniqueResult();
String queryString = "Select {user.*}, (select max(submitted) from posts where post.user_id = user.id) MAX_POST from users user"; SQLQuery query = getSession().createSQLQuery(queryString); query.addEntity("user", User.class); query.addScalar("MAX_POST", Hibernate.DATE); List results = query.list(); List<User> users = new ArrayList(); for (Object item : results) { Object[] element = (Object[]) item; User user = (User)element[0]; user.setMaxPost((Date)element[1]); users.add(user); }
String sql = "select A.SL_NO, A.DATETIME, A.IP, A.CATEGORY, A.SUBCATEGORY, A.VALUE FROM APP_MON_REF_TABLE A, " + "(SELECT category, max(to_char(datetime,'YYYY-MM-DD HH24:MI:SS')) maxtime from APP_MON_REF_TABLE group by category) B " + "where A.category = B.category and to_char(A.datetime,'YYYY-MM-DD HH24:MI:SS') = B.maxtime"; SQLQuery sqlQuery = getCurrentSession().createSQLQuery(sql); sqlQuery.addEntity("A", YourEntity.class); sqlQuery.addScalar("maxtime", StandardBasicTypes.CHARACTER_ARRAY); List<Object[]> results = sqlQuery.list(); for (Object[] result : results) { YouEntity a= result[0]; String maxTime = (String) result[1]; }
@SuppressWarnings( "unchecked" ) public List<Employee> findByDepartment(long departmentId){ SQLQuery query = session.createSQLQuery("SELECT {emp.*} " + " FROM employee emp " + +"WHERE emp.department_id = :departement_id"); query.setLong("department_id", departmentId); query.addEntity("emp", Employee.class); return (List<Employee>) = query.list(); }
String sql = "SELECT * FROM EMPLOYEE WHERE id = :employee_id"; SQLQuery query = session.createSQLQuery(sql); query.addEntity(User.class); query.setParameter("employee_id", 3); List<User> results = query.list();
public Integer CountCorpusByAttributes(Long auId, String corpusstr) { Session session = sessionFactory.getCurrentSession(); String sqlString = "SELECT b.* FROM auth_user_data_objects AS a " + "INNER JOIN corpus as b ON a.audo_uid_resource = b.crp_id " + "WHERE audo_user_id = ? AND audo_type_resource = ?"; SQLQuery qry = session.createSQLQuery(sqlString); qry.setParameter(0, auId); qry.setParameter(1, corpusstr); qry.addEntity("corpus", Corpus.class); @SuppressWarnings("unchecked") List<Corpus> result = qry.list(); return result.size(); }
@SuppressWarnings("unchecked") public <T> List<T> queryList(Class<T> clazz, String sql, Object... args) { SQLQuery query = getSession().createSQLQuery(sql); query.addEntity(clazz); for(int i = 0; i < args.length; i++) { query.setParameter(i, args[i]); } return (List<T>)query.list(); }
@SuppressWarnings("unchecked") public <T> T queryObject(Class<T> T, String sql, Object... args) { SQLQuery query = getSession().createSQLQuery(sql); query.addEntity(T); for(int i = 0; i < args.length; i++) { query.setParameter(i, args[i]); } return (T)query.uniqueResult(); }
@SuppressWarnings("unchecked") public <T> T queryObject(Class<T> T, String sql, Object... args) { SQLQuery query = getSession().createSQLQuery(sql); query.addEntity(T); for(int i = 0; i < args.length; i++) { query.setParameter(i, args[i]); } return (T)query.uniqueResult(); }
@SuppressWarnings("unchecked") public <T> List<T> queryList(Class<T> clazz, String sql, Object... args) { SQLQuery query = getSession().createSQLQuery(sql); query.addEntity(clazz); for(int i = 0; i < args.length; i++) { query.setParameter(i, args[i]); } return (List<T>)query.list(); }