Example usage for org.hibernate.criterion Criterion getTypedValues

Introduction

In this page you can find the example usage for org.hibernate.criterion Criterion getTypedValues.

Prototype

public TypedValue[] getTypedValues(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException;

Source Link

Document

Return typed values for all parameters in the rendered SQL fragment

Usage

From source file:gov.nih.nci.cabig.ctms.tools.hibernate.MoreRestrictionsTest.java

License:BSD License

public void testShortInListPreservesValues() throws Exception {
    Criterion actual = MoreRestrictions.in("foo", createNumberList(3), 10);
    TypedValue[] actualValues = actual.getTypedValues(null, criteriaQuery);
    for (int i = 0; i < actualValues.length; i++) {
        assertEquals("value " + i + " is wrong", i + 1, actualValues[i].getValue());
    }//w  ww  . j  av a  2 s  .  c  om
    assertEquals("Wrong number of actual values", 3, actualValues.length);
}

---

From source file:gov.nih.nci.cabig.ctms.tools.hibernate.MoreRestrictionsTest.java

License:BSD License

public void testLongInListPreservesValues() throws Exception {
    Criterion actual = MoreRestrictions.in("foo", createNumberList(5), 3);
    TypedValue[] actualValues = actual.getTypedValues(null, criteriaQuery);
    for (int i = 0; i < actualValues.length; i++) {
        assertEquals("value " + i + " is wrong", i + 1, actualValues[i].getValue());
    }/*from  w w w  .ja v  a  2  s.  c om*/
    assertEquals("Wrong number of actual values", 5, actualValues.length);
}

---

From source file:org.iternine.jeppetto.dao.hibernate.HibernateQueryModelDAO.java

License:Apache License

private List<TypedValue> buildWhereClause(StringBuilder queryStringBuilder, QueryModel queryModel,
        Criteria criteria, CriteriaQueryTranslator criteriaQueryTranslator) {
    List<TypedValue> parameters = new ArrayList<TypedValue>();

    queryStringBuilder.append(" where ");

    if (queryModel.getConditions() != null) {
        for (Condition condition : queryModel.getConditions()) {
            Criterion criterion = (Criterion) condition.getConstraint();

            queryStringBuilder.append(criterion.toSqlString(criteria, criteriaQueryTranslator));
            queryStringBuilder.append(" and ");

            parameters.addAll(Arrays.asList(criterion.getTypedValues(criteria, criteriaQueryTranslator)));
        }/*from w w w . j av a 2 s .  co  m*/
    }

    if (queryModel.getAssociationConditions() != null) {
        for (Map.Entry<String, List<Condition>> associationCriteriaEntry : queryModel.getAssociationConditions()
                .entrySet()) {
            CriteriaImpl.Subcriteria associationCriteria = (CriteriaImpl.Subcriteria) criteriaQueryTranslator
                    .getCriteria(associationCriteriaEntry.getKey());

            for (Condition condition : associationCriteriaEntry.getValue()) {
                Criterion criterion = (Criterion) condition.getConstraint();

                queryStringBuilder.append(criterion.toSqlString(associationCriteria, criteriaQueryTranslator));
                queryStringBuilder.append(" and ");

                parameters.addAll(
                        Arrays.asList(criterion.getTypedValues(associationCriteria, criteriaQueryTranslator)));
            }
        }
    }

    queryStringBuilder.append(" ace.objectType = '");
    queryStringBuilder.append(persistentClass.getSimpleName());
    queryStringBuilder.append("' and ace.objectId = ");
    queryStringBuilder.append(criteriaQueryTranslator.getRootSQLALias());
    queryStringBuilder.append('.');
    queryStringBuilder.append(idField);
    queryStringBuilder.append(" and ace.accessibleBy = ? ");

    return parameters;
}

---