@Override
public Iterable<T> findUsingQueryModel(QueryModel queryModel) {
if (accessControlContextProvider == null
|| roleAllowsAccess(queryModel.getAccessControlContext().getRole())) {
Criteria criteria = buildCriteria(queryModel);
if (queryModel.getSorts() != null) {
for (Sort sort : queryModel.getSorts()) {
criteria.addOrder(
sort.getSortDirection() == SortDirection.Ascending
? Order.asc(sort.getField())
: Order.desc(sort.getField()));
}
}
if (queryModel.getMaxResults() > 0) {
criteria.setMaxResults(queryModel.getMaxResults());
}
if (queryModel.getFirstResult() > 0) {
criteria.setFirstResult(queryModel.getFirstResult());
}
//noinspection unchecked
return criteria.list();
} else {
//noinspection unchecked
return createEntryBasedQuery(queryModel).list();
}
}
@Override
public T findUniqueUsingQueryModel(QueryModel queryModel) throws NoSuchItemException {
T result;
if (accessControlContextProvider == null
|| roleAllowsAccess(queryModel.getAccessControlContext().getRole())) {
// noinspection unchecked
result = (T) buildCriteria(queryModel).uniqueResult();
} else {
// noinspection unchecked
result = (T) createEntryBasedQuery(queryModel).uniqueResult();
}
if (result == null) {
throw new NoSuchItemException(persistentClass.getSimpleName(), queryModel.toString());
}
return result;
}
// TODO: Add projection, maxResults, firstResult support
private Query createEntryBasedQuery(QueryModel queryModel) {
Criteria criteria = getCurrentSession().createCriteria(persistentClass);
for (String associationPath : queryModel.getAssociationConditions().keySet()) {
criteria.createCriteria(associationPath);
}
CriteriaQueryTranslator criteriaQueryTranslator =
new CriteriaQueryTranslator(
(SessionFactoryImplementor) sessionFactory,
(CriteriaImpl) criteria,
persistentClass.getName(),
CriteriaQueryTranslator.ROOT_SQL_ALIAS);
StringBuilder queryStringBuilder = new StringBuilder();
buildSelectClause(
queryStringBuilder,
criteriaQueryTranslator,
queryModel.getAssociationConditions().keySet());
List<TypedValue> parameters =
buildWhereClause(queryStringBuilder, queryModel, criteria, criteriaQueryTranslator);
if ((queryModel.getAssociationConditions() == null
|| queryModel.getAssociationConditions().isEmpty())
&& (queryModel.getSorts() == null || queryModel.getSorts().isEmpty())) {
buildDefaultOrderClause(queryStringBuilder);
} else {
// can't use the default ordering by "ace.id" because of "select distinct..." syntax
buildOrderClause(queryStringBuilder, queryModel, criteria, criteriaQueryTranslator);
}
Query query = getCurrentSession().createQuery(queryStringBuilder.toString());
setParameters(parameters, query, queryModel.getAccessControlContext());
return query;
}