Search in sources :

Example 21 with Product

use of org.hibernate.jpa.test.metamodel.Product in project hibernate-orm by hibernate.

the class AggregationResultTest method testSumOfBigDecimals.

/**
 * Sum of BigDecimal should return a BigDecimal
 */
@Test
public void testSumOfBigDecimals() {
    EntityManager em = getOrCreateEntityManager();
    em.getTransaction().begin();
    CriteriaQuery<BigDecimal> criteria = builder.createQuery(BigDecimal.class);
    Root<Product> productRoot = criteria.from(Product.class);
    criteria.select(builder.sum(productRoot.get(Product_.someBigDecimal)));
    Object sumResult = em.createQuery(criteria).getSingleResult();
    assertReturnType(BigDecimal.class, sumResult);
    em.getTransaction().commit();
    em.close();
}
Also used : EntityManager(javax.persistence.EntityManager) Product(org.hibernate.jpa.test.metamodel.Product) BigDecimal(java.math.BigDecimal) Test(org.junit.Test) AbstractMetamodelSpecificTest(org.hibernate.jpa.test.metamodel.AbstractMetamodelSpecificTest)

Example 22 with Product

use of org.hibernate.jpa.test.metamodel.Product in project hibernate-orm by hibernate.

the class AggregationResultTest method testSumOfLongs.

/**
 * Sum of Longs should return a Long
 */
@Test
public void testSumOfLongs() {
    EntityManager em = getOrCreateEntityManager();
    em.getTransaction().begin();
    CriteriaQuery<Long> criteria = builder.createQuery(Long.class);
    Root<Product> productRoot = criteria.from(Product.class);
    criteria.select(builder.sum(productRoot.get(Product_.partNumber)));
    Object sumResult = em.createQuery(criteria).getSingleResult();
    assertReturnType(Long.class, sumResult);
    em.getTransaction().commit();
    em.close();
}
Also used : EntityManager(javax.persistence.EntityManager) Product(org.hibernate.jpa.test.metamodel.Product) Test(org.junit.Test) AbstractMetamodelSpecificTest(org.hibernate.jpa.test.metamodel.AbstractMetamodelSpecificTest)

Aggregations

EntityManager (javax.persistence.EntityManager)22 Product (org.hibernate.jpa.test.metamodel.Product)22 Test (org.junit.Test)20 AbstractMetamodelSpecificTest (org.hibernate.jpa.test.metamodel.AbstractMetamodelSpecificTest)18 BigInteger (java.math.BigInteger)2 MetamodelImpl (org.hibernate.metamodel.internal.MetamodelImpl)2 CriteriaBuilderImpl (org.hibernate.query.criteria.internal.CriteriaBuilderImpl)2 TestForIssue (org.hibernate.testing.TestForIssue)2 Before (org.junit.Before)2 BigDecimal (java.math.BigDecimal)1 TypedQuery (javax.persistence.TypedQuery)1 CriteriaBuilder (javax.persistence.criteria.CriteriaBuilder)1 CriteriaQuery (javax.persistence.criteria.CriteriaQuery)1 Predicate (javax.persistence.criteria.Predicate)1 Query (org.hibernate.Query)1 ComparisonPredicate (org.hibernate.query.criteria.internal.predicate.ComparisonPredicate)1 RequiresDialect (org.hibernate.testing.RequiresDialect)1 SkipForDialect (org.hibernate.testing.SkipForDialect)1