@Override public Spell findByName(String name) { Transaction tx = null; Spell result = null; try (Session session = getSessionFactory().openSession()) { tx = session.beginTransaction(); Criteria criteria = session.createCriteria(persistentClass); criteria.add(Restrictions.eq("name", name)); result = (Spell) criteria.uniqueResult(); tx.commit(); } catch (Exception e) { if (tx != null) { tx.rollback(); } throw e; } return result; } }
/** * Check if authority exists. * * @param authority the authority * @return true if authority exists */ public boolean isAuthorityExists(String authority) { Criteria criteria = getSession().createCriteria(Authority.class); criteria.add(Restrictions.eq(AUTHORITY_PROPERTY, authority)); List<Authority> resultList = criteria.list(); return !resultList.isEmpty(); }
@Override @SuppressWarnings({"unchecked", "deprecation"}) public <T> List<T> findByExample( @Nullable final String entityName, final T exampleEntity, final int firstResult, final int maxResults) throws DataAccessException { Assert.notNull(exampleEntity, "Example entity must not be null"); return nonNull(executeWithNativeSession((HibernateCallback<List<T>>) session -> { Criteria executableCriteria = (entityName != null ? session.createCriteria(entityName) : session.createCriteria(exampleEntity.getClass())); executableCriteria.add(Example.create(exampleEntity)); prepareCriteria(executableCriteria); if (firstResult >= 0) { executableCriteria.setFirstResult(firstResult); } if (maxResults > 0) { executableCriteria.setMaxResults(maxResults); } return executableCriteria.list(); })); }
@Test public void shouldNotRetrieveSubSubSubEntityWithCriteria() { session = openSession(); try { SubSubSubEntity loaded = (SubSubSubEntity) session.createCriteria( SubSubSubEntity.class ) .add( Restrictions.idEq( subSubEntityId ) ) .uniqueResult(); assertNull( loaded ); } finally { session.close(); } }
protected Criteria getCriteria(Session s) { // should use RootEntityTransformer by default return s.createCriteria( Student.class, "s" ) .add( Restrictions.eq( "studentNumber", shermanExpected.getStudentNumber() ) ); } };
return (T) sessionFactory.getCurrentSession().save(o); sessionFactory.getCurrentSession().delete(object); return (T) sessionFactory.getCurrentSession().get(type, id); final Session session = sessionFactory.getCurrentSession(); final Criteria crit = session.createCriteria(type); return crit.list();
@Override @SuppressWarnings({"unchecked", "deprecation"}) public <T> List<T> loadAll(final Class<T> entityClass) throws DataAccessException { return nonNull(executeWithNativeSession((HibernateCallback<List<T>>) session -> { Criteria criteria = session.createCriteria(entityClass); criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY); prepareCriteria(criteria); return criteria.list(); })); }
public ServerBackup lastBackup() { List results = (List) getHibernateTemplate().execute((HibernateCallback) session -> { Criteria criteria = session.createCriteria(ServerBackup.class); criteria.setMaxResults(1); criteria.addOrder(Order.desc("id")); return criteria.list(); }); return results.isEmpty() ? null : (ServerBackup) results.get(0); }
Criteria criteria = session.createCriteria( Seller.class, "s" ); criteria.createCriteria( "s.soldTo", "c", JoinType.INNER_JOIN, Restrictions.eq( "name", "join-table-customer1" ) ); criteria.setResultTransformer( Criteria.DISTINCT_ROOT_ENTITY ); @SuppressWarnings("unchecked") List<Seller> results = criteria.list(); assertTrue( results.size() == 1 ); assertTrue( results.contains( seller1 ) ); criteria = session.createCriteria( Seller.class, "s" ); criteria.createCriteria( "s.soldTo", "c", JoinType.INNER_JOIN, Restrictions.eq( "name", "join-table-customer2" ) ); criteria.setResultTransformer( Criteria.DISTINCT_ROOT_ENTITY ); List<Seller> results2 = criteria.list(); assertTrue( results2.size() == 2 ); assertTrue( results2.contains( seller1 ) );
private Criteria getCriteria(Session s) { Criteria crit = s.createCriteria( A.class, "anAlias" ); crit.add( Restrictions.naturalId().set( "name", "name1" ) ); crit.setFlushMode( FlushMode.COMMIT ); crit.setCacheable( true ); return crit; }
private State getState(Session s, String name) { Criteria criteria = s.createCriteria( State.class ); criteria.add( Restrictions.eq( "name", name ) ); criteria.setCacheable( true ); return (State) criteria.list().get( 0 ); }
public long enabledUserCount() { Long value = (Long) goCache.get(ENABLED_USER_COUNT_CACHE_KEY); if (value != null) { return value; } synchronized (ENABLED_USER_COUNT_CACHE_KEY) { value = (Long) goCache.get(ENABLED_USER_COUNT_CACHE_KEY); if (value == null) { value = hibernateTemplate().execute(session -> (Long) session.createCriteria(User.class).add(Restrictions.eq("enabled", true)).setProjection(Projections.rowCount()).setCacheable(true).uniqueResult()); goCache.put(ENABLED_USER_COUNT_CACHE_KEY, value); } return value; } }
@Test public void shouldRetrieveSubSubEntityWithCriteria() { session = openSession(); try { SubSubEntity loaded = (SubSubEntity) session.createCriteria( SubSubEntity.class ) .add( Restrictions.idEq( subSubEntityId ) ) .uniqueResult(); assertNotNull( loaded ); } finally { session.close(); } }
@Test public void testEnablingJoinFetchProfileAgainstSelfReferentialAssociation() { Session s = openSession(); s.beginTransaction(); s.enableFetchProfile( Employee.FETCH_PROFILE_TREE ); s.createCriteria( Employee.class ) .add( Restrictions.isNull( "manager" ) ) .list(); s.getTransaction().commit(); s.close(); } }
protected Criteria getCriteria(Session s) { // should use PassThroughTransformer by default return s.createCriteria( Enrolment.class ) .setProjection( Projections.property( "student" ) ) .add( Restrictions.eq( "studentNumber", Long.valueOf( yogiExpected.getStudentNumber() ) ) ); } };
/** * Use a Criteria query - see FORGE-247 */ public List listEventsWithCriteria() { Session session = sessionFactory.getCurrentSession(); session.beginTransaction(); List result = session.createCriteria(Event.class) .setCacheable(true) .list(); session.getTransaction().commit(); return result; }
@Override @SuppressWarnings({"unchecked", "deprecation"}) public <T> List<T> loadAll(final Class<T> entityClass) throws DataAccessException { return nonNull(executeWithNativeSession((HibernateCallback<List<T>>) session -> { Criteria criteria = session.createCriteria(entityClass); criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY); prepareCriteria(criteria); return criteria.list(); })); }
@Override public List<Offer> readOffersByAutomaticDeliveryType() { //TODO change this to a JPA criteria Criteria criteria = ((HibernateEntityManager) em).getSession().createCriteria(OfferImpl.class); Date myDate = getCurrentDateAfterFactoringInDateResolution(); Calendar c = Calendar.getInstance(); c.setTime(myDate); c.add(Calendar.DATE, +1); criteria.add(Restrictions.lt("startDate", c.getTime())); c = Calendar.getInstance(); c.setTime(myDate); c.add(Calendar.DATE, -1); criteria.add(Restrictions.or(Restrictions.isNull("endDate"), Restrictions.gt("endDate", c.getTime()))); criteria.add(Restrictions.or(Restrictions.eq("archiveStatus.archived", 'N'), Restrictions.isNull("archiveStatus.archived"))); criteria.add(Restrictions.eq("automaticallyAdded", true)); criteria.setCacheable(true); criteria.setCacheRegion("query.Offer"); return criteria.list(); }
private EntityMapEnum assertFindCriteria( EntityMapEnum expected, String mapPath, Object param) { assertNotEquals( 0, expected.id ); Session session = openNewSession(); session.beginTransaction(); EntityMapEnum found = (EntityMapEnum) session.createCriteria( EntityMapEnum.class ) .createCriteria( mapPath, "m" ) .add( Restrictions.eq( "indices", param ) ) .uniqueResult(); //find assetEntityMapEnumEquals( expected, found ); session.getTransaction().commit(); session.close(); return found; }
@Test public void testNaturalIdCriteria() { Session s = openSession(); s.beginTransaction(); Account u = new Account(new AccountId(1), "testAcct" ); s.persist( u ); s.getTransaction().commit(); s.close(); s = openSession(); s.beginTransaction(); u = ( Account ) s.createCriteria( Account.class ) .add( Restrictions.naturalId().set( "shortCode", "testAcct" ) ) .setCacheable( true ) .uniqueResult(); assertNotNull( u ); s.getTransaction().commit(); s.close(); s = openSession(); s.beginTransaction(); s.createQuery( "delete Account" ).executeUpdate(); s.getTransaction().commit(); s.close(); }