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

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

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

Introduction

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

Prototype

public Query setMaxResults(int maxResults);

Source Link

Usage

From source file:com.rivetlogic.suggestionbox.service.persistence.SuggestionPersistenceImpl.java

License:Open Source License

protected Suggestion filterGetByGroupId_PrevAndNext(Session session, Suggestion suggestion, long groupId,
        OrderByComparator orderByComparator, boolean previous) {
    StringBundler query = null;/*  w ww  .  j a  v a 2 s.co m*/

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

    if (getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_SUGGESTION_WHERE);
    } else {
        query.append(_FILTER_SQL_SELECT_SUGGESTION_NO_INLINE_DISTINCT_WHERE_1);
    }

    query.append(_FINDER_COLUMN_GROUPID_GROUPID_2);

    if (!getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_SUGGESTION_NO_INLINE_DISTINCT_WHERE_2);
    }

    if (orderByComparator != null) {
        String[] orderByConditionFields = orderByComparator.getOrderByConditionFields();

        if (orderByConditionFields.length > 0) {
            query.append(WHERE_AND);
        }

        for (int i = 0; i < orderByConditionFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByConditionFields[i]);

            if ((i + 1) < orderByConditionFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN_HAS_NEXT);
                } else {
                    query.append(WHERE_LESSER_THAN_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN);
                } else {
                    query.append(WHERE_LESSER_THAN);
                }
            }
        }

        query.append(ORDER_BY_CLAUSE);

        String[] orderByFields = orderByComparator.getOrderByFields();

        for (int i = 0; i < orderByFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByFields[i]);

            if ((i + 1) < orderByFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC_HAS_NEXT);
                } else {
                    query.append(ORDER_BY_DESC_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC);
                } else {
                    query.append(ORDER_BY_DESC);
                }
            }
        }
    } else {
        if (getDB().isSupportsInlineDistinct()) {
            query.append(SuggestionModelImpl.ORDER_BY_JPQL);
        } else {
            query.append(SuggestionModelImpl.ORDER_BY_SQL);
        }
    }

    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(), Suggestion.class.getName(),
            _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN, groupId);

    SQLQuery q = session.createSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, SuggestionImpl.class);
    } else {
        q.addEntity(_FILTER_ENTITY_TABLE, SuggestionImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(groupId);

    if (orderByComparator != null) {
        Object[] values = orderByComparator.getOrderByConditionValues(suggestion);

        for (Object value : values) {
            qPos.add(value);
        }
    }

    List<Suggestion> list = q.list();

    if (list.size() == 2) {
        return list.get(1);
    } else {
        return null;
    }
}

From source file:com.rivetlogic.suggestionbox.service.persistence.SuggestionPersistenceImpl.java

License:Open Source License

protected Suggestion filterGetByCompanyGroup_PrevAndNext(Session session, Suggestion suggestion, long companyId,
        long groupId, OrderByComparator orderByComparator, boolean previous) {
    StringBundler query = null;//  www. ja  v  a  2 s . com

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

    if (getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_SUGGESTION_WHERE);
    } else {
        query.append(_FILTER_SQL_SELECT_SUGGESTION_NO_INLINE_DISTINCT_WHERE_1);
    }

    query.append(_FINDER_COLUMN_COMPANYGROUP_COMPANYID_2);

    query.append(_FINDER_COLUMN_COMPANYGROUP_GROUPID_2);

    if (!getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_SUGGESTION_NO_INLINE_DISTINCT_WHERE_2);
    }

    if (orderByComparator != null) {
        String[] orderByConditionFields = orderByComparator.getOrderByConditionFields();

        if (orderByConditionFields.length > 0) {
            query.append(WHERE_AND);
        }

        for (int i = 0; i < orderByConditionFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByConditionFields[i]);

            if ((i + 1) < orderByConditionFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN_HAS_NEXT);
                } else {
                    query.append(WHERE_LESSER_THAN_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN);
                } else {
                    query.append(WHERE_LESSER_THAN);
                }
            }
        }

        query.append(ORDER_BY_CLAUSE);

        String[] orderByFields = orderByComparator.getOrderByFields();

        for (int i = 0; i < orderByFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByFields[i]);

            if ((i + 1) < orderByFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC_HAS_NEXT);
                } else {
                    query.append(ORDER_BY_DESC_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC);
                } else {
                    query.append(ORDER_BY_DESC);
                }
            }
        }
    } else {
        if (getDB().isSupportsInlineDistinct()) {
            query.append(SuggestionModelImpl.ORDER_BY_JPQL);
        } else {
            query.append(SuggestionModelImpl.ORDER_BY_SQL);
        }
    }

    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(), Suggestion.class.getName(),
            _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN, groupId);

    SQLQuery q = session.createSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, SuggestionImpl.class);
    } else {
        q.addEntity(_FILTER_ENTITY_TABLE, SuggestionImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(companyId);

    qPos.add(groupId);

    if (orderByComparator != null) {
        Object[] values = orderByComparator.getOrderByConditionValues(suggestion);

        for (Object value : values) {
            qPos.add(value);
        }
    }

    List<Suggestion> list = q.list();

    if (list.size() == 2) {
        return list.get(1);
    } else {
        return null;
    }
}

From source file:com.rivetlogic.suggestionbox.service.persistence.SuggestionPersistenceImpl.java

License:Open Source License

protected Suggestion filterGetByCompanyGroupUser_PrevAndNext(Session session, Suggestion suggestion,
        long companyId, long groupId, long userId, OrderByComparator orderByComparator, boolean previous) {
    StringBundler query = null;/*from  w  w w . j a v a 2  s  .  c o m*/

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

    if (getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_SUGGESTION_WHERE);
    } else {
        query.append(_FILTER_SQL_SELECT_SUGGESTION_NO_INLINE_DISTINCT_WHERE_1);
    }

    query.append(_FINDER_COLUMN_COMPANYGROUPUSER_COMPANYID_2);

    query.append(_FINDER_COLUMN_COMPANYGROUPUSER_GROUPID_2);

    query.append(_FINDER_COLUMN_COMPANYGROUPUSER_USERID_2);

    if (!getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_SUGGESTION_NO_INLINE_DISTINCT_WHERE_2);
    }

    if (orderByComparator != null) {
        String[] orderByConditionFields = orderByComparator.getOrderByConditionFields();

        if (orderByConditionFields.length > 0) {
            query.append(WHERE_AND);
        }

        for (int i = 0; i < orderByConditionFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByConditionFields[i]);

            if ((i + 1) < orderByConditionFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN_HAS_NEXT);
                } else {
                    query.append(WHERE_LESSER_THAN_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN);
                } else {
                    query.append(WHERE_LESSER_THAN);
                }
            }
        }

        query.append(ORDER_BY_CLAUSE);

        String[] orderByFields = orderByComparator.getOrderByFields();

        for (int i = 0; i < orderByFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByFields[i]);

            if ((i + 1) < orderByFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC_HAS_NEXT);
                } else {
                    query.append(ORDER_BY_DESC_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC);
                } else {
                    query.append(ORDER_BY_DESC);
                }
            }
        }
    } else {
        if (getDB().isSupportsInlineDistinct()) {
            query.append(SuggestionModelImpl.ORDER_BY_JPQL);
        } else {
            query.append(SuggestionModelImpl.ORDER_BY_SQL);
        }
    }

    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(), Suggestion.class.getName(),
            _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN, groupId);

    SQLQuery q = session.createSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, SuggestionImpl.class);
    } else {
        q.addEntity(_FILTER_ENTITY_TABLE, SuggestionImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(companyId);

    qPos.add(groupId);

    qPos.add(userId);

    if (orderByComparator != null) {
        Object[] values = orderByComparator.getOrderByConditionValues(suggestion);

        for (Object value : values) {
            qPos.add(value);
        }
    }

    List<Suggestion> list = q.list();

    if (list.size() == 2) {
        return list.get(1);
    } else {
        return null;
    }
}

From source file:com.rivetlogic.training.todo.service.persistence.TodoPersistenceImpl.java

License:Open Source License

protected Todo filterGetByCompanyId_GroupId_UserId_PrevAndNext(Session session, Todo todo, long companyId,
        long groupId, long userId, OrderByComparator orderByComparator, boolean previous) {
    StringBundler query = null;//  w w w .  jav  a 2s . c o  m

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

    if (getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_TODO_WHERE);
    } else {
        query.append(_FILTER_SQL_SELECT_TODO_NO_INLINE_DISTINCT_WHERE_1);
    }

    query.append(_FINDER_COLUMN_COMPANYID_GROUPID_USERID_COMPANYID_2);

    query.append(_FINDER_COLUMN_COMPANYID_GROUPID_USERID_GROUPID_2);

    query.append(_FINDER_COLUMN_COMPANYID_GROUPID_USERID_USERID_2);

    if (!getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_TODO_NO_INLINE_DISTINCT_WHERE_2);
    }

    if (orderByComparator != null) {
        String[] orderByConditionFields = orderByComparator.getOrderByConditionFields();

        if (orderByConditionFields.length > 0) {
            query.append(WHERE_AND);
        }

        for (int i = 0; i < orderByConditionFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByConditionFields[i]);

            if ((i + 1) < orderByConditionFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN_HAS_NEXT);
                } else {
                    query.append(WHERE_LESSER_THAN_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN);
                } else {
                    query.append(WHERE_LESSER_THAN);
                }
            }
        }

        query.append(ORDER_BY_CLAUSE);

        String[] orderByFields = orderByComparator.getOrderByFields();

        for (int i = 0; i < orderByFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByFields[i]);

            if ((i + 1) < orderByFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC_HAS_NEXT);
                } else {
                    query.append(ORDER_BY_DESC_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC);
                } else {
                    query.append(ORDER_BY_DESC);
                }
            }
        }
    } else {
        if (getDB().isSupportsInlineDistinct()) {
            query.append(TodoModelImpl.ORDER_BY_JPQL);
        } else {
            query.append(TodoModelImpl.ORDER_BY_SQL);
        }
    }

    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(), Todo.class.getName(),
            _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN, groupId);

    SQLQuery q = session.createSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, TodoImpl.class);
    } else {
        q.addEntity(_FILTER_ENTITY_TABLE, TodoImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(companyId);

    qPos.add(groupId);

    qPos.add(userId);

    if (orderByComparator != null) {
        Object[] values = orderByComparator.getOrderByConditionValues(todo);

        for (Object value : values) {
            qPos.add(value);
        }
    }

    List<Todo> list = q.list();

    if (list.size() == 2) {
        return list.get(1);
    } else {
        return null;
    }
}

From source file:com.tls.liferaylms.mail.service.persistence.MailTemplatePersistenceImpl.java

License:Open Source License

protected MailTemplate filterGetByg_PrevAndNext(Session session, MailTemplate mailTemplate, long groupId,
        OrderByComparator orderByComparator, boolean previous) {
    StringBundler query = null;/*from   www  .  jav a  2 s. c o m*/

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

    if (getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_MAILTEMPLATE_WHERE);
    } else {
        query.append(_FILTER_SQL_SELECT_MAILTEMPLATE_NO_INLINE_DISTINCT_WHERE_1);
    }

    query.append(_FINDER_COLUMN_G_GROUPID_2);

    if (!getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_MAILTEMPLATE_NO_INLINE_DISTINCT_WHERE_2);
    }

    if (orderByComparator != null) {
        String[] orderByConditionFields = orderByComparator.getOrderByConditionFields();

        if (orderByConditionFields.length > 0) {
            query.append(WHERE_AND);
        }

        for (int i = 0; i < orderByConditionFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByConditionFields[i]);

            if ((i + 1) < orderByConditionFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN_HAS_NEXT);
                } else {
                    query.append(WHERE_LESSER_THAN_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN);
                } else {
                    query.append(WHERE_LESSER_THAN);
                }
            }
        }

        query.append(ORDER_BY_CLAUSE);

        String[] orderByFields = orderByComparator.getOrderByFields();

        for (int i = 0; i < orderByFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByFields[i]);

            if ((i + 1) < orderByFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC_HAS_NEXT);
                } else {
                    query.append(ORDER_BY_DESC_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC);
                } else {
                    query.append(ORDER_BY_DESC);
                }
            }
        }
    }

    else {
        if (getDB().isSupportsInlineDistinct()) {
            query.append(MailTemplateModelImpl.ORDER_BY_JPQL);
        } else {
            query.append(MailTemplateModelImpl.ORDER_BY_SQL);
        }
    }

    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(), MailTemplate.class.getName(),
            _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN, groupId);

    SQLQuery q = session.createSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, MailTemplateImpl.class);
    } else {
        q.addEntity(_FILTER_ENTITY_TABLE, MailTemplateImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(groupId);

    if (orderByComparator != null) {
        Object[] values = orderByComparator.getOrderByConditionValues(mailTemplate);

        for (Object value : values) {
            qPos.add(value);
        }
    }

    List<MailTemplate> list = q.list();

    if (list.size() == 2) {
        return list.get(1);
    } else {
        return null;
    }
}

From source file:com.xtivia.book.portlet.service.persistence.impl.BookPersistenceImpl.java

License:Open Source License

protected Book filterGetByGroupId_PrevAndNext(Session session, Book book, long groupId,
        OrderByComparator<Book> orderByComparator, boolean previous) {
    StringBundler query = null;//from  www . ja v a  2s.  c o m

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

    if (getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_BOOK_WHERE);
    } else {
        query.append(_FILTER_SQL_SELECT_BOOK_NO_INLINE_DISTINCT_WHERE_1);
    }

    query.append(_FINDER_COLUMN_GROUPID_GROUPID_2);

    if (!getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_BOOK_NO_INLINE_DISTINCT_WHERE_2);
    }

    if (orderByComparator != null) {
        String[] orderByConditionFields = orderByComparator.getOrderByConditionFields();

        if (orderByConditionFields.length > 0) {
            query.append(WHERE_AND);
        }

        for (int i = 0; i < orderByConditionFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByConditionFields[i]);

            if ((i + 1) < orderByConditionFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN_HAS_NEXT);
                } else {
                    query.append(WHERE_LESSER_THAN_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN);
                } else {
                    query.append(WHERE_LESSER_THAN);
                }
            }
        }

        query.append(ORDER_BY_CLAUSE);

        String[] orderByFields = orderByComparator.getOrderByFields();

        for (int i = 0; i < orderByFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByFields[i]);

            if ((i + 1) < orderByFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC_HAS_NEXT);
                } else {
                    query.append(ORDER_BY_DESC_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC);
                } else {
                    query.append(ORDER_BY_DESC);
                }
            }
        }
    } else {
        if (getDB().isSupportsInlineDistinct()) {
            query.append(BookModelImpl.ORDER_BY_JPQL);
        } else {
            query.append(BookModelImpl.ORDER_BY_SQL);
        }
    }

    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(), Book.class.getName(),
            _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN, groupId);

    SQLQuery q = session.createSynchronizedSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, BookImpl.class);
    } else {
        q.addEntity(_FILTER_ENTITY_TABLE, BookImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(groupId);

    if (orderByComparator != null) {
        Object[] values = orderByComparator.getOrderByConditionValues(book);

        for (Object value : values) {
            qPos.add(value);
        }
    }

    List<Book> list = q.list();

    if (list.size() == 2) {
        return list.get(1);
    } else {
        return null;
    }
}

From source file:com.xtivia.book.portlet.service.persistence.impl.BookPersistenceImpl.java

License:Open Source License

protected Book filterGetByG_S_PrevAndNext(Session session, Book book, long groupId, int status,
        OrderByComparator<Book> orderByComparator, boolean previous) {
    StringBundler query = null;// w  w  w  .j a va  2s  .c  o m

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

    if (getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_BOOK_WHERE);
    } else {
        query.append(_FILTER_SQL_SELECT_BOOK_NO_INLINE_DISTINCT_WHERE_1);
    }

    query.append(_FINDER_COLUMN_G_S_GROUPID_2);

    query.append(_FINDER_COLUMN_G_S_STATUS_2);

    if (!getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_BOOK_NO_INLINE_DISTINCT_WHERE_2);
    }

    if (orderByComparator != null) {
        String[] orderByConditionFields = orderByComparator.getOrderByConditionFields();

        if (orderByConditionFields.length > 0) {
            query.append(WHERE_AND);
        }

        for (int i = 0; i < orderByConditionFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByConditionFields[i]);

            if ((i + 1) < orderByConditionFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN_HAS_NEXT);
                } else {
                    query.append(WHERE_LESSER_THAN_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN);
                } else {
                    query.append(WHERE_LESSER_THAN);
                }
            }
        }

        query.append(ORDER_BY_CLAUSE);

        String[] orderByFields = orderByComparator.getOrderByFields();

        for (int i = 0; i < orderByFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByFields[i]);

            if ((i + 1) < orderByFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC_HAS_NEXT);
                } else {
                    query.append(ORDER_BY_DESC_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC);
                } else {
                    query.append(ORDER_BY_DESC);
                }
            }
        }
    } else {
        if (getDB().isSupportsInlineDistinct()) {
            query.append(BookModelImpl.ORDER_BY_JPQL);
        } else {
            query.append(BookModelImpl.ORDER_BY_SQL);
        }
    }

    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(), Book.class.getName(),
            _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN, groupId);

    SQLQuery q = session.createSynchronizedSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, BookImpl.class);
    } else {
        q.addEntity(_FILTER_ENTITY_TABLE, BookImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(groupId);

    qPos.add(status);

    if (orderByComparator != null) {
        Object[] values = orderByComparator.getOrderByConditionValues(book);

        for (Object value : values) {
            qPos.add(value);
        }
    }

    List<Book> list = q.list();

    if (list.size() == 2) {
        return list.get(1);
    } else {
        return null;
    }
}

From source file:de.ancud.shorturl.service.persistence.ShortUrlPersistenceImpl.java

License:Open Source License

protected ShortUrl filterGetByGroupId_PrevAndNext(Session session, ShortUrl shortUrl, long groupId,
        OrderByComparator orderByComparator, boolean previous) {
    StringBundler query = null;//  www . j av a2 s .  c om

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

    if (getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_SHORTURL_WHERE);
    } else {
        query.append(_FILTER_SQL_SELECT_SHORTURL_NO_INLINE_DISTINCT_WHERE_1);
    }

    query.append(_FINDER_COLUMN_GROUPID_GROUPID_2);

    if (!getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_SHORTURL_NO_INLINE_DISTINCT_WHERE_2);
    }

    if (orderByComparator != null) {
        String[] orderByConditionFields = orderByComparator.getOrderByConditionFields();

        if (orderByConditionFields.length > 0) {
            query.append(WHERE_AND);
        }

        for (int i = 0; i < orderByConditionFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByConditionFields[i]);

            if ((i + 1) < orderByConditionFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN_HAS_NEXT);
                } else {
                    query.append(WHERE_LESSER_THAN_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN);
                } else {
                    query.append(WHERE_LESSER_THAN);
                }
            }
        }

        query.append(ORDER_BY_CLAUSE);

        String[] orderByFields = orderByComparator.getOrderByFields();

        for (int i = 0; i < orderByFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByFields[i]);

            if ((i + 1) < orderByFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC_HAS_NEXT);
                } else {
                    query.append(ORDER_BY_DESC_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC);
                } else {
                    query.append(ORDER_BY_DESC);
                }
            }
        }
    } else {
        if (getDB().isSupportsInlineDistinct()) {
            query.append(ShortUrlModelImpl.ORDER_BY_JPQL);
        } else {
            query.append(ShortUrlModelImpl.ORDER_BY_SQL);
        }
    }

    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(), ShortUrl.class.getName(),
            _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN, groupId);

    SQLQuery q = session.createSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, ShortUrlImpl.class);
    } else {
        q.addEntity(_FILTER_ENTITY_TABLE, ShortUrlImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(groupId);

    if (orderByComparator != null) {
        Object[] values = orderByComparator.getOrderByConditionValues(shortUrl);

        for (Object value : values) {
            qPos.add(value);
        }
    }

    List<ShortUrl> list = q.list();

    if (list.size() == 2) {
        return list.get(1);
    } else {
        return null;
    }
}

From source file:gr.open.loglevelsmanager.loglevel.service.persistence.LogLevelPersistenceImpl.java

License:Open Source License

protected LogLevel filterGetByGroupId_PrevAndNext(Session session, LogLevel logLevel, long groupId,
        OrderByComparator orderByComparator, boolean previous) {
    StringBundler query = null;/*from  w  w w . j a va2  s . c  o m*/

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

    if (getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_LOGLEVEL_WHERE);
    } else {
        query.append(_FILTER_SQL_SELECT_LOGLEVEL_NO_INLINE_DISTINCT_WHERE_1);
    }

    query.append(_FINDER_COLUMN_GROUPID_GROUPID_2);

    if (!getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_LOGLEVEL_NO_INLINE_DISTINCT_WHERE_2);
    }

    if (orderByComparator != null) {
        String[] orderByConditionFields = orderByComparator.getOrderByConditionFields();

        if (orderByConditionFields.length > 0) {
            query.append(WHERE_AND);
        }

        for (int i = 0; i < orderByConditionFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByConditionFields[i]);

            if ((i + 1) < orderByConditionFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN_HAS_NEXT);
                } else {
                    query.append(WHERE_LESSER_THAN_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN);
                } else {
                    query.append(WHERE_LESSER_THAN);
                }
            }
        }

        query.append(ORDER_BY_CLAUSE);

        String[] orderByFields = orderByComparator.getOrderByFields();

        for (int i = 0; i < orderByFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByFields[i]);

            if ((i + 1) < orderByFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC_HAS_NEXT);
                } else {
                    query.append(ORDER_BY_DESC_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC);
                } else {
                    query.append(ORDER_BY_DESC);
                }
            }
        }
    } else {
        if (getDB().isSupportsInlineDistinct()) {
            query.append(LogLevelModelImpl.ORDER_BY_JPQL);
        } else {
            query.append(LogLevelModelImpl.ORDER_BY_SQL);
        }
    }

    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(), LogLevel.class.getName(),
            _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN, groupId);

    SQLQuery q = session.createSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, LogLevelImpl.class);
    } else {
        q.addEntity(_FILTER_ENTITY_TABLE, LogLevelImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(groupId);

    if (orderByComparator != null) {
        Object[] values = orderByComparator.getOrderByConditionValues(logLevel);

        for (Object value : values) {
            qPos.add(value);
        }
    }

    List<LogLevel> list = q.list();

    if (list.size() == 2) {
        return list.get(1);
    } else {
        return null;
    }
}

From source file:gr.open.loglevelsmanager.loglevel.service.persistence.LogLevelPersistenceImpl.java

License:Open Source License

protected LogLevel filterGetByUserIdGroupId_PrevAndNext(Session session, LogLevel logLevel, long userId,
        long groupId, OrderByComparator orderByComparator, boolean previous) {
    StringBundler query = null;//w  ww  .jav a  2s.c  om

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

    if (getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_LOGLEVEL_WHERE);
    } else {
        query.append(_FILTER_SQL_SELECT_LOGLEVEL_NO_INLINE_DISTINCT_WHERE_1);
    }

    query.append(_FINDER_COLUMN_USERIDGROUPID_USERID_2);

    query.append(_FINDER_COLUMN_USERIDGROUPID_GROUPID_2);

    if (!getDB().isSupportsInlineDistinct()) {
        query.append(_FILTER_SQL_SELECT_LOGLEVEL_NO_INLINE_DISTINCT_WHERE_2);
    }

    if (orderByComparator != null) {
        String[] orderByConditionFields = orderByComparator.getOrderByConditionFields();

        if (orderByConditionFields.length > 0) {
            query.append(WHERE_AND);
        }

        for (int i = 0; i < orderByConditionFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByConditionFields[i]);

            if ((i + 1) < orderByConditionFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN_HAS_NEXT);
                } else {
                    query.append(WHERE_LESSER_THAN_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(WHERE_GREATER_THAN);
                } else {
                    query.append(WHERE_LESSER_THAN);
                }
            }
        }

        query.append(ORDER_BY_CLAUSE);

        String[] orderByFields = orderByComparator.getOrderByFields();

        for (int i = 0; i < orderByFields.length; i++) {
            if (getDB().isSupportsInlineDistinct()) {
                query.append(_ORDER_BY_ENTITY_ALIAS);
            } else {
                query.append(_ORDER_BY_ENTITY_TABLE);
            }

            query.append(orderByFields[i]);

            if ((i + 1) < orderByFields.length) {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC_HAS_NEXT);
                } else {
                    query.append(ORDER_BY_DESC_HAS_NEXT);
                }
            } else {
                if (orderByComparator.isAscending() ^ previous) {
                    query.append(ORDER_BY_ASC);
                } else {
                    query.append(ORDER_BY_DESC);
                }
            }
        }
    } else {
        if (getDB().isSupportsInlineDistinct()) {
            query.append(LogLevelModelImpl.ORDER_BY_JPQL);
        } else {
            query.append(LogLevelModelImpl.ORDER_BY_SQL);
        }
    }

    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(), LogLevel.class.getName(),
            _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN, groupId);

    SQLQuery q = session.createSQLQuery(sql);

    q.setFirstResult(0);
    q.setMaxResults(2);

    if (getDB().isSupportsInlineDistinct()) {
        q.addEntity(_FILTER_ENTITY_ALIAS, LogLevelImpl.class);
    } else {
        q.addEntity(_FILTER_ENTITY_TABLE, LogLevelImpl.class);
    }

    QueryPos qPos = QueryPos.getInstance(q);

    qPos.add(userId);

    qPos.add(groupId);

    if (orderByComparator != null) {
        Object[] values = orderByComparator.getOrderByConditionValues(logLevel);

        for (Object value : values) {
            qPos.add(value);
        }
    }

    List<LogLevel> list = q.list();

    if (list.size() == 2) {
        return list.get(1);
    } else {
        return null;
    }
}