Refine search
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 EndpointProfileSchema findLatestByAppId(String appId) { EndpointProfileSchema latestSchema = null; LOG.debug("Searching latest profile schema by application id [{}] ", appId); if (isNotBlank(appId)) { Criteria criteria = getCriteria().createAlias(APPLICATION_PROPERTY, APPLICATION_ALIAS) .add(Restrictions.eq(APPLICATION_REFERENCE, Long.valueOf(appId))) .addOrder(Order.desc(VERSION_PROPERTY)).setMaxResults(FIRST); latestSchema = findOneByCriteria(criteria); } if (LOG.isTraceEnabled()) { LOG.trace("[{}] Search result: {}.", appId, latestSchema); } else { LOG.debug("[{}] Search result: {}.", appId, latestSchema != null); } return latestSchema; }
@Override public List<CtlSchema> findAllByMetaInfoId(String metaInfoId) { LOG.debug("Searching available version of ctl schema by meta info id [{}]", metaInfoId); Criteria criteria = getCriteria() .createAlias(CTL_SCHEMA_META_INFO_PROPERTY, CTL_SCHEMA_META_INFO_ALIAS) .add(Restrictions.eq(CTL_SCHEMA_META_INFO_ALIAS_ID, Long.valueOf(metaInfoId))) .addOrder(Order.asc(CTL_SCHEMA_VERSION)); List<CtlSchema> schemas = findListByCriteria(criteria); if (LOG.isTraceEnabled()) { LOG.trace("Search result: [{}].", Arrays.toString(schemas.toArray())); } else { LOG.debug("Search result: [{}].", schemas.size()); } return schemas; }
@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; }
/** * @see org.openmrs.api.db.ConceptDAO#getPrevConcept(org.openmrs.Concept) */ @Override @SuppressWarnings("unchecked") public Concept getPrevConcept(Concept c) { Integer i = c.getConceptId(); List<Concept> concepts = sessionFactory.getCurrentSession().createCriteria(Concept.class).add( Restrictions.lt("conceptId", i)).addOrder(Order.desc("conceptId")).setFetchSize(1).list(); if (concepts.isEmpty()) { return null; } return concepts.get(0); }
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); }
CTL_SCHEMA_META_INFO_PROPERTY, CTL_SCHEMA_META_INFO_ALIAS) .add(Restrictions.and( Restrictions.eq(CTL_SCHEMA_META_INFO_ALIAS_FQN, fqn), tenantId != null ? Restrictions.eq( CTL_SCHEMA_META_INFO_ALIAS_TENANT_ID, Long.valueOf(tenantId)) : Restrictions.isNull(CTL_SCHEMA_META_INFO_ALIAS_TENANT_ID), applicationId != null ? Restrictions.eq( CTL_SCHEMA_META_INFO_ALIAS_APPLICATION_ID, Long.valueOf(applicationId)) : Restrictions.isNull(CTL_SCHEMA_META_INFO_ALIAS_APPLICATION_ID)) ).addOrder(Order.asc(CTL_SCHEMA_VERSION));
@Override public ConfigurationSchema findLatestByApplicationId(String appId) { ConfigurationSchema latestSchema = null; LOG.debug("Searching latest configuration schema by application id [{}] ", appId); if (isNotBlank(appId)) { Criteria criteria = getCriteria().createAlias(APPLICATION_PROPERTY, APPLICATION_ALIAS) .add(Restrictions.eq(APPLICATION_REFERENCE, Long.valueOf(appId))) .addOrder(Order.desc(VERSION_PROPERTY)) .setMaxResults(FIRST); latestSchema = findOneByCriteria(criteria); } if (LOG.isTraceEnabled()) { LOG.trace("[{}] Search result: {}.", appId, latestSchema); } else { LOG.debug("[{}] Search result: {}.", appId, latestSchema != null); } return latestSchema; }
@Override public List<AssignedProductOptionDTO> findAssignedProductOptionsByProductId(Long productId) { Session session = em.unwrap(Session.class); Criteria criteria = session.createCriteria(SkuProductOptionValueXrefImpl.class); List dtoList = criteria .createAlias("sku", "sku") .createAlias("sku.product", "product") .createAlias("productOptionValue", "productOptionValue") .createAlias("productOptionValue.productOption", "productOption") .setProjection(Projections.distinct( Projections.projectionList() .add(Projections.property("product.id"), "productId") .add(Projections.property("productOption.attributeName"), "productOptionAttrName") .add(Projections.property("productOptionValue"), "productOptionValue") .add(Projections.property("sku"), "sku") ) ).setResultTransformer(Transformers.aliasToBean(AssignedProductOptionDTO.class)) .add(Restrictions.eq("product.id", productId)) .addOrder(Order.asc("productOption.attributeName")).list(); List<AssignedProductOptionDTO> results = new ArrayList<>(); for (Object o : dtoList) { AssignedProductOptionDTO dto = (AssignedProductOptionDTO) o; if (dto.getSku().isActive()) { results.add(dto); } } return results; }
@Override public NotificationSchema findLatestNotificationSchemaByAppId( String appId, NotificationTypeDto type) { LOG.debug("Searching latest notification schema by application id [{}] type [{}]", appId, type); NotificationSchema latestSchema = null; if (isNotBlank(appId)) { Criteria criteria = getCriteria().add(Restrictions.and( Restrictions.eq(APPLICATION_REFERENCE, Long.valueOf(appId)), Restrictions.eq(NOTIFICATION_SCHEMA_TYPE_PROPERTY, type) )).addOrder(Order.desc(VERSION_PROPERTY)).setMaxResults(FIRST); latestSchema = findOneByCriteria(criteria); } if (LOG.isTraceEnabled()) { LOG.trace("[{},{}] Search result: {}.", appId, type, latestSchema); } else { LOG.debug("[{},{}] Search result: {}.", appId, type, latestSchema != null); } return latestSchema; } }