org.hibernate.query.Query - java examples

Here are the examples of the java api org.hibernate.query.Query taken from open source projects. By voting up you can indicate which examples are most useful and appropriate.

155 Examples 7

19 View Complete Implementation : HibernateTrackedEntityInstanceStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public boolean existsIncludingDeleted(String uid) {
    Query query = getSession().createNativeQuery("select count(*) from trackedenreplacedyinstance where uid=?");
    query.setParameter(1, uid);
    int count = ((Number) query.getSingleResult()).intValue();
    return count > 0;
}

19 View Complete Implementation : HibernateTrackedEntityAttributeStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@SuppressWarnings({ "unchecked", "rawtypes" })
public Set<TrackedEnreplacedyAttribute> getTrackedEnreplacedyAttributesByTrackedEnreplacedyTypes() {
    Query query = sessionFactory.getCurrentSession().createQuery("select trackedEnreplacedyTypeAttributes from TrackedEnreplacedyType");
    Set<TrackedEnreplacedyTypeAttribute> trackedEnreplacedyTypeAttributes = new HashSet<>(query.list());
    return trackedEnreplacedyTypeAttributes.stream().map(TrackedEnreplacedyTypeAttribute::getTrackedEnreplacedyAttribute).collect(Collectors.toSet());
}

19 View Complete Implementation : HibernateDataValueStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public List<DataValue> getDataValues(OrganisationUnit source, Period period, Collection<DataElement> dataElements, CategoryOptionCombo attributeOptionCombo) {
    Period storedPeriod = periodStore.reloadPeriod(period);
    if (storedPeriod == null || dataElements == null || dataElements.isEmpty()) {
        return new ArrayList<>();
    }
    String hql = "select dv from DataValue dv  where dv.dataElement in (:dataElements) and dv.period =:period and dv.deleted = false ";
    if (source != null) {
        hql += " and dv.source =:source ";
    }
    if (attributeOptionCombo != null) {
        hql += " and dv.attributeOptionCombo =:attributeOptionCombo ";
    }
    Query<DataValue> query = getQuery(hql).setParameter("dataElements", dataElements).setParameter("period", storedPeriod);
    if (source != null) {
        query.setParameter("source", source);
    }
    if (attributeOptionCombo != null) {
        query.setParameter("attributeOptionCombo", attributeOptionCombo);
    }
    return getList(query);
}

19 View Complete Implementation : HibernateTrackedEntityInstanceStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
// -------------------------------------------------------------------------
// Implementation methods
// -------------------------------------------------------------------------
@Override
public int countTrackedEnreplacedyInstances(TrackedEnreplacedyInstanceQueryParams params) {
    String hql = buildTrackedEnreplacedyInstanceCountHql(params);
    Query query = getQuery(hql);
    return ((Number) query.iterate().next()).intValue();
}

19 View Complete Implementation : HibernateTrackedEntityInstanceStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public boolean exists(String uid) {
    Query query = getSession().createNativeQuery("select count(*) from trackedenreplacedyinstance where uid=? and deleted is false");
    query.setParameter(1, uid);
    int count = ((Number) query.getSingleResult()).intValue();
    return count > 0;
}

19 View Complete Implementation : HibernateTrackedEntityInstanceStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public void updateTrackedEnreplacedyInstancesSyncTimestamp(List<String> trackedEnreplacedyInstanceUIDs, Date lastSynchronized) {
    String hql = "update TrackedEnreplacedyInstance set lastSynchronized = :lastSynchronized WHERE uid in :trackedEnreplacedyInstances";
    Query query = getQuery(hql);
    query.setParameter("lastSynchronized", lastSynchronized);
    query.setParameter("trackedEnreplacedyInstances", trackedEnreplacedyInstanceUIDs);
    query.executeUpdate();
}

18 View Complete Implementation : HibernateTrackedEntityAttributeValueStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public List<TrackedEnreplacedyAttributeValue> get(Collection<TrackedEnreplacedyInstance> enreplacedyInstances) {
    if (enreplacedyInstances == null || enreplacedyInstances.isEmpty()) {
        return new ArrayList<>();
    }
    String query = " from TrackedEnreplacedyAttributeValue v where v.enreplacedyInstance  in :enreplacedyInstances";
    Query<TrackedEnreplacedyAttributeValue> typedQuery = getQuery(query).setParameter("enreplacedyInstances", enreplacedyInstances);
    return getList(typedQuery);
}

18 View Complete Implementation : HibernateInterpretationStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public int countChartInterpretations(Chart chart) {
    Query query = getQuery("select count(distinct c) from " + clazz.getName() + " c where c.chart=:chart").setParameter("chart", chart).setCacheable(cacheable);
    return ((Long) query.uniqueResult()).intValue();
}

18 View Complete Implementation : HibernateInterpretationStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public int countMapInterpretations(Map map) {
    Query query = getQuery("select count(distinct c) from " + clazz.getName() + " c where c.map=:map").setParameter("map", map).setCacheable(cacheable);
    return ((Long) query.uniqueResult()).intValue();
}

18 View Complete Implementation : HibernateInterpretationStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public int countReportTableInterpretations(ReportTable reportTable) {
    Query query = getQuery("select count(distinct c) from " + clazz.getName() + " c where c.reportTable=:reportTable").setParameter("reportTable", reportTable).setCacheable(cacheable);
    return ((Long) query.uniqueResult()).intValue();
}

18 View Complete Implementation : HibernateInterpretationStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
public List<Interpretation> getInterpretations(User user) {
    String hql = "select distinct i from Interpretation i left join i.comments c " + "where i.user = :user or c.user = :user order by i.lastUpdated desc";
    Query<Interpretation> query = getQuery(hql).setParameter("user", user).setCacheable(cacheable);
    return query.list();
}

18 View Complete Implementation : HibernateUserStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public int getUserCount() {
    Query<Long> query = getTypedQuery("select count(*) from User");
    return query.uniqueResult().intValue();
}

18 View Complete Implementation : HibernateInterpretationStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public Interpretation getByChartId(long id) {
    String hql = "from Interpretation i where i.chart.id = " + id;
    Query<Interpretation> query = getQuery(hql);
    return query.uniqueResult();
}

18 View Complete Implementation : HibernateTrackedEntityAttributeValueStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public List<TrackedEnreplacedyAttributeValue> get(TrackedEnreplacedyAttribute attribute, String value) {
    String query = " from TrackedEnreplacedyAttributeValue v where v.attribute =:attribute and lower(v.plainValue) like :value";
    Query<TrackedEnreplacedyAttributeValue> typedQuery = getQuery(query).setParameter("attribute", attribute).setParameter("value", StringUtils.lowerCase(value));
    return getList(typedQuery);
}

18 View Complete Implementation : HibernateInterpretationStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public Interpretation getByVisualizationId(long id) {
    String hql = "from Interpretation i where i.visualization.id = " + id;
    Query<Interpretation> query = getSession().createQuery(hql, Interpretation.clreplaced).setCacheable(cacheable);
    return query.uniqueResult();
}

18 View Complete Implementation : HibernateInterpretationStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
public List<Interpretation> getInterpretations(User user, int first, int max) {
    String hql = "select distinct i from Interpretation i left join i.comments c " + "where i.user = :user or c.user = :user order by i.lastUpdated desc";
    Query<Interpretation> query = getQuery(hql).setParameter("user", user).setMaxResults(first).setMaxResults(max).setCacheable(cacheable);
    return query.list();
}

18 View Complete Implementation : HibernateTrackedEntityAttributeValueStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public List<TrackedEnreplacedyAttributeValue> searchByValue(TrackedEnreplacedyAttribute attribute, String searchText) {
    String query = " from TrackedEnreplacedyAttributeValue v where v.attribute =:attribute and lower(v.plainValue) like :searchText";
    Query<TrackedEnreplacedyAttributeValue> typedQuery = getQuery(query).setParameter("attribute", attribute).setParameter("searchText", "%" + StringUtils.lowerCase(searchText) + "%");
    return getList(typedQuery);
}

18 View Complete Implementation : HibernatePeriodStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public List<Period> getPeriodsByPeriodType(PeriodType periodType) {
    String query = "from Period p where p.periodType.id =:periodType";
    Query<Period> typedQuery = getQuery(query).setParameter("periodType", reloadPeriodType(periodType).getId());
    return getList(typedQuery);
}

18 View Complete Implementation : HibernateTrackedEntityAttributeValueStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public List<TrackedEnreplacedyAttributeValue> get(TrackedEnreplacedyAttribute attribute) {
    String query = " from TrackedEnreplacedyAttributeValue v where v.attribute =:attribute";
    Query<TrackedEnreplacedyAttributeValue> typedQuery = getQuery(query).setParameter("attribute", attribute);
    return getList(typedQuery);
}

18 View Complete Implementation : HibernateTrackedEntityInstanceStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public List<TrackedEnreplacedyInstance> getTrackedEnreplacedyInstances(TrackedEnreplacedyInstanceQueryParams params) {
    String hql = buildTrackedEnreplacedyInstanceHql(params);
    // If it is a sync job running a query, I need to adjust an HQL a bit, because I am adding 2 joins and don't want duplicates in results
    if (params.isSynchronizationQuery()) {
        hql = hql.replaceFirst("select tei from", "select distinct tei from");
    }
    Query<TrackedEnreplacedyInstance> query = getQuery(hql);
    if (params.isPaging()) {
        query.setFirstResult(params.getOffset());
        query.setMaxResults(params.getPageSizeWithDefault());
    }
    return query.list();
}

17 View Complete Implementation : HibernateUserCredentialsStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public UserCredentials getUserCredentialsByLdapId(String ldapId) {
    Query query = getQuery("from UserCredentials uc where uc.ldapId = :ldapId");
    query.setParameter("ldapId", ldapId);
    return (UserCredentials) query.uniqueResult();
}

17 View Complete Implementation : HibernateTrackedEntityAttributeValueStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public List<TrackedEnreplacedyAttributeValue> get(TrackedEnreplacedyInstance enreplacedyInstance) {
    String query = " from TrackedEnreplacedyAttributeValue v where v.enreplacedyInstance =:enreplacedyInstance";
    Query<TrackedEnreplacedyAttributeValue> typedQuery = getQuery(query).setParameter("enreplacedyInstance", enreplacedyInstance);
    return getList(typedQuery);
}

17 View Complete Implementation : HibernatePeriodStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public Period getPeriodFromDates(Date startDate, Date endDate, PeriodType periodType) {
    String query = "from Period p where p.startDate =:startDate and p.endDate =:endDate and p.periodType.id =:periodType";
    Query<Period> typedQuery = getQuery(query).setParameter("startDate", startDate).setParameter("endDate", endDate).setParameter("periodType", reloadPeriodType(periodType).getId());
    return getSingleResult(typedQuery);
}

17 View Complete Implementation : HibernateTrackedEntityAttributeStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@SuppressWarnings({ "unchecked", "rawtypes" })
public Map<Program, Set<TrackedEnreplacedyAttribute>> getTrackedEnreplacedyAttributesByProgram() {
    Map<Program, Set<TrackedEnreplacedyAttribute>> result = new HashMap<>();
    Query query = sessionFactory.getCurrentSession().createQuery("select p.programAttributes from Program p");
    List<ProgramTrackedEnreplacedyAttribute> programTrackedEnreplacedyAttributes = (List<ProgramTrackedEnreplacedyAttribute>) query.list();
    for (ProgramTrackedEnreplacedyAttribute programTrackedEnreplacedyAttribute : programTrackedEnreplacedyAttributes) {
        if (!result.containsKey(programTrackedEnreplacedyAttribute.getProgram())) {
            result.put(programTrackedEnreplacedyAttribute.getProgram(), Sets.newHashSet(programTrackedEnreplacedyAttribute.getAttribute()));
        } else {
            result.get(programTrackedEnreplacedyAttribute.getProgram()).add(programTrackedEnreplacedyAttribute.getAttribute());
        }
    }
    return result;
}

17 View Complete Implementation : HibernateAnalyticalObjectStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public int countreplacedyticalObjects(CategoryOptionGroup categoryOptionGroup) {
    Query query = getQuery("select count(distinct c) from " + clazz.getName() + " c where :categoryOptionGroup in elements(c.categoryOptionGroups)");
    query.setParameter("categoryOptionGroup", categoryOptionGroup);
    return ((Long) query.uniqueResult()).intValue();
}

17 View Complete Implementation : HibernateProgramInstanceStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public int countProgramInstances(ProgramInstanceQueryParams params) {
    String hql = buildCountProgramInstanceHql(params);
    Query<Long> query = getTypedQuery(hql);
    return query.getSingleResult().intValue();
}

17 View Complete Implementation : HibernateKeyJsonValueStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public List<String> getKeysInNamespace(String namespace) {
    String hql = "select key from KeyJsonValue where namespace = :namespace";
    Query<String> query = getTypedQuery(hql);
    return query.setParameter("namespace", namespace).list();
}

17 View Complete Implementation : HibernateProgramStageInstanceStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public boolean exists(String uid) {
    Query query = getSession().createNativeQuery("select count(*) from programstageinstance where uid=? and deleted is false");
    query.setParameter(1, uid);
    int count = ((Number) query.getSingleResult()).intValue();
    return count > 0;
}

17 View Complete Implementation : HibernateAnalyticalObjectStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public int countreplacedyticalObjects(ProgramIndicator programIndicator) {
    Query query = getQuery("select count(distinct c) from " + clazz.getName() + " c join c.dataDimensionItems d where d.programIndicator = :programIndicator");
    query.setParameter("dataSet", programIndicator);
    return ((Long) query.uniqueResult()).intValue();
}

17 View Complete Implementation : HibernateUserCredentialsStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public UserCredentials getUserCredentialsByUsername(String username) {
    Query query = getQuery("from UserCredentials uc where uc.username = :username");
    query.setParameter("username", username);
    return (UserCredentials) query.uniqueResult();
}

17 View Complete Implementation : HibernateUserCredentialsStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public UserCredentials getUserCredentialsByOpenId(String openId) {
    Query query = getQuery("from UserCredentials uc where uc.openId = :openId");
    query.setParameter("openId", openId);
    return (UserCredentials) query.uniqueResult();
}

17 View Complete Implementation : HibernateAnalyticalObjectStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public int countreplacedyticalObjects(Indicator indicator) {
    Query query = getQuery("select count(distinct c) from " + clazz.getName() + " c join c.dataDimensionItems d where d.indicator = :indicator");
    query.setParameter("indicator", indicator);
    return ((Long) query.uniqueResult()).intValue();
}

17 View Complete Implementation : HibernatePeriodStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public List<Period> getIntersectingPeriods(Date startDate, Date endDate) {
    String query = "from Period p where p.startDate <=:endDate and p.endDate >=:startDate";
    Query<Period> typedQuery = getQuery(query).setParameter("startDate", startDate).setParameter("endDate", endDate);
    return getList(typedQuery);
}

17 View Complete Implementation : HibernateOrganisationUnitStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public int getMaxLevel() {
    String hql = "select max(ou.hierarchyLevel) from OrganisationUnit ou";
    Query<Integer> query = getTypedQuery(hql);
    Integer maxLength = query.getSingleResult();
    return maxLength != null ? maxLength : 0;
}

17 View Complete Implementation : HibernateMapStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public int countMapViewMaps(MapView mapView) {
    Query<Long> query = getTypedQuery("select count(distinct c) from Map c where :mapView in elements(c.mapViews)");
    query.setParameter("mapView", mapView);
    return query.getSingleResult().intValue();
}

17 View Complete Implementation : HibernateAnalyticalObjectStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public int countreplacedyticalObjects(Period period) {
    Query query = getQuery("select count(distinct c) from " + clazz.getName() + " c where :period in elements(c.periods)");
    query.setParameter("period", period);
    return ((Long) query.uniqueResult()).intValue();
}

17 View Complete Implementation : HibernateProgramStageInstanceStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public boolean existsIncludingDeleted(String uid) {
    Query query = getSession().createNativeQuery("select count(*) from programstageinstance where uid=?");
    query.setParameter(1, uid);
    int count = ((Number) query.getSingleResult()).intValue();
    return count > 0;
}

17 View Complete Implementation : HibernateTrackedEntityAttributeValueStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public int getCountOfreplacedignedTEAValues(TrackedEnreplacedyAttribute attribute) {
    Query query = getQuery("select count(distinct c) from TrackedEnreplacedyAttributeValue c where c.attribute = :attribute");
    query.setParameter("attribute", attribute);
    return ((Long) query.getSingleResult()).intValue();
}

17 View Complete Implementation : HibernateTrackedEntityAttributeValueStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public TrackedEnreplacedyAttributeValue get(TrackedEnreplacedyInstance enreplacedyInstance, TrackedEnreplacedyAttribute attribute) {
    String query = " from TrackedEnreplacedyAttributeValue v where v.enreplacedyInstance =:enreplacedyInstance and attribute =:attribute";
    Query<TrackedEnreplacedyAttributeValue> typedQuery = getQuery(query).setParameter("enreplacedyInstance", enreplacedyInstance).setParameter("attribute", attribute);
    return getSingleResult(typedQuery);
}

17 View Complete Implementation : HibernatePeriodStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public List<Period> getIntersectingPeriodsByPeriodType(PeriodType periodType, Date startDate, Date endDate) {
    String query = "from Period p where p.startDate <=:endDate and p.endDate >=:startDate and p.periodType.id =:periodType";
    Query<Period> typedQuery = getQuery(query).setParameter("startDate", startDate).setParameter("endDate", endDate).setParameter("periodType", reloadPeriodType(periodType).getId());
    return getList(typedQuery);
}

17 View Complete Implementation : HibernatePeriodStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public List<Period> getPeriodsBetweenDates(PeriodType periodType, Date startDate, Date endDate) {
    String query = "from Period p where p.startDate >=:startDate and p.endDate <=:endDate and p.periodType.id =:periodType";
    Query<Period> typedQuery = getQuery(query).setParameter("startDate", startDate).setParameter("endDate", endDate).setParameter("periodType", reloadPeriodType(periodType).getId());
    return getList(typedQuery);
}

17 View Complete Implementation : HibernateProgramInstanceStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public boolean existsIncludingDeleted(String uid) {
    Query query = getSession().createNativeQuery("select count(*) from programinstance where uid=?");
    query.setParameter(1, uid);
    int count = ((Number) query.getSingleResult()).intValue();
    return count > 0;
}

17 View Complete Implementation : HibernateProgramInstanceStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public boolean exists(String uid) {
    Query query = getSession().createNativeQuery("select count(*) from programinstance where uid=? and deleted is false");
    query.setParameter(1, uid);
    int count = ((Number) query.getSingleResult()).intValue();
    return count > 0;
}

17 View Complete Implementation : HibernateKeyJsonValueStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public List<String> getNamespaces() {
    String hql = "select distinct namespace from KeyJsonValue";
    Query<String> query = getTypedQuery(hql);
    return query.list();
}

17 View Complete Implementation : HibernatePeriodStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public List<Period> getPeriodsBetweenDates(Date startDate, Date endDate) {
    String query = "from Period p where p.startDate >=:startDate and p.endDate <=:endDate";
    Query<Period> typedQuery = getQuery(query).setParameter("startDate", startDate).setParameter("endDate", endDate);
    return getList(typedQuery);
}

16 View Complete Implementation : HibernateMessageConversationStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public int deleteMessages(User sender) {
    replacedert.notNull(sender, "User must be specified");
    String sql = "delete from messageconversation_messages where messageid in (" + "select messageid from message where userid = " + sender.getId() + ")";
    getSqlQuery(sql).executeUpdate();
    String hql = "delete Message m where m.sender = :sender";
    Query query = getQuery(hql);
    query.setParameter("sender", sender);
    return query.executeUpdate();
}

16 View Complete Implementation : HibernateMessageConversationStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public int removeUserFromMessageConversations(User lastSender) {
    replacedert.notNull(lastSender, "User must be specified");
    String hql = "update MessageConversation m set m.lastSender = null where m.lastSender = :lastSender";
    Query query = getQuery(hql);
    query.setParameter("lastSender", lastSender);
    return query.executeUpdate();
}

16 View Complete Implementation : HibernateMessageConversationStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public int deleteUserMessages(User user) {
    replacedert.notNull(user, "User must be specified");
    String sql = "delete from messageconversation_usermessages where usermessageid in (" + "select usermessageid from usermessage where userid = " + user.getId() + ")";
    getSqlQuery(sql).executeUpdate();
    String hql = "delete UserMessage u where u.user = :user";
    Query query = getQuery(hql);
    query.setParameter("user", user);
    return query.executeUpdate();
}

16 View Complete Implementation : HibernatePotentialDuplicateStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public int getCountByQuery(PotentialDuplicateQuery query) {
    if (query.getTeis() != null && query.getTeis().size() > 0) {
        Query<Long> hibernateQuery = getTypedQuery("select count(*) from PotentialDuplicate pr where pr.teiA in (:uids)  or pr.teiB in (:uids)");
        hibernateQuery.setParameterList("uids", query.getTeis());
        return hibernateQuery.getSingleResult().intValue();
    } else {
        return getCount();
    }
}

16 View Complete Implementation : HibernateSMSCommandStore.java
Copyright BSD 3-Clause "New" or "Revised" License
Author : dhis2
@Override
public int countDataSetSmsCommands(DataSet dataSet) {
    Query<Long> query = getTypedQuery("select count(distinct c) from SMSCommand c where c.dataset=:dataSet");
    query.setParameter("dataSet", dataSet);
    // TODO rename data set property
    return query.getSingleResult().intValue();
}