Example usage for com.liferay.portal.kernel.dao.orm QueryUtil ALL_POS

List of usage examples for com.liferay.portal.kernel.dao.orm QueryUtil ALL_POS

  1. HOME
  2. Java
  3. com.liferay.portal
  4. com.liferay.portal.kernel.dao.orm.*
  5. QueryUtil
  6. ALL_POS

Introduction

In this page you can find the example usage for com.liferay.portal.kernel.dao.orm QueryUtil ALL_POS.

Prototype

int ALL_POS

To view the source code for com.liferay.portal.kernel.dao.orm QueryUtil ALL_POS.

Click Source Link

Usage

From source file:at.graz.meduni.bibbox.liferay.portlet.service.persistence.impl.ApplicationInstanceContainerPersistenceImpl.java

License:Open Source License

/**
 * Removes all the application instance containers where applicationInstanceId = ? from the database.
 *
 * @param applicationInstanceId the application instance ID
 *///  w  w w  .  ja  v a 2  s  .co m
@Override
public void removeByApplicationInstance(long applicationInstanceId) {
    for (ApplicationInstanceContainer applicationInstanceContainer : findByApplicationInstance(
            applicationInstanceId, QueryUtil.ALL_POS, QueryUtil.ALL_POS, null)) {
        remove(applicationInstanceContainer);
    }
}

From source file:at.graz.meduni.bibbox.liferay.portlet.service.persistence.impl.ApplicationInstanceContainerPersistenceImpl.java

License:Open Source License

/**
 * Returns all the application instance containers where applicationInstanceId = ? and needrunning = ?.
 *
 * @param applicationInstanceId the application instance ID
 * @param needrunning the needrunning//from w  w w.ja  v  a2  s . c o  m
 * @return the matching application instance containers
 */
@Override
public List<ApplicationInstanceContainer> findByApplicationInstanceRunning(long applicationInstanceId,
        boolean needrunning) {
    return findByApplicationInstanceRunning(applicationInstanceId, needrunning, QueryUtil.ALL_POS,
            QueryUtil.ALL_POS, null);
}

From source file:at.graz.meduni.bibbox.liferay.portlet.service.persistence.impl.ApplicationInstanceContainerPersistenceImpl.java

License:Open Source License

/**
 * Returns an ordered range of all the application instance containers where applicationInstanceId = &#63; and needrunning = &#63;.
 *
 * <p>/* w w w .java2 s .c  o  m*/
 * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link ApplicationInstanceContainerModelImpl}. If both <code>orderByComparator</code> and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
 * </p>
 *
 * @param applicationInstanceId the application instance ID
 * @param needrunning the needrunning
 * @param start the lower bound of the range of application instance containers
 * @param end the upper bound of the range of application instance containers (not inclusive)
 * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
 * @param retrieveFromCache whether to retrieve from the finder cache
 * @return the ordered range of matching application instance containers
 */
@Override
public List<ApplicationInstanceContainer> findByApplicationInstanceRunning(long applicationInstanceId,
        boolean needrunning, int start, int end,
        OrderByComparator<ApplicationInstanceContainer> orderByComparator, boolean retrieveFromCache) {
    boolean pagination = true;
    FinderPath finderPath = null;
    Object[] finderArgs = null;

    if ((start == QueryUtil.ALL_POS) && (end == QueryUtil.ALL_POS) && (orderByComparator == null)) {
        pagination = false;
        finderPath = FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_APPLICATIONINSTANCERUNNING;
        finderArgs = new Object[] { applicationInstanceId, needrunning };
    } else {
        finderPath = FINDER_PATH_WITH_PAGINATION_FIND_BY_APPLICATIONINSTANCERUNNING;
        finderArgs = new Object[] { applicationInstanceId, needrunning,

                start, end, orderByComparator };
    }

    List<ApplicationInstanceContainer> list = null;

    if (retrieveFromCache) {
        list = (List<ApplicationInstanceContainer>) finderCache.getResult(finderPath, finderArgs, this);

        if ((list != null) && !list.isEmpty()) {
            for (ApplicationInstanceContainer applicationInstanceContainer : list) {
                if ((applicationInstanceId != applicationInstanceContainer.getApplicationInstanceId())
                        || (needrunning != applicationInstanceContainer.getNeedrunning())) {
                    list = null;

                    break;
                }
            }
        }
    }

    if (list == null) {
        StringBundler query = null;

        if (orderByComparator != null) {
            query = new StringBundler(4 + (orderByComparator.getOrderByFields().length * 2));
        } else {
            query = new StringBundler(4);
        }

        query.append(_SQL_SELECT_APPLICATIONINSTANCECONTAINER_WHERE);

        query.append(_FINDER_COLUMN_APPLICATIONINSTANCERUNNING_APPLICATIONINSTANCEID_2);

        query.append(_FINDER_COLUMN_APPLICATIONINSTANCERUNNING_NEEDRUNNING_2);

        if (orderByComparator != null) {
            appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, orderByComparator);
        } else if (pagination) {
            query.append(ApplicationInstanceContainerModelImpl.ORDER_BY_JPQL);
        }

        String sql = query.toString();

        Session session = null;

        try {
            session = openSession();

            Query q = session.createQuery(sql);

            QueryPos qPos = QueryPos.getInstance(q);

            qPos.add(applicationInstanceId);

            qPos.add(needrunning);

            if (!pagination) {
                list = (List<ApplicationInstanceContainer>) QueryUtil.list(q, getDialect(), start, end, false);

                Collections.sort(list);

                list = Collections.unmodifiableList(list);
            } else {
                list = (List<ApplicationInstanceContainer>) QueryUtil.list(q, getDialect(), start, end);
            }

            cacheResult(list);

            finderCache.putResult(finderPath, finderArgs, list);
        } catch (Exception e) {
            finderCache.removeResult(finderPath, finderArgs);

            throw processException(e);
        } finally {
            closeSession(session);
        }
    }

    return list;
}

From source file:at.graz.meduni.bibbox.liferay.portlet.service.persistence.impl.ApplicationInstanceContainerPersistenceImpl.java

License:Open Source License

/**
 * Removes all the application instance containers where applicationInstanceId = &#63; and needrunning = &#63; from the database.
 *
 * @param applicationInstanceId the application instance ID
 * @param needrunning the needrunning/*from   w  ww . j a v  a  2  s  .  co m*/
 */
@Override
public void removeByApplicationInstanceRunning(long applicationInstanceId, boolean needrunning) {
    for (ApplicationInstanceContainer applicationInstanceContainer : findByApplicationInstanceRunning(
            applicationInstanceId, needrunning, QueryUtil.ALL_POS, QueryUtil.ALL_POS, null)) {
        remove(applicationInstanceContainer);
    }
}

From source file:at.graz.meduni.bibbox.liferay.portlet.service.persistence.impl.ApplicationInstanceContainerPersistenceImpl.java

License:Open Source License

/**
 * Returns all the application instance containers.
 *
 * @return the application instance containers
 *//* ww w .  j  av  a2 s .com*/
@Override
public List<ApplicationInstanceContainer> findAll() {
    return findAll(QueryUtil.ALL_POS, QueryUtil.ALL_POS, null);
}

From source file:at.graz.meduni.bibbox.liferay.portlet.service.persistence.impl.ApplicationInstanceContainerPersistenceImpl.java

License:Open Source License

/**
 * Returns an ordered range of all the application instance containers.
 *
 * <p>//from   www .  j a  va2s  .  co  m
 * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link ApplicationInstanceContainerModelImpl}. If both <code>orderByComparator</code> and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
 * </p>
 *
 * @param start the lower bound of the range of application instance containers
 * @param end the upper bound of the range of application instance containers (not inclusive)
 * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
 * @param retrieveFromCache whether to retrieve from the finder cache
 * @return the ordered range of application instance containers
 */
@Override
public List<ApplicationInstanceContainer> findAll(int start, int end,
        OrderByComparator<ApplicationInstanceContainer> orderByComparator, boolean retrieveFromCache) {
    boolean pagination = true;
    FinderPath finderPath = null;
    Object[] finderArgs = null;

    if ((start == QueryUtil.ALL_POS) && (end == QueryUtil.ALL_POS) && (orderByComparator == null)) {
        pagination = false;
        finderPath = FINDER_PATH_WITHOUT_PAGINATION_FIND_ALL;
        finderArgs = FINDER_ARGS_EMPTY;
    } else {
        finderPath = FINDER_PATH_WITH_PAGINATION_FIND_ALL;
        finderArgs = new Object[] { start, end, orderByComparator };
    }

    List<ApplicationInstanceContainer> list = null;

    if (retrieveFromCache) {
        list = (List<ApplicationInstanceContainer>) finderCache.getResult(finderPath, finderArgs, this);
    }

    if (list == null) {
        StringBundler query = null;
        String sql = null;

        if (orderByComparator != null) {
            query = new StringBundler(2 + (orderByComparator.getOrderByFields().length * 2));

            query.append(_SQL_SELECT_APPLICATIONINSTANCECONTAINER);

            appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, orderByComparator);

            sql = query.toString();
        } else {
            sql = _SQL_SELECT_APPLICATIONINSTANCECONTAINER;

            if (pagination) {
                sql = sql.concat(ApplicationInstanceContainerModelImpl.ORDER_BY_JPQL);
            }
        }

        Session session = null;

        try {
            session = openSession();

            Query q = session.createQuery(sql);

            if (!pagination) {
                list = (List<ApplicationInstanceContainer>) QueryUtil.list(q, getDialect(), start, end, false);

                Collections.sort(list);

                list = Collections.unmodifiableList(list);
            } else {
                list = (List<ApplicationInstanceContainer>) QueryUtil.list(q, getDialect(), start, end);
            }

            cacheResult(list);

            finderCache.putResult(finderPath, finderArgs, list);
        } catch (Exception e) {
            finderCache.removeResult(finderPath, finderArgs);

            throw processException(e);
        } finally {
            closeSession(session);
        }
    }

    return list;
}

From source file:at.graz.meduni.bibbox.liferay.portlet.service.persistence.impl.ApplicationInstancePersistenceImpl.java

License:Open Source License

/**
 * Returns all the application instances where folderName = &#63;.
 *
 * @param folderName the folder name/*from   w w  w  .j  av  a 2  s  . com*/
 * @return the matching application instances
 */
@Override
public List<ApplicationInstance> findByFolderName(String folderName) {
    return findByFolderName(folderName, QueryUtil.ALL_POS, QueryUtil.ALL_POS, null);
}

From source file:at.graz.meduni.bibbox.liferay.portlet.service.persistence.impl.ApplicationInstancePersistenceImpl.java

License:Open Source License

/**
 * Returns an ordered range of all the application instances where folderName = &#63;.
 *
 * <p>//from  www .  j  a v a2  s  . c  o m
 * Useful when paginating results. Returns a maximum of <code>end - start</code> instances. <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start</code> and <code>end</code> to {@link QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link ApplicationInstanceModelImpl}. If both <code>orderByComparator</code> and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order.
 * </p>
 *
 * @param folderName the folder name
 * @param start the lower bound of the range of application instances
 * @param end the upper bound of the range of application instances (not inclusive)
 * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
 * @param retrieveFromCache whether to retrieve from the finder cache
 * @return the ordered range of matching application instances
 */
@Override
public List<ApplicationInstance> findByFolderName(String folderName, int start, int end,
        OrderByComparator<ApplicationInstance> orderByComparator, boolean retrieveFromCache) {
    boolean pagination = true;
    FinderPath finderPath = null;
    Object[] finderArgs = null;

    if ((start == QueryUtil.ALL_POS) && (end == QueryUtil.ALL_POS) && (orderByComparator == null)) {
        pagination = false;
        finderPath = FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_FOLDERNAME;
        finderArgs = new Object[] { folderName };
    } else {
        finderPath = FINDER_PATH_WITH_PAGINATION_FIND_BY_FOLDERNAME;
        finderArgs = new Object[] { folderName, start, end, orderByComparator };
    }

    List<ApplicationInstance> list = null;

    if (retrieveFromCache) {
        list = (List<ApplicationInstance>) finderCache.getResult(finderPath, finderArgs, this);

        if ((list != null) && !list.isEmpty()) {
            for (ApplicationInstance applicationInstance : list) {
                if (!Objects.equals(folderName, applicationInstance.getFolderName())) {
                    list = null;

                    break;
                }
            }
        }
    }

    if (list == null) {
        StringBundler query = null;

        if (orderByComparator != null) {
            query = new StringBundler(3 + (orderByComparator.getOrderByFields().length * 2));
        } else {
            query = new StringBundler(3);
        }

        query.append(_SQL_SELECT_APPLICATIONINSTANCE_WHERE);

        boolean bindFolderName = false;

        if (folderName == null) {
            query.append(_FINDER_COLUMN_FOLDERNAME_FOLDERNAME_1);
        } else if (folderName.equals(StringPool.BLANK)) {
            query.append(_FINDER_COLUMN_FOLDERNAME_FOLDERNAME_3);
        } else {
            bindFolderName = true;

            query.append(_FINDER_COLUMN_FOLDERNAME_FOLDERNAME_2);
        }

        if (orderByComparator != null) {
            appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, orderByComparator);
        } else if (pagination) {
            query.append(ApplicationInstanceModelImpl.ORDER_BY_JPQL);
        }

        String sql = query.toString();

        Session session = null;

        try {
            session = openSession();

            Query q = session.createQuery(sql);

            QueryPos qPos = QueryPos.getInstance(q);

            if (bindFolderName) {
                qPos.add(folderName);
            }

            if (!pagination) {
                list = (List<ApplicationInstance>) QueryUtil.list(q, getDialect(), start, end, false);

                Collections.sort(list);

                list = Collections.unmodifiableList(list);
            } else {
                list = (List<ApplicationInstance>) QueryUtil.list(q, getDialect(), start, end);
            }

            cacheResult(list);

            finderCache.putResult(finderPath, finderArgs, list);
        } catch (Exception e) {
            finderCache.removeResult(finderPath, finderArgs);

            throw processException(e);
        } finally {
            closeSession(session);
        }
    }

    return list;
}

From source file:at.graz.meduni.bibbox.liferay.portlet.service.persistence.impl.ApplicationInstancePersistenceImpl.java

License:Open Source License

/**
 * Removes all the application instances where folderName = &#63; from the database.
 *
 * @param folderName the folder name//  w w w.  j  av  a  2 s . c  o  m
 */
@Override
public void removeByFolderName(String folderName) {
    for (ApplicationInstance applicationInstance : findByFolderName(folderName, QueryUtil.ALL_POS,
            QueryUtil.ALL_POS, null)) {
        remove(applicationInstance);
    }
}

From source file:at.graz.meduni.bibbox.liferay.portlet.service.persistence.impl.ApplicationInstancePersistenceImpl.java

License:Open Source License

/**
 * Returns all the application instances where deleted = &#63;.
 *
 * @param deleted the deleted// w ww. j a  v  a 2s . co  m
 * @return the matching application instances
 */
@Override
public List<ApplicationInstance> findByInstancesNotDeleted(boolean deleted) {
    return findByInstancesNotDeleted(deleted, QueryUtil.ALL_POS, QueryUtil.ALL_POS, null);
}