Search in sources :

Example 1 with Query

use of org.hibernate.query.Query in project OpenClinica by OpenClinica.

the class CrfVersionDao method findByCrfVersionId.

public CrfVersion findByCrfVersionId(int crf_version_id) {
    String query = "from " + getDomainClassName() + " crf_version  where crf_version.crfVersionId = :crfversionid ";
    Query q = getCurrentSession().createQuery(query);
    q.setParameter("crfversionid", crf_version_id);
    return (CrfVersion) q.uniqueResult();
}
Also used : Query(org.hibernate.query.Query) CrfVersion(org.akaza.openclinica.domain.datamap.CrfVersion)

Example 2 with Query

use of org.hibernate.query.Query in project OpenClinica by OpenClinica.

the class CrfVersionDao method findAllByCrfId.

public List<CrfVersion> findAllByCrfId(int crfId) {
    String query = "from " + getDomainClassName() + " crf_version  where crf_version.crf.crfId = :crfId ";
    Query q = getCurrentSession().createQuery(query);
    q.setParameter("crfId", crfId);
    return (List<CrfVersion>) q.list();
}
Also used : Query(org.hibernate.query.Query) List(java.util.List)

Example 3 with Query

use of org.hibernate.query.Query in project OpenClinica by OpenClinica.

the class VersioningMapDao method findByFormLayoutId.

public List<VersioningMap> findByFormLayoutId(int formLayoutId) {
    String query = "from " + getDomainClassName() + " vm  where vm.formLayout.formLayoutId = :formLayoutId ";
    Query q = getCurrentSession().createQuery(query);
    q.setParameter("formLayoutId", formLayoutId);
    return (List<VersioningMap>) q.list();
}
Also used : Query(org.hibernate.query.Query) List(java.util.List) ArrayList(java.util.ArrayList)

Example 4 with Query

use of org.hibernate.query.Query in project OpenClinica by OpenClinica.

the class FormLayoutDao method findAllByCrfId.

public List<FormLayout> findAllByCrfId(int crfId) {
    String query = "from " + getDomainClassName() + " form_layout  where form_layout.crf.crfId = :crfId ";
    Query q = getCurrentSession().createQuery(query);
    q.setParameter("crfId", crfId);
    return (List<FormLayout>) q.list();
}
Also used : Query(org.hibernate.query.Query) List(java.util.List)

Example 5 with Query

use of org.hibernate.query.Query in project OpenClinica by OpenClinica.

the class ItemDao method findAllByCrfVersion.

@SuppressWarnings("unchecked")
public ArrayList<Item> findAllByCrfVersion(Integer crfVersionId) {
    Query q = getCurrentSession().createQuery(findAllByCrfVersion);
    q.setParameter("crfVersionId", crfVersionId);
    return (ArrayList<Item>) q.list();
}
Also used : Query(org.hibernate.query.Query) ArrayList(java.util.ArrayList)

Aggregations

Query (org.hibernate.query.Query)149 Test (org.junit.Test)46 Session (org.hibernate.Session)39 List (java.util.List)24 ArrayList (java.util.ArrayList)19 TestForIssue (org.hibernate.testing.TestForIssue)19 ObjectQuery (com.evolveum.midpoint.prism.query.ObjectQuery)17 CriteriaQuery (javax.persistence.criteria.CriteriaQuery)17 HashMap (java.util.HashMap)15 Map (java.util.Map)14 NativeQuery (org.hibernate.query.NativeQuery)14 AbstractJPATest (org.hibernate.test.jpa.AbstractJPATest)11 SessionFactory (org.hibernate.SessionFactory)9 OperationResult (com.evolveum.midpoint.schema.result.OperationResult)7 SQLException (java.sql.SQLException)7 Collectors (java.util.stream.Collectors)7 RQuery (com.evolveum.midpoint.repo.sql.query.RQuery)6 CriteriaBuilder (javax.persistence.criteria.CriteriaBuilder)6 Predicate (javax.persistence.criteria.Predicate)6 Root (javax.persistence.criteria.Root)6