Example usage for org.hibernate.criterion DetachedCriteria add

Introduction

In this page you can find the example usage for org.hibernate.criterion DetachedCriteria add.

Prototype

public DetachedCriteria add(Criterion criterion)

Source Link

Document

Add a restriction

Usage

From source file:com.ephesoft.dcma.da.dao.hibernate.FieldTypeDaoImpl.java

License:Open Source License

/**
 * An API to fetch all Field types by document type name.
 * /*w  ww .  j  av  a  2  s .c  o  m*/
 * @param docTypeName String
 * @param batchInstanceIdentifier String
 * @param isKVExtraction boolean
 * @return List<FieldType>
 */
@Override
public List<FieldType> getFdTypeByDocumentTypeName(String docTypeName, String batchInstanceIdentifier,
        boolean isKVExtraction) {
    LOG.info("batchInstanceID ID  : " + batchInstanceIdentifier);
    DetachedCriteria criteria = criteria();
    criteria.createAlias(DOC_TYPE, DOC_TYPE, JoinFragment.INNER_JOIN);
    criteria.add(Restrictions.eq(DOC_TYPE_NAME, docTypeName));
    criteria.createAlias(DOC_TYPE_BATCH_CLASS, BATCH_CLASS1, JoinFragment.INNER_JOIN);

    if (isKVExtraction) {
        criteria.setFetchMode("kvExtraction", FetchMode.JOIN);
        criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);
    }

    DetachedCriteria subQuery = criteria(BatchInstance.class);
    subQuery.add(Restrictions.eq(IDENTIFIER, batchInstanceIdentifier));
    subQuery.createAlias(BATCH_CLASS, BATCH_CLASS2, JoinFragment.INNER_JOIN);
    subQuery.setProjection(Projections.property(BATCH_CLASS2_IDENTIFIER));
    criteria.add(Subqueries.propertyEq(BATCH_CLASS1_IDENTIFIER, subQuery));
    criteria.addOrder(org.hibernate.criterion.Order.asc(FIELD_ORDER_NUMBER));
    return find(criteria);
}

From source file:com.ephesoft.dcma.da.dao.hibernate.FieldTypeDaoImpl.java

License:Open Source License

/**
 * An API to fetch all Field types by document type name.
 * // www  .  j a  v a 2s  .com
 * @param docTypeName String
 * @param batchInstanceIdentifier String
 * @return List<FieldType>
 */
@Override
public List<FieldType> getFdTypeAndRegexValidationByDocTypeName(String docTypeName,
        String batchInstanceIdentifier) {

    LOG.info("batchInstanceID ID  : " + batchInstanceIdentifier);
    DetachedCriteria criteria = criteria();
    criteria.createAlias(DOC_TYPE, DOC_TYPE, JoinFragment.INNER_JOIN);
    criteria.add(Restrictions.eq(DOC_TYPE_NAME, docTypeName));
    criteria.createAlias(DOC_TYPE_BATCH_CLASS, BATCH_CLASS1, JoinFragment.INNER_JOIN);

    criteria.setFetchMode(REGEX_VALIDATION, FetchMode.JOIN);
    criteria.setResultTransformer(Criteria.DISTINCT_ROOT_ENTITY);

    DetachedCriteria subQuery = criteria(BatchInstance.class);
    subQuery.add(Restrictions.eq(IDENTIFIER, batchInstanceIdentifier));
    subQuery.createAlias(BATCH_CLASS, BATCH_CLASS2, JoinFragment.INNER_JOIN);
    subQuery.setProjection(Projections.property(BATCH_CLASS2_IDENTIFIER));
    criteria.add(Subqueries.propertyEq(BATCH_CLASS1_IDENTIFIER, subQuery));
    criteria.addOrder(org.hibernate.criterion.Order.asc(FIELD_ORDER_NUMBER));

    return find(criteria);

}

From source file:com.ephesoft.dcma.da.dao.hibernate.FieldTypeDaoImpl.java

License:Open Source License

/**
 * An API to fetch all Field types by document type name for a batch class.
 * /*www.  jav  a 2 s .  com*/
 * @param docTypeName String
 * @param batchClassIdentifier String
 * @return List<FieldType>
 */
@Override
public List<FieldType> getFdTypeByDocumentTypeNameForBatchClass(String docTypeName,
        String batchClassIdentifier) {
    LOG.info("batchClassID ID  : " + batchClassIdentifier);
    DetachedCriteria criteria = criteria();
    criteria.createAlias(DOC_TYPE, DOC_TYPE, JoinFragment.INNER_JOIN);
    criteria.add(Restrictions.eq(DOC_TYPE_NAME, docTypeName));
    criteria.createAlias(DOC_TYPE_BATCH_CLASS, BATCH_CLASS1, JoinFragment.INNER_JOIN);
    criteria.add(Restrictions.eq(BATCH_CLASS1_IDENTIFIER, batchClassIdentifier));
    criteria.addOrder(org.hibernate.criterion.Order.asc(FIELD_ORDER_NUMBER));
    return find(criteria);
}

From source file:com.ephesoft.dcma.da.dao.hibernate.KVExtractionDaoImpl.java

License:Open Source License

/**
 * An API to fetch all KV Extraction by field type.
 * // w  w  w . ja  v  a 2s . c  o  m
 * @param fieldType FieldType
 * @return List<KVExtraction>
 */
@Override
public List<KVExtraction> getKVExtractionByFieldType(FieldType fieldType) {
    LOG.info("field type : " + fieldType);
    DetachedCriteria criteria = criteria();
    criteria.add(Restrictions.eq("fieldType", fieldType));
    return find(criteria);
}

From source file:com.ephesoft.dcma.da.dao.hibernate.KVExtractionDaoImpl.java

License:Open Source License

/**
 * An API to check whether KVExtraction field already exists for a field type.
 * //from   w  ww  . jav  a 2  s .  com
 * @param fieldType FieldType
 * @param locationType LocationType
 * @param valuePattern String
 * @param keyPattern String
 * @return List<KVExtraction> 
 */
@Override
public List<KVExtraction> getDuplicateKVFields(FieldType fieldType, LocationType locationType,
        String keyPattern, String valuePattern) {
    LOG.info("field type : " + fieldType);
    DetachedCriteria criteria = criteria();
    criteria.add(Restrictions.eq("fieldType", fieldType));
    criteria.add(Restrictions.eq("locationType", locationType));
    criteria.add(Restrictions.eq("valuePattern", valuePattern));
    criteria.add(Restrictions.eq("keyPattern", keyPattern));
    return find(criteria);
}

From source file:com.ephesoft.dcma.da.dao.hibernate.LockStatusDaoImpl.java

License:Open Source License

@Override
public LockStatus getLockStatus(final FeatureName featureName) {
    final DetachedCriteria criteria = criteria();
    criteria.add(Restrictions.eq(FEATURE_NAME, featureName));
    return findSingle(criteria);
}

From source file:com.ephesoft.dcma.da.dao.hibernate.LockStatusDaoImpl.java

License:Open Source License

@Override
public List<LockStatus> getAllFeaturesLockedByUser(final String userName) {
    final DetachedCriteria criteria = criteria();
    criteria.add(Restrictions.eq(USER_NAME, userName));
    criteria.add(Restrictions.eq(IS_LOCKED, true));
    return find(criteria);
}

From source file:com.ephesoft.dcma.da.dao.hibernate.ManualStepHistoryDaoImpl.java

License:Open Source License

/**
 * An API to get the ManualStepHistoryInWorkflow object from batchInstanceId And Status.
 * /*from   www.  j ava  2 s.  c om*/
 * @param String batchInstanceId
 * @param String batchInstanceStatus
 * @param String userName
 * @return ManualStepHistoryInWorkflow
 */
@Override
public ManualStepHistoryInWorkflow getManualStepHistory(String batchInstanceId, String batchInstanceStatus,
        String userName) {
    LOGGER.info("Inside getManualStepHistory in ManualStepHistoryDaoImpl");
    DetachedCriteria criteria = criteria();
    criteria.add(Restrictions.eq("batchInstanceId", batchInstanceId));
    criteria.add(Restrictions.eq("batchInstanceStatus", batchInstanceStatus));
    criteria.add(Restrictions.eq("userName", userName));
    criteria.add(Restrictions.eq("endTime", new Date(0L)));
    ManualStepHistoryInWorkflow manualStepHistoryInWorkflow = null;
    List<ManualStepHistoryInWorkflow> resultList = find(criteria);
    if (resultList != null && resultList.size() > 0) {
        manualStepHistoryInWorkflow = resultList.get(0);
    }
    return manualStepHistoryInWorkflow;
}

From source file:com.ephesoft.dcma.da.dao.hibernate.ManualStepHistoryDaoImpl.java

License:Open Source License

/**
 * An API to get the existing ManualStepHistoryInWorkflow object from batchInstanceId ,Status and username.
 * //from  w  w  w. ja v a 2s. c  o  m
 * @param String batchInstanceId
 * @param String batchInstanceStatus
 * @param String userName
 * @return ManualStepHistoryInWorkflow
 */
@Override
public ManualStepHistoryInWorkflow getExistingManualStepHistory(String batchInstanceId,
        String batchInstanceStatus, String userName) {
    LOGGER.info("Inside getExistingManualStepHistory in ManualStepHistoryDaoImpl");
    DetachedCriteria criteria = criteria();
    criteria.add(Restrictions.eq("batchInstanceId", batchInstanceId));
    criteria.add(Restrictions.eq("batchInstanceStatus", batchInstanceStatus));
    criteria.add(Restrictions.eq("userName", userName));
    ManualStepHistoryInWorkflow manualStepHistoryInWorkflow = null;
    List<ManualStepHistoryInWorkflow> resultList = find(criteria);
    if (resultList != null && resultList.size() > 0) {
        manualStepHistoryInWorkflow = resultList.get(0);
    }
    return manualStepHistoryInWorkflow;

}

From source file:com.ephesoft.dcma.da.dao.hibernate.ModuleConfigDaoImpl.java

License:Open Source License

/**
 * API to get module by child name.// ww w .  j a  v  a 2s. com
 * 
 * @param childName String
 * @return List<ModuleConfig>
 */
@Override
public List<ModuleConfig> getModuleByChildName(String childName) {
    DetachedCriteria criteria = criteria();
    if (childName != null) {
        criteria.add(Restrictions.eq(CHILD_KEY, childName));
    } else {
        criteria.add(Restrictions.isNull(CHILD_KEY));
    }
    return this.find(criteria);
}