Example usage for com.liferay.portal.kernel.dao.orm SQLQuery iterate

List of usage examples for com.liferay.portal.kernel.dao.orm SQLQuery iterate

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

Introduction

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

Prototype

@SuppressWarnings("rawtypes")
    public Iterator iterate() throws ORMException;

Source Link

Usage

From source file:com.amf.registration.service.persistence.AMFUserFinderImpl.java

License:Open Source License

public int countByZip(String zip) throws SystemException {
    Session session = null;/*from   w w  w .  j  a va2s.  co m*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(COUNT_BY_ZIP);

        SQLQuery q = session.createSQLQuery(sql);

        q.addScalar(COUNT_COLUMN_NAME, Type.LONG);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(zip);

        Iterator<Long> itr = q.iterate();

        if (itr.hasNext()) {
            Long count = itr.next();

            if (count != null) {
                return count.intValue();
            }
        }

        return 0;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

From source file:com.liferay.asset.category.property.service.persistence.impl.AssetCategoryPropertyFinderImpl.java

License:Open Source License

@Override
public int countByG_K(long groupId, String key) {
    Session session = null;//from   w w w .j a va2s.  c  o m

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(getClass(), COUNT_BY_G_K);

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addScalar(COUNT_COLUMN_NAME, Type.LONG);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);
        qPos.add(key);

        Iterator<Long> itr = q.iterate();

        if (itr.hasNext()) {
            Long count = itr.next();

            if (count != null) {
                return count.intValue();
            }
        }

        return 0;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

From source file:com.liferay.blogs.service.persistence.impl.BlogsEntryFinderImpl.java

License:Open Source License

@Override
public int countByOrganizationIds(List<Long> organizationIds, Date displayDate,
        QueryDefinition<BlogsEntry> queryDefinition) {

    Timestamp displayDate_TS = CalendarUtil.getTimestamp(displayDate);

    Session session = null;//ww  w  . j  a va2 s .c om

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(getClass(), COUNT_BY_ORGANIZATION_IDS);

        if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) {
            if (queryDefinition.isExcludeStatus()) {
                sql = CustomSQLUtil.appendCriteria(sql, "AND (BlogsEntry.status != ?)");
            } else {
                sql = CustomSQLUtil.appendCriteria(sql, "AND (BlogsEntry.status = ?)");
            }
        }

        sql = StringUtil.replace(sql, "[$ORGANIZATION_ID$]", getOrganizationIds(organizationIds));

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addScalar(COUNT_COLUMN_NAME, Type.LONG);

        QueryPos qPos = QueryPos.getInstance(q);

        for (Long organizationId : organizationIds) {
            qPos.add(organizationId);
        }

        qPos.add(displayDate_TS);

        if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) {
            qPos.add(queryDefinition.getStatus());
        }

        Iterator<Long> itr = q.iterate();

        if (itr.hasNext()) {
            Long count = itr.next();

            if (count != null) {
                return count.intValue();
            }
        }

        return 0;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

From source file:com.liferay.blogs.service.persistence.impl.BlogsStatsUserFinderImpl.java

License:Open Source License

@Override
public int countByOrganizationIds(List<Long> organizationIds) {
    Session session = null;/*w ww . j a  v  a 2 s . c  o  m*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(getClass(), COUNT_BY_ORGANIZATION_IDS);

        sql = StringUtil.replace(sql, "[$ORGANIZATION_ID$]", getOrganizationIds(organizationIds));

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addScalar(COUNT_COLUMN_NAME, Type.LONG);

        QueryPos qPos = QueryPos.getInstance(q);

        for (Long organizationId : organizationIds) {
            qPos.add(organizationId);
        }

        Iterator<Long> itr = q.iterate();

        if (itr.hasNext()) {
            Long count = itr.next();

            if (count != null) {
                return count.intValue();
            }
        }

        return 0;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

From source file:com.liferay.bookmarks.service.persistence.impl.BookmarksFolderFinderImpl.java

License:Open Source License

protected int doCountF_E_ByG_F(long groupId, long folderId, QueryDefinition<?> queryDefinition,
        boolean inlineSQLHelper) {

    Session session = null;/*from   ww  w.  j  a v  a 2 s .c om*/

    try {
        session = openSession();

        StringBundler sb = new StringBundler(5);

        sb.append(StringPool.OPEN_PARENTHESIS);

        String sql = null;

        if (queryDefinition.getStatus() == WorkflowConstants.STATUS_ANY) {
            sql = CustomSQLUtil.get(getClass(), COUNT_F_BY_G_P);
        } else {
            sql = CustomSQLUtil.get(getClass(), COUNT_F_BY_G_P_S);

            sql = replaceExcludeStatus(sql, queryDefinition);
        }

        if (inlineSQLHelper) {
            sql = InlineSQLHelperUtil.replacePermissionCheck(sql, BookmarksFolder.class.getName(),
                    "BookmarksFolder.folderId", groupId);
        }

        sb.append(sql);
        sb.append(") UNION ALL (");

        if (queryDefinition.getStatus() == WorkflowConstants.STATUS_ANY) {
            sql = CustomSQLUtil.get(getClass(), COUNT_E_BY_G_F);
        } else {
            sql = CustomSQLUtil.get(getClass(), COUNT_E_BY_G_F_S);

            sql = replaceExcludeStatus(sql, queryDefinition);
        }

        if (inlineSQLHelper) {
            sql = InlineSQLHelperUtil.replacePermissionCheck(sql, BookmarksEntry.class.getName(),
                    "BookmarksEntry.fileEntryId", groupId);
        }

        sb.append(sql);
        sb.append(StringPool.CLOSE_PARENTHESIS);

        sql = sb.toString();

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addScalar(COUNT_COLUMN_NAME, Type.LONG);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(groupId);
        qPos.add(folderId);

        if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) {
            qPos.add(queryDefinition.getStatus());
        }

        qPos.add(groupId);
        qPos.add(folderId);

        if (queryDefinition.getStatus() != WorkflowConstants.STATUS_ANY) {
            qPos.add(queryDefinition.getStatus());
        }

        int count = 0;

        Iterator<Long> itr = q.iterate();

        while (itr.hasNext()) {
            Long l = itr.next();

            if (l != null) {
                count += l.intValue();
            }
        }

        return count;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

From source file:com.liferay.calendar.service.persistence.CalendarBookingFinderImpl.java

License:Open Source License

protected int doCountByC_G_C_C_P_T_D_L_S_E_S(long companyId, long[] groupIds, long[] calendarIds,
        long[] calendarResourceIds, long parentCalendarBookingId, String[] titles, String[] descriptions,
        String[] locations, long startTime, long endTime, int[] statuses, boolean andOperator,
        boolean inlineSQLHelper) throws SystemException {

    titles = CustomSQLUtil.keywords(titles);
    descriptions = CustomSQLUtil.keywords(descriptions, false);
    locations = CustomSQLUtil.keywords(locations);

    Session session = null;//from w w w .  j ava  2s  .c o m

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(COUNT_BY_C_G_C_C_P_T_D_L_S_E_S);

        if (inlineSQLHelper) {
            sql = InlineSQLHelperUtil.replacePermissionCheck(sql, CalendarBooking.class.getName(),
                    "CalendarBooking.calendarBookingId", groupIds);
        }

        sql = StringUtil.replace(sql, "[$GROUP_ID$]", getGroupIds(groupIds));
        sql = StringUtil.replace(sql, "[$CALENDAR_ID$]", getCalendarIds(calendarIds));
        sql = StringUtil.replace(sql, "[$CALENDAR_RESOURCE_ID$]", getCalendarResourceIds(calendarResourceIds));
        sql = StringUtil.replace(sql, "[$STATUS$]", getStatuses(statuses));

        if (parentCalendarBookingId < 0) {
            sql = StringUtil.replace(sql, "(parentCalendarBookingId = ?) AND", StringPool.BLANK);
        }

        sql = CustomSQLUtil.replaceKeywords(sql, "lower(title)", StringPool.LIKE, false, titles);
        sql = CustomSQLUtil.replaceKeywords(sql, "description", StringPool.LIKE, false, descriptions);
        sql = CustomSQLUtil.replaceKeywords(sql, "lower(location)", StringPool.LIKE, true, locations);
        sql = CustomSQLUtil.replaceAndOperator(sql, andOperator);

        SQLQuery q = session.createSQLQuery(sql);

        q.addScalar(COUNT_COLUMN_NAME, Type.LONG);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(companyId);
        qPos.add(groupIds);

        if (ArrayUtil.isNotEmpty(calendarIds)) {
            qPos.add(calendarIds);
        }

        if (ArrayUtil.isNotEmpty(calendarResourceIds)) {
            qPos.add(calendarResourceIds);
        }

        if (parentCalendarBookingId >= 0) {
            qPos.add(parentCalendarBookingId);
        }

        qPos.add(titles, 2);
        qPos.add(descriptions, 2);
        qPos.add(locations, 2);
        qPos.add(startTime);
        qPos.add(endTime);
        qPos.add(startTime);
        qPos.add(endTime);
        qPos.add(startTime);
        qPos.add(endTime);
        qPos.add(endTime);
        qPos.add(startTime);
        qPos.add(startTime);
        qPos.add(endTime);

        if (ArrayUtil.isNotEmpty(statuses)) {
            qPos.add(statuses);
        }

        Iterator<Long> itr = q.iterate();

        if (itr.hasNext()) {
            Long count = itr.next();

            if (count != null) {
                return count.intValue();
            }
        }

        return 0;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

From source file:com.liferay.calendar.service.persistence.CalendarFinderImpl.java

License:Open Source License

protected int doCountByC_G_C_N_D(long companyId, long[] groupIds, long[] calendarResourceIds, String[] names,
        String[] descriptions, boolean andOperator, boolean inlineSQLHelper) throws SystemException {

    if (groupIds == null) {
        groupIds = new long[0];
    }/*  www  . j av a 2s. com*/

    names = CustomSQLUtil.keywords(names);
    descriptions = CustomSQLUtil.keywords(descriptions, false);

    Session session = null;

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(COUNT_BY_C_G_C_N_D);

        if (inlineSQLHelper) {
            sql = InlineSQLHelperUtil.replacePermissionCheck(sql, Calendar.class.getName(),
                    "Calendar.calendarId", groupIds);
        }

        sql = StringUtil.replace(sql, "[$GROUP_ID$]", getGroupIds(groupIds));
        sql = StringUtil.replace(sql, "[$CALENDAR_RESOURCE_ID$]", getCalendarResourceIds(calendarResourceIds));
        sql = CustomSQLUtil.replaceKeywords(sql, "lower(name)", StringPool.LIKE, false, names);
        sql = CustomSQLUtil.replaceKeywords(sql, "description", StringPool.LIKE, false, descriptions);
        sql = CustomSQLUtil.replaceAndOperator(sql, andOperator);

        SQLQuery q = session.createSQLQuery(sql);

        q.addScalar(COUNT_COLUMN_NAME, Type.LONG);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(companyId);
        qPos.add(groupIds);

        if (ArrayUtil.isNotEmpty(calendarResourceIds)) {
            qPos.add(calendarResourceIds);
        }

        qPos.add(names, 2);
        qPos.add(descriptions, 2);

        Iterator<Long> itr = q.iterate();

        if (itr.hasNext()) {
            Long count = itr.next();

            if (count != null) {
                return count.intValue();
            }
        }

        return 0;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

From source file:com.liferay.calendar.service.persistence.CalendarResourceFinderImpl.java

License:Open Source License

protected int doCountByC_G_C_C_N_D_A(long companyId, long[] groupIds, long[] classNameIds, String[] codes,
        String[] names, String[] descriptions, boolean active, boolean andOperator, boolean inlineSQLHelper)
        throws SystemException {

    codes = CustomSQLUtil.keywords(codes);
    names = CustomSQLUtil.keywords(names);
    descriptions = CustomSQLUtil.keywords(descriptions, false);

    Session session = null;/*from   ww w.ja  va2 s  .c o  m*/

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(COUNT_BY_C_G_C_C_N_D_A);

        if (inlineSQLHelper) {
            sql = InlineSQLHelperUtil.replacePermissionCheck(sql, CalendarResource.class.getName(),
                    "CalendarResource.calendarResourceId", groupIds);
        }

        sql = StringUtil.replace(sql, "[$GROUP_ID$]", getGroupIds(groupIds));
        sql = StringUtil.replace(sql, "[$CLASS_NAME_ID$]", getClassNameIds(classNameIds));
        sql = CustomSQLUtil.replaceKeywords(sql, "lower(code_)", StringPool.LIKE, false, codes);
        sql = CustomSQLUtil.replaceKeywords(sql, "lower(name)", StringPool.LIKE, false, names);
        sql = CustomSQLUtil.replaceKeywords(sql, "description", StringPool.LIKE, false, descriptions);
        sql = CustomSQLUtil.replaceAndOperator(sql, andOperator);

        SQLQuery q = session.createSQLQuery(sql);

        q.addScalar(COUNT_COLUMN_NAME, Type.LONG);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(companyId);
        qPos.add(groupIds);

        if (ArrayUtil.isNotEmpty(classNameIds)) {
            qPos.add(classNameIds);
        }

        qPos.add(codes, 2);
        qPos.add(names, 2);
        qPos.add(descriptions, 2);
        qPos.add(active);

        Iterator<Long> itr = q.iterate();

        if (itr.hasNext()) {
            Long count = itr.next();

            if (count != null) {
                return count.intValue();
            }
        }

        return 0;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

From source file:com.liferay.calendar.service.persistence.impl.CalendarBookingFinderImpl.java

License:Open Source License

protected int doCountByC_G_C_C_P_T_D_L_S_E_S(long companyId, long[] groupIds, long[] calendarIds,
        long[] calendarResourceIds, long parentCalendarBookingId, String[] titles, String[] descriptions,
        String[] locations, long startTime, long endTime, int[] statuses, boolean andOperator,
        boolean inlineSQLHelper) {

    titles = CustomSQLUtil.keywords(titles);
    descriptions = CustomSQLUtil.keywords(descriptions, false);
    locations = CustomSQLUtil.keywords(locations);

    Session session = null;//from  ww w.j  a  v a 2s  . c o  m

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(COUNT_BY_C_G_C_C_P_T_D_L_S_E_S);

        if (inlineSQLHelper) {
            sql = InlineSQLHelperUtil.replacePermissionCheck(sql, CalendarBooking.class.getName(),
                    "CalendarBooking.calendarBookingId", groupIds);
        }

        sql = StringUtil.replace(sql, "[$GROUP_ID$]", getGroupIds(groupIds));
        sql = StringUtil.replace(sql, "[$CALENDAR_ID$]", getCalendarIds(calendarIds));
        sql = StringUtil.replace(sql, "[$CALENDAR_RESOURCE_ID$]", getCalendarResourceIds(calendarResourceIds));
        sql = StringUtil.replace(sql, "[$STATUS$]", getStatuses(statuses));

        if (parentCalendarBookingId < 0) {
            sql = StringUtil.replace(sql, "(parentCalendarBookingId = ?) AND", StringPool.BLANK);
        }

        sql = CustomSQLUtil.replaceKeywords(sql, "lower(title)", StringPool.LIKE, false, titles);
        sql = CustomSQLUtil.replaceKeywords(sql, "description", StringPool.LIKE, false, descriptions);
        sql = CustomSQLUtil.replaceKeywords(sql, "lower(location)", StringPool.LIKE, true, locations);
        sql = CustomSQLUtil.replaceAndOperator(sql, andOperator);

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addScalar(COUNT_COLUMN_NAME, Type.LONG);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(companyId);
        qPos.add(groupIds);

        if (ArrayUtil.isNotEmpty(calendarIds)) {
            qPos.add(calendarIds);
        }

        if (ArrayUtil.isNotEmpty(calendarResourceIds)) {
            qPos.add(calendarResourceIds);
        }

        if (parentCalendarBookingId >= 0) {
            qPos.add(parentCalendarBookingId);
        }

        qPos.add(titles, 2);
        qPos.add(descriptions, 2);
        qPos.add(locations, 2);
        qPos.add(startTime);
        qPos.add(endTime);
        qPos.add(startTime);
        qPos.add(endTime);
        qPos.add(startTime);
        qPos.add(endTime);
        qPos.add(endTime);
        qPos.add(startTime);
        qPos.add(startTime);
        qPos.add(endTime);

        if (ArrayUtil.isNotEmpty(statuses)) {
            qPos.add(statuses);
        }

        Iterator<Long> itr = q.iterate();

        if (itr.hasNext()) {
            Long count = itr.next();

            if (count != null) {
                return count.intValue();
            }
        }

        return 0;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}

From source file:com.liferay.calendar.service.persistence.impl.CalendarFinderImpl.java

License:Open Source License

protected int doCountByC_G_C_N_D(long companyId, long[] groupIds, long[] calendarResourceIds, String[] names,
        String[] descriptions, boolean andOperator, boolean inlineSQLHelper) {

    if (groupIds == null) {
        groupIds = new long[0];
    }//from  w  w w  . ja  va 2 s  . c  o  m

    names = CustomSQLUtil.keywords(names);
    descriptions = CustomSQLUtil.keywords(descriptions, false);

    Session session = null;

    try {
        session = openSession();

        String sql = CustomSQLUtil.get(COUNT_BY_C_G_C_N_D);

        if (inlineSQLHelper) {
            sql = InlineSQLHelperUtil.replacePermissionCheck(sql, Calendar.class.getName(),
                    "Calendar.calendarId", groupIds);
        }

        sql = StringUtil.replace(sql, "[$GROUP_ID$]", getGroupIds(groupIds));
        sql = StringUtil.replace(sql, "[$CALENDAR_RESOURCE_ID$]", getCalendarResourceIds(calendarResourceIds));
        sql = CustomSQLUtil.replaceKeywords(sql, "lower(name)", StringPool.LIKE, false, names);
        sql = CustomSQLUtil.replaceKeywords(sql, "description", StringPool.LIKE, false, descriptions);
        sql = CustomSQLUtil.replaceAndOperator(sql, andOperator);

        SQLQuery q = session.createSynchronizedSQLQuery(sql);

        q.addScalar(COUNT_COLUMN_NAME, Type.LONG);

        QueryPos qPos = QueryPos.getInstance(q);

        qPos.add(companyId);
        qPos.add(groupIds);

        if (ArrayUtil.isNotEmpty(calendarResourceIds)) {
            qPos.add(calendarResourceIds);
        }

        qPos.add(names, 2);
        qPos.add(descriptions, 2);

        Iterator<Long> itr = q.iterate();

        if (itr.hasNext()) {
            Long count = itr.next();

            if (count != null) {
                return count.intValue();
            }
        }

        return 0;
    } catch (Exception e) {
        throw new SystemException(e);
    } finally {
        closeSession(session);
    }
}