Example usage for org.hibernate.criterion DetachedCriteria add

List of usage examples for org.hibernate.criterion DetachedCriteria add

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. DetachedCriteria
  6. 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.DocumentTypeDaoImpl.java

License:Open Source License

/**
 * An API to fetch all DocumentType by batch instance id.
 * //from  w w  w  .jav a2s. co  m
 * @param batchInstanceIdentifier String
 * @return List<DocumentType>
 */
@Override
public List<DocumentType> getDocTypeByBatchInstanceIdentifier(String batchInstanceIdentifier) {
    LOG.info("batchInstanceID : " + batchInstanceIdentifier);
    DetachedCriteria criteria = criteria();
    DetachedCriteria subQuery = criteria(BatchInstance.class);
    subQuery.add(Restrictions.eq(DataAccessConstant.IDENTIFIER, batchInstanceIdentifier));
    subQuery.setProjection(Projections.property(DataAccessConstant.BATCH_CLASS_ID));
    criteria.add(Subqueries.propertyIn(DataAccessConstant.BATCH_CLASS_ID, subQuery));
    return find(criteria);
}

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

License:Open Source License

/**
 * An API to fetch all DocumentType by batch class id.
 * /*from w  w  w  .  ja v  a 2  s .  c o  m*/
 * @param batchClassIdentifier String
 * @param firstIndex int
 * @param maxResults int
 * @return List<DocumentType>
 */
@Override
public List<DocumentType> getDocTypeByBatchClassIdentifier(final String batchClassIdentifier,
        final int firstIndex, final int maxResults) {
    DetachedCriteria criteria = criteria();
    criteria.createAlias(DataAccessConstant.BATCHCLASS, DataAccessConstant.BATCHCLASS, JoinFragment.INNER_JOIN);
    criteria.add(Restrictions.eq(DataAccessConstant.BATCH_CLASS_IDENTIFIER, batchClassIdentifier));
    return find(criteria, firstIndex, maxResults);
}

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

License:Open Source License

/**
 * An API to fetch all DocumentType by document type name.
 * //w w w  . ja  v a  2  s.  c o  m
 * @param docTypeName String
 * @return List<DocumentType>
 */
@Override
public List<DocumentType> getDocTypeByDocTypeName(String docTypeName) {
    DetachedCriteria criteria = criteria();
    criteria.add(Restrictions.eq(DataAccessConstant.NAME, docTypeName));
    return find(criteria);
}

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

License:Open Source License

/**
 * An API to get document type based on document type identifier.
 * //from   ww  w  .j a v a  2s .  c  o  m
 * @param identifier String
 * @return DocumentType
 */
@Override
public DocumentType getDocTypeByIdentifier(String identifier) {
    DetachedCriteria criteria = criteria();
    criteria.add(Restrictions.eq(DataAccessConstant.IDENTIFIER, identifier));
    return this.findSingle(criteria);
}

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

License:Open Source License

/**
 * An API to fetch all DocumentType by batch class id.
 * //from  w ww  . j av a2  s .c  o  m
 * @param batchClassIdentifier String
 * @return List<DocumentType>
 */
@Override
public List<DocumentType> getDocTypeByBatchClassIdentifier(final String batchClassIdentifier) {
    DetachedCriteria criteria = criteria();
    criteria.createAlias(DataAccessConstant.BATCHCLASS, DataAccessConstant.BATCHCLASS, JoinFragment.INNER_JOIN);
    criteria.add(Restrictions.eq(DataAccessConstant.BATCH_CLASS_IDENTIFIER, batchClassIdentifier));
    return find(criteria);
}

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

License:Open Source License

@Override
public List<DocumentTypeMappingConfig> getDocumentTypeMappingConfigByConnectionId(long connectionID) {
    LOG.info(EphesoftStringUtil.concatenate("connection id is :", connectionID));
    DetachedCriteria criteria = criteria();
    criteria.add(Restrictions.or(Restrictions.eq(FUZZY_CONNECTION_ID, connectionID),
            Restrictions.eq(DB_EXPORT_CONNECTION_ID, connectionID)));
    return this.find(criteria);
}

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

License:Open Source License

@Override
public EncryptionKeyMetaData getApplicationKeyMetadata() {
    DetachedCriteria criteria = criteria();
    criteria.add(Restrictions.eq(DataAccessConstant.APPLICATION_KEY_ATTRIBUTE_NAME,
            DataAccessConstant.APPLICATION_KEY_ENTITY_ID_VALUE));
    return findSingle(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.
 * //  ww w  .jav a  2  s .  c  om
 * @param docTypeName String
 * @param batchInstanceIdentifierIdentifier String
 * @return List<FieldType>
 */
@Override
public List<FieldType> getFdTypeByDocTypeNameForBatchInstance(String docTypeName,
        String batchInstanceIdentifier) {

    LOG.info("batchInstanceID  : " + 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);
    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 get field type for a batch for a particular document.
 *  // w  w w .  jav a 2s . com
 * @param fieldTypeName String
 * @param docTypeName String
 * @param batchInstanceIdentifier String
 * @return FieldType
 */
@Override
public FieldType getFieldType(String fieldTypeName, String docTypeName, String batchInstanceIdentifier) {

    LOG.info("batchInstanceID  : " + batchInstanceIdentifier);
    DetachedCriteria criteria = criteria();
    criteria.add(Restrictions.eq(NAME, fieldTypeName));
    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);
    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));

    return findSingle(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.
 * /*from   www.ja v  a2 s  . co  m*/
 * @param documentType DocumentType
 * @return List<FieldType>
 */
@Override
public List<FieldType> getFdTypeByDocumentType(DocumentType documentType) {
    DetachedCriteria criteria = criteria();
    criteria.add(Restrictions.eq(DOC_TYPE, documentType));
    criteria.addOrder(org.hibernate.criterion.Order.asc(FIELD_ORDER_NUMBER));
    return find(criteria);
}