/**
* Returns the number of social equity histories.
*
* @return the number of social equity histories
* @throws SystemException if a system exception occurred
*/
public int countAll() throws SystemException {
Object[] finderArgs = new Object[0];
Long count = (Long) FinderCacheUtil.getResult(FINDER_PATH_COUNT_ALL, finderArgs, this);
if (count == null) {
Session session = null;
try {
session = openSession();
Query q = session.createQuery(_SQL_COUNT_SOCIALEQUITYHISTORY);
count = (Long) q.uniqueResult();
} catch (Exception e) {
throw processException(e);
} finally {
if (count == null) {
count = Long.valueOf(0);
}
FinderCacheUtil.putResult(FINDER_PATH_COUNT_ALL, finderArgs, count);
closeSession(session);
}
}
return count.intValue();
}
/**
* Returns the number of shopping item prices.
*
* @return the number of shopping item prices
*/
@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_SHOPPINGITEMPRICE);
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();
}
public int countAll() throws SystemException {
Object[] finderArgs = new Object[0];
Long count = (Long) FinderCacheUtil.getResult(FINDER_PATH_COUNT_ALL, finderArgs, this);
if (count == null) {
Session session = null;
try {
session = openSession();
Query q =
session.createQuery(
"SELECT COUNT(*) FROM com.ext.portlet.debaterevision.model.DebateItemReference");
count = (Long) q.uniqueResult();
} catch (Exception e) {
throw processException(e);
} finally {
if (count == null) {
count = Long.valueOf(0);
}
FinderCacheUtil.putResult(FINDER_PATH_COUNT_ALL, finderArgs, count);
closeSession(session);
}
}
return count.intValue();
}
/**
* Returns the number of class names.
*
* @return the number of class names
* @throws SystemException if a system exception occurred
*/
public int countAll() throws SystemException {
Long count = (Long) FinderCacheUtil.getResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY, this);
if (count == null) {
Session session = null;
try {
session = openSession();
Query q = session.createQuery(_SQL_COUNT_CLASSNAME);
count = (Long) q.uniqueResult();
} catch (Exception e) {
throw processException(e);
} finally {
if (count == null) {
count = Long.valueOf(0);
}
FinderCacheUtil.putResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY, count);
closeSession(session);
}
}
return count.intValue();
}
/**
* Returns the number of projects entries.
*
* @return the number of projects entries
* @throws SystemException if a system exception occurred
*/
@Override
public int countAll() throws SystemException {
Long count = (Long) FinderCacheUtil.getResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY, this);
if (count == null) {
Session session = null;
try {
session = openSession();
Query q = session.createQuery(_SQL_COUNT_PROJECTSENTRY);
count = (Long) q.uniqueResult();
FinderCacheUtil.putResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY, count);
} catch (Exception e) {
FinderCacheUtil.removeResult(FINDER_PATH_COUNT_ALL, FINDER_ARGS_EMPTY);
throw processException(e);
} finally {
closeSession(session);
}
}
return count.intValue();
}
public int countAll() throws SystemException {
Object[] finderArgs = new Object[0];
Long count = (Long) FinderCacheUtil.getResult(FINDER_PATH_COUNT_ALL, finderArgs, this);
if (count == null) {
Session session = null;
try {
session = openSession();
Query q =
session.createQuery(
"SELECT COUNT(*) FROM larion.progate.cds.model.ViewListTitleCompetencies");
count = (Long) q.uniqueResult();
} catch (Exception e) {
throw processException(e);
} finally {
if (count == null) {
count = Long.valueOf(0);
}
FinderCacheUtil.putResult(FINDER_PATH_COUNT_ALL, finderArgs, count);
closeSession(session);
}
}
return count.intValue();
}
/**
* Returns the number of entries where userId = ? and emailAddress = ?.
*
* @param userId the user ID
* @param emailAddress the email address
* @return the number of matching entries
* @throws SystemException if a system exception occurred
*/
@Override
public int countByU_EA(long userId, String emailAddress) throws SystemException {
FinderPath finderPath = FINDER_PATH_COUNT_BY_U_EA;
Object[] finderArgs = new Object[] {userId, emailAddress};
Long count = (Long) FinderCacheUtil.getResult(finderPath, finderArgs, this);
if (count == null) {
StringBundler query = new StringBundler(3);
query.append(_SQL_COUNT_ENTRY_WHERE);
query.append(_FINDER_COLUMN_U_EA_USERID_2);
boolean bindEmailAddress = false;
if (emailAddress == null) {
query.append(_FINDER_COLUMN_U_EA_EMAILADDRESS_1);
} else if (emailAddress.equals(StringPool.BLANK)) {
query.append(_FINDER_COLUMN_U_EA_EMAILADDRESS_3);
} else {
bindEmailAddress = true;
query.append(_FINDER_COLUMN_U_EA_EMAILADDRESS_2);
}
String sql = query.toString();
Session session = null;
try {
session = openSession();
Query q = session.createQuery(sql);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(userId);
if (bindEmailAddress) {
qPos.add(emailAddress);
}
count = (Long) q.uniqueResult();
FinderCacheUtil.putResult(finderPath, finderArgs, count);
} catch (Exception e) {
FinderCacheUtil.removeResult(finderPath, finderArgs);
throw processException(e);
} finally {
closeSession(session);
}
}
return count.intValue();
}
/**
* Returns the number of bars where text = ?.
*
* @param text the text
* @return the number of matching bars
*/
@Override
public int countByText(String text) {
FinderPath finderPath = FINDER_PATH_COUNT_BY_TEXT;
Object[] finderArgs = new Object[] {text};
Long count = (Long) FinderCacheUtil.getResult(finderPath, finderArgs, this);
if (count == null) {
StringBundler query = new StringBundler(2);
query.append(_SQL_COUNT_BAR_WHERE);
boolean bindText = false;
if (text == null) {
query.append(_FINDER_COLUMN_TEXT_TEXT_1);
} else if (text.equals(StringPool.BLANK)) {
query.append(_FINDER_COLUMN_TEXT_TEXT_3);
} else {
bindText = true;
query.append(_FINDER_COLUMN_TEXT_TEXT_2);
}
String sql = query.toString();
Session session = null;
try {
session = openSession();
Query q = session.createQuery(sql);
QueryPos qPos = QueryPos.getInstance(q);
if (bindText) {
qPos.add(text);
}
count = (Long) q.uniqueResult();
FinderCacheUtil.putResult(finderPath, finderArgs, count);
} catch (Exception e) {
FinderCacheUtil.removeResult(finderPath, finderArgs);
throw processException(e);
} finally {
closeSession(session);
}
}
return count.intValue();
}
/**
* Returns the number of releases where servletContextName = ?.
*
* @param servletContextName the servlet context name
* @return the number of matching releases
* @throws SystemException if a system exception occurred
*/
public int countByServletContextName(String servletContextName) throws SystemException {
FinderPath finderPath = FINDER_PATH_COUNT_BY_SERVLETCONTEXTNAME;
Object[] finderArgs = new Object[] {servletContextName};
Long count = (Long) FinderCacheUtil.getResult(finderPath, finderArgs, this);
if (count == null) {
StringBundler query = new StringBundler(2);
query.append(_SQL_COUNT_RELEASE_WHERE);
boolean bindServletContextName = false;
if (servletContextName == null) {
query.append(_FINDER_COLUMN_SERVLETCONTEXTNAME_SERVLETCONTEXTNAME_1);
} else if (servletContextName.equals(StringPool.BLANK)) {
query.append(_FINDER_COLUMN_SERVLETCONTEXTNAME_SERVLETCONTEXTNAME_3);
} else {
bindServletContextName = true;
query.append(_FINDER_COLUMN_SERVLETCONTEXTNAME_SERVLETCONTEXTNAME_2);
}
String sql = query.toString();
Session session = null;
try {
session = openSession();
Query q = session.createQuery(sql);
QueryPos qPos = QueryPos.getInstance(q);
if (bindServletContextName) {
qPos.add(servletContextName.toLowerCase());
}
count = (Long) q.uniqueResult();
FinderCacheUtil.putResult(finderPath, finderArgs, count);
} catch (Exception e) {
FinderCacheUtil.removeResult(finderPath, finderArgs);
throw processException(e);
} finally {
closeSession(session);
}
}
return count.intValue();
}
/**
* Returns the number of class names where value = ?.
*
* @param value the value
* @return the number of matching class names
* @throws SystemException if a system exception occurred
*/
public int countByValue(String value) throws SystemException {
Object[] finderArgs = new Object[] {value};
Long count = (Long) FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_VALUE, finderArgs, this);
if (count == null) {
StringBundler query = new StringBundler(2);
query.append(_SQL_COUNT_CLASSNAME_WHERE);
if (value == null) {
query.append(_FINDER_COLUMN_VALUE_VALUE_1);
} else {
if (value.equals(StringPool.BLANK)) {
query.append(_FINDER_COLUMN_VALUE_VALUE_3);
} else {
query.append(_FINDER_COLUMN_VALUE_VALUE_2);
}
}
String sql = query.toString();
Session session = null;
try {
session = openSession();
Query q = session.createQuery(sql);
QueryPos qPos = QueryPos.getInstance(q);
if (value != null) {
qPos.add(value);
}
count = (Long) q.uniqueResult();
} catch (Exception e) {
throw processException(e);
} finally {
if (count == null) {
count = Long.valueOf(0);
}
FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_VALUE, finderArgs, count);
closeSession(session);
}
}
return count.intValue();
}
/**
* Returns the number of semesters where beginYear = ? and endYear = ? and division =
* ?.
*
* @param beginYear the begin year
* @param endYear the end year
* @param division the division
* @return the number of matching semesters
*/
@Override
public int countByB_E_D(int beginYear, int endYear, int division) {
FinderPath finderPath = FINDER_PATH_COUNT_BY_B_E_D;
Object[] finderArgs = new Object[] {beginYear, endYear, division};
Long count = (Long) finderCache.getResult(finderPath, finderArgs, this);
if (count == null) {
StringBundler query = new StringBundler(4);
query.append(_SQL_COUNT_SEMESTER_WHERE);
query.append(_FINDER_COLUMN_B_E_D_BEGINYEAR_2);
query.append(_FINDER_COLUMN_B_E_D_ENDYEAR_2);
query.append(_FINDER_COLUMN_B_E_D_DIVISION_2);
String sql = query.toString();
Session session = null;
try {
session = openSession();
Query q = session.createQuery(sql);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(beginYear);
qPos.add(endYear);
qPos.add(division);
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();
}
/**
* Returns the number of Tips of the Day Userses where companyId = ? and groupId = ? and
* userId = ?.
*
* @param companyId the company ID
* @param groupId the group ID
* @param userId the user ID
* @return the number of matching Tips of the Day Userses
* @throws SystemException if a system exception occurred
*/
@Override
public int countByC_G_U(long companyId, long groupId, long userId) throws SystemException {
FinderPath finderPath = FINDER_PATH_COUNT_BY_C_G_U;
Object[] finderArgs = new Object[] {companyId, groupId, userId};
Long count = (Long) FinderCacheUtil.getResult(finderPath, finderArgs, this);
if (count == null) {
StringBundler query = new StringBundler(4);
query.append(_SQL_COUNT_TIPSOFTHEDAYUSERS_WHERE);
query.append(_FINDER_COLUMN_C_G_U_COMPANYID_2);
query.append(_FINDER_COLUMN_C_G_U_GROUPID_2);
query.append(_FINDER_COLUMN_C_G_U_USERID_2);
String sql = query.toString();
Session session = null;
try {
session = openSession();
Query q = session.createQuery(sql);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(companyId);
qPos.add(groupId);
qPos.add(userId);
count = (Long) q.uniqueResult();
FinderCacheUtil.putResult(finderPath, finderArgs, count);
} catch (Exception e) {
FinderCacheUtil.removeResult(finderPath, finderArgs);
throw processException(e);
} finally {
closeSession(session);
}
}
return count.intValue();
}
/**
* Returns the number of d l syncs where companyId = ? and modifiedDate > ? and
* repositoryId = ?.
*
* @param companyId the company ID
* @param modifiedDate the modified date
* @param repositoryId the repository ID
* @return the number of matching d l syncs
* @throws SystemException if a system exception occurred
*/
public int countByC_M_R(long companyId, long modifiedDate, long repositoryId)
throws SystemException {
FinderPath finderPath = FINDER_PATH_WITH_PAGINATION_COUNT_BY_C_M_R;
Object[] finderArgs = new Object[] {companyId, modifiedDate, repositoryId};
Long count = (Long) FinderCacheUtil.getResult(finderPath, finderArgs, this);
if (count == null) {
StringBundler query = new StringBundler(4);
query.append(_SQL_COUNT_DLSYNC_WHERE);
query.append(_FINDER_COLUMN_C_M_R_COMPANYID_2);
query.append(_FINDER_COLUMN_C_M_R_MODIFIEDDATE_2);
query.append(_FINDER_COLUMN_C_M_R_REPOSITORYID_2);
String sql = query.toString();
Session session = null;
try {
session = openSession();
Query q = session.createQuery(sql);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(companyId);
qPos.add(modifiedDate);
qPos.add(repositoryId);
count = (Long) q.uniqueResult();
FinderCacheUtil.putResult(finderPath, finderArgs, count);
} catch (Exception e) {
FinderCacheUtil.removeResult(finderPath, finderArgs);
throw processException(e);
} finally {
closeSession(session);
}
}
return count.intValue();
}
/**
* Returns the number of announcements flags where userId = ? and entryId = ? and value =
* ?.
*
* @param userId the user ID
* @param entryId the entry ID
* @param value the value
* @return the number of matching announcements flags
* @throws SystemException if a system exception occurred
*/
public int countByU_E_V(long userId, long entryId, int value) throws SystemException {
Object[] finderArgs = new Object[] {userId, entryId, value};
Long count = (Long) FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_U_E_V, finderArgs, this);
if (count == null) {
StringBundler query = new StringBundler(4);
query.append(_SQL_COUNT_ANNOUNCEMENTSFLAG_WHERE);
query.append(_FINDER_COLUMN_U_E_V_USERID_2);
query.append(_FINDER_COLUMN_U_E_V_ENTRYID_2);
query.append(_FINDER_COLUMN_U_E_V_VALUE_2);
String sql = query.toString();
Session session = null;
try {
session = openSession();
Query q = session.createQuery(sql);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(userId);
qPos.add(entryId);
qPos.add(value);
count = (Long) q.uniqueResult();
} catch (Exception e) {
throw processException(e);
} finally {
if (count == null) {
count = Long.valueOf(0);
}
FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_U_E_V, finderArgs, count);
closeSession(session);
}
}
return count.intValue();
}
/**
* Returns the number of shards where classNameId = ? and classPK = ?.
*
* @param classNameId the class name ID
* @param classPK the class p k
* @return the number of matching shards
* @throws SystemException if a system exception occurred
*/
@Override
public int countByC_C(long classNameId, long classPK) throws SystemException {
FinderPath finderPath = FINDER_PATH_COUNT_BY_C_C;
Object[] finderArgs = new Object[] {classNameId, classPK};
Long count = (Long) FinderCacheUtil.getResult(finderPath, finderArgs, this);
if (count == null) {
StringBundler query = new StringBundler(3);
query.append(_SQL_COUNT_SHARD_WHERE);
query.append(_FINDER_COLUMN_C_C_CLASSNAMEID_2);
query.append(_FINDER_COLUMN_C_C_CLASSPK_2);
String sql = query.toString();
Session session = null;
try {
session = openSession();
Query q = session.createQuery(sql);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(classNameId);
qPos.add(classPK);
count = (Long) q.uniqueResult();
FinderCacheUtil.putResult(finderPath, finderArgs, count);
} catch (Exception e) {
FinderCacheUtil.removeResult(finderPath, finderArgs);
throw processException(e);
} finally {
closeSession(session);
}
}
return count.intValue();
}
/**
* Returns the number of expando rows where tableId = ? and classPK = ?.
*
* @param tableId the table ID
* @param classPK the class p k
* @return the number of matching expando rows
* @throws SystemException if a system exception occurred
*/
public int countByT_C(long tableId, long classPK) throws SystemException {
Object[] finderArgs = new Object[] {tableId, classPK};
Long count = (Long) FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_T_C, finderArgs, this);
if (count == null) {
StringBundler query = new StringBundler(3);
query.append(_SQL_COUNT_EXPANDOROW_WHERE);
query.append(_FINDER_COLUMN_T_C_TABLEID_2);
query.append(_FINDER_COLUMN_T_C_CLASSPK_2);
String sql = query.toString();
Session session = null;
try {
session = openSession();
Query q = session.createQuery(sql);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(tableId);
qPos.add(classPK);
count = (Long) q.uniqueResult();
} catch (Exception e) {
throw processException(e);
} finally {
if (count == null) {
count = Long.valueOf(0);
}
FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_T_C, finderArgs, count);
closeSession(session);
}
}
return count.intValue();
}
/**
* Returns the number of portal preferenceses where ownerId = ? and ownerType = ?.
*
* @param ownerId the owner ID
* @param ownerType the owner type
* @return the number of matching portal preferenceses
* @throws SystemException if a system exception occurred
*/
public int countByO_O(long ownerId, int ownerType) throws SystemException {
Object[] finderArgs = new Object[] {ownerId, ownerType};
Long count = (Long) FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_O_O, finderArgs, this);
if (count == null) {
StringBundler query = new StringBundler(3);
query.append(_SQL_COUNT_PORTALPREFERENCES_WHERE);
query.append(_FINDER_COLUMN_O_O_OWNERID_2);
query.append(_FINDER_COLUMN_O_O_OWNERTYPE_2);
String sql = query.toString();
Session session = null;
try {
session = openSession();
Query q = session.createQuery(sql);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(ownerId);
qPos.add(ownerType);
count = (Long) q.uniqueResult();
} catch (Exception e) {
throw processException(e);
} finally {
if (count == null) {
count = Long.valueOf(0);
}
FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_O_O, finderArgs, count);
closeSession(session);
}
}
return count.intValue();
}
/**
* Returns the number of layout sets where groupId = ? and privateLayout = ?.
*
* @param groupId the group ID
* @param privateLayout the private layout
* @return the number of matching layout sets
* @throws SystemException if a system exception occurred
*/
public int countByG_P(long groupId, boolean privateLayout) throws SystemException {
Object[] finderArgs = new Object[] {groupId, privateLayout};
Long count = (Long) FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_G_P, finderArgs, this);
if (count == null) {
StringBundler query = new StringBundler(3);
query.append(_SQL_COUNT_LAYOUTSET_WHERE);
query.append(_FINDER_COLUMN_G_P_GROUPID_2);
query.append(_FINDER_COLUMN_G_P_PRIVATELAYOUT_2);
String sql = query.toString();
Session session = null;
try {
session = openSession();
Query q = session.createQuery(sql);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(groupId);
qPos.add(privateLayout);
count = (Long) q.uniqueResult();
} catch (Exception e) {
throw processException(e);
} finally {
if (count == null) {
count = Long.valueOf(0);
}
FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_G_P, finderArgs, count);
closeSession(session);
}
}
return count.intValue();
}
/**
* Returns the number of images where size < ?.
*
* @param size the size
* @return the number of matching images
* @throws SystemException if a system exception occurred
*/
public int countByLtSize(int size) throws SystemException {
Object[] finderArgs = new Object[] {size};
Long count =
(Long)
FinderCacheUtil.getResult(
FINDER_PATH_WITH_PAGINATION_COUNT_BY_LTSIZE, finderArgs, this);
if (count == null) {
StringBundler query = new StringBundler(2);
query.append(_SQL_COUNT_IMAGE_WHERE);
query.append(_FINDER_COLUMN_LTSIZE_SIZE_2);
String sql = query.toString();
Session session = null;
try {
session = openSession();
Query q = session.createQuery(sql);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(size);
count = (Long) q.uniqueResult();
} catch (Exception e) {
throw processException(e);
} finally {
if (count == null) {
count = Long.valueOf(0);
}
FinderCacheUtil.putResult(FINDER_PATH_WITH_PAGINATION_COUNT_BY_LTSIZE, finderArgs, count);
closeSession(session);
}
}
return count.intValue();
}
/**
* Returns the number of projects entries where userId = ?.
*
* @param userId the user ID
* @return the number of matching projects entries
* @throws SystemException if a system exception occurred
*/
@Override
public int countByUserId(long userId) throws SystemException {
FinderPath finderPath = FINDER_PATH_COUNT_BY_USERID;
Object[] finderArgs = new Object[] {userId};
Long count = (Long) FinderCacheUtil.getResult(finderPath, finderArgs, this);
if (count == null) {
StringBundler query = new StringBundler(2);
query.append(_SQL_COUNT_PROJECTSENTRY_WHERE);
query.append(_FINDER_COLUMN_USERID_USERID_2);
String sql = query.toString();
Session session = null;
try {
session = openSession();
Query q = session.createQuery(sql);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(userId);
count = (Long) q.uniqueResult();
FinderCacheUtil.putResult(finderPath, finderArgs, count);
} catch (Exception e) {
FinderCacheUtil.removeResult(finderPath, finderArgs);
throw processException(e);
} finally {
closeSession(session);
}
}
return count.intValue();
}
/**
* Returns the number of foos where field2 = ?.
*
* @param field2 the field2
* @return the number of matching foos
*/
@Override
public int countByField2(boolean field2) {
FinderPath finderPath = FINDER_PATH_COUNT_BY_FIELD2;
Object[] finderArgs = new Object[] {field2};
Long count = (Long) FinderCacheUtil.getResult(finderPath, finderArgs, this);
if (count == null) {
StringBundler query = new StringBundler(2);
query.append(_SQL_COUNT_FOO_WHERE);
query.append(_FINDER_COLUMN_FIELD2_FIELD2_2);
String sql = query.toString();
Session session = null;
try {
session = openSession();
Query q = session.createQuery(sql);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(field2);
count = (Long) q.uniqueResult();
FinderCacheUtil.putResult(finderPath, finderArgs, count);
} catch (Exception e) {
FinderCacheUtil.removeResult(finderPath, finderArgs);
throw processException(e);
} finally {
closeSession(session);
}
}
return count.intValue();
}
/**
* Returns the number of d l sync events where modifiedTime > ?.
*
* @param modifiedTime the modified time
* @return the number of matching d l sync events
* @throws SystemException if a system exception occurred
*/
@Override
public int countByModifiedTime(long modifiedTime) throws SystemException {
FinderPath finderPath = FINDER_PATH_WITH_PAGINATION_COUNT_BY_MODIFIEDTIME;
Object[] finderArgs = new Object[] {modifiedTime};
Long count = (Long) FinderCacheUtil.getResult(finderPath, finderArgs, this);
if (count == null) {
StringBundler query = new StringBundler(2);
query.append(_SQL_COUNT_DLSYNCEVENT_WHERE);
query.append(_FINDER_COLUMN_MODIFIEDTIME_MODIFIEDTIME_2);
String sql = query.toString();
Session session = null;
try {
session = openSession();
Query q = session.createQuery(sql);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(modifiedTime);
count = (Long) q.uniqueResult();
FinderCacheUtil.putResult(finderPath, finderArgs, count);
} catch (Exception e) {
FinderCacheUtil.removeResult(finderPath, finderArgs);
throw processException(e);
} finally {
closeSession(session);
}
}
return count.intValue();
}
/**
* Returns the number of shopping item prices where itemId = ?.
*
* @param itemId the item ID
* @return the number of matching shopping item prices
*/
@Override
public int countByItemId(long itemId) {
FinderPath finderPath = FINDER_PATH_COUNT_BY_ITEMID;
Object[] finderArgs = new Object[] {itemId};
Long count = (Long) finderCache.getResult(finderPath, finderArgs, this);
if (count == null) {
StringBundler query = new StringBundler(2);
query.append(_SQL_COUNT_SHOPPINGITEMPRICE_WHERE);
query.append(_FINDER_COLUMN_ITEMID_ITEMID_2);
String sql = query.toString();
Session session = null;
try {
session = openSession();
Query q = session.createQuery(sql);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(itemId);
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();
}
/**
* Returns the number of j i r a change items where jiraChangeGroupId = ?.
*
* @param jiraChangeGroupId the jira change group ID
* @return the number of matching j i r a change items
* @throws SystemException if a system exception occurred
*/
public int countByJiraChangeGroupId(long jiraChangeGroupId) throws SystemException {
Object[] finderArgs = new Object[] {jiraChangeGroupId};
Long count =
(Long) FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_JIRACHANGEGROUPID, finderArgs, this);
if (count == null) {
StringBundler query = new StringBundler(2);
query.append(_SQL_COUNT_JIRACHANGEITEM_WHERE);
query.append(_FINDER_COLUMN_JIRACHANGEGROUPID_JIRACHANGEGROUPID_2);
String sql = query.toString();
Session session = null;
try {
session = openSession();
Query q = session.createQuery(sql);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(jiraChangeGroupId);
count = (Long) q.uniqueResult();
} catch (Exception e) {
throw processException(e);
} finally {
if (count == null) {
count = Long.valueOf(0);
}
FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_JIRACHANGEGROUPID, finderArgs, count);
closeSession(session);
}
}
return count.intValue();
}
public int countByTitleId(int titleId) throws SystemException {
Object[] finderArgs = new Object[] {new Integer(titleId)};
Long count = (Long) FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_TITLEID, finderArgs, this);
if (count == null) {
Session session = null;
try {
session = openSession();
StringBuilder query = new StringBuilder();
query.append("SELECT COUNT(*) ");
query.append("FROM larion.progate.cds.model.ViewListTitleCompetencies WHERE ");
query.append("title_id = ?");
query.append(" ");
Query q = session.createQuery(query.toString());
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(titleId);
count = (Long) q.uniqueResult();
} catch (Exception e) {
throw processException(e);
} finally {
if (count == null) {
count = Long.valueOf(0);
}
FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_TITLEID, finderArgs, count);
closeSession(session);
}
}
return count.intValue();
}
/**
* Returns the number of panic buttons where moduleId = ?.
*
* @param moduleId the module ID
* @return the number of matching panic buttons
* @throws SystemException if a system exception occurred
*/
public int countByByModule(long moduleId) throws SystemException {
Object[] finderArgs = new Object[] {moduleId};
Long count = (Long) FinderCacheUtil.getResult(FINDER_PATH_COUNT_BY_BYMODULE, finderArgs, this);
if (count == null) {
StringBundler query = new StringBundler(2);
query.append(_SQL_COUNT_PANICBUTTON_WHERE);
query.append(_FINDER_COLUMN_BYMODULE_MODULEID_2);
String sql = query.toString();
Session session = null;
try {
session = openSession();
Query q = session.createQuery(sql);
QueryPos qPos = QueryPos.getInstance(q);
qPos.add(moduleId);
count = (Long) q.uniqueResult();
} catch (Exception e) {
throw processException(e);
} finally {
if (count == null) {
count = Long.valueOf(0);
}
FinderCacheUtil.putResult(FINDER_PATH_COUNT_BY_BYMODULE, finderArgs, count);
closeSession(session);
}
}
return count.intValue();
}
public int countByDebateItemIdItemVersionStatus(
Long debateItemId, Long itemVersion, String status) throws SystemException {
Object[] finderArgs = new Object[] {debateItemId, itemVersion, status};
Long count =
(Long)
FinderCacheUtil.getResult(
FINDER_PATH_COUNT_BY_DEBATEITEMIDITEMVERSIONSTATUS, finderArgs, this);
if (count == null) {
Session session = null;
try {
session = openSession();
StringBuilder query = new StringBuilder();
query.append("SELECT COUNT(*) ");
query.append("FROM com.ext.portlet.debaterevision.model.DebateItemReference WHERE ");
if (debateItemId == null) {
query.append("debateItemId IS NULL");
} else {
query.append("debateItemId = ?");
}
query.append(" AND ");
if (itemVersion == null) {
query.append("itemVersion IS NULL");
} else {
query.append("itemVersion = ?");
}
query.append(" AND ");
if (status == null) {
query.append("status IS NULL");
} else {
query.append("status = ?");
}
query.append(" ");
Query q = session.createQuery(query.toString());
QueryPos qPos = QueryPos.getInstance(q);
if (debateItemId != null) {
qPos.add(debateItemId.longValue());
}
if (itemVersion != null) {
qPos.add(itemVersion.longValue());
}
if (status != null) {
qPos.add(status);
}
count = (Long) q.uniqueResult();
} catch (Exception e) {
throw processException(e);
} finally {
if (count == null) {
count = Long.valueOf(0);
}
FinderCacheUtil.putResult(
FINDER_PATH_COUNT_BY_DEBATEITEMIDITEMVERSIONSTATUS, finderArgs, count);
closeSession(session);
}
}
return count.intValue();
}
