Example usage for org.hibernate.criterion Restrictions disjunction

List of usage examples for org.hibernate.criterion Restrictions disjunction

  1. HOME
  2. Java
  3. org.hibernate
  4. org.hibernate.criterion.*
  5. Restrictions
  6. disjunction

Introduction

In this page you can find the example usage for org.hibernate.criterion Restrictions disjunction.

Prototype

public static Disjunction disjunction()

Source Link

Document

Group expressions together in a single disjunction (A or B or C...).

Usage

From source file:com.eharmony.matching.seeking.translator.hibernate.HibernateQueryTranslator.java

License:Apache License

@Override
public Criterion or(Criterion... subqueries) {
    Disjunction disjunction = Restrictions.disjunction();
    for (Criterion criterion : subqueries) {
        disjunction.add(criterion);/*w w  w . ja va 2  s . co m*/
    }
    return disjunction;
}

From source file:com.emergya.persistenceGeo.dao.impl.FolderEntityDaoHibernateImpl.java

License:Open Source License

/**
 * Get all channel folders filtered//ww  w  . j  a  v a 2s  . c  o m
 * 
 * @param inZone indicates if obtain channel folders with a zone. If this parameter is null only obtain not zoned channels
 * @param idZone filter by zone. Obtain only channels of the zone identified by <code>idZone</code>
  * @param <code>isEnabled</code>
 * 
 * @return folder list
 */
public List<AbstractFolderEntity> getChannelFolders(Boolean inZone, Long idZone, Boolean isEnable) {
    Criteria criteria = getSession().createCriteria(persistentClass);
    //FIXME: remove this fixme when merge
    if (inZone != null) {
        if (inZone) {
            criteria.add(Restrictions.isNotNull(ZONE));
        } else {
            criteria.add(Restrictions.isNull(ZONE));
        }
    }
    if (idZone != null) {
        criteria.createAlias(ZONE, ZONE).add(Restrictions.eq(ZONE + ".id", idZone));
    }
    if (isEnable != null && isEnable) {
        criteria.add(Restrictions.eq("enabled", isEnable));
    } else if (isEnable != null) {
        Disjunction dis = Restrictions.disjunction();
        dis.add(Restrictions.isNull("enabled"));
        dis.add(Restrictions.eq("enabled", Boolean.FALSE));
        criteria.add(dis);
    }
    // only parent folders
    criteria.add(Restrictions.isNull(PARENT));
    criteria.addOrder(Order.asc("name"));

    return criteria.list();

}

From source file:com.emergya.persistenceGeo.dao.impl.FolderEntityDaoHibernateImpl.java

License:Open Source License

/**
 * Get a folders list by zones. If zoneId is NULL returns all the
 * folder not associated to any zone.//from  w ww.  j  a  va2s.  c om
 *
 * @param <code>zoneId</code>
 * @param <code>isEnabled</code>
 *
 * @return Entities list associated with the zoneId or null if not found
 */
public List<AbstractFolderEntity> findByZone(Long zoneId, Boolean isEnable) {
    List<AbstractFolderEntity> folderList = new LinkedList<AbstractFolderEntity>();
    Criteria criteria = getSession().createCriteria(persistentClass).createAlias("zone", "zone")
            .add(Restrictions.eq("zone.id", zoneId));
    if (isEnable != null && isEnable) {
        criteria.add(Restrictions.eq("enabled", isEnable));
    } else if (isEnable != null) {
        Disjunction dis = Restrictions.disjunction();
        dis.add(Restrictions.isNull("enabled"));
        dis.add(Restrictions.eq("enabled", Boolean.FALSE));
        criteria.add(dis);
    }
    folderList.addAll(criteria.list());
    return folderList;
}

From source file:com.emergya.persistenceGeo.dao.impl.FolderEntityDaoHibernateImpl.java

License:Open Source License

/**
 * Get a folders list by zones with an specific parent. If zoneId is NULL
 * returns all the folder not associated to any zone. If parentId is NULL
 * the returned folders are root folders.
 *
 * @param <code>zoneId</code>
 * @param <code>parentId</code>
 * @param <code>isEnabled</code>
 *
 * @return Entities list associated with the zoneId or null if not found
 *//*from ww w .java 2s.  com*/
public List<AbstractFolderEntity> findByZone(Long zoneId, Long parentId, Boolean isEnable) {
    List<AbstractFolderEntity> folderList = new LinkedList<AbstractFolderEntity>();
    Criteria criteria = getSession().createCriteria(persistentClass);

    if (zoneId != null) {
        criteria.createAlias("zone", "zone").add(Restrictions.eq("zone.id", zoneId));
    }

    if (parentId == null) {
        criteria.add(Restrictions.isNull("parent"));
    } else {
        criteria.createAlias("parent", "parent");
        criteria.add(Restrictions.eq("parent.id", parentId));
    }
    if (isEnable != null && isEnable) {
        criteria.add(Restrictions.eq("enabled", isEnable));
    } else if (isEnable != null) {
        Disjunction dis = Restrictions.disjunction();
        dis.add(Restrictions.isNull("enabled"));
        dis.add(Restrictions.eq("enabled", Boolean.FALSE));
        criteria.add(dis);
    }
    folderList.addAll(criteria.list());
    return folderList;
}

From source file:com.emergya.persistenceGeo.dao.impl.LayerEntityDaoHibernateImpl.java

License:Open Source License

/**
 * Get a layers list by authority//w  w w  .  ja  v a  2 s  .co  m
 * 
 * @param <code>id</code>
 * 
 * @param <code>isChannel</code> compare with entity property and filter by this. False value get null values too
 * 
 * @return Entities list associated with the identifier or null if not found 
 */
public List<AbstractLayerEntity> findByAuthorityId(Long id, Boolean isChannel) {
    Criteria criteria = getSession().createCriteria(persistentClass).createAlias("auth", "auth")
            .add(Restrictions.eq("auth.id", id));
    if (isChannel == null) {
        criteria.add(Restrictions.isNull("isChannel"));
    } else if (isChannel) {
        criteria.add(Restrictions.eq("isChannel", isChannel));
    } else {
        Disjunction dis = Restrictions.disjunction();
        dis.add(Restrictions.isNull("isChannel"));
        dis.add(Restrictions.eq("isChannel", isChannel));
        criteria.add(dis);
    }

    return criteria.list();
}

From source file:com.emergya.persistenceGeo.dao.impl.LayerEntityDaoHibernateImpl.java

License:Open Source License

/**
 * Get a layers list by authority/*from w  w w .j  a  v a 2  s  .c  o m*/
 * 
 * @param <code>id</code>
 * @param <code>isChannel</code> compare with entity property and filter by this. False value get null values too
 * 
 * @return Entities list associated with the identifier or null if not found 
 */
public List<AbstractLayerEntity> getLayersByFolder(Long folderId, Boolean isChannel) {
    Criteria criteria = getSession().createCriteria(persistentClass).createAlias("folder", "folder")
            .add(Restrictions.eq("folder.id", folderId));
    if (isChannel == null) {
        criteria.add(Restrictions.isNull("isChannel"));
    } else if (isChannel) {
        criteria.add(Restrictions.eq("isChannel", isChannel));
    } else {
        Disjunction dis = Restrictions.disjunction();
        dis.add(Restrictions.isNull("isChannel"));
        dis.add(Restrictions.eq("isChannel", isChannel));
        criteria.add(dis);
    }
    return criteria.list();
}

From source file:com.emergya.persistenceGeo.dao.impl.LayerEntityDaoHibernateImpl.java

License:Open Source License

/**
 * Get layers by folder//w  w  w . ja  v  a2  s .co m
 * 
 * @param folderId
 * @param isChannel
 * @param isEnabled
 * 
 * @return all layers in a folder mark as channel
 */
public List<AbstractLayerEntity> getLayersByFolder(Long folderId, Boolean isChannel, Boolean isEnabled) {
    Criteria criteria = getSession().createCriteria(persistentClass).createAlias("folder", "folder")
            .add(Restrictions.eq("folder.id", folderId));
    if (isChannel != null) {
        if (isChannel) {
            criteria.add(Restrictions.eq("isChannel", isChannel));
        } else {
            Disjunction dis = Restrictions.disjunction();
            dis.add(Restrictions.isNull("isChannel"));
            dis.add(Restrictions.eq("isChannel", isChannel));
            criteria.add(dis);
        }
    }
    if (isEnabled == null) {
        criteria.add(Restrictions.isNull("enabled"));
    } else if (isEnabled) {
        criteria.add(Restrictions.eq("enabled", isEnabled));
    } else {
        Disjunction dis = Restrictions.disjunction();
        dis.add(Restrictions.isNull("enabled"));
        dis.add(Restrictions.eq("enabled", isEnabled));
        criteria.add(dis);
    }

    return criteria.list();
}

From source file:com.emergya.persistenceGeo.dao.impl.ZoneEntityDaoHibernateImpl.java

License:Open Source License

/**
 * Get a zones list by the zone name //  w w  w .ja v a 2s. c om
 * 
 * @param <code>zoneName</code>
 * @param isEnabled
 * 
 * @return Entities list associated with the zone name or null if not found 
 */
public List<AbstractZoneEntity> getZones(String zoneName, Boolean isEnabled) {

    Criteria criteria = getSession().createCriteria(persistentClass).add(Restrictions.eq("name", zoneName));

    if (isEnabled == null) {
        criteria.add(Restrictions.isNull("enabled"));
    } else if (isEnabled) {
        criteria.add(Restrictions.eq("enabled", isEnabled));
    } else {
        Disjunction dis = Restrictions.disjunction();
        dis.add(Restrictions.isNull("enabled"));
        dis.add(Restrictions.eq("enabled", isEnabled));
        criteria.add(dis);
    }

    return criteria.list();
}

From source file:com.emergya.persistenceGeo.dao.impl.ZoneEntityDaoHibernateImpl.java

License:Open Source License

/**
 * Get a zones list by its type/*  www.j a va  2 s .  c  o  m*/
 *
 * @param <code>zoneType</code>
 * @param isEnabled
 *
 * @return Entities list associated with the zone type or null if not found
 */
public List<AbstractZoneEntity> findByType(String zoneType, Boolean isEnabled) {

    Criteria criteria = getSession().createCriteria(persistentClass).add(Restrictions.eq("type", zoneType));

    if (isEnabled == null) {
        criteria.add(Restrictions.isNull("enabled"));
    } else if (isEnabled) {
        criteria.add(Restrictions.eq("enabled", isEnabled));
    } else {
        Disjunction dis = Restrictions.disjunction();
        dis.add(Restrictions.isNull("enabled"));
        dis.add(Restrictions.eq("enabled", isEnabled));
        criteria.add(dis);
    }

    return criteria.list();
}

From source file:com.emergya.persistenceGeo.dao.impl.ZoneEntityDaoHibernateImpl.java

License:Open Source License

/**
 * Find zone by id// w w  w  . j a va2s .c  o m
 * 
 * @param idParent
 * @param isEnabled
 * 
 * @return zones
 */
public List<AbstractZoneEntity> findByParent(Long idParent, Boolean isEnabled) {
    Criteria criteria = getSession().createCriteria(persistentClass).add(Restrictions.eq("id", idParent))
            .createAlias("zoneList", "child");

    if (isEnabled == null) {
        criteria.add(Restrictions.isNull("enabled"));
    } else if (isEnabled) {
        criteria.add(Restrictions.eq("enabled", isEnabled));
    } else {
        Disjunction dis = Restrictions.disjunction();
        dis.add(Restrictions.isNull("enabled"));
        dis.add(Restrictions.eq("enabled", isEnabled));
        criteria.add(dis);
    }

    return criteria.list();
}