/** * Copyright (c) 2000-present Liferay, Inc. All rights reserved. * * This library is free software; you can redistribute it and/or modify it under * the terms of the GNU Lesser General Public License as published by the Free * Software Foundation; either version 2.1 of the License, or (at your option) * any later version. * * This library is distributed in the hope that it will be useful, but WITHOUT * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS * FOR A PARTICULAR PURPOSE. See the GNU Lesser General Public License for more * details. */ package com.liferay.portal.workflow.kaleo.service.persistence.impl; import aQute.bnd.annotation.ProviderType; import com.liferay.portal.kernel.dao.orm.EntityCache; import com.liferay.portal.kernel.dao.orm.FinderCache; import com.liferay.portal.kernel.dao.orm.FinderPath; import com.liferay.portal.kernel.dao.orm.Query; import com.liferay.portal.kernel.dao.orm.QueryPos; import com.liferay.portal.kernel.dao.orm.QueryUtil; import com.liferay.portal.kernel.dao.orm.Session; import com.liferay.portal.kernel.log.Log; import com.liferay.portal.kernel.log.LogFactoryUtil; import com.liferay.portal.kernel.service.ServiceContext; import com.liferay.portal.kernel.service.ServiceContextThreadLocal; import com.liferay.portal.kernel.service.persistence.CompanyProvider; import com.liferay.portal.kernel.service.persistence.CompanyProviderWrapper; import com.liferay.portal.kernel.service.persistence.impl.BasePersistenceImpl; import com.liferay.portal.kernel.util.OrderByComparator; import com.liferay.portal.kernel.util.StringBundler; import com.liferay.portal.kernel.util.StringPool; import com.liferay.portal.kernel.util.StringUtil; import com.liferay.portal.spring.extender.service.ServiceReference; import com.liferay.portal.workflow.kaleo.exception.NoSuchTaskFormException; import com.liferay.portal.workflow.kaleo.model.KaleoTaskForm; import com.liferay.portal.workflow.kaleo.model.impl.KaleoTaskFormImpl; import com.liferay.portal.workflow.kaleo.model.impl.KaleoTaskFormModelImpl; import com.liferay.portal.workflow.kaleo.service.persistence.KaleoTaskFormPersistence; import java.io.Serializable; import java.util.Collections; import java.util.Date; import java.util.HashMap; import java.util.HashSet; import java.util.Iterator; import java.util.List; import java.util.Map; import java.util.Objects; import java.util.Set; /** * The persistence implementation for the kaleo task form service. * * <p> * Caching information and settings can be found in <code>portal.properties</code> * </p> * * @author Brian Wing Shun Chan * @see KaleoTaskFormPersistence * @see com.liferay.portal.workflow.kaleo.service.persistence.KaleoTaskFormUtil * @generated */ @ProviderType public class KaleoTaskFormPersistenceImpl extends BasePersistenceImpl<KaleoTaskForm> implements KaleoTaskFormPersistence { /* * NOTE FOR DEVELOPERS: * * Never modify or reference this class directly. Always use {@link KaleoTaskFormUtil} to access the kaleo task form persistence. Modify <code>service.xml</code> and rerun ServiceBuilder to regenerate this class. */ public static final String FINDER_CLASS_NAME_ENTITY = KaleoTaskFormImpl.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(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormModelImpl.FINDER_CACHE_ENABLED, KaleoTaskFormImpl.class, FINDER_CLASS_NAME_LIST_WITH_PAGINATION, "findAll", new String[0]); public static final FinderPath FINDER_PATH_WITHOUT_PAGINATION_FIND_ALL = new FinderPath(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormModelImpl.FINDER_CACHE_ENABLED, KaleoTaskFormImpl.class, FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION, "findAll", new String[0]); public static final FinderPath FINDER_PATH_COUNT_ALL = new FinderPath(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormModelImpl.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_COMPANYID = new FinderPath(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormModelImpl.FINDER_CACHE_ENABLED, KaleoTaskFormImpl.class, FINDER_CLASS_NAME_LIST_WITH_PAGINATION, "findByCompanyId", new String[] { Long.class.getName(), Integer.class.getName(), Integer.class.getName(), OrderByComparator.class.getName() }); public static final FinderPath FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_COMPANYID = new FinderPath(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormModelImpl.FINDER_CACHE_ENABLED, KaleoTaskFormImpl.class, FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION, "findByCompanyId", new String[] { Long.class.getName() }, KaleoTaskFormModelImpl.COMPANYID_COLUMN_BITMASK | KaleoTaskFormModelImpl.PRIORITY_COLUMN_BITMASK); public static final FinderPath FINDER_PATH_COUNT_BY_COMPANYID = new FinderPath(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormModelImpl.FINDER_CACHE_ENABLED, Long.class, FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION, "countByCompanyId", new String[] { Long.class.getName() }); /** * Returns all the kaleo task forms where companyId = ?. * * @param companyId the company ID * @return the matching kaleo task forms */ @Override public List<KaleoTaskForm> findByCompanyId(long companyId) { return findByCompanyId(companyId, QueryUtil.ALL_POS, QueryUtil.ALL_POS, null); } /** * Returns a range of all the kaleo task forms where companyId = ?. * * <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 QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link KaleoTaskFormModelImpl}. 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 companyId the company ID * @param start the lower bound of the range of kaleo task forms * @param end the upper bound of the range of kaleo task forms (not inclusive) * @return the range of matching kaleo task forms */ @Override public List<KaleoTaskForm> findByCompanyId(long companyId, int start, int end) { return findByCompanyId(companyId, start, end, null); } /** * Returns an ordered range of all the kaleo task forms where companyId = ?. * * <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 QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link KaleoTaskFormModelImpl}. 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 companyId the company ID * @param start the lower bound of the range of kaleo task forms * @param end the upper bound of the range of kaleo task forms (not inclusive) * @param orderByComparator the comparator to order the results by (optionally <code>null</code>) * @return the ordered range of matching kaleo task forms */ @Override public List<KaleoTaskForm> findByCompanyId(long companyId, int start, int end, OrderByComparator<KaleoTaskForm> orderByComparator) { return findByCompanyId(companyId, start, end, orderByComparator, true); } /** * Returns an ordered range of all the kaleo task forms where companyId = ?. * * <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 QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link KaleoTaskFormModelImpl}. 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 companyId the company ID * @param start the lower bound of the range of kaleo task forms * @param end the upper bound of the range of kaleo task forms (not inclusive) * @param orderByComparator the comparator to order the results by (optionally <code>null</code>) * @param retrieveFromCache whether to retrieve from the finder cache * @return the ordered range of matching kaleo task forms */ @Override public List<KaleoTaskForm> findByCompanyId(long companyId, int start, int end, OrderByComparator<KaleoTaskForm> orderByComparator, boolean retrieveFromCache) { boolean pagination = true; FinderPath finderPath = null; Object[] finderArgs = null; if ((start == QueryUtil.ALL_POS) && (end == QueryUtil.ALL_POS) && (orderByComparator == null)) { pagination = false; finderPath = FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_COMPANYID; finderArgs = new Object[] { companyId }; } else { finderPath = FINDER_PATH_WITH_PAGINATION_FIND_BY_COMPANYID; finderArgs = new Object[] { companyId, start, end, orderByComparator }; } List<KaleoTaskForm> list = null; if (retrieveFromCache) { list = (List<KaleoTaskForm>)finderCache.getResult(finderPath, finderArgs, this); if ((list != null) && !list.isEmpty()) { for (KaleoTaskForm kaleoTaskForm : list) { if ((companyId != kaleoTaskForm.getCompanyId())) { list = null; break; } } } } if (list == null) { StringBundler query = null; if (orderByComparator != null) { query = new StringBundler(3 + (orderByComparator.getOrderByFields().length * 2)); } else { query = new StringBundler(3); } query.append(_SQL_SELECT_KALEOTASKFORM_WHERE); query.append(_FINDER_COLUMN_COMPANYID_COMPANYID_2); if (orderByComparator != null) { appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, orderByComparator); } else if (pagination) { query.append(KaleoTaskFormModelImpl.ORDER_BY_JPQL); } String sql = query.toString(); Session session = null; try { session = openSession(); Query q = session.createQuery(sql); QueryPos qPos = QueryPos.getInstance(q); qPos.add(companyId); if (!pagination) { list = (List<KaleoTaskForm>)QueryUtil.list(q, getDialect(), start, end, false); Collections.sort(list); list = Collections.unmodifiableList(list); } else { list = (List<KaleoTaskForm>)QueryUtil.list(q, getDialect(), start, end); } cacheResult(list); finderCache.putResult(finderPath, finderArgs, list); } catch (Exception e) { finderCache.removeResult(finderPath, finderArgs); throw processException(e); } finally { closeSession(session); } } return list; } /** * Returns the first kaleo task form in the ordered set where companyId = ?. * * @param companyId the company ID * @param orderByComparator the comparator to order the set by (optionally <code>null</code>) * @return the first matching kaleo task form * @throws NoSuchTaskFormException if a matching kaleo task form could not be found */ @Override public KaleoTaskForm findByCompanyId_First(long companyId, OrderByComparator<KaleoTaskForm> orderByComparator) throws NoSuchTaskFormException { KaleoTaskForm kaleoTaskForm = fetchByCompanyId_First(companyId, orderByComparator); if (kaleoTaskForm != null) { return kaleoTaskForm; } StringBundler msg = new StringBundler(4); msg.append(_NO_SUCH_ENTITY_WITH_KEY); msg.append("companyId="); msg.append(companyId); msg.append(StringPool.CLOSE_CURLY_BRACE); throw new NoSuchTaskFormException(msg.toString()); } /** * Returns the first kaleo task form in the ordered set where companyId = ?. * * @param companyId the company ID * @param orderByComparator the comparator to order the set by (optionally <code>null</code>) * @return the first matching kaleo task form, or <code>null</code> if a matching kaleo task form could not be found */ @Override public KaleoTaskForm fetchByCompanyId_First(long companyId, OrderByComparator<KaleoTaskForm> orderByComparator) { List<KaleoTaskForm> list = findByCompanyId(companyId, 0, 1, orderByComparator); if (!list.isEmpty()) { return list.get(0); } return null; } /** * Returns the last kaleo task form in the ordered set where companyId = ?. * * @param companyId the company ID * @param orderByComparator the comparator to order the set by (optionally <code>null</code>) * @return the last matching kaleo task form * @throws NoSuchTaskFormException if a matching kaleo task form could not be found */ @Override public KaleoTaskForm findByCompanyId_Last(long companyId, OrderByComparator<KaleoTaskForm> orderByComparator) throws NoSuchTaskFormException { KaleoTaskForm kaleoTaskForm = fetchByCompanyId_Last(companyId, orderByComparator); if (kaleoTaskForm != null) { return kaleoTaskForm; } StringBundler msg = new StringBundler(4); msg.append(_NO_SUCH_ENTITY_WITH_KEY); msg.append("companyId="); msg.append(companyId); msg.append(StringPool.CLOSE_CURLY_BRACE); throw new NoSuchTaskFormException(msg.toString()); } /** * Returns the last kaleo task form in the ordered set where companyId = ?. * * @param companyId the company ID * @param orderByComparator the comparator to order the set by (optionally <code>null</code>) * @return the last matching kaleo task form, or <code>null</code> if a matching kaleo task form could not be found */ @Override public KaleoTaskForm fetchByCompanyId_Last(long companyId, OrderByComparator<KaleoTaskForm> orderByComparator) { int count = countByCompanyId(companyId); if (count == 0) { return null; } List<KaleoTaskForm> list = findByCompanyId(companyId, count - 1, count, orderByComparator); if (!list.isEmpty()) { return list.get(0); } return null; } /** * Returns the kaleo task forms before and after the current kaleo task form in the ordered set where companyId = ?. * * @param kaleoTaskFormId the primary key of the current kaleo task form * @param companyId the company ID * @param orderByComparator the comparator to order the set by (optionally <code>null</code>) * @return the previous, current, and next kaleo task form * @throws NoSuchTaskFormException if a kaleo task form with the primary key could not be found */ @Override public KaleoTaskForm[] findByCompanyId_PrevAndNext(long kaleoTaskFormId, long companyId, OrderByComparator<KaleoTaskForm> orderByComparator) throws NoSuchTaskFormException { KaleoTaskForm kaleoTaskForm = findByPrimaryKey(kaleoTaskFormId); Session session = null; try { session = openSession(); KaleoTaskForm[] array = new KaleoTaskFormImpl[3]; array[0] = getByCompanyId_PrevAndNext(session, kaleoTaskForm, companyId, orderByComparator, true); array[1] = kaleoTaskForm; array[2] = getByCompanyId_PrevAndNext(session, kaleoTaskForm, companyId, orderByComparator, false); return array; } catch (Exception e) { throw processException(e); } finally { closeSession(session); } } protected KaleoTaskForm getByCompanyId_PrevAndNext(Session session, KaleoTaskForm kaleoTaskForm, long companyId, OrderByComparator<KaleoTaskForm> orderByComparator, boolean previous) { StringBundler query = null; if (orderByComparator != null) { query = new StringBundler(4 + (orderByComparator.getOrderByConditionFields().length * 3) + (orderByComparator.getOrderByFields().length * 3)); } else { query = new StringBundler(3); } query.append(_SQL_SELECT_KALEOTASKFORM_WHERE); query.append(_FINDER_COLUMN_COMPANYID_COMPANYID_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(KaleoTaskFormModelImpl.ORDER_BY_JPQL); } String sql = query.toString(); Query q = session.createQuery(sql); q.setFirstResult(0); q.setMaxResults(2); QueryPos qPos = QueryPos.getInstance(q); qPos.add(companyId); if (orderByComparator != null) { Object[] values = orderByComparator.getOrderByConditionValues(kaleoTaskForm); for (Object value : values) { qPos.add(value); } } List<KaleoTaskForm> list = q.list(); if (list.size() == 2) { return list.get(1); } else { return null; } } /** * Removes all the kaleo task forms where companyId = ? from the database. * * @param companyId the company ID */ @Override public void removeByCompanyId(long companyId) { for (KaleoTaskForm kaleoTaskForm : findByCompanyId(companyId, QueryUtil.ALL_POS, QueryUtil.ALL_POS, null)) { remove(kaleoTaskForm); } } /** * Returns the number of kaleo task forms where companyId = ?. * * @param companyId the company ID * @return the number of matching kaleo task forms */ @Override public int countByCompanyId(long companyId) { FinderPath finderPath = FINDER_PATH_COUNT_BY_COMPANYID; Object[] finderArgs = new Object[] { companyId }; Long count = (Long)finderCache.getResult(finderPath, finderArgs, this); if (count == null) { StringBundler query = new StringBundler(2); query.append(_SQL_COUNT_KALEOTASKFORM_WHERE); query.append(_FINDER_COLUMN_COMPANYID_COMPANYID_2); String sql = query.toString(); Session session = null; try { session = openSession(); Query q = session.createQuery(sql); QueryPos qPos = QueryPos.getInstance(q); qPos.add(companyId); count = (Long)q.uniqueResult(); finderCache.putResult(finderPath, finderArgs, count); } catch (Exception e) { finderCache.removeResult(finderPath, finderArgs); throw processException(e); } finally { closeSession(session); } } return count.intValue(); } private static final String _FINDER_COLUMN_COMPANYID_COMPANYID_2 = "kaleoTaskForm.companyId = ?"; public static final FinderPath FINDER_PATH_WITH_PAGINATION_FIND_BY_KALEODEFINITIONID = new FinderPath(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormModelImpl.FINDER_CACHE_ENABLED, KaleoTaskFormImpl.class, FINDER_CLASS_NAME_LIST_WITH_PAGINATION, "findByKaleoDefinitionId", new String[] { Long.class.getName(), Integer.class.getName(), Integer.class.getName(), OrderByComparator.class.getName() }); public static final FinderPath FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_KALEODEFINITIONID = new FinderPath(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormModelImpl.FINDER_CACHE_ENABLED, KaleoTaskFormImpl.class, FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION, "findByKaleoDefinitionId", new String[] { Long.class.getName() }, KaleoTaskFormModelImpl.KALEODEFINITIONID_COLUMN_BITMASK | KaleoTaskFormModelImpl.PRIORITY_COLUMN_BITMASK); public static final FinderPath FINDER_PATH_COUNT_BY_KALEODEFINITIONID = new FinderPath(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormModelImpl.FINDER_CACHE_ENABLED, Long.class, FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION, "countByKaleoDefinitionId", new String[] { Long.class.getName() }); /** * Returns all the kaleo task forms where kaleoDefinitionId = ?. * * @param kaleoDefinitionId the kaleo definition ID * @return the matching kaleo task forms */ @Override public List<KaleoTaskForm> findByKaleoDefinitionId(long kaleoDefinitionId) { return findByKaleoDefinitionId(kaleoDefinitionId, QueryUtil.ALL_POS, QueryUtil.ALL_POS, null); } /** * Returns a range of all the kaleo task forms where kaleoDefinitionId = ?. * * <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 QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link KaleoTaskFormModelImpl}. 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 kaleoDefinitionId the kaleo definition ID * @param start the lower bound of the range of kaleo task forms * @param end the upper bound of the range of kaleo task forms (not inclusive) * @return the range of matching kaleo task forms */ @Override public List<KaleoTaskForm> findByKaleoDefinitionId(long kaleoDefinitionId, int start, int end) { return findByKaleoDefinitionId(kaleoDefinitionId, start, end, null); } /** * Returns an ordered range of all the kaleo task forms where kaleoDefinitionId = ?. * * <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 QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link KaleoTaskFormModelImpl}. 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 kaleoDefinitionId the kaleo definition ID * @param start the lower bound of the range of kaleo task forms * @param end the upper bound of the range of kaleo task forms (not inclusive) * @param orderByComparator the comparator to order the results by (optionally <code>null</code>) * @return the ordered range of matching kaleo task forms */ @Override public List<KaleoTaskForm> findByKaleoDefinitionId(long kaleoDefinitionId, int start, int end, OrderByComparator<KaleoTaskForm> orderByComparator) { return findByKaleoDefinitionId(kaleoDefinitionId, start, end, orderByComparator, true); } /** * Returns an ordered range of all the kaleo task forms where kaleoDefinitionId = ?. * * <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 QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link KaleoTaskFormModelImpl}. 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 kaleoDefinitionId the kaleo definition ID * @param start the lower bound of the range of kaleo task forms * @param end the upper bound of the range of kaleo task forms (not inclusive) * @param orderByComparator the comparator to order the results by (optionally <code>null</code>) * @param retrieveFromCache whether to retrieve from the finder cache * @return the ordered range of matching kaleo task forms */ @Override public List<KaleoTaskForm> findByKaleoDefinitionId(long kaleoDefinitionId, int start, int end, OrderByComparator<KaleoTaskForm> orderByComparator, boolean retrieveFromCache) { boolean pagination = true; FinderPath finderPath = null; Object[] finderArgs = null; if ((start == QueryUtil.ALL_POS) && (end == QueryUtil.ALL_POS) && (orderByComparator == null)) { pagination = false; finderPath = FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_KALEODEFINITIONID; finderArgs = new Object[] { kaleoDefinitionId }; } else { finderPath = FINDER_PATH_WITH_PAGINATION_FIND_BY_KALEODEFINITIONID; finderArgs = new Object[] { kaleoDefinitionId, start, end, orderByComparator }; } List<KaleoTaskForm> list = null; if (retrieveFromCache) { list = (List<KaleoTaskForm>)finderCache.getResult(finderPath, finderArgs, this); if ((list != null) && !list.isEmpty()) { for (KaleoTaskForm kaleoTaskForm : list) { if ((kaleoDefinitionId != kaleoTaskForm.getKaleoDefinitionId())) { list = null; break; } } } } if (list == null) { StringBundler query = null; if (orderByComparator != null) { query = new StringBundler(3 + (orderByComparator.getOrderByFields().length * 2)); } else { query = new StringBundler(3); } query.append(_SQL_SELECT_KALEOTASKFORM_WHERE); query.append(_FINDER_COLUMN_KALEODEFINITIONID_KALEODEFINITIONID_2); if (orderByComparator != null) { appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, orderByComparator); } else if (pagination) { query.append(KaleoTaskFormModelImpl.ORDER_BY_JPQL); } String sql = query.toString(); Session session = null; try { session = openSession(); Query q = session.createQuery(sql); QueryPos qPos = QueryPos.getInstance(q); qPos.add(kaleoDefinitionId); if (!pagination) { list = (List<KaleoTaskForm>)QueryUtil.list(q, getDialect(), start, end, false); Collections.sort(list); list = Collections.unmodifiableList(list); } else { list = (List<KaleoTaskForm>)QueryUtil.list(q, getDialect(), start, end); } cacheResult(list); finderCache.putResult(finderPath, finderArgs, list); } catch (Exception e) { finderCache.removeResult(finderPath, finderArgs); throw processException(e); } finally { closeSession(session); } } return list; } /** * Returns the first kaleo task form in the ordered set where kaleoDefinitionId = ?. * * @param kaleoDefinitionId the kaleo definition ID * @param orderByComparator the comparator to order the set by (optionally <code>null</code>) * @return the first matching kaleo task form * @throws NoSuchTaskFormException if a matching kaleo task form could not be found */ @Override public KaleoTaskForm findByKaleoDefinitionId_First(long kaleoDefinitionId, OrderByComparator<KaleoTaskForm> orderByComparator) throws NoSuchTaskFormException { KaleoTaskForm kaleoTaskForm = fetchByKaleoDefinitionId_First(kaleoDefinitionId, orderByComparator); if (kaleoTaskForm != null) { return kaleoTaskForm; } StringBundler msg = new StringBundler(4); msg.append(_NO_SUCH_ENTITY_WITH_KEY); msg.append("kaleoDefinitionId="); msg.append(kaleoDefinitionId); msg.append(StringPool.CLOSE_CURLY_BRACE); throw new NoSuchTaskFormException(msg.toString()); } /** * Returns the first kaleo task form in the ordered set where kaleoDefinitionId = ?. * * @param kaleoDefinitionId the kaleo definition ID * @param orderByComparator the comparator to order the set by (optionally <code>null</code>) * @return the first matching kaleo task form, or <code>null</code> if a matching kaleo task form could not be found */ @Override public KaleoTaskForm fetchByKaleoDefinitionId_First( long kaleoDefinitionId, OrderByComparator<KaleoTaskForm> orderByComparator) { List<KaleoTaskForm> list = findByKaleoDefinitionId(kaleoDefinitionId, 0, 1, orderByComparator); if (!list.isEmpty()) { return list.get(0); } return null; } /** * Returns the last kaleo task form in the ordered set where kaleoDefinitionId = ?. * * @param kaleoDefinitionId the kaleo definition ID * @param orderByComparator the comparator to order the set by (optionally <code>null</code>) * @return the last matching kaleo task form * @throws NoSuchTaskFormException if a matching kaleo task form could not be found */ @Override public KaleoTaskForm findByKaleoDefinitionId_Last(long kaleoDefinitionId, OrderByComparator<KaleoTaskForm> orderByComparator) throws NoSuchTaskFormException { KaleoTaskForm kaleoTaskForm = fetchByKaleoDefinitionId_Last(kaleoDefinitionId, orderByComparator); if (kaleoTaskForm != null) { return kaleoTaskForm; } StringBundler msg = new StringBundler(4); msg.append(_NO_SUCH_ENTITY_WITH_KEY); msg.append("kaleoDefinitionId="); msg.append(kaleoDefinitionId); msg.append(StringPool.CLOSE_CURLY_BRACE); throw new NoSuchTaskFormException(msg.toString()); } /** * Returns the last kaleo task form in the ordered set where kaleoDefinitionId = ?. * * @param kaleoDefinitionId the kaleo definition ID * @param orderByComparator the comparator to order the set by (optionally <code>null</code>) * @return the last matching kaleo task form, or <code>null</code> if a matching kaleo task form could not be found */ @Override public KaleoTaskForm fetchByKaleoDefinitionId_Last(long kaleoDefinitionId, OrderByComparator<KaleoTaskForm> orderByComparator) { int count = countByKaleoDefinitionId(kaleoDefinitionId); if (count == 0) { return null; } List<KaleoTaskForm> list = findByKaleoDefinitionId(kaleoDefinitionId, count - 1, count, orderByComparator); if (!list.isEmpty()) { return list.get(0); } return null; } /** * Returns the kaleo task forms before and after the current kaleo task form in the ordered set where kaleoDefinitionId = ?. * * @param kaleoTaskFormId the primary key of the current kaleo task form * @param kaleoDefinitionId the kaleo definition ID * @param orderByComparator the comparator to order the set by (optionally <code>null</code>) * @return the previous, current, and next kaleo task form * @throws NoSuchTaskFormException if a kaleo task form with the primary key could not be found */ @Override public KaleoTaskForm[] findByKaleoDefinitionId_PrevAndNext( long kaleoTaskFormId, long kaleoDefinitionId, OrderByComparator<KaleoTaskForm> orderByComparator) throws NoSuchTaskFormException { KaleoTaskForm kaleoTaskForm = findByPrimaryKey(kaleoTaskFormId); Session session = null; try { session = openSession(); KaleoTaskForm[] array = new KaleoTaskFormImpl[3]; array[0] = getByKaleoDefinitionId_PrevAndNext(session, kaleoTaskForm, kaleoDefinitionId, orderByComparator, true); array[1] = kaleoTaskForm; array[2] = getByKaleoDefinitionId_PrevAndNext(session, kaleoTaskForm, kaleoDefinitionId, orderByComparator, false); return array; } catch (Exception e) { throw processException(e); } finally { closeSession(session); } } protected KaleoTaskForm getByKaleoDefinitionId_PrevAndNext( Session session, KaleoTaskForm kaleoTaskForm, long kaleoDefinitionId, OrderByComparator<KaleoTaskForm> orderByComparator, boolean previous) { StringBundler query = null; if (orderByComparator != null) { query = new StringBundler(4 + (orderByComparator.getOrderByConditionFields().length * 3) + (orderByComparator.getOrderByFields().length * 3)); } else { query = new StringBundler(3); } query.append(_SQL_SELECT_KALEOTASKFORM_WHERE); query.append(_FINDER_COLUMN_KALEODEFINITIONID_KALEODEFINITIONID_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(KaleoTaskFormModelImpl.ORDER_BY_JPQL); } String sql = query.toString(); Query q = session.createQuery(sql); q.setFirstResult(0); q.setMaxResults(2); QueryPos qPos = QueryPos.getInstance(q); qPos.add(kaleoDefinitionId); if (orderByComparator != null) { Object[] values = orderByComparator.getOrderByConditionValues(kaleoTaskForm); for (Object value : values) { qPos.add(value); } } List<KaleoTaskForm> list = q.list(); if (list.size() == 2) { return list.get(1); } else { return null; } } /** * Removes all the kaleo task forms where kaleoDefinitionId = ? from the database. * * @param kaleoDefinitionId the kaleo definition ID */ @Override public void removeByKaleoDefinitionId(long kaleoDefinitionId) { for (KaleoTaskForm kaleoTaskForm : findByKaleoDefinitionId( kaleoDefinitionId, QueryUtil.ALL_POS, QueryUtil.ALL_POS, null)) { remove(kaleoTaskForm); } } /** * Returns the number of kaleo task forms where kaleoDefinitionId = ?. * * @param kaleoDefinitionId the kaleo definition ID * @return the number of matching kaleo task forms */ @Override public int countByKaleoDefinitionId(long kaleoDefinitionId) { FinderPath finderPath = FINDER_PATH_COUNT_BY_KALEODEFINITIONID; Object[] finderArgs = new Object[] { kaleoDefinitionId }; Long count = (Long)finderCache.getResult(finderPath, finderArgs, this); if (count == null) { StringBundler query = new StringBundler(2); query.append(_SQL_COUNT_KALEOTASKFORM_WHERE); query.append(_FINDER_COLUMN_KALEODEFINITIONID_KALEODEFINITIONID_2); String sql = query.toString(); Session session = null; try { session = openSession(); Query q = session.createQuery(sql); QueryPos qPos = QueryPos.getInstance(q); qPos.add(kaleoDefinitionId); count = (Long)q.uniqueResult(); finderCache.putResult(finderPath, finderArgs, count); } catch (Exception e) { finderCache.removeResult(finderPath, finderArgs); throw processException(e); } finally { closeSession(session); } } return count.intValue(); } private static final String _FINDER_COLUMN_KALEODEFINITIONID_KALEODEFINITIONID_2 = "kaleoTaskForm.kaleoDefinitionId = ?"; public static final FinderPath FINDER_PATH_WITH_PAGINATION_FIND_BY_KALEONODEID = new FinderPath(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormModelImpl.FINDER_CACHE_ENABLED, KaleoTaskFormImpl.class, FINDER_CLASS_NAME_LIST_WITH_PAGINATION, "findByKaleoNodeId", new String[] { Long.class.getName(), Integer.class.getName(), Integer.class.getName(), OrderByComparator.class.getName() }); public static final FinderPath FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_KALEONODEID = new FinderPath(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormModelImpl.FINDER_CACHE_ENABLED, KaleoTaskFormImpl.class, FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION, "findByKaleoNodeId", new String[] { Long.class.getName() }, KaleoTaskFormModelImpl.KALEONODEID_COLUMN_BITMASK | KaleoTaskFormModelImpl.PRIORITY_COLUMN_BITMASK); public static final FinderPath FINDER_PATH_COUNT_BY_KALEONODEID = new FinderPath(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormModelImpl.FINDER_CACHE_ENABLED, Long.class, FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION, "countByKaleoNodeId", new String[] { Long.class.getName() }); /** * Returns all the kaleo task forms where kaleoNodeId = ?. * * @param kaleoNodeId the kaleo node ID * @return the matching kaleo task forms */ @Override public List<KaleoTaskForm> findByKaleoNodeId(long kaleoNodeId) { return findByKaleoNodeId(kaleoNodeId, QueryUtil.ALL_POS, QueryUtil.ALL_POS, null); } /** * Returns a range of all the kaleo task forms where kaleoNodeId = ?. * * <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 QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link KaleoTaskFormModelImpl}. 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 kaleoNodeId the kaleo node ID * @param start the lower bound of the range of kaleo task forms * @param end the upper bound of the range of kaleo task forms (not inclusive) * @return the range of matching kaleo task forms */ @Override public List<KaleoTaskForm> findByKaleoNodeId(long kaleoNodeId, int start, int end) { return findByKaleoNodeId(kaleoNodeId, start, end, null); } /** * Returns an ordered range of all the kaleo task forms where kaleoNodeId = ?. * * <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 QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link KaleoTaskFormModelImpl}. 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 kaleoNodeId the kaleo node ID * @param start the lower bound of the range of kaleo task forms * @param end the upper bound of the range of kaleo task forms (not inclusive) * @param orderByComparator the comparator to order the results by (optionally <code>null</code>) * @return the ordered range of matching kaleo task forms */ @Override public List<KaleoTaskForm> findByKaleoNodeId(long kaleoNodeId, int start, int end, OrderByComparator<KaleoTaskForm> orderByComparator) { return findByKaleoNodeId(kaleoNodeId, start, end, orderByComparator, true); } /** * Returns an ordered range of all the kaleo task forms where kaleoNodeId = ?. * * <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 QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link KaleoTaskFormModelImpl}. 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 kaleoNodeId the kaleo node ID * @param start the lower bound of the range of kaleo task forms * @param end the upper bound of the range of kaleo task forms (not inclusive) * @param orderByComparator the comparator to order the results by (optionally <code>null</code>) * @param retrieveFromCache whether to retrieve from the finder cache * @return the ordered range of matching kaleo task forms */ @Override public List<KaleoTaskForm> findByKaleoNodeId(long kaleoNodeId, int start, int end, OrderByComparator<KaleoTaskForm> orderByComparator, boolean retrieveFromCache) { boolean pagination = true; FinderPath finderPath = null; Object[] finderArgs = null; if ((start == QueryUtil.ALL_POS) && (end == QueryUtil.ALL_POS) && (orderByComparator == null)) { pagination = false; finderPath = FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_KALEONODEID; finderArgs = new Object[] { kaleoNodeId }; } else { finderPath = FINDER_PATH_WITH_PAGINATION_FIND_BY_KALEONODEID; finderArgs = new Object[] { kaleoNodeId, start, end, orderByComparator }; } List<KaleoTaskForm> list = null; if (retrieveFromCache) { list = (List<KaleoTaskForm>)finderCache.getResult(finderPath, finderArgs, this); if ((list != null) && !list.isEmpty()) { for (KaleoTaskForm kaleoTaskForm : list) { if ((kaleoNodeId != kaleoTaskForm.getKaleoNodeId())) { list = null; break; } } } } if (list == null) { StringBundler query = null; if (orderByComparator != null) { query = new StringBundler(3 + (orderByComparator.getOrderByFields().length * 2)); } else { query = new StringBundler(3); } query.append(_SQL_SELECT_KALEOTASKFORM_WHERE); query.append(_FINDER_COLUMN_KALEONODEID_KALEONODEID_2); if (orderByComparator != null) { appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, orderByComparator); } else if (pagination) { query.append(KaleoTaskFormModelImpl.ORDER_BY_JPQL); } String sql = query.toString(); Session session = null; try { session = openSession(); Query q = session.createQuery(sql); QueryPos qPos = QueryPos.getInstance(q); qPos.add(kaleoNodeId); if (!pagination) { list = (List<KaleoTaskForm>)QueryUtil.list(q, getDialect(), start, end, false); Collections.sort(list); list = Collections.unmodifiableList(list); } else { list = (List<KaleoTaskForm>)QueryUtil.list(q, getDialect(), start, end); } cacheResult(list); finderCache.putResult(finderPath, finderArgs, list); } catch (Exception e) { finderCache.removeResult(finderPath, finderArgs); throw processException(e); } finally { closeSession(session); } } return list; } /** * Returns the first kaleo task form in the ordered set where kaleoNodeId = ?. * * @param kaleoNodeId the kaleo node ID * @param orderByComparator the comparator to order the set by (optionally <code>null</code>) * @return the first matching kaleo task form * @throws NoSuchTaskFormException if a matching kaleo task form could not be found */ @Override public KaleoTaskForm findByKaleoNodeId_First(long kaleoNodeId, OrderByComparator<KaleoTaskForm> orderByComparator) throws NoSuchTaskFormException { KaleoTaskForm kaleoTaskForm = fetchByKaleoNodeId_First(kaleoNodeId, orderByComparator); if (kaleoTaskForm != null) { return kaleoTaskForm; } StringBundler msg = new StringBundler(4); msg.append(_NO_SUCH_ENTITY_WITH_KEY); msg.append("kaleoNodeId="); msg.append(kaleoNodeId); msg.append(StringPool.CLOSE_CURLY_BRACE); throw new NoSuchTaskFormException(msg.toString()); } /** * Returns the first kaleo task form in the ordered set where kaleoNodeId = ?. * * @param kaleoNodeId the kaleo node ID * @param orderByComparator the comparator to order the set by (optionally <code>null</code>) * @return the first matching kaleo task form, or <code>null</code> if a matching kaleo task form could not be found */ @Override public KaleoTaskForm fetchByKaleoNodeId_First(long kaleoNodeId, OrderByComparator<KaleoTaskForm> orderByComparator) { List<KaleoTaskForm> list = findByKaleoNodeId(kaleoNodeId, 0, 1, orderByComparator); if (!list.isEmpty()) { return list.get(0); } return null; } /** * Returns the last kaleo task form in the ordered set where kaleoNodeId = ?. * * @param kaleoNodeId the kaleo node ID * @param orderByComparator the comparator to order the set by (optionally <code>null</code>) * @return the last matching kaleo task form * @throws NoSuchTaskFormException if a matching kaleo task form could not be found */ @Override public KaleoTaskForm findByKaleoNodeId_Last(long kaleoNodeId, OrderByComparator<KaleoTaskForm> orderByComparator) throws NoSuchTaskFormException { KaleoTaskForm kaleoTaskForm = fetchByKaleoNodeId_Last(kaleoNodeId, orderByComparator); if (kaleoTaskForm != null) { return kaleoTaskForm; } StringBundler msg = new StringBundler(4); msg.append(_NO_SUCH_ENTITY_WITH_KEY); msg.append("kaleoNodeId="); msg.append(kaleoNodeId); msg.append(StringPool.CLOSE_CURLY_BRACE); throw new NoSuchTaskFormException(msg.toString()); } /** * Returns the last kaleo task form in the ordered set where kaleoNodeId = ?. * * @param kaleoNodeId the kaleo node ID * @param orderByComparator the comparator to order the set by (optionally <code>null</code>) * @return the last matching kaleo task form, or <code>null</code> if a matching kaleo task form could not be found */ @Override public KaleoTaskForm fetchByKaleoNodeId_Last(long kaleoNodeId, OrderByComparator<KaleoTaskForm> orderByComparator) { int count = countByKaleoNodeId(kaleoNodeId); if (count == 0) { return null; } List<KaleoTaskForm> list = findByKaleoNodeId(kaleoNodeId, count - 1, count, orderByComparator); if (!list.isEmpty()) { return list.get(0); } return null; } /** * Returns the kaleo task forms before and after the current kaleo task form in the ordered set where kaleoNodeId = ?. * * @param kaleoTaskFormId the primary key of the current kaleo task form * @param kaleoNodeId the kaleo node ID * @param orderByComparator the comparator to order the set by (optionally <code>null</code>) * @return the previous, current, and next kaleo task form * @throws NoSuchTaskFormException if a kaleo task form with the primary key could not be found */ @Override public KaleoTaskForm[] findByKaleoNodeId_PrevAndNext(long kaleoTaskFormId, long kaleoNodeId, OrderByComparator<KaleoTaskForm> orderByComparator) throws NoSuchTaskFormException { KaleoTaskForm kaleoTaskForm = findByPrimaryKey(kaleoTaskFormId); Session session = null; try { session = openSession(); KaleoTaskForm[] array = new KaleoTaskFormImpl[3]; array[0] = getByKaleoNodeId_PrevAndNext(session, kaleoTaskForm, kaleoNodeId, orderByComparator, true); array[1] = kaleoTaskForm; array[2] = getByKaleoNodeId_PrevAndNext(session, kaleoTaskForm, kaleoNodeId, orderByComparator, false); return array; } catch (Exception e) { throw processException(e); } finally { closeSession(session); } } protected KaleoTaskForm getByKaleoNodeId_PrevAndNext(Session session, KaleoTaskForm kaleoTaskForm, long kaleoNodeId, OrderByComparator<KaleoTaskForm> orderByComparator, boolean previous) { StringBundler query = null; if (orderByComparator != null) { query = new StringBundler(4 + (orderByComparator.getOrderByConditionFields().length * 3) + (orderByComparator.getOrderByFields().length * 3)); } else { query = new StringBundler(3); } query.append(_SQL_SELECT_KALEOTASKFORM_WHERE); query.append(_FINDER_COLUMN_KALEONODEID_KALEONODEID_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(KaleoTaskFormModelImpl.ORDER_BY_JPQL); } String sql = query.toString(); Query q = session.createQuery(sql); q.setFirstResult(0); q.setMaxResults(2); QueryPos qPos = QueryPos.getInstance(q); qPos.add(kaleoNodeId); if (orderByComparator != null) { Object[] values = orderByComparator.getOrderByConditionValues(kaleoTaskForm); for (Object value : values) { qPos.add(value); } } List<KaleoTaskForm> list = q.list(); if (list.size() == 2) { return list.get(1); } else { return null; } } /** * Removes all the kaleo task forms where kaleoNodeId = ? from the database. * * @param kaleoNodeId the kaleo node ID */ @Override public void removeByKaleoNodeId(long kaleoNodeId) { for (KaleoTaskForm kaleoTaskForm : findByKaleoNodeId(kaleoNodeId, QueryUtil.ALL_POS, QueryUtil.ALL_POS, null)) { remove(kaleoTaskForm); } } /** * Returns the number of kaleo task forms where kaleoNodeId = ?. * * @param kaleoNodeId the kaleo node ID * @return the number of matching kaleo task forms */ @Override public int countByKaleoNodeId(long kaleoNodeId) { FinderPath finderPath = FINDER_PATH_COUNT_BY_KALEONODEID; Object[] finderArgs = new Object[] { kaleoNodeId }; Long count = (Long)finderCache.getResult(finderPath, finderArgs, this); if (count == null) { StringBundler query = new StringBundler(2); query.append(_SQL_COUNT_KALEOTASKFORM_WHERE); query.append(_FINDER_COLUMN_KALEONODEID_KALEONODEID_2); String sql = query.toString(); Session session = null; try { session = openSession(); Query q = session.createQuery(sql); QueryPos qPos = QueryPos.getInstance(q); qPos.add(kaleoNodeId); count = (Long)q.uniqueResult(); finderCache.putResult(finderPath, finderArgs, count); } catch (Exception e) { finderCache.removeResult(finderPath, finderArgs); throw processException(e); } finally { closeSession(session); } } return count.intValue(); } private static final String _FINDER_COLUMN_KALEONODEID_KALEONODEID_2 = "kaleoTaskForm.kaleoNodeId = ?"; public static final FinderPath FINDER_PATH_WITH_PAGINATION_FIND_BY_KALEOTASKID = new FinderPath(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormModelImpl.FINDER_CACHE_ENABLED, KaleoTaskFormImpl.class, FINDER_CLASS_NAME_LIST_WITH_PAGINATION, "findByKaleoTaskId", new String[] { Long.class.getName(), Integer.class.getName(), Integer.class.getName(), OrderByComparator.class.getName() }); public static final FinderPath FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_KALEOTASKID = new FinderPath(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormModelImpl.FINDER_CACHE_ENABLED, KaleoTaskFormImpl.class, FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION, "findByKaleoTaskId", new String[] { Long.class.getName() }, KaleoTaskFormModelImpl.KALEOTASKID_COLUMN_BITMASK | KaleoTaskFormModelImpl.PRIORITY_COLUMN_BITMASK); public static final FinderPath FINDER_PATH_COUNT_BY_KALEOTASKID = new FinderPath(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormModelImpl.FINDER_CACHE_ENABLED, Long.class, FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION, "countByKaleoTaskId", new String[] { Long.class.getName() }); /** * Returns all the kaleo task forms where kaleoTaskId = ?. * * @param kaleoTaskId the kaleo task ID * @return the matching kaleo task forms */ @Override public List<KaleoTaskForm> findByKaleoTaskId(long kaleoTaskId) { return findByKaleoTaskId(kaleoTaskId, QueryUtil.ALL_POS, QueryUtil.ALL_POS, null); } /** * Returns a range of all the kaleo task forms where kaleoTaskId = ?. * * <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 QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link KaleoTaskFormModelImpl}. 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 kaleoTaskId the kaleo task ID * @param start the lower bound of the range of kaleo task forms * @param end the upper bound of the range of kaleo task forms (not inclusive) * @return the range of matching kaleo task forms */ @Override public List<KaleoTaskForm> findByKaleoTaskId(long kaleoTaskId, int start, int end) { return findByKaleoTaskId(kaleoTaskId, start, end, null); } /** * Returns an ordered range of all the kaleo task forms where kaleoTaskId = ?. * * <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 QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link KaleoTaskFormModelImpl}. 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 kaleoTaskId the kaleo task ID * @param start the lower bound of the range of kaleo task forms * @param end the upper bound of the range of kaleo task forms (not inclusive) * @param orderByComparator the comparator to order the results by (optionally <code>null</code>) * @return the ordered range of matching kaleo task forms */ @Override public List<KaleoTaskForm> findByKaleoTaskId(long kaleoTaskId, int start, int end, OrderByComparator<KaleoTaskForm> orderByComparator) { return findByKaleoTaskId(kaleoTaskId, start, end, orderByComparator, true); } /** * Returns an ordered range of all the kaleo task forms where kaleoTaskId = ?. * * <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 QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link KaleoTaskFormModelImpl}. 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 kaleoTaskId the kaleo task ID * @param start the lower bound of the range of kaleo task forms * @param end the upper bound of the range of kaleo task forms (not inclusive) * @param orderByComparator the comparator to order the results by (optionally <code>null</code>) * @param retrieveFromCache whether to retrieve from the finder cache * @return the ordered range of matching kaleo task forms */ @Override public List<KaleoTaskForm> findByKaleoTaskId(long kaleoTaskId, int start, int end, OrderByComparator<KaleoTaskForm> orderByComparator, boolean retrieveFromCache) { boolean pagination = true; FinderPath finderPath = null; Object[] finderArgs = null; if ((start == QueryUtil.ALL_POS) && (end == QueryUtil.ALL_POS) && (orderByComparator == null)) { pagination = false; finderPath = FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_KALEOTASKID; finderArgs = new Object[] { kaleoTaskId }; } else { finderPath = FINDER_PATH_WITH_PAGINATION_FIND_BY_KALEOTASKID; finderArgs = new Object[] { kaleoTaskId, start, end, orderByComparator }; } List<KaleoTaskForm> list = null; if (retrieveFromCache) { list = (List<KaleoTaskForm>)finderCache.getResult(finderPath, finderArgs, this); if ((list != null) && !list.isEmpty()) { for (KaleoTaskForm kaleoTaskForm : list) { if ((kaleoTaskId != kaleoTaskForm.getKaleoTaskId())) { list = null; break; } } } } if (list == null) { StringBundler query = null; if (orderByComparator != null) { query = new StringBundler(3 + (orderByComparator.getOrderByFields().length * 2)); } else { query = new StringBundler(3); } query.append(_SQL_SELECT_KALEOTASKFORM_WHERE); query.append(_FINDER_COLUMN_KALEOTASKID_KALEOTASKID_2); if (orderByComparator != null) { appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, orderByComparator); } else if (pagination) { query.append(KaleoTaskFormModelImpl.ORDER_BY_JPQL); } String sql = query.toString(); Session session = null; try { session = openSession(); Query q = session.createQuery(sql); QueryPos qPos = QueryPos.getInstance(q); qPos.add(kaleoTaskId); if (!pagination) { list = (List<KaleoTaskForm>)QueryUtil.list(q, getDialect(), start, end, false); Collections.sort(list); list = Collections.unmodifiableList(list); } else { list = (List<KaleoTaskForm>)QueryUtil.list(q, getDialect(), start, end); } cacheResult(list); finderCache.putResult(finderPath, finderArgs, list); } catch (Exception e) { finderCache.removeResult(finderPath, finderArgs); throw processException(e); } finally { closeSession(session); } } return list; } /** * Returns the first kaleo task form in the ordered set where kaleoTaskId = ?. * * @param kaleoTaskId the kaleo task ID * @param orderByComparator the comparator to order the set by (optionally <code>null</code>) * @return the first matching kaleo task form * @throws NoSuchTaskFormException if a matching kaleo task form could not be found */ @Override public KaleoTaskForm findByKaleoTaskId_First(long kaleoTaskId, OrderByComparator<KaleoTaskForm> orderByComparator) throws NoSuchTaskFormException { KaleoTaskForm kaleoTaskForm = fetchByKaleoTaskId_First(kaleoTaskId, orderByComparator); if (kaleoTaskForm != null) { return kaleoTaskForm; } StringBundler msg = new StringBundler(4); msg.append(_NO_SUCH_ENTITY_WITH_KEY); msg.append("kaleoTaskId="); msg.append(kaleoTaskId); msg.append(StringPool.CLOSE_CURLY_BRACE); throw new NoSuchTaskFormException(msg.toString()); } /** * Returns the first kaleo task form in the ordered set where kaleoTaskId = ?. * * @param kaleoTaskId the kaleo task ID * @param orderByComparator the comparator to order the set by (optionally <code>null</code>) * @return the first matching kaleo task form, or <code>null</code> if a matching kaleo task form could not be found */ @Override public KaleoTaskForm fetchByKaleoTaskId_First(long kaleoTaskId, OrderByComparator<KaleoTaskForm> orderByComparator) { List<KaleoTaskForm> list = findByKaleoTaskId(kaleoTaskId, 0, 1, orderByComparator); if (!list.isEmpty()) { return list.get(0); } return null; } /** * Returns the last kaleo task form in the ordered set where kaleoTaskId = ?. * * @param kaleoTaskId the kaleo task ID * @param orderByComparator the comparator to order the set by (optionally <code>null</code>) * @return the last matching kaleo task form * @throws NoSuchTaskFormException if a matching kaleo task form could not be found */ @Override public KaleoTaskForm findByKaleoTaskId_Last(long kaleoTaskId, OrderByComparator<KaleoTaskForm> orderByComparator) throws NoSuchTaskFormException { KaleoTaskForm kaleoTaskForm = fetchByKaleoTaskId_Last(kaleoTaskId, orderByComparator); if (kaleoTaskForm != null) { return kaleoTaskForm; } StringBundler msg = new StringBundler(4); msg.append(_NO_SUCH_ENTITY_WITH_KEY); msg.append("kaleoTaskId="); msg.append(kaleoTaskId); msg.append(StringPool.CLOSE_CURLY_BRACE); throw new NoSuchTaskFormException(msg.toString()); } /** * Returns the last kaleo task form in the ordered set where kaleoTaskId = ?. * * @param kaleoTaskId the kaleo task ID * @param orderByComparator the comparator to order the set by (optionally <code>null</code>) * @return the last matching kaleo task form, or <code>null</code> if a matching kaleo task form could not be found */ @Override public KaleoTaskForm fetchByKaleoTaskId_Last(long kaleoTaskId, OrderByComparator<KaleoTaskForm> orderByComparator) { int count = countByKaleoTaskId(kaleoTaskId); if (count == 0) { return null; } List<KaleoTaskForm> list = findByKaleoTaskId(kaleoTaskId, count - 1, count, orderByComparator); if (!list.isEmpty()) { return list.get(0); } return null; } /** * Returns the kaleo task forms before and after the current kaleo task form in the ordered set where kaleoTaskId = ?. * * @param kaleoTaskFormId the primary key of the current kaleo task form * @param kaleoTaskId the kaleo task ID * @param orderByComparator the comparator to order the set by (optionally <code>null</code>) * @return the previous, current, and next kaleo task form * @throws NoSuchTaskFormException if a kaleo task form with the primary key could not be found */ @Override public KaleoTaskForm[] findByKaleoTaskId_PrevAndNext(long kaleoTaskFormId, long kaleoTaskId, OrderByComparator<KaleoTaskForm> orderByComparator) throws NoSuchTaskFormException { KaleoTaskForm kaleoTaskForm = findByPrimaryKey(kaleoTaskFormId); Session session = null; try { session = openSession(); KaleoTaskForm[] array = new KaleoTaskFormImpl[3]; array[0] = getByKaleoTaskId_PrevAndNext(session, kaleoTaskForm, kaleoTaskId, orderByComparator, true); array[1] = kaleoTaskForm; array[2] = getByKaleoTaskId_PrevAndNext(session, kaleoTaskForm, kaleoTaskId, orderByComparator, false); return array; } catch (Exception e) { throw processException(e); } finally { closeSession(session); } } protected KaleoTaskForm getByKaleoTaskId_PrevAndNext(Session session, KaleoTaskForm kaleoTaskForm, long kaleoTaskId, OrderByComparator<KaleoTaskForm> orderByComparator, boolean previous) { StringBundler query = null; if (orderByComparator != null) { query = new StringBundler(4 + (orderByComparator.getOrderByConditionFields().length * 3) + (orderByComparator.getOrderByFields().length * 3)); } else { query = new StringBundler(3); } query.append(_SQL_SELECT_KALEOTASKFORM_WHERE); query.append(_FINDER_COLUMN_KALEOTASKID_KALEOTASKID_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(KaleoTaskFormModelImpl.ORDER_BY_JPQL); } String sql = query.toString(); Query q = session.createQuery(sql); q.setFirstResult(0); q.setMaxResults(2); QueryPos qPos = QueryPos.getInstance(q); qPos.add(kaleoTaskId); if (orderByComparator != null) { Object[] values = orderByComparator.getOrderByConditionValues(kaleoTaskForm); for (Object value : values) { qPos.add(value); } } List<KaleoTaskForm> list = q.list(); if (list.size() == 2) { return list.get(1); } else { return null; } } /** * Removes all the kaleo task forms where kaleoTaskId = ? from the database. * * @param kaleoTaskId the kaleo task ID */ @Override public void removeByKaleoTaskId(long kaleoTaskId) { for (KaleoTaskForm kaleoTaskForm : findByKaleoTaskId(kaleoTaskId, QueryUtil.ALL_POS, QueryUtil.ALL_POS, null)) { remove(kaleoTaskForm); } } /** * Returns the number of kaleo task forms where kaleoTaskId = ?. * * @param kaleoTaskId the kaleo task ID * @return the number of matching kaleo task forms */ @Override public int countByKaleoTaskId(long kaleoTaskId) { FinderPath finderPath = FINDER_PATH_COUNT_BY_KALEOTASKID; Object[] finderArgs = new Object[] { kaleoTaskId }; Long count = (Long)finderCache.getResult(finderPath, finderArgs, this); if (count == null) { StringBundler query = new StringBundler(2); query.append(_SQL_COUNT_KALEOTASKFORM_WHERE); query.append(_FINDER_COLUMN_KALEOTASKID_KALEOTASKID_2); String sql = query.toString(); Session session = null; try { session = openSession(); Query q = session.createQuery(sql); QueryPos qPos = QueryPos.getInstance(q); qPos.add(kaleoTaskId); count = (Long)q.uniqueResult(); finderCache.putResult(finderPath, finderArgs, count); } catch (Exception e) { finderCache.removeResult(finderPath, finderArgs); throw processException(e); } finally { closeSession(session); } } return count.intValue(); } private static final String _FINDER_COLUMN_KALEOTASKID_KALEOTASKID_2 = "kaleoTaskForm.kaleoTaskId = ?"; public static final FinderPath FINDER_PATH_FETCH_BY_FORMUUID_KTI = new FinderPath(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormModelImpl.FINDER_CACHE_ENABLED, KaleoTaskFormImpl.class, FINDER_CLASS_NAME_ENTITY, "fetchByFormUuid_KTI", new String[] { Long.class.getName(), String.class.getName() }, KaleoTaskFormModelImpl.KALEOTASKID_COLUMN_BITMASK | KaleoTaskFormModelImpl.FORMUUID_COLUMN_BITMASK); public static final FinderPath FINDER_PATH_COUNT_BY_FORMUUID_KTI = new FinderPath(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormModelImpl.FINDER_CACHE_ENABLED, Long.class, FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION, "countByFormUuid_KTI", new String[] { Long.class.getName(), String.class.getName() }); /** * Returns the kaleo task form where kaleoTaskId = ? and formUuid = ? or throws a {@link NoSuchTaskFormException} if it could not be found. * * @param kaleoTaskId the kaleo task ID * @param formUuid the form uuid * @return the matching kaleo task form * @throws NoSuchTaskFormException if a matching kaleo task form could not be found */ @Override public KaleoTaskForm findByFormUuid_KTI(long kaleoTaskId, String formUuid) throws NoSuchTaskFormException { KaleoTaskForm kaleoTaskForm = fetchByFormUuid_KTI(kaleoTaskId, formUuid); if (kaleoTaskForm == null) { StringBundler msg = new StringBundler(6); msg.append(_NO_SUCH_ENTITY_WITH_KEY); msg.append("kaleoTaskId="); msg.append(kaleoTaskId); msg.append(", formUuid="); msg.append(formUuid); msg.append(StringPool.CLOSE_CURLY_BRACE); if (_log.isDebugEnabled()) { _log.debug(msg.toString()); } throw new NoSuchTaskFormException(msg.toString()); } return kaleoTaskForm; } /** * Returns the kaleo task form where kaleoTaskId = ? and formUuid = ? or returns <code>null</code> if it could not be found. Uses the finder cache. * * @param kaleoTaskId the kaleo task ID * @param formUuid the form uuid * @return the matching kaleo task form, or <code>null</code> if a matching kaleo task form could not be found */ @Override public KaleoTaskForm fetchByFormUuid_KTI(long kaleoTaskId, String formUuid) { return fetchByFormUuid_KTI(kaleoTaskId, formUuid, true); } /** * Returns the kaleo task form where kaleoTaskId = ? and formUuid = ? or returns <code>null</code> if it could not be found, optionally using the finder cache. * * @param kaleoTaskId the kaleo task ID * @param formUuid the form uuid * @param retrieveFromCache whether to retrieve from the finder cache * @return the matching kaleo task form, or <code>null</code> if a matching kaleo task form could not be found */ @Override public KaleoTaskForm fetchByFormUuid_KTI(long kaleoTaskId, String formUuid, boolean retrieveFromCache) { Object[] finderArgs = new Object[] { kaleoTaskId, formUuid }; Object result = null; if (retrieveFromCache) { result = finderCache.getResult(FINDER_PATH_FETCH_BY_FORMUUID_KTI, finderArgs, this); } if (result instanceof KaleoTaskForm) { KaleoTaskForm kaleoTaskForm = (KaleoTaskForm)result; if ((kaleoTaskId != kaleoTaskForm.getKaleoTaskId()) || !Objects.equals(formUuid, kaleoTaskForm.getFormUuid())) { result = null; } } if (result == null) { StringBundler query = new StringBundler(4); query.append(_SQL_SELECT_KALEOTASKFORM_WHERE); query.append(_FINDER_COLUMN_FORMUUID_KTI_KALEOTASKID_2); boolean bindFormUuid = false; if (formUuid == null) { query.append(_FINDER_COLUMN_FORMUUID_KTI_FORMUUID_1); } else if (formUuid.equals(StringPool.BLANK)) { query.append(_FINDER_COLUMN_FORMUUID_KTI_FORMUUID_3); } else { bindFormUuid = true; query.append(_FINDER_COLUMN_FORMUUID_KTI_FORMUUID_2); } String sql = query.toString(); Session session = null; try { session = openSession(); Query q = session.createQuery(sql); QueryPos qPos = QueryPos.getInstance(q); qPos.add(kaleoTaskId); if (bindFormUuid) { qPos.add(formUuid); } List<KaleoTaskForm> list = q.list(); if (list.isEmpty()) { finderCache.putResult(FINDER_PATH_FETCH_BY_FORMUUID_KTI, finderArgs, list); } else { if (list.size() > 1) { Collections.sort(list, Collections.reverseOrder()); if (_log.isWarnEnabled()) { _log.warn( "KaleoTaskFormPersistenceImpl.fetchByFormUuid_KTI(long, String, boolean) with parameters (" + StringUtil.merge(finderArgs) + ") yields a result set with more than 1 result. This violates the logical unique restriction. There is no order guarantee on which result is returned by this finder."); } } KaleoTaskForm kaleoTaskForm = list.get(0); result = kaleoTaskForm; cacheResult(kaleoTaskForm); if ((kaleoTaskForm.getKaleoTaskId() != kaleoTaskId) || (kaleoTaskForm.getFormUuid() == null) || !kaleoTaskForm.getFormUuid().equals(formUuid)) { finderCache.putResult(FINDER_PATH_FETCH_BY_FORMUUID_KTI, finderArgs, kaleoTaskForm); } } } catch (Exception e) { finderCache.removeResult(FINDER_PATH_FETCH_BY_FORMUUID_KTI, finderArgs); throw processException(e); } finally { closeSession(session); } } if (result instanceof List<?>) { return null; } else { return (KaleoTaskForm)result; } } /** * Removes the kaleo task form where kaleoTaskId = ? and formUuid = ? from the database. * * @param kaleoTaskId the kaleo task ID * @param formUuid the form uuid * @return the kaleo task form that was removed */ @Override public KaleoTaskForm removeByFormUuid_KTI(long kaleoTaskId, String formUuid) throws NoSuchTaskFormException { KaleoTaskForm kaleoTaskForm = findByFormUuid_KTI(kaleoTaskId, formUuid); return remove(kaleoTaskForm); } /** * Returns the number of kaleo task forms where kaleoTaskId = ? and formUuid = ?. * * @param kaleoTaskId the kaleo task ID * @param formUuid the form uuid * @return the number of matching kaleo task forms */ @Override public int countByFormUuid_KTI(long kaleoTaskId, String formUuid) { FinderPath finderPath = FINDER_PATH_COUNT_BY_FORMUUID_KTI; Object[] finderArgs = new Object[] { kaleoTaskId, formUuid }; Long count = (Long)finderCache.getResult(finderPath, finderArgs, this); if (count == null) { StringBundler query = new StringBundler(3); query.append(_SQL_COUNT_KALEOTASKFORM_WHERE); query.append(_FINDER_COLUMN_FORMUUID_KTI_KALEOTASKID_2); boolean bindFormUuid = false; if (formUuid == null) { query.append(_FINDER_COLUMN_FORMUUID_KTI_FORMUUID_1); } else if (formUuid.equals(StringPool.BLANK)) { query.append(_FINDER_COLUMN_FORMUUID_KTI_FORMUUID_3); } else { bindFormUuid = true; query.append(_FINDER_COLUMN_FORMUUID_KTI_FORMUUID_2); } String sql = query.toString(); Session session = null; try { session = openSession(); Query q = session.createQuery(sql); QueryPos qPos = QueryPos.getInstance(q); qPos.add(kaleoTaskId); if (bindFormUuid) { qPos.add(formUuid); } count = (Long)q.uniqueResult(); finderCache.putResult(finderPath, finderArgs, count); } catch (Exception e) { finderCache.removeResult(finderPath, finderArgs); throw processException(e); } finally { closeSession(session); } } return count.intValue(); } private static final String _FINDER_COLUMN_FORMUUID_KTI_KALEOTASKID_2 = "kaleoTaskForm.kaleoTaskId = ? AND "; private static final String _FINDER_COLUMN_FORMUUID_KTI_FORMUUID_1 = "kaleoTaskForm.formUuid IS NULL"; private static final String _FINDER_COLUMN_FORMUUID_KTI_FORMUUID_2 = "kaleoTaskForm.formUuid = ?"; private static final String _FINDER_COLUMN_FORMUUID_KTI_FORMUUID_3 = "(kaleoTaskForm.formUuid IS NULL OR kaleoTaskForm.formUuid = '')"; public KaleoTaskFormPersistenceImpl() { setModelClass(KaleoTaskForm.class); } /** * Caches the kaleo task form in the entity cache if it is enabled. * * @param kaleoTaskForm the kaleo task form */ @Override public void cacheResult(KaleoTaskForm kaleoTaskForm) { entityCache.putResult(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormImpl.class, kaleoTaskForm.getPrimaryKey(), kaleoTaskForm); finderCache.putResult(FINDER_PATH_FETCH_BY_FORMUUID_KTI, new Object[] { kaleoTaskForm.getKaleoTaskId(), kaleoTaskForm.getFormUuid() }, kaleoTaskForm); kaleoTaskForm.resetOriginalValues(); } /** * Caches the kaleo task forms in the entity cache if it is enabled. * * @param kaleoTaskForms the kaleo task forms */ @Override public void cacheResult(List<KaleoTaskForm> kaleoTaskForms) { for (KaleoTaskForm kaleoTaskForm : kaleoTaskForms) { if (entityCache.getResult( KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormImpl.class, kaleoTaskForm.getPrimaryKey()) == null) { cacheResult(kaleoTaskForm); } else { kaleoTaskForm.resetOriginalValues(); } } } /** * Clears the cache for all kaleo task forms. * * <p> * The {@link EntityCache} and {@link FinderCache} are both cleared by this method. * </p> */ @Override public void clearCache() { entityCache.clearCache(KaleoTaskFormImpl.class); finderCache.clearCache(FINDER_CLASS_NAME_ENTITY); finderCache.clearCache(FINDER_CLASS_NAME_LIST_WITH_PAGINATION); finderCache.clearCache(FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION); } /** * Clears the cache for the kaleo task form. * * <p> * The {@link EntityCache} and {@link FinderCache} are both cleared by this method. * </p> */ @Override public void clearCache(KaleoTaskForm kaleoTaskForm) { entityCache.removeResult(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormImpl.class, kaleoTaskForm.getPrimaryKey()); finderCache.clearCache(FINDER_CLASS_NAME_LIST_WITH_PAGINATION); finderCache.clearCache(FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION); clearUniqueFindersCache((KaleoTaskFormModelImpl)kaleoTaskForm, true); } @Override public void clearCache(List<KaleoTaskForm> kaleoTaskForms) { finderCache.clearCache(FINDER_CLASS_NAME_LIST_WITH_PAGINATION); finderCache.clearCache(FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION); for (KaleoTaskForm kaleoTaskForm : kaleoTaskForms) { entityCache.removeResult(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormImpl.class, kaleoTaskForm.getPrimaryKey()); clearUniqueFindersCache((KaleoTaskFormModelImpl)kaleoTaskForm, true); } } protected void cacheUniqueFindersCache( KaleoTaskFormModelImpl kaleoTaskFormModelImpl) { Object[] args = new Object[] { kaleoTaskFormModelImpl.getKaleoTaskId(), kaleoTaskFormModelImpl.getFormUuid() }; finderCache.putResult(FINDER_PATH_COUNT_BY_FORMUUID_KTI, args, Long.valueOf(1), false); finderCache.putResult(FINDER_PATH_FETCH_BY_FORMUUID_KTI, args, kaleoTaskFormModelImpl, false); } protected void clearUniqueFindersCache( KaleoTaskFormModelImpl kaleoTaskFormModelImpl, boolean clearCurrent) { if (clearCurrent) { Object[] args = new Object[] { kaleoTaskFormModelImpl.getKaleoTaskId(), kaleoTaskFormModelImpl.getFormUuid() }; finderCache.removeResult(FINDER_PATH_COUNT_BY_FORMUUID_KTI, args); finderCache.removeResult(FINDER_PATH_FETCH_BY_FORMUUID_KTI, args); } if ((kaleoTaskFormModelImpl.getColumnBitmask() & FINDER_PATH_FETCH_BY_FORMUUID_KTI.getColumnBitmask()) != 0) { Object[] args = new Object[] { kaleoTaskFormModelImpl.getOriginalKaleoTaskId(), kaleoTaskFormModelImpl.getOriginalFormUuid() }; finderCache.removeResult(FINDER_PATH_COUNT_BY_FORMUUID_KTI, args); finderCache.removeResult(FINDER_PATH_FETCH_BY_FORMUUID_KTI, args); } } /** * Creates a new kaleo task form with the primary key. Does not add the kaleo task form to the database. * * @param kaleoTaskFormId the primary key for the new kaleo task form * @return the new kaleo task form */ @Override public KaleoTaskForm create(long kaleoTaskFormId) { KaleoTaskForm kaleoTaskForm = new KaleoTaskFormImpl(); kaleoTaskForm.setNew(true); kaleoTaskForm.setPrimaryKey(kaleoTaskFormId); kaleoTaskForm.setCompanyId(companyProvider.getCompanyId()); return kaleoTaskForm; } /** * Removes the kaleo task form with the primary key from the database. Also notifies the appropriate model listeners. * * @param kaleoTaskFormId the primary key of the kaleo task form * @return the kaleo task form that was removed * @throws NoSuchTaskFormException if a kaleo task form with the primary key could not be found */ @Override public KaleoTaskForm remove(long kaleoTaskFormId) throws NoSuchTaskFormException { return remove((Serializable)kaleoTaskFormId); } /** * Removes the kaleo task form with the primary key from the database. Also notifies the appropriate model listeners. * * @param primaryKey the primary key of the kaleo task form * @return the kaleo task form that was removed * @throws NoSuchTaskFormException if a kaleo task form with the primary key could not be found */ @Override public KaleoTaskForm remove(Serializable primaryKey) throws NoSuchTaskFormException { Session session = null; try { session = openSession(); KaleoTaskForm kaleoTaskForm = (KaleoTaskForm)session.get(KaleoTaskFormImpl.class, primaryKey); if (kaleoTaskForm == null) { if (_log.isDebugEnabled()) { _log.debug(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY + primaryKey); } throw new NoSuchTaskFormException(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY + primaryKey); } return remove(kaleoTaskForm); } catch (NoSuchTaskFormException nsee) { throw nsee; } catch (Exception e) { throw processException(e); } finally { closeSession(session); } } @Override protected KaleoTaskForm removeImpl(KaleoTaskForm kaleoTaskForm) { kaleoTaskForm = toUnwrappedModel(kaleoTaskForm); Session session = null; try { session = openSession(); if (!session.contains(kaleoTaskForm)) { kaleoTaskForm = (KaleoTaskForm)session.get(KaleoTaskFormImpl.class, kaleoTaskForm.getPrimaryKeyObj()); } if (kaleoTaskForm != null) { session.delete(kaleoTaskForm); } } catch (Exception e) { throw processException(e); } finally { closeSession(session); } if (kaleoTaskForm != null) { clearCache(kaleoTaskForm); } return kaleoTaskForm; } @Override public KaleoTaskForm updateImpl(KaleoTaskForm kaleoTaskForm) { kaleoTaskForm = toUnwrappedModel(kaleoTaskForm); boolean isNew = kaleoTaskForm.isNew(); KaleoTaskFormModelImpl kaleoTaskFormModelImpl = (KaleoTaskFormModelImpl)kaleoTaskForm; ServiceContext serviceContext = ServiceContextThreadLocal.getServiceContext(); Date now = new Date(); if (isNew && (kaleoTaskForm.getCreateDate() == null)) { if (serviceContext == null) { kaleoTaskForm.setCreateDate(now); } else { kaleoTaskForm.setCreateDate(serviceContext.getCreateDate(now)); } } if (!kaleoTaskFormModelImpl.hasSetModifiedDate()) { if (serviceContext == null) { kaleoTaskForm.setModifiedDate(now); } else { kaleoTaskForm.setModifiedDate(serviceContext.getModifiedDate( now)); } } Session session = null; try { session = openSession(); if (kaleoTaskForm.isNew()) { session.save(kaleoTaskForm); kaleoTaskForm.setNew(false); } else { kaleoTaskForm = (KaleoTaskForm)session.merge(kaleoTaskForm); } } catch (Exception e) { throw processException(e); } finally { closeSession(session); } finderCache.clearCache(FINDER_CLASS_NAME_LIST_WITH_PAGINATION); if (!KaleoTaskFormModelImpl.COLUMN_BITMASK_ENABLED) { finderCache.clearCache(FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION); } else if (isNew) { Object[] args = new Object[] { kaleoTaskFormModelImpl.getCompanyId() }; finderCache.removeResult(FINDER_PATH_COUNT_BY_COMPANYID, args); finderCache.removeResult(FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_COMPANYID, args); args = new Object[] { kaleoTaskFormModelImpl.getKaleoDefinitionId() }; finderCache.removeResult(FINDER_PATH_COUNT_BY_KALEODEFINITIONID, args); finderCache.removeResult(FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_KALEODEFINITIONID, args); args = new Object[] { kaleoTaskFormModelImpl.getKaleoNodeId() }; finderCache.removeResult(FINDER_PATH_COUNT_BY_KALEONODEID, args); finderCache.removeResult(FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_KALEONODEID, args); args = new Object[] { kaleoTaskFormModelImpl.getKaleoTaskId() }; finderCache.removeResult(FINDER_PATH_COUNT_BY_KALEOTASKID, args); finderCache.removeResult(FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_KALEOTASKID, args); finderCache.removeResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY); finderCache.removeResult(FINDER_PATH_WITHOUT_PAGINATION_FIND_ALL, FINDER_ARGS_EMPTY); } else { if ((kaleoTaskFormModelImpl.getColumnBitmask() & FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_COMPANYID.getColumnBitmask()) != 0) { Object[] args = new Object[] { kaleoTaskFormModelImpl.getOriginalCompanyId() }; finderCache.removeResult(FINDER_PATH_COUNT_BY_COMPANYID, args); finderCache.removeResult(FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_COMPANYID, args); args = new Object[] { kaleoTaskFormModelImpl.getCompanyId() }; finderCache.removeResult(FINDER_PATH_COUNT_BY_COMPANYID, args); finderCache.removeResult(FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_COMPANYID, args); } if ((kaleoTaskFormModelImpl.getColumnBitmask() & FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_KALEODEFINITIONID.getColumnBitmask()) != 0) { Object[] args = new Object[] { kaleoTaskFormModelImpl.getOriginalKaleoDefinitionId() }; finderCache.removeResult(FINDER_PATH_COUNT_BY_KALEODEFINITIONID, args); finderCache.removeResult(FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_KALEODEFINITIONID, args); args = new Object[] { kaleoTaskFormModelImpl.getKaleoDefinitionId() }; finderCache.removeResult(FINDER_PATH_COUNT_BY_KALEODEFINITIONID, args); finderCache.removeResult(FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_KALEODEFINITIONID, args); } if ((kaleoTaskFormModelImpl.getColumnBitmask() & FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_KALEONODEID.getColumnBitmask()) != 0) { Object[] args = new Object[] { kaleoTaskFormModelImpl.getOriginalKaleoNodeId() }; finderCache.removeResult(FINDER_PATH_COUNT_BY_KALEONODEID, args); finderCache.removeResult(FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_KALEONODEID, args); args = new Object[] { kaleoTaskFormModelImpl.getKaleoNodeId() }; finderCache.removeResult(FINDER_PATH_COUNT_BY_KALEONODEID, args); finderCache.removeResult(FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_KALEONODEID, args); } if ((kaleoTaskFormModelImpl.getColumnBitmask() & FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_KALEOTASKID.getColumnBitmask()) != 0) { Object[] args = new Object[] { kaleoTaskFormModelImpl.getOriginalKaleoTaskId() }; finderCache.removeResult(FINDER_PATH_COUNT_BY_KALEOTASKID, args); finderCache.removeResult(FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_KALEOTASKID, args); args = new Object[] { kaleoTaskFormModelImpl.getKaleoTaskId() }; finderCache.removeResult(FINDER_PATH_COUNT_BY_KALEOTASKID, args); finderCache.removeResult(FINDER_PATH_WITHOUT_PAGINATION_FIND_BY_KALEOTASKID, args); } } entityCache.putResult(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormImpl.class, kaleoTaskForm.getPrimaryKey(), kaleoTaskForm, false); clearUniqueFindersCache(kaleoTaskFormModelImpl, false); cacheUniqueFindersCache(kaleoTaskFormModelImpl); kaleoTaskForm.resetOriginalValues(); return kaleoTaskForm; } protected KaleoTaskForm toUnwrappedModel(KaleoTaskForm kaleoTaskForm) { if (kaleoTaskForm instanceof KaleoTaskFormImpl) { return kaleoTaskForm; } KaleoTaskFormImpl kaleoTaskFormImpl = new KaleoTaskFormImpl(); kaleoTaskFormImpl.setNew(kaleoTaskForm.isNew()); kaleoTaskFormImpl.setPrimaryKey(kaleoTaskForm.getPrimaryKey()); kaleoTaskFormImpl.setKaleoTaskFormId(kaleoTaskForm.getKaleoTaskFormId()); kaleoTaskFormImpl.setGroupId(kaleoTaskForm.getGroupId()); kaleoTaskFormImpl.setCompanyId(kaleoTaskForm.getCompanyId()); kaleoTaskFormImpl.setUserId(kaleoTaskForm.getUserId()); kaleoTaskFormImpl.setUserName(kaleoTaskForm.getUserName()); kaleoTaskFormImpl.setCreateDate(kaleoTaskForm.getCreateDate()); kaleoTaskFormImpl.setModifiedDate(kaleoTaskForm.getModifiedDate()); kaleoTaskFormImpl.setKaleoDefinitionId(kaleoTaskForm.getKaleoDefinitionId()); kaleoTaskFormImpl.setKaleoNodeId(kaleoTaskForm.getKaleoNodeId()); kaleoTaskFormImpl.setKaleoTaskId(kaleoTaskForm.getKaleoTaskId()); kaleoTaskFormImpl.setKaleoTaskName(kaleoTaskForm.getKaleoTaskName()); kaleoTaskFormImpl.setName(kaleoTaskForm.getName()); kaleoTaskFormImpl.setDescription(kaleoTaskForm.getDescription()); kaleoTaskFormImpl.setFormCompanyId(kaleoTaskForm.getFormCompanyId()); kaleoTaskFormImpl.setFormDefinition(kaleoTaskForm.getFormDefinition()); kaleoTaskFormImpl.setFormGroupId(kaleoTaskForm.getFormGroupId()); kaleoTaskFormImpl.setFormId(kaleoTaskForm.getFormId()); kaleoTaskFormImpl.setFormUuid(kaleoTaskForm.getFormUuid()); kaleoTaskFormImpl.setMetadata(kaleoTaskForm.getMetadata()); kaleoTaskFormImpl.setPriority(kaleoTaskForm.getPriority()); return kaleoTaskFormImpl; } /** * Returns the kaleo task form with the primary key or throws a {@link com.liferay.portal.kernel.exception.NoSuchModelException} if it could not be found. * * @param primaryKey the primary key of the kaleo task form * @return the kaleo task form * @throws NoSuchTaskFormException if a kaleo task form with the primary key could not be found */ @Override public KaleoTaskForm findByPrimaryKey(Serializable primaryKey) throws NoSuchTaskFormException { KaleoTaskForm kaleoTaskForm = fetchByPrimaryKey(primaryKey); if (kaleoTaskForm == null) { if (_log.isDebugEnabled()) { _log.debug(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY + primaryKey); } throw new NoSuchTaskFormException(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY + primaryKey); } return kaleoTaskForm; } /** * Returns the kaleo task form with the primary key or throws a {@link NoSuchTaskFormException} if it could not be found. * * @param kaleoTaskFormId the primary key of the kaleo task form * @return the kaleo task form * @throws NoSuchTaskFormException if a kaleo task form with the primary key could not be found */ @Override public KaleoTaskForm findByPrimaryKey(long kaleoTaskFormId) throws NoSuchTaskFormException { return findByPrimaryKey((Serializable)kaleoTaskFormId); } /** * Returns the kaleo task form with the primary key or returns <code>null</code> if it could not be found. * * @param primaryKey the primary key of the kaleo task form * @return the kaleo task form, or <code>null</code> if a kaleo task form with the primary key could not be found */ @Override public KaleoTaskForm fetchByPrimaryKey(Serializable primaryKey) { Serializable serializable = entityCache.getResult(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormImpl.class, primaryKey); if (serializable == nullModel) { return null; } KaleoTaskForm kaleoTaskForm = (KaleoTaskForm)serializable; if (kaleoTaskForm == null) { Session session = null; try { session = openSession(); kaleoTaskForm = (KaleoTaskForm)session.get(KaleoTaskFormImpl.class, primaryKey); if (kaleoTaskForm != null) { cacheResult(kaleoTaskForm); } else { entityCache.putResult(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormImpl.class, primaryKey, nullModel); } } catch (Exception e) { entityCache.removeResult(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormImpl.class, primaryKey); throw processException(e); } finally { closeSession(session); } } return kaleoTaskForm; } /** * Returns the kaleo task form with the primary key or returns <code>null</code> if it could not be found. * * @param kaleoTaskFormId the primary key of the kaleo task form * @return the kaleo task form, or <code>null</code> if a kaleo task form with the primary key could not be found */ @Override public KaleoTaskForm fetchByPrimaryKey(long kaleoTaskFormId) { return fetchByPrimaryKey((Serializable)kaleoTaskFormId); } @Override public Map<Serializable, KaleoTaskForm> fetchByPrimaryKeys( Set<Serializable> primaryKeys) { if (primaryKeys.isEmpty()) { return Collections.emptyMap(); } Map<Serializable, KaleoTaskForm> map = new HashMap<Serializable, KaleoTaskForm>(); if (primaryKeys.size() == 1) { Iterator<Serializable> iterator = primaryKeys.iterator(); Serializable primaryKey = iterator.next(); KaleoTaskForm kaleoTaskForm = fetchByPrimaryKey(primaryKey); if (kaleoTaskForm != null) { map.put(primaryKey, kaleoTaskForm); } return map; } Set<Serializable> uncachedPrimaryKeys = null; for (Serializable primaryKey : primaryKeys) { Serializable serializable = entityCache.getResult(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormImpl.class, primaryKey); if (serializable != nullModel) { if (serializable == null) { if (uncachedPrimaryKeys == null) { uncachedPrimaryKeys = new HashSet<Serializable>(); } uncachedPrimaryKeys.add(primaryKey); } else { map.put(primaryKey, (KaleoTaskForm)serializable); } } } if (uncachedPrimaryKeys == null) { return map; } StringBundler query = new StringBundler((uncachedPrimaryKeys.size() * 2) + 1); query.append(_SQL_SELECT_KALEOTASKFORM_WHERE_PKS_IN); for (Serializable primaryKey : uncachedPrimaryKeys) { query.append((long)primaryKey); query.append(StringPool.COMMA); } query.setIndex(query.index() - 1); query.append(StringPool.CLOSE_PARENTHESIS); String sql = query.toString(); Session session = null; try { session = openSession(); Query q = session.createQuery(sql); for (KaleoTaskForm kaleoTaskForm : (List<KaleoTaskForm>)q.list()) { map.put(kaleoTaskForm.getPrimaryKeyObj(), kaleoTaskForm); cacheResult(kaleoTaskForm); uncachedPrimaryKeys.remove(kaleoTaskForm.getPrimaryKeyObj()); } for (Serializable primaryKey : uncachedPrimaryKeys) { entityCache.putResult(KaleoTaskFormModelImpl.ENTITY_CACHE_ENABLED, KaleoTaskFormImpl.class, primaryKey, nullModel); } } catch (Exception e) { throw processException(e); } finally { closeSession(session); } return map; } /** * Returns all the kaleo task forms. * * @return the kaleo task forms */ @Override public List<KaleoTaskForm> findAll() { return findAll(QueryUtil.ALL_POS, QueryUtil.ALL_POS, null); } /** * Returns a range of all the kaleo task forms. * * <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 QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link KaleoTaskFormModelImpl}. If both <code>orderByComparator</code> and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order. * </p> * * @param start the lower bound of the range of kaleo task forms * @param end the upper bound of the range of kaleo task forms (not inclusive) * @return the range of kaleo task forms */ @Override public List<KaleoTaskForm> findAll(int start, int end) { return findAll(start, end, null); } /** * Returns an ordered range of all the kaleo task forms. * * <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 QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link KaleoTaskFormModelImpl}. If both <code>orderByComparator</code> and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order. * </p> * * @param start the lower bound of the range of kaleo task forms * @param end the upper bound of the range of kaleo task forms (not inclusive) * @param orderByComparator the comparator to order the results by (optionally <code>null</code>) * @return the ordered range of kaleo task forms */ @Override public List<KaleoTaskForm> findAll(int start, int end, OrderByComparator<KaleoTaskForm> orderByComparator) { return findAll(start, end, orderByComparator, true); } /** * Returns an ordered range of all the kaleo task forms. * * <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 QueryUtil#ALL_POS} will return the full result set. If <code>orderByComparator</code> is specified, then the query will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and pagination is required (<code>start</code> and <code>end</code> are not {@link QueryUtil#ALL_POS}), then the query will include the default ORDER BY logic from {@link KaleoTaskFormModelImpl}. If both <code>orderByComparator</code> and pagination are absent, for performance reasons, the query will not have an ORDER BY clause and the returned result set will be sorted on by the primary key in an ascending order. * </p> * * @param start the lower bound of the range of kaleo task forms * @param end the upper bound of the range of kaleo task forms (not inclusive) * @param orderByComparator the comparator to order the results by (optionally <code>null</code>) * @param retrieveFromCache whether to retrieve from the finder cache * @return the ordered range of kaleo task forms */ @Override public List<KaleoTaskForm> findAll(int start, int end, OrderByComparator<KaleoTaskForm> orderByComparator, boolean retrieveFromCache) { boolean pagination = true; FinderPath finderPath = null; Object[] finderArgs = null; if ((start == QueryUtil.ALL_POS) && (end == QueryUtil.ALL_POS) && (orderByComparator == null)) { pagination = false; finderPath = FINDER_PATH_WITHOUT_PAGINATION_FIND_ALL; finderArgs = FINDER_ARGS_EMPTY; } else { finderPath = FINDER_PATH_WITH_PAGINATION_FIND_ALL; finderArgs = new Object[] { start, end, orderByComparator }; } List<KaleoTaskForm> list = null; if (retrieveFromCache) { list = (List<KaleoTaskForm>)finderCache.getResult(finderPath, finderArgs, this); } if (list == null) { StringBundler query = null; String sql = null; if (orderByComparator != null) { query = new StringBundler(2 + (orderByComparator.getOrderByFields().length * 2)); query.append(_SQL_SELECT_KALEOTASKFORM); appendOrderByComparator(query, _ORDER_BY_ENTITY_ALIAS, orderByComparator); sql = query.toString(); } else { sql = _SQL_SELECT_KALEOTASKFORM; if (pagination) { sql = sql.concat(KaleoTaskFormModelImpl.ORDER_BY_JPQL); } } Session session = null; try { session = openSession(); Query q = session.createQuery(sql); if (!pagination) { list = (List<KaleoTaskForm>)QueryUtil.list(q, getDialect(), start, end, false); Collections.sort(list); list = Collections.unmodifiableList(list); } else { list = (List<KaleoTaskForm>)QueryUtil.list(q, getDialect(), start, end); } cacheResult(list); finderCache.putResult(finderPath, finderArgs, list); } catch (Exception e) { finderCache.removeResult(finderPath, finderArgs); throw processException(e); } finally { closeSession(session); } } return list; } /** * Removes all the kaleo task forms from the database. * */ @Override public void removeAll() { for (KaleoTaskForm kaleoTaskForm : findAll()) { remove(kaleoTaskForm); } } /** * Returns the number of kaleo task forms. * * @return the number of kaleo task forms */ @Override public int countAll() { Long count = (Long)finderCache.getResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY, this); if (count == null) { Session session = null; try { session = openSession(); Query q = session.createQuery(_SQL_COUNT_KALEOTASKFORM); count = (Long)q.uniqueResult(); finderCache.putResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY, count); } catch (Exception e) { finderCache.removeResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY); throw processException(e); } finally { closeSession(session); } } return count.intValue(); } @Override protected Map<String, Integer> getTableColumnsMap() { return KaleoTaskFormModelImpl.TABLE_COLUMNS_MAP; } /** * Initializes the kaleo task form persistence. */ public void afterPropertiesSet() { } public void destroy() { entityCache.removeCache(KaleoTaskFormImpl.class.getName()); finderCache.removeCache(FINDER_CLASS_NAME_ENTITY); finderCache.removeCache(FINDER_CLASS_NAME_LIST_WITH_PAGINATION); finderCache.removeCache(FINDER_CLASS_NAME_LIST_WITHOUT_PAGINATION); } @ServiceReference(type = CompanyProviderWrapper.class) protected CompanyProvider companyProvider; @ServiceReference(type = EntityCache.class) protected EntityCache entityCache; @ServiceReference(type = FinderCache.class) protected FinderCache finderCache; private static final String _SQL_SELECT_KALEOTASKFORM = "SELECT kaleoTaskForm FROM KaleoTaskForm kaleoTaskForm"; private static final String _SQL_SELECT_KALEOTASKFORM_WHERE_PKS_IN = "SELECT kaleoTaskForm FROM KaleoTaskForm kaleoTaskForm WHERE kaleoTaskFormId IN ("; private static final String _SQL_SELECT_KALEOTASKFORM_WHERE = "SELECT kaleoTaskForm FROM KaleoTaskForm kaleoTaskForm WHERE "; private static final String _SQL_COUNT_KALEOTASKFORM = "SELECT COUNT(kaleoTaskForm) FROM KaleoTaskForm kaleoTaskForm"; private static final String _SQL_COUNT_KALEOTASKFORM_WHERE = "SELECT COUNT(kaleoTaskForm) FROM KaleoTaskForm kaleoTaskForm WHERE "; private static final String _ORDER_BY_ENTITY_ALIAS = "kaleoTaskForm."; private static final String _NO_SUCH_ENTITY_WITH_PRIMARY_KEY = "No KaleoTaskForm exists with the primary key "; private static final String _NO_SUCH_ENTITY_WITH_KEY = "No KaleoTaskForm exists with the key {"; private static final Log _log = LogFactoryUtil.getLog(KaleoTaskFormPersistenceImpl.class); }