Search in sources :

Example 16 with SystemException

use of com.liferay.portal.kernel.exception.SystemException in project liferay-ide by liferay.

the class AlbumPersistenceImpl method filterCountByG_A_S.

/**
 * Returns the number of albums that the user has permission to view where groupId = ? and artistId = ? and status = ?.
 *
 * @param groupId the group ID
 * @param artistId the artist ID
 * @param status the status
 * @return the number of matching albums that the user has permission to view
 * @throws SystemException if a system exception occurred
 */
@Override
public int filterCountByG_A_S(long groupId, long artistId, int status) throws SystemException {
    if (!InlineSQLHelperUtil.isEnabled(groupId)) {
        return countByG_A_S(groupId, artistId, status);
    }
    StringBundler query = new StringBundler(4);
    query.append(_FILTER_SQL_COUNT_ALBUM_WHERE);
    query.append(_FINDER_COLUMN_G_A_S_GROUPID_2);
    query.append(_FINDER_COLUMN_G_A_S_ARTISTID_2);
    query.append(_FINDER_COLUMN_G_A_S_STATUS_2);
    String sql = InlineSQLHelperUtil.replacePermissionCheck(query.toString(), Album.class.getName(), _FILTER_ENTITY_TABLE_FILTER_PK_COLUMN, groupId);
    Session session = null;
    try {
        session = openSession();
        SQLQuery q = session.createSQLQuery(sql);
        q.addScalar(COUNT_COLUMN_NAME, com.liferay.portal.kernel.dao.orm.Type.LONG);
        QueryPos qPos = QueryPos.getInstance(q);
        qPos.add(groupId);
        qPos.add(artistId);
        qPos.add(status);
        Long count = (Long) q.uniqueResult();
        return count.intValue();
    } catch (Exception e) {
        throw processException(e);
    } finally {
        closeSession(session);
    }
}
Also used : Album(org.liferay.jukebox.model.Album) SQLQuery(com.liferay.portal.kernel.dao.orm.SQLQuery) QueryPos(com.liferay.portal.kernel.dao.orm.QueryPos) StringBundler(com.liferay.portal.kernel.util.StringBundler) SystemException(com.liferay.portal.kernel.exception.SystemException) NoSuchAlbumException(org.liferay.jukebox.NoSuchAlbumException) Session(com.liferay.portal.kernel.dao.orm.Session)

Example 17 with SystemException

use of com.liferay.portal.kernel.exception.SystemException in project liferay-ide by liferay.

the class AlbumPersistenceImpl method findByUuid_C_PrevAndNext.

/**
 * Returns the albums before and after the current album in the ordered set where uuid = ? and companyId = ?.
 *
 * @param albumId the primary key of the current album
 * @param uuid the uuid
 * @param companyId the company ID
 * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
 * @return the previous, current, and next album
 * @throws org.liferay.jukebox.NoSuchAlbumException if a album with the primary key could not be found
 * @throws SystemException if a system exception occurred
 */
@Override
public Album[] findByUuid_C_PrevAndNext(long albumId, String uuid, long companyId, OrderByComparator orderByComparator) throws NoSuchAlbumException, SystemException {
    Album album = findByPrimaryKey(albumId);
    Session session = null;
    try {
        session = openSession();
        Album[] array = new AlbumImpl[3];
        array[0] = getByUuid_C_PrevAndNext(session, album, uuid, companyId, orderByComparator, true);
        array[1] = album;
        array[2] = getByUuid_C_PrevAndNext(session, album, uuid, companyId, orderByComparator, false);
        return array;
    } catch (Exception e) {
        throw processException(e);
    } finally {
        closeSession(session);
    }
}
Also used : AlbumImpl(org.liferay.jukebox.model.impl.AlbumImpl) Album(org.liferay.jukebox.model.Album) SystemException(com.liferay.portal.kernel.exception.SystemException) NoSuchAlbumException(org.liferay.jukebox.NoSuchAlbumException) Session(com.liferay.portal.kernel.dao.orm.Session)

Example 18 with SystemException

use of com.liferay.portal.kernel.exception.SystemException in project liferay-ide by liferay.

the class AlbumPersistenceImpl method countByG_S.

/**
 * Returns the number of albums where groupId = &#63; and status = &#63;.
 *
 * @param groupId the group ID
 * @param status the status
 * @return the number of matching albums
 * @throws SystemException if a system exception occurred
 */
@Override
public int countByG_S(long groupId, int status) throws SystemException {
    FinderPath finderPath = FINDER_PATH_COUNT_BY_G_S;
    Object[] finderArgs = new Object[] { groupId, status };
    Long count = (Long) FinderCacheUtil.getResult(finderPath, finderArgs, this);
    if (count == null) {
        StringBundler query = new StringBundler(3);
        query.append(_SQL_COUNT_ALBUM_WHERE);
        query.append(_FINDER_COLUMN_G_S_GROUPID_2);
        query.append(_FINDER_COLUMN_G_S_STATUS_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(status);
            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();
}
Also used : SQLQuery(com.liferay.portal.kernel.dao.orm.SQLQuery) Query(com.liferay.portal.kernel.dao.orm.Query) FinderPath(com.liferay.portal.kernel.dao.orm.FinderPath) QueryPos(com.liferay.portal.kernel.dao.orm.QueryPos) StringBundler(com.liferay.portal.kernel.util.StringBundler) SystemException(com.liferay.portal.kernel.exception.SystemException) NoSuchAlbumException(org.liferay.jukebox.NoSuchAlbumException) Session(com.liferay.portal.kernel.dao.orm.Session)

Example 19 with SystemException

use of com.liferay.portal.kernel.exception.SystemException in project liferay-ide by liferay.

the class AlbumPersistenceImpl method findByGroupId_PrevAndNext.

/**
 * Returns the albums before and after the current album in the ordered set where groupId = &#63;.
 *
 * @param albumId the primary key of the current album
 * @param groupId the group ID
 * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
 * @return the previous, current, and next album
 * @throws org.liferay.jukebox.NoSuchAlbumException if a album with the primary key could not be found
 * @throws SystemException if a system exception occurred
 */
@Override
public Album[] findByGroupId_PrevAndNext(long albumId, long groupId, OrderByComparator orderByComparator) throws NoSuchAlbumException, SystemException {
    Album album = findByPrimaryKey(albumId);
    Session session = null;
    try {
        session = openSession();
        Album[] array = new AlbumImpl[3];
        array[0] = getByGroupId_PrevAndNext(session, album, groupId, orderByComparator, true);
        array[1] = album;
        array[2] = getByGroupId_PrevAndNext(session, album, groupId, orderByComparator, false);
        return array;
    } catch (Exception e) {
        throw processException(e);
    } finally {
        closeSession(session);
    }
}
Also used : AlbumImpl(org.liferay.jukebox.model.impl.AlbumImpl) Album(org.liferay.jukebox.model.Album) SystemException(com.liferay.portal.kernel.exception.SystemException) NoSuchAlbumException(org.liferay.jukebox.NoSuchAlbumException) Session(com.liferay.portal.kernel.dao.orm.Session)

Example 20 with SystemException

use of com.liferay.portal.kernel.exception.SystemException in project liferay-ide by liferay.

the class AlbumPersistenceImpl method findByG_A_S_PrevAndNext.

/**
 * Returns the albums before and after the current album in the ordered set where groupId = &#63; and artistId = &#63; and status = &#63;.
 *
 * @param albumId the primary key of the current album
 * @param groupId the group ID
 * @param artistId the artist ID
 * @param status the status
 * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
 * @return the previous, current, and next album
 * @throws org.liferay.jukebox.NoSuchAlbumException if a album with the primary key could not be found
 * @throws SystemException if a system exception occurred
 */
@Override
public Album[] findByG_A_S_PrevAndNext(long albumId, long groupId, long artistId, int status, OrderByComparator orderByComparator) throws NoSuchAlbumException, SystemException {
    Album album = findByPrimaryKey(albumId);
    Session session = null;
    try {
        session = openSession();
        Album[] array = new AlbumImpl[3];
        array[0] = getByG_A_S_PrevAndNext(session, album, groupId, artistId, status, orderByComparator, true);
        array[1] = album;
        array[2] = getByG_A_S_PrevAndNext(session, album, groupId, artistId, status, orderByComparator, false);
        return array;
    } catch (Exception e) {
        throw processException(e);
    } finally {
        closeSession(session);
    }
}
Also used : AlbumImpl(org.liferay.jukebox.model.impl.AlbumImpl) Album(org.liferay.jukebox.model.Album) SystemException(com.liferay.portal.kernel.exception.SystemException) NoSuchAlbumException(org.liferay.jukebox.NoSuchAlbumException) Session(com.liferay.portal.kernel.dao.orm.Session)

Aggregations

SystemException (com.liferay.portal.kernel.exception.SystemException)571 Session (com.liferay.portal.kernel.dao.orm.Session)509 StringBundler (com.liferay.portal.kernel.util.StringBundler)336 QueryPos (com.liferay.portal.kernel.dao.orm.QueryPos)324 SQLQuery (com.liferay.portal.kernel.dao.orm.SQLQuery)312 Query (com.liferay.portal.kernel.dao.orm.Query)252 NoSuchArticleException (com.liferay.knowledgebase.NoSuchArticleException)194 FinderPath (com.liferay.portal.kernel.dao.orm.FinderPath)191 ArrayList (java.util.ArrayList)175 UnmodifiableList (com.liferay.portal.kernel.util.UnmodifiableList)173 List (java.util.List)173 KBArticle (com.liferay.knowledgebase.model.KBArticle)147 NoSuchSongException (org.liferay.jukebox.NoSuchSongException)58 NoSuchAlbumException (org.liferay.jukebox.NoSuchAlbumException)53 KBArticleImpl (com.liferay.knowledgebase.model.impl.KBArticleImpl)46 NoSuchArtistException (org.liferay.jukebox.NoSuchArtistException)44 Song (org.liferay.jukebox.model.Song)44 PortalException (com.liferay.portal.kernel.exception.PortalException)43 Album (org.liferay.jukebox.model.Album)42 NoSuchCommentException (com.liferay.knowledgebase.NoSuchCommentException)34