use of org.hibernate.jpa.test.metamodel.Product in project hibernate-orm by hibernate.
the class ExpressionsTest method testInExplicitTupleListVarargs.
@Test
public void testInExplicitTupleListVarargs() {
EntityManager em = getOrCreateEntityManager();
em.getTransaction().begin();
CriteriaQuery<Product> criteria = builder.createQuery(Product.class);
Root<Product> from = criteria.from(Product.class);
criteria.where(from.get(Product_.partNumber).in(((long) Integer.MAX_VALUE) + 1));
List<Product> result = em.createQuery(criteria).getResultList();
assertEquals(1, result.size());
em.getTransaction().commit();
em.close();
}
use of org.hibernate.jpa.test.metamodel.Product in project hibernate-orm by hibernate.
the class ExpressionsTest method testEmptyDisjunctionIsFalse.
@Test
public void testEmptyDisjunctionIsFalse() {
EntityManager em = getOrCreateEntityManager();
em.getTransaction().begin();
CriteriaQuery<Product> criteria = builder.createQuery(Product.class);
criteria.from(Product.class);
criteria.where(builder.isFalse(builder.disjunction()));
List<Product> result = em.createQuery(criteria).getResultList();
assertEquals(1, result.size());
em.getTransaction().commit();
em.close();
}
use of org.hibernate.jpa.test.metamodel.Product in project hibernate-orm by hibernate.
the class AggregationResultTest method testSumOfFloats.
/**
* Sum of Floats should return a Float; note that this is distinctly different than JPAQL
*/
@Test
public void testSumOfFloats() {
EntityManager em = getOrCreateEntityManager();
em.getTransaction().begin();
CriteriaQuery<Float> criteria = builder.createQuery(Float.class);
Root<Product> productRoot = criteria.from(Product.class);
criteria.select(builder.sum(productRoot.get(Product_.rating)));
Object sumResult = em.createQuery(criteria).getSingleResult();
assertReturnType(Float.class, sumResult);
em.getTransaction().commit();
em.close();
}
use of org.hibernate.jpa.test.metamodel.Product in project hibernate-orm by hibernate.
the class AggregationResultTest method testSumOfBigIntegers.
/**
* Sum of BigInteger should return a BigInteger
*/
@Test
public void testSumOfBigIntegers() {
EntityManager em = getOrCreateEntityManager();
em.getTransaction().begin();
CriteriaQuery<BigInteger> criteria = builder.createQuery(BigInteger.class);
Root<Product> productRoot = criteria.from(Product.class);
criteria.select(builder.sum(productRoot.get(Product_.someBigInteger)));
Object sumResult = em.createQuery(criteria).getSingleResult();
assertReturnType(BigInteger.class, sumResult);
em.getTransaction().commit();
em.close();
}
use of org.hibernate.jpa.test.metamodel.Product in project hibernate-orm by hibernate.
the class AggregationResultTest method testSumOfDoubles.
/**
* Sum of Doubles should return a Double
*/
@Test
public void testSumOfDoubles() {
EntityManager em = getOrCreateEntityManager();
em.getTransaction().begin();
CriteriaQuery<Double> criteria = builder.createQuery(Double.class);
Root<Product> productRoot = criteria.from(Product.class);
criteria.select(builder.sum(productRoot.get(Product_.price)));
Object sumResult = em.createQuery(criteria).getSingleResult();
assertReturnType(Double.class, sumResult);
em.getTransaction().commit();
em.close();
}
Aggregations