use of jakarta.persistence.criteria.Root in project hibernate-orm by hibernate.
the class AbstractQueryCacheResultTransformerTest method testAliasToEntityMapNoProjectionNullAndNonNullAliasList.
@Test
public void testAliasToEntityMapNoProjectionNullAndNonNullAliasList(SessionFactoryScope scope) throws Exception {
CriteriaExecutor criteriaExecutor = new CriteriaExecutor() {
@Override
protected JpaCriteriaQuery getCriteria(Session s) {
final CriteriaBuilder builder = s.getSessionFactory().getCriteriaBuilder();
final JpaCriteriaQuery<Student> criteria = (JpaCriteriaQuery<Student>) builder.createQuery(Student.class);
final Root<Student> studentRoot = criteria.from(Student.class);
studentRoot.alias("s");
studentRoot.join("addresses", JoinType.LEFT).alias("a");
studentRoot.join("preferredCourse", JoinType.INNER);
criteria.orderBy(builder.asc(studentRoot.get("studentNumber")));
return criteria;
// return s.createCriteria( Student.class, "s" )
// .createAlias( "s.addresses", "a", CriteriaSpecification.LEFT_JOIN )
// .setResultTransformer( CriteriaSpecification.ALIAS_TO_ENTITY_MAP )
// .createCriteria( "s.preferredCourse", CriteriaSpecification.INNER_JOIN )
// .addOrder( Order.asc( "s.studentNumber") );
}
};
HqlExecutor hqlExecutor = new HqlExecutor() {
@Override
public Query getQuery(Session s) {
return s.createQuery("from Student s left join s.addresses a left join s.preferredCourse order by s.studentNumber").setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
}
};
ResultChecker checker = results -> {
List resultList = (List) results;
assertEquals(2, resultList.size());
Map yogiMap1 = (Map) resultList.get(0);
assertEquals(2, yogiMap1.size());
Map yogiMap2 = (Map) resultList.get(1);
assertEquals(2, yogiMap2.size());
assertEquals(yogiExpected, yogiMap1.get("s"));
Address yogiAddress1 = (Address) yogiMap1.get("a");
assertEquals(yogiExpected.getAddresses().get(yogiAddress1.getAddressType()), yogiMap1.get("a"));
assertEquals(yogiExpected, yogiMap2.get("s"));
Address yogiAddress2 = (Address) yogiMap2.get("a");
assertEquals(yogiExpected.getAddresses().get(yogiAddress2.getAddressType()), yogiMap2.get("a"));
assertSame(yogiMap1.get("s"), yogiMap2.get("s"));
assertNotEquals(yogiAddress1.getAddressType(), yogiAddress2.getAddressType());
};
runTest(hqlExecutor, criteriaExecutor, checker, false, scope);
}
use of jakarta.persistence.criteria.Root in project hibernate-orm by hibernate.
the class AbstractQueryCacheResultTransformerTest method testAliasToEntityMapMultiProjectionWithNullAliasList.
@Test
public void testAliasToEntityMapMultiProjectionWithNullAliasList(SessionFactoryScope scope) throws Exception {
CriteriaExecutor criteriaExecutor = new CriteriaExecutor() {
@Override
protected JpaCriteriaQuery getCriteria(Session s) {
CriteriaBuilder builder = s.getCriteriaBuilder();
JpaCriteriaQuery criteria = (JpaCriteriaQuery) builder.createQuery();
final JpaRoot<Enrolment> root = criteria.from(Enrolment.class);
criteria.multiselect(root.get("student").alias("student"), root.get("semester"), root.get("year"), root.get("course").alias("course"));
criteria.orderBy(builder.asc(root.get("studentNumber")));
return criteria;
// return s.createCriteria( Enrolment.class, "e" )
// .setProjection(
// Projections.projectionList()
// .add( Property.forName( "e.student" ), "student" )
// .add( Property.forName( "e.semester" ) )
// .add( Property.forName( "e.year" ) )
// .add( Property.forName( "e.course" ), "course" )
// )
// .addOrder( Order.asc( "e.studentNumber") )
// .setResultTransformer( Transformers.ALIAS_TO_ENTITY_MAP );
}
};
HqlExecutor hqlExecutor = new HqlExecutor() {
@Override
public Query getQuery(Session s) {
return s.createQuery("select e.student as student, e.semester, e.year, e.course as course from Enrolment e order by e.studentNumber").setResultTransformer(Transformers.ALIAS_TO_ENTITY_MAP);
}
};
ResultChecker checker = results -> {
List resultList = (List) results;
assertEquals(2, resultList.size());
Map yogiMap = (Map) resultList.get(0);
Map shermanMap = (Map) resultList.get(1);
// TODO: following are initialized for hql and uninitialied for criteria; why?
// assertFalse( Hibernate.isInitialized( yogiMap.get( "student" ) ) );
// assertFalse( Hibernate.isInitialized( shermanMap.get( "student" ) ) );
assertTrue(yogiMap.get("student") instanceof Student);
assertEquals(yogiExpected.getStudentNumber(), ((Student) yogiMap.get("student")).getStudentNumber());
assertEquals(shermanExpected.getStudentNumber(), ((Student) shermanMap.get("student")).getStudentNumber());
assertNull(yogiMap.get("semester"));
assertNull(yogiMap.get("year"));
assertEquals(courseExpected, yogiMap.get("course"));
assertNull(shermanMap.get("semester"));
assertNull(shermanMap.get("year"));
assertEquals(courseExpected, shermanMap.get("course"));
};
runTest(hqlExecutor, criteriaExecutor, checker, false, scope);
}
use of jakarta.persistence.criteria.Root in project hibernate-orm by hibernate.
the class AbstractQueryCacheResultTransformerTest method testEntityWithLazyAsList.
@Test
public void testEntityWithLazyAsList(SessionFactoryScope scope) throws Exception {
CriteriaExecutor criteriaExecutor = new CriteriaExecutor() {
@Override
protected ResultTransformer getResultTransformer() {
return null;
}
@Override
protected JpaCriteriaQuery getCriteria(Session s) {
CriteriaBuilder builder = s.getCriteriaBuilder();
JpaCriteriaQuery<Student> criteria = (JpaCriteriaQuery<Student>) builder.createQuery(Student.class);
JpaRoot<Student> root = criteria.from(Student.class);
criteria.orderBy(builder.asc(root.get("studentNumber")));
return criteria;
// return s.createCriteria( Student.class )
// .addOrder( Order.asc( "studentNumber" ) );
}
};
ResultChecker checker = results -> {
List resultList = (List) results;
assertEquals(2, resultList.size());
assertEquals(yogiExpected, resultList.get(0));
assertEquals(shermanExpected, resultList.get(1));
assertNotNull(((Student) resultList.get(0)).getEnrolments());
assertNotNull(((Student) resultList.get(0)).getPreferredCourse());
assertNotNull(((Student) resultList.get(1)).getEnrolments());
assertNull(((Student) resultList.get(1)).getPreferredCourse());
assertFalse(Hibernate.isInitialized(((Student) resultList.get(0)).getEnrolments()));
assertFalse(Hibernate.isInitialized(((Student) resultList.get(0)).getPreferredCourse()));
assertFalse(Hibernate.isInitialized(((Student) resultList.get(1)).getEnrolments()));
assertNull(((Student) resultList.get(1)).getPreferredCourse());
};
runTest(null, criteriaExecutor, checker, false, scope);
}
use of jakarta.persistence.criteria.Root in project hibernate-orm by hibernate.
the class AbstractQueryCacheResultTransformerTest method testOneNonEntityProjectionUnique.
@Test
public void testOneNonEntityProjectionUnique(SessionFactoryScope scope) throws Exception {
CriteriaExecutor criteriaExecutor = new CriteriaExecutor() {
@Override
protected ResultTransformer getResultTransformer() {
return null;
}
@Override
protected JpaCriteriaQuery getCriteria(Session s) {
// should use PassThroughTransformer by default
CriteriaBuilder builder = s.getCriteriaBuilder();
JpaCriteriaQuery criteria = (JpaCriteriaQuery) builder.createQuery();
Root<Enrolment> root = criteria.from(Enrolment.class);
criteria.select(root.get("semester"));
criteria.where(builder.equal(root.get("studentNumber"), shermanEnrolmentExpected.getStudentNumber()));
return criteria;
// return s.createCriteria( Enrolment.class, "e" )
// .setProjection( Projections.property( "e.semester" ) )
// .add( Restrictions.eq( "e.studentNumber", shermanEnrolmentExpected.getStudentNumber() ) );
}
};
HqlExecutor hqlExecutor = new HqlExecutor() {
@Override
public Query getQuery(Session s) {
return s.createQuery("select e.semester from Enrolment e where e.studentNumber = :studentNumber").setParameter("studentNumber", shermanEnrolmentExpected.getStudentNumber());
}
};
ResultChecker checker = results -> {
assertTrue(results instanceof Short);
assertEquals(shermanEnrolmentExpected.getSemester(), results);
};
runTest(hqlExecutor, criteriaExecutor, checker, true, scope);
}
use of jakarta.persistence.criteria.Root in project hibernate-orm by hibernate.
the class AbstractQueryCacheResultTransformerTest method testEntityWithSelectFetchedLazyOneToManySingleElementListCriteria.
@Test
public void testEntityWithSelectFetchedLazyOneToManySingleElementListCriteria(SessionFactoryScope scope) throws Exception {
CriteriaExecutor criteriaExecutorUnaliased = new CriteriaExecutor() {
@Override
protected ResultTransformer getResultTransformer() {
return null;
}
@Override
protected JpaCriteriaQuery getCriteria(Session s) {
CriteriaBuilder builder = s.getCriteriaBuilder();
JpaCriteriaQuery<Student> criteria = (JpaCriteriaQuery<Student>) builder.createQuery(Student.class);
JpaRoot<Student> root = criteria.from(Student.class);
root.join("enrolments");
criteria.orderBy(builder.asc(root.get("studentNumber")));
return criteria;
// return s.createCriteria( Student.class, "s" )
// .setFetchMode( "enrolments", FetchMode.SELECT )
// .addOrder( Order.asc( "s.studentNumber" ) );
}
};
ResultChecker checker = results -> {
List resultList = (List) results;
assertEquals(2, resultList.size());
assertEquals(yogiExpected, resultList.get(0));
assertEquals(shermanExpected, resultList.get(1));
assertNotNull(((Student) resultList.get(0)).getEnrolments());
assertFalse(Hibernate.isInitialized(((Student) resultList.get(0)).getEnrolments()));
assertNotNull(((Student) resultList.get(1)).getEnrolments());
assertFalse(Hibernate.isInitialized(((Student) resultList.get(1)).getEnrolments()));
};
runTest(null, criteriaExecutorUnaliased, checker, false, scope);
}
Aggregations