@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(); }
/** * Find user by username. * * @param userName the username of user * @return user */ public User findByUserName(String userName) { Criteria criteria = getCriteria(); criteria.add(Restrictions.eq(USERNAME_PROPERTY, userName)); return (User) criteria.uniqueResult(); }
protected Criteria getCriteria(Session s) { // should use RootEntityTransformer by default return s.createCriteria( Student.class, "s" ) .add( Restrictions.eq( "studentNumber", shermanExpected.getStudentNumber() ) ); } };
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 ) );
@Override public LogSchema findLatestLogSchemaByAppId(String applicationId) { LOG.debug("Searching latest log schema by application id [{}]", applicationId); LogSchema logSchema = null; if (isNotBlank(applicationId)) { Criteria criteria = getCriteria(); criteria.createAlias(APPLICATION_PROPERTY, APPLICATION_ALIAS); Criterion criterion = Restrictions.eq(APPLICATION_REFERENCE, Long.valueOf(applicationId)); logSchema = (LogSchema) criteria.add(criterion).addOrder(Order.desc(VERSION_PROPERTY)) .setMaxResults(FIRST).uniqueResult(); } if (LOG.isTraceEnabled()) { LOG.trace("[{}] Search result: {}.", applicationId, logSchema); } else { LOG.debug("[{}] Search result: {}.", applicationId, logSchema != null); } return logSchema; }
public EnvironmentVariables load(final Long entityId, final EnvironmentVariableType type) { List<EnvironmentVariable> result = (List<EnvironmentVariable>) transactionTemplate.execute((TransactionCallback) transactionStatus -> { Criteria criteria = sessionFactory.getCurrentSession().createCriteria(EnvironmentVariable.class).add(Restrictions.eq("entityId", entityId)).add( Restrictions.eq("entityType", type.toString())).addOrder(Order.asc("id")); criteria.setCacheable(true); return criteria.list(); }); return new EnvironmentVariables(result); }
@Override public Object doInTransaction(TransactionStatus transactionStatus) { return sessionFactory.getCurrentSession() .createCriteria(PipelineState.class) .add(Restrictions.eq("pipelineName", pipelineName)) .setCacheable(false).uniqueResult(); } });
/** * Find user by password reset hash. * * @param passwordResetHash the password reset hash * @return user */ public User findByPasswordResetHash(String passwordResetHash) { Criteria criteria = getCriteria(); criteria.add(Restrictions.eq(PASSWORD_RESET_HASH_PROPERTY, passwordResetHash)); return (User) criteria.uniqueResult(); }
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() ) ) ); } };
Criteria criteria = session.createCriteria( Customer.class, "c" ); criteria.createCriteria( "c.boughtFrom", "s", JoinType.INNER_JOIN, Restrictions.eq( "name", "mappedby-seller1" ) ); criteria.setResultTransformer( Criteria.DISTINCT_ROOT_ENTITY ); @SuppressWarnings("unchecked") List<Customer> results = criteria.list(); assertTrue( results.size() == 2 ); assertTrue( results.contains( customer1 ) ); criteria = session.createCriteria( Customer.class, "c" ); criteria.createCriteria( "c.boughtFrom", "s", JoinType.INNER_JOIN, Restrictions.eq( "name", "mappedby-seller2" ) ); criteria.setResultTransformer( Criteria.DISTINCT_ROOT_ENTITY ); @SuppressWarnings("unchecked") List<Customer> results2 = criteria.list(); assertTrue( results2.size() == 2 ); assertFalse( results2.contains( customer1 ) );
criteria.createAlias(ENDPOINT_GROUP_PROPERTY, ENDPOINT_GROUP_ALIAS); Criterion crit = Restrictions.and( Restrictions.eq(ENDPOINT_GROUP_REFERENCE, Long.valueOf(groupId)), buildEqIdCriterion(ENDPOINT_PROFILE_SCHEMA_REFERENCE, endpointProfileSchemaId), buildEqIdCriterion(SERVER_PROFILE_SCHEMA_REFERENCE, serverProfileSchemaId), Restrictions.eq(STATUS_PROPERTY, UpdateStatus.DEPRECATED)); filter = (ProfileFilter) criteria.add(crit).addOrder(Order.desc(SEQUENCE_NUMBER_PROPERTY)) .setMaxResults(FIRST).uniqueResult();
@Override public Object doInTransaction(TransactionStatus status) { PropertyProjection pipelineName = Projections.property("pipelineName"); Criteria criteria = sessionFactory.getCurrentSession().createCriteria(PipelineState.class).setProjection(pipelineName).add( Restrictions.eq("locked", true)); criteria.setCacheable(false); List<String> list = criteria.list(); return list; } });
@Override public VersionInfo findByComponentName(final String name) { return (VersionInfo) transactionTemplate.execute((TransactionCallback) transactionStatus -> sessionFactory.getCurrentSession() .createCriteria(VersionInfo.class) .add(Restrictions.eq("componentName", name)) .setCacheable(true).uniqueResult()); }
/** * Find user by username or email. * * @param usernameOrMail the username or email of user * @return user */ public User findByUsernameOrMail(String usernameOrMail) { Criteria criteria = getCriteria(); Criterion usernameCriterion = Restrictions.eq(USERNAME_PROPERTY, usernameOrMail); Criterion mailCriterion = Restrictions.eq(MAIL_PROPERTY, usernameOrMail); criteria.add(Restrictions.or(usernameCriterion, mailCriterion)); return (User) criteria.uniqueResult(); }
protected Criteria getCriteria(Session s) { // should use PassThroughTransformer by default return s.createCriteria( Enrolment.class, "e" ) .setProjection( Projections.property( "e.semester" ) ) .add( Restrictions.eq( "e.studentNumber", shermanEnrolmentExpected.getStudentNumber() ) ); } };
s.getTransaction().begin(); Criteria rootCriteria = s.createCriteria( Order.class, "o" ); Criteria subCriteria = rootCriteria.createCriteria( "orderLines", Restrictions.or( Restrictions.isNull( "ol.articleId" ), // Allow null Restrictions.eq( "ol.articleId", "1000" ) List orders = rootCriteria.setResultTransformer( Criteria.ALIAS_TO_ENTITY_MAP ).list();
public Users findNotificationSubscribingUsers() { return (Users) transactionTemplate.execute((TransactionCallback) transactionStatus -> { Criteria criteria = sessionFactory.getCurrentSession().createCriteria(User.class); criteria.setCacheable(true); criteria.add(Restrictions.isNotEmpty("notificationFilters")); criteria.add(Restrictions.eq("enabled", true)); return new Users(criteria.list()); }); }
@Override public JobAgentMetadata load(final Long jobId) { return (JobAgentMetadata) transactionTemplate.execute((TransactionCallback) transactionStatus -> sessionFactory.getCurrentSession() .createCriteria(JobAgentMetadata.class) .add(Restrictions.eq("jobId", jobId)) .setCacheable(true).uniqueResult()); }