* The persistence implementation for the l f question category service.

*

* <p>

* Caching information and settings can be found in <code>portal.properties</code>

* </p>

*

* @author Brian Wing Shun Chan

* @see LFQuestionCategoryPersistence

* @see LFQuestionCategoryUtil

* @generated

*/

    implements LFQuestionCategoryPersistence {

    /*

     * NOTE FOR DEVELOPERS:

     *

     * Never modify or reference this class directly. Always use {@link LFQuestionCategoryUtil} to access the l f question category persistence. Modify <code>service.xml</code> and rerun ServiceBuilder to regenerate this class.

     */

    public static final String FINDER_CLASS_NAME_ENTITY = LFQuestionCategoryImpl.class.getName();

    public static final String FINDER_CLASS_NAME_LIST_WITH_PAGINATION = FINDER_CLASS_NAME_ENTITY +

        ".List1";

    public static final String FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION = FINDER_CLASS_NAME_ENTITY +

        ".List2";

    public static final FinderPath FINDER_PATH_WITH_PAGINATION_FIND_ALL = new FinderPath(LFQuestionCategoryModelImpl.ENTITY_CACHE_ENABLED,

            LFQuestionCategoryModelImpl.FINDER_CACHE_ENABLED,

            LFQuestionCategoryImpl.class,

            FINDER_CLASS_NAME_LIST_WITH_PAGINATION, "findAll", new String[0]);

    public static final FinderPath FINDER_PATH_WITHOUT_PAGINATION_FIND_ALL = new FinderPath(LFQuestionCategoryModelImpl.ENTITY_CACHE_ENABLED,

            LFQuestionCategoryModelImpl.FINDER_CACHE_ENABLED,

            LFQuestionCategoryImpl.class,

            FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION, "findAll", new String[0]);

    public static final FinderPath FINDER_PATH_COUNT_ALL = new FinderPath(LFQuestionCategoryModelImpl.ENTITY_CACHE_ENABLED,

            LFQuestionCategoryModelImpl.FINDER_CACHE_ENABLED, Long.class,

            FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION, "countAll", new String[0]);

    public static final FinderPath FINDER_PATH_WITH_PAGINATION_FIND_BY_COURSEID = new FinderPath(LFQuestionCategoryModelImpl.ENTITY_CACHE_ENABLED,

            LFQuestionCategoryModelImpl.FINDER_CACHE_ENABLED,

            LFQuestionCategoryImpl.class,

            FINDER_CLASS_NAME_LIST_WITH_PAGINATION, "findByCourseId",

            new String[] {

                Integer.class.getName(),

               

            Integer.class.getName(), Integer.class.getName(),

                OrderByComparator.class.getName()

            });

    public static final FinderPath FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_COURSEID =

        new FinderPath(LFQuestionCategoryModelImpl.ENTITY_CACHE_ENABLED,

            LFQuestionCategoryModelImpl.FINDER_CACHE_ENABLED,

            LFQuestionCategoryImpl.class,

            FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION, "findByCourseId",

            new String[] { Integer.class.getName() },

            LFQuestionCategoryModelImpl.COURSEID_COLUMN_BITMASK);

    public static final FinderPath FINDER_PATH_COUNT_BY_COURSEID = new FinderPath(LFQuestionCategoryModelImpl.ENTITY_CACHE_ENABLED,

            LFQuestionCategoryModelImpl.FINDER_CACHE_ENABLED, Long.class,

            FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION, "countByCourseId",

            new String[] { Integer.class.getName() });

    public static final FinderPath FINDER_PATH_WITH_PAGINATION_COUNT_BY_COURSEID =

        new FinderPath(LFQuestionCategoryModelImpl.ENTITY_CACHE_ENABLED,

            LFQuestionCategoryModelImpl.FINDER_CACHE_ENABLED, Long.class,

            FINDER_CLASS_NAME_LIST_WITH_PAGINATION, "countByCourseId",

            new String[] { Integer.class.getName() });

    private static final String _FINDER_COLUMN_COURSEID_COURSEID_NULL = "lfQuestionCategory.courseId IS NULL";

    private static final String _FINDER_COLUMN_COURSEID_COURSEID_2 = "lfQuestionCategory.courseId = ?";

    private static final String _FINDER_COLUMN_COURSEID_COURSEID_NULL_2 = "lfQuestionCategory.courseId IS NULL ";

    private static final String _FINDER_COLUMN_COURSEID_COURSEID_5 = "(" +

        removeConjunction(_FINDER_COLUMN_COURSEID_COURSEID_2) + ")";

    private static final String _FINDER_COLUMN_COURSEID_COURSEID_5_NULL = "(" +

        _removeConjunction(_FINDER_COLUMN_COURSEID_COURSEID_NULL_2) + ")";

    public static final FinderPath FINDER_PATH_WITH_PAGINATION_FIND_BY_COURSEIDANDPARENTID =

        new FinderPath(LFQuestionCategoryModelImpl.ENTITY_CACHE_ENABLED,

            LFQuestionCategoryModelImpl.FINDER_CACHE_ENABLED,

            LFQuestionCategoryImpl.class,

            FINDER_CLASS_NAME_LIST_WITH_PAGINATION,

            "findByCourseIdAndParentId",

            new String[] {

                Integer.class.getName(), Integer.class.getName(),

               

            Integer.class.getName(), Integer.class.getName(),

                OrderByComparator.class.getName()

            });

    public static final FinderPath FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_COURSEIDANDPARENTID =

        new FinderPath(LFQuestionCategoryModelImpl.ENTITY_CACHE_ENABLED,

            LFQuestionCategoryModelImpl.FINDER_CACHE_ENABLED,

            LFQuestionCategoryImpl.class,

            FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION,

            "findByCourseIdAndParentId",

            new String[] { Integer.class.getName(), Integer.class.getName() },

            LFQuestionCategoryModelImpl.COURSEID_COLUMN_BITMASK |

            LFQuestionCategoryModelImpl.PARENTID_COLUMN_BITMASK);

    public static final FinderPath FINDER_PATH_COUNT_BY_COURSEIDANDPARENTID = new FinderPath(LFQuestionCategoryModelImpl.ENTITY_CACHE_ENABLED,

            LFQuestionCategoryModelImpl.FINDER_CACHE_ENABLED, Long.class,

            FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION,

            "countByCourseIdAndParentId",

            new String[] { Integer.class.getName(), Integer.class.getName() });

    public static final FinderPath FINDER_PATH_WITH_PAGINATION_COUNT_BY_COURSEIDANDPARENTID =

        new FinderPath(LFQuestionCategoryModelImpl.ENTITY_CACHE_ENABLED,

            LFQuestionCategoryModelImpl.FINDER_CACHE_ENABLED, Long.class,

            FINDER_CLASS_NAME_LIST_WITH_PAGINATION,

            "countByCourseIdAndParentId",

            new String[] { Integer.class.getName(), Integer.class.getName() });

    private static final String _FINDER_COLUMN_COURSEIDANDPARENTID_COURSEID_NULL =

        "lfQuestionCategory.courseId IS NULL";

    private static final String _FINDER_COLUMN_COURSEIDANDPARENTID_COURSEID_2 = "lfQuestionCategory.courseId = ? AND ";

    private static final String _FINDER_COLUMN_COURSEIDANDPARENTID_COURSEID_NULL_2 =

        "lfQuestionCategory.courseId IS NULL  AND ";

    private static final String _FINDER_COLUMN_COURSEIDANDPARENTID_COURSEID_5 = "(" +

        removeConjunction(_FINDER_COLUMN_COURSEIDANDPARENTID_COURSEID_2) + ")";

    private static final String _FINDER_COLUMN_COURSEIDANDPARENTID_COURSEID_5_NULL =

        "(" +

        _removeConjunction(_FINDER_COLUMN_COURSEIDANDPARENTID_COURSEID_NULL_2) +

        ")";

    private static final String _FINDER_COLUMN_COURSEIDANDPARENTID_PARENTID_NULL =

        "lfQuestionCategory.parentId IS NULL";

    private static final String _FINDER_COLUMN_COURSEIDANDPARENTID_PARENTID_2 = "lfQuestionCategory.parentId = ?";

    private static final String _FINDER_COLUMN_COURSEIDANDPARENTID_PARENTID_NULL_2 =

        "lfQuestionCategory.parentId IS NULL ";

    private static final String _FINDER_COLUMN_COURSEIDANDPARENTID_PARENTID_5 = "(" +

        removeConjunction(_FINDER_COLUMN_COURSEIDANDPARENTID_PARENTID_2) + ")";

    private static final String _FINDER_COLUMN_COURSEIDANDPARENTID_PARENTID_5_NULL =

        "(" +

        _removeConjunction(_FINDER_COLUMN_COURSEIDANDPARENTID_PARENTID_NULL_2) +

        ")";

    private static final String _SQL_SELECT_LFQUESTIONCATEGORY = "SELECT lfQuestionCategory FROM LFQuestionCategory lfQuestionCategory";

    private static final String _SQL_SELECT_LFQUESTIONCATEGORY_WHERE = "SELECT lfQuestionCategory FROM LFQuestionCategory lfQuestionCategory WHERE ";

    private static final String _SQL_COUNT_LFQUESTIONCATEGORY = "SELECT COUNT(lfQuestionCategory) FROM LFQuestionCategory lfQuestionCategory";

    private static final String _SQL_COUNT_LFQUESTIONCATEGORY_WHERE = "SELECT COUNT(lfQuestionCategory) FROM LFQuestionCategory lfQuestionCategory WHERE ";

    private static final String _ORDER_BY_ENTITY_ALIAS = "lfQuestionCategory.";

    private static final String _NO_SUCH_ENTITY_WITH_PRIMARY_KEY = "No LFQuestionCategory exists with the primary key ";

    private static final String _NO_SUCH_ENTITY_WITH_KEY = "No LFQuestionCategory exists with the key {";

    private static final boolean _HIBERNATE_CACHE_USE_SECOND_LEVEL_CACHE = GetterUtil.getBoolean(PropsUtil.get(

                PropsKeys.HIBERNATE_CACHE_USE_SECOND_LEVEL_CACHE));

    private static Log _log = LogFactoryUtil.getLog(LFQuestionCategoryPersistenceImpl.class);

    private static Set<String> _badColumnNames = SetUtil.fromArray(new String[] {

                "id"

            });

    private static LFQuestionCategory _nullLFQuestionCategory = new LFQuestionCategoryImpl() {

            @Override

            public Object clone() {

                return this;

            }

            @Override

            public CacheModel<LFQuestionCategory> toCacheModel() {

                return _nullLFQuestionCategoryCacheModel;

            }

        };

    private static CacheModel<LFQuestionCategory> _nullLFQuestionCategoryCacheModel =

        new CacheModel<LFQuestionCategory>() {

            @Override

            public LFQuestionCategory toEntityModel() {

                return _nullLFQuestionCategory;

            }

        };

    public LFQuestionCategoryPersistenceImpl() {

        setModelClass(LFQuestionCategory.class);

    }

    /**

     * Returns all the l f question categories where courseId = &#63;.

     *

     * @param courseId the course ID

     * @return the matching l f question categories

     * @throws SystemException if a system exception occurred

     */

    @Override

    public List<LFQuestionCategory> findByCourseId(Integer courseId)

        throws SystemException {

        return findByCourseId(courseId, QueryUtil.ALL_POS, QueryUtil.ALL_POS,

            null);

    }

    /**

     * Returns a range of all the l f question categories where courseId = &#63;.

     *

     * <p>

     * 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 com.liferay.portal.kernel.dao.orm.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 com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.arcusys.learn.persistence.liferay.model.impl.LFQuestionCategoryModelImpl}. 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 courseId the course ID

     * @param start the lower bound of the range of l f question categories

     * @param end the upper bound of the range of l f question categories (not inclusive)

     * @return the range of matching l f question categories

     * @throws SystemException if a system exception occurred

     */

    @Override

    public List<LFQuestionCategory> findByCourseId(Integer courseId, int start,

        int end) throws SystemException {

        return findByCourseId(courseId, start, end, null);

    }

    /**

     * Returns an ordered range of all the l f question categories where courseId = &#63;.

     *

     * <p>

     * 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 com.liferay.portal.kernel.dao.orm.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 com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.arcusys.learn.persistence.liferay.model.impl.LFQuestionCategoryModelImpl}. 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 courseId the course ID

     * @param start the lower bound of the range of l f question categories

     * @param end the upper bound of the range of l f question categories (not inclusive)

     * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)

     * @return the ordered range of matching l f question categories

     * @throws SystemException if a system exception occurred

     */

    @Override

    public List<LFQuestionCategory> findByCourseId(Integer courseId, int start,

        int end, OrderByComparator orderByComparator) throws SystemException {

        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_COURSEID;

            finderArgs = new Object[] { courseId };

        } else {

            finderPath = FINDER_PATH_WITH_PAGINATION_FIND_BY_COURSEID;

            finderArgs = new Object[] { courseId, start, end, orderByComparator };

        }

        List<LFQuestionCategory> list = (List<LFQuestionCategory>) FinderCacheUtil.getResult(finderPath,

                finderArgs, this);

        if ((list != null) && !list.isEmpty()) {

            for (LFQuestionCategory lfQuestionCategory : list) {

                if (!Validator.equals(courseId, lfQuestionCategory.getCourseId())) {

                    list = null;

                    break;

                }

            }

        }

        if (list == null) {

            StringBundler query = null;

            if (orderByComparator != null) {

                query = new StringBundler(3 +

                        (orderByComparator.getOrderByFields().length * 3));

            } else {

                query = new StringBundler(3);

            }

            query.append(_SQL_SELECT_LFQUESTIONCATEGORY_WHERE);

            if (courseId == null) {

                query.append(_FINDER_COLUMN_COURSEID_COURSEID_NULL_2);

            } else {

                query.append(_FINDER_COLUMN_COURSEID_COURSEID_2);

            }

            if (orderByComparator != null) {

                appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,

                    orderByComparator);

            } else

             if (pagination) {

                query.append(LFQuestionCategoryModelImpl.ORDER_BY_JPQL);

            }

            String sql = query.toString();

            Session session = null;

            try {

                session = openSession();

                Query q = session.createQuery(sql);

                QueryPos qPos = QueryPos.getInstance(q);

                if (courseId != null) {

                    qPos.add(courseId.intValue());

                }

                if (!pagination) {

                    list = (List<LFQuestionCategory>) QueryUtil.list(q,

                            getDialect(), start, end, false);

                    Collections.sort(list);

                    list = new UnmodifiableList<LFQuestionCategory>(list);

                } else {

                    list = (List<LFQuestionCategory>) QueryUtil.list(q,

                            getDialect(), start, end);

                }

                cacheResult(list);

                FinderCacheUtil.putResult(finderPath, finderArgs, list);

            } catch (Exception e) {

                FinderCacheUtil.removeResult(finderPath, finderArgs);

                throw processException(e);

            } finally {

                closeSession(session);

            }

        }

        return list;

    }

    /**

     * Returns the first l f question category in the ordered set where courseId = &#63;.

     *

     * @param courseId the course ID

     * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)

     * @return the first matching l f question category

     * @throws com.arcusys.learn.persistence.liferay.NoSuchLFQuestionCategoryException if a matching l f question category could not be found

     * @throws SystemException if a system exception occurred

     */

    @Override

    public LFQuestionCategory findByCourseId_First(Integer courseId,

        OrderByComparator orderByComparator)

        throws NoSuchLFQuestionCategoryException, SystemException {

        LFQuestionCategory lfQuestionCategory = fetchByCourseId_First(courseId,

                orderByComparator);

        if (lfQuestionCategory != null) {

            return lfQuestionCategory;

        }

        StringBundler msg = new StringBundler(4);

        msg.append(_NO_SUCH_ENTITY_WITH_KEY);

        msg.append("courseId=");

        msg.append(courseId);

        msg.append(StringPool.CLOSE_CURLY_BRACE);

        throw new NoSuchLFQuestionCategoryException(msg.toString());

    }

    /**

     * Returns the first l f question category in the ordered set where courseId = &#63;.

     *

     * @param courseId the course ID

     * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)

     * @return the first matching l f question category, or <code>null</code> if a matching l f question category could not be found

     * @throws SystemException if a system exception occurred

     */

    @Override

    public LFQuestionCategory fetchByCourseId_First(Integer courseId,

        OrderByComparator orderByComparator) throws SystemException {

        List<LFQuestionCategory> list = findByCourseId(courseId, 0, 1,

                orderByComparator);

        if (!list.isEmpty()) {

            return list.get(0);

        }

        return null;

    }

    /**

     * Returns the last l f question category in the ordered set where courseId = &#63;.

     *

     * @param courseId the course ID

     * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)

     * @return the last matching l f question category

     * @throws com.arcusys.learn.persistence.liferay.NoSuchLFQuestionCategoryException if a matching l f question category could not be found

     * @throws SystemException if a system exception occurred

     */

    @Override

    public LFQuestionCategory findByCourseId_Last(Integer courseId,

        OrderByComparator orderByComparator)

        throws NoSuchLFQuestionCategoryException, SystemException {

        LFQuestionCategory lfQuestionCategory = fetchByCourseId_Last(courseId,

                orderByComparator);

        if (lfQuestionCategory != null) {

            return lfQuestionCategory;

        }

        StringBundler msg = new StringBundler(4);

        msg.append(_NO_SUCH_ENTITY_WITH_KEY);

        msg.append("courseId=");

        msg.append(courseId);

        msg.append(StringPool.CLOSE_CURLY_BRACE);

        throw new NoSuchLFQuestionCategoryException(msg.toString());

    }

    /**

     * Returns the last l f question category in the ordered set where courseId = &#63;.

     *

     * @param courseId the course ID

     * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)

     * @return the last matching l f question category, or <code>null</code> if a matching l f question category could not be found

     * @throws SystemException if a system exception occurred

     */

    @Override

    public LFQuestionCategory fetchByCourseId_Last(Integer courseId,

        OrderByComparator orderByComparator) throws SystemException {

        int count = countByCourseId(courseId);

        if (count == 0) {

            return null;

        }

        List<LFQuestionCategory> list = findByCourseId(courseId, count - 1,

                count, orderByComparator);

        if (!list.isEmpty()) {

            return list.get(0);

        }

        return null;

    }

    /**

     * Returns the l f question categories before and after the current l f question category in the ordered set where courseId = &#63;.

     *

     * @param id the primary key of the current l f question category

     * @param courseId the course ID

     * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)

     * @return the previous, current, and next l f question category

     * @throws com.arcusys.learn.persistence.liferay.NoSuchLFQuestionCategoryException if a l f question category with the primary key could not be found

     * @throws SystemException if a system exception occurred

     */

    @Override

    public LFQuestionCategory[] findByCourseId_PrevAndNext(long id,

        Integer courseId, OrderByComparator orderByComparator)

        throws NoSuchLFQuestionCategoryException, SystemException {

        LFQuestionCategory lfQuestionCategory = findByPrimaryKey(id);

        Session session = null;

        try {

            session = openSession();

            LFQuestionCategory[] array = new LFQuestionCategoryImpl[3];

            array[0] = getByCourseId_PrevAndNext(session, lfQuestionCategory,

                    courseId, orderByComparator, true);

            array[1] = lfQuestionCategory;

            array[2] = getByCourseId_PrevAndNext(session, lfQuestionCategory,

                    courseId, orderByComparator, false);

            return array;

        } catch (Exception e) {

            throw processException(e);

        } finally {

            closeSession(session);

        }

    }

    protected LFQuestionCategory getByCourseId_PrevAndNext(Session session,

        LFQuestionCategory lfQuestionCategory, Integer courseId,

        OrderByComparator orderByComparator, boolean previous) {

        StringBundler query = null;

        if (orderByComparator != null) {

            query = new StringBundler(6 +

                    (orderByComparator.getOrderByFields().length * 6));

        } else {

            query = new StringBundler(3);

        }

        query.append(_SQL_SELECT_LFQUESTIONCATEGORY_WHERE);

        if (courseId == null) {

            query.append(_FINDER_COLUMN_COURSEID_COURSEID_NULL_2);

        } else {

            query.append(_FINDER_COLUMN_COURSEID_COURSEID_2);

        }

        if (orderByComparator != null) {

            String[] orderByConditionFields = orderByComparator.getOrderByConditionFields();

            if (orderByConditionFields.length > 0) {

                query.append(WHERE_AND);

            }

            for (int i = 0; i < orderByConditionFields.length; i++) {

                query.append(_ORDER_BY_ENTITY_ALIAS);

                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++) {

                query.append(_ORDER_BY_ENTITY_ALIAS);

                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 {

            query.append(LFQuestionCategoryModelImpl.ORDER_BY_JPQL);

        }

        String sql = query.toString();

        Query q = session.createQuery(sql);

        q.setFirstResult(0);

        q.setMaxResults(2);

        QueryPos qPos = QueryPos.getInstance(q);

        if (courseId != null) {

            qPos.add(courseId.intValue());

        }

        if (orderByComparator != null) {

            Object[] values = orderByComparator.getOrderByConditionValues(lfQuestionCategory);

            for (Object value : values) {

                qPos.add(value);

            }

        }

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

        if (list.size() == 2) {

            return list.get(1);

        } else {

            return null;

        }

    }

    /**

     * Returns all the l f question categories where courseId = any &#63;.

     *

     * <p>

     * 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 com.liferay.portal.kernel.dao.orm.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 com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.arcusys.learn.persistence.liferay.model.impl.LFQuestionCategoryModelImpl}. 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 courseIds the course IDs

     * @return the matching l f question categories

     * @throws SystemException if a system exception occurred

     */

    @Override

    public List<LFQuestionCategory> findByCourseId(Integer[] courseIds)

        throws SystemException {

        return findByCourseId(courseIds, QueryUtil.ALL_POS, QueryUtil.ALL_POS,

            null);

    }

    /**

     * Returns a range of all the l f question categories where courseId = any &#63;.

     *

     * <p>

     * 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 com.liferay.portal.kernel.dao.orm.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 com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.arcusys.learn.persistence.liferay.model.impl.LFQuestionCategoryModelImpl}. 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 courseIds the course IDs

     * @param start the lower bound of the range of l f question categories

     * @param end the upper bound of the range of l f question categories (not inclusive)

     * @return the range of matching l f question categories

     * @throws SystemException if a system exception occurred

     */

    @Override

    public List<LFQuestionCategory> findByCourseId(Integer[] courseIds,

        int start, int end) throws SystemException {

        return findByCourseId(courseIds, start, end, null);

    }

    /**

     * Returns an ordered range of all the l f question categories where courseId = any &#63;.

     *

     * <p>

     * 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 com.liferay.portal.kernel.dao.orm.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 com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link com.arcusys.learn.persistence.liferay.model.impl.LFQuestionCategoryModelImpl}. 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 courseIds the course IDs

     * @param start the lower bound of the range of l f question categories

     * @param end the upper bound of the range of l f question categories (not inclusive)

     * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)

     * @return the ordered range of matching l f question categories

     * @throws SystemException if a system exception occurred

     */

    @Override

    public List<LFQuestionCategory> findByCourseId(Integer[] courseIds,

        int start, int end, OrderByComparator orderByComparator)

        throws SystemException {

        if ((courseIds != null) && (courseIds.length == 1)) {

            return findByCourseId(courseIds[0], start, end, orderByComparator);

        }

        boolean pagination = true;

        Object[] finderArgs = null;

        if ((start == QueryUtil.ALL_POS) && (end == QueryUtil.ALL_POS) &&

                (orderByComparator == null)) {

            pagination = false;

            finderArgs = new Object[] { StringUtil.merge(courseIds) };

        } else {

            finderArgs = new Object[] {

                    StringUtil.merge(courseIds),

                   

                    start, end, orderByComparator

                };

        }

        List<LFQuestionCategory> list = (List<LFQuestionCategory>) FinderCacheUtil.getResult(FINDER_PATH_WITH_PAGINATION_FIND_BY_COURSEID,

                finderArgs, this);

        if ((list != null) && !list.isEmpty()) {

            for (LFQuestionCategory lfQuestionCategory : list) {

                if (!ArrayUtil.contains(courseIds,

                            lfQuestionCategory.getCourseId())) {

                    list = null;

                    break;

                }

            }

        }

        if (list == null) {

            StringBundler query = new StringBundler();

            query.append(_SQL_SELECT_LFQUESTIONCATEGORY_WHERE);

            boolean conjunctionable = false;

            if ((courseIds != null) && (courseIds.length > 0)) {

                if (conjunctionable) {

                    query.append(WHERE_AND);

                }

                query.append(StringPool.OPEN_PARENTHESIS);

                for (int i = 0; i < courseIds.length; i++) {

                    if (courseIds[i] == null) {

                        query.append(_FINDER_COLUMN_COURSEID_COURSEID_NULL);

                    } else {

                        query.append(_FINDER_COLUMN_COURSEID_COURSEID_5);

                    }

                    if ((i + 1) < courseIds.length) {

                        query.append(WHERE_OR);

                    }

                }

                query.append(StringPool.CLOSE_PARENTHESIS);

                conjunctionable = true;

            }

            if (orderByComparator != null) {

                appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS,

                    orderByComparator);

            } else

             if (pagination) {

                query.append(LFQuestionCategoryModelImpl.ORDER_BY_JPQL);

            }

            String sql = query.toString();

            Session session = null;

            try {

                session = openSession();

                Query q = session.createQuery(sql);

                QueryPos qPos = QueryPos.getInstance(q);

                if (courseIds != null) {

                    for (Integer courseId : courseIds) {

                        if (courseId != null) {

                            qPos.add(courseId);

                        }

                    }

                }

                if (!pagination) {

                    list = (List<LFQuestionCategory>) QueryUtil.list(q,

                            getDialect(), start, end, false);

                    Collections.sort(list);

                    list = new UnmodifiableList<LFQuestionCategory>(list);

                } else {

                    list = (List<LFQuestionCategory>) QueryUtil.list(q,

                            getDialect(), start, end);

                }

                cacheResult(list);

                FinderCacheUtil.putResult(FINDER_PATH_WITH_PAGINATION_FIND_BY_COURSEID,

                    finderArgs, list);

            } catch (Exception e) {

                FinderCacheUtil.removeResult(FINDER_PATH_WITH_PAGINATION_FIND_BY_COURSEID,

                    finderArgs);

                throw processException(e);

            } finally {

                closeSession(session);

            }

        }

        return list;

    }

    /**

     * Removes all the l f question categories where courseId = &#63; from the database.

     *

     * @param courseId the course ID

     * @throws SystemException if a system exception occurred

     */

    @Override

    public void removeByCourseId(Integer courseId) throws SystemException {

        for (LFQuestionCategory lfQuestionCategory : findByCourseId(courseId,

                QueryUtil.ALL_POS, QueryUtil.ALL_POS, null)) {

            remove(lfQuestionCategory);

        }

    }

    /**

     * Returns the number of l f question categories where courseId = &#63;.

     *

     * @param courseId the course ID

     * @return the number of matching l f question categories

     * @throws SystemException if a system exception occurred

     */

    @Override

    public int countByCourseId(Integer courseId) throws SystemException {

        FinderPath finderPath = FINDER_PATH_COUNT_BY_COURSEID;

        Object[] finderArgs = new Object[] { courseId };

        Long count = (Long) FinderCacheUtil.getResult(finderPath, finderArgs,

                this);

        if (count == null) {