Examples with Song org.liferay.jukebox.model.Song used on opensource projects

Example 16 with Song

use of org.liferay.jukebox.model.Song in project liferay-ide by liferay.

the class SongPersistenceImpl method findByArtistId_Last.

/**
 * Returns the last song in the ordered set where artistId = ?.
 *
 * @param artistId the artist ID
 * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
 * @return the last matching song
 * @throws org.liferay.jukebox.NoSuchSongException if a matching song could not be found
 * @throws SystemException if a system exception occurred
 */
@Override
public Song findByArtistId_Last(long artistId, OrderByComparator orderByComparator) throws NoSuchSongException, SystemException {
    Song song = fetchByArtistId_Last(artistId, orderByComparator);
    if (song != null) {
        return song;
    }
    StringBundler msg = new StringBundler(4);
    msg.append(_NO_SUCH_ENTITY_WITH_KEY);
    msg.append("artistId=");
    msg.append(artistId);
    msg.append(StringPool.CLOSE_CURLY_BRACE);
    throw new NoSuchSongException(msg.toString());
}

Example 17 with Song

use of org.liferay.jukebox.model.Song in project liferay-ide by liferay.

the class SongPersistenceImpl method getByGroupId_PrevAndNext.

protected Song getByGroupId_PrevAndNext(Session session, Song song, long groupId, OrderByComparator orderByComparator, boolean previous) {
    StringBundler query = null;
    if (orderByComparator != null) {
        query = new StringBundler(6 + (orderByComparator.getOrderByFields().length * 6));
    } else {
        query = new StringBundler(3);
    }
    query.append(_SQL_SELECT_SONG_WHERE);
    query.append(_FINDER_COLUMN_GROUPID_GROUPID_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(SongModelImpl.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(groupId);
    if (orderByComparator != null) {
        Object[] values = orderByComparator.getOrderByConditionValues(song);
        for (Object value : values) {
            qPos.add(value);
        }
    }
    List<Song> list = q.list();
    if (list.size() == 2) {
        return list.get(1);
    } else {
        return null;
    }
}

Example 18 with Song

use of org.liferay.jukebox.model.Song in project liferay-ide by liferay.

the class SongPersistenceImpl method filterFindByGroupId_PrevAndNext.

/**
 * Returns the songs before and after the current song in the ordered set of songs that the user has permission to view where groupId = ?.
 *
 * @param songId the primary key of the current song
 * @param groupId the group ID
 * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
 * @return the previous, current, and next song
 * @throws org.liferay.jukebox.NoSuchSongException if a song with the primary key could not be found
 * @throws SystemException if a system exception occurred
 */
@Override
public Song[] filterFindByGroupId_PrevAndNext(long songId, long groupId, OrderByComparator orderByComparator) throws NoSuchSongException, SystemException {
    if (!InlineSQLHelperUtil.isEnabled(groupId)) {
        return findByGroupId_PrevAndNext(songId, groupId, orderByComparator);
    }
    Song song = findByPrimaryKey(songId);
    Session session = null;
    try {
        session = openSession();
        Song[] array = new SongImpl[3];
        array[0] = filterGetByGroupId_PrevAndNext(session, song, groupId, orderByComparator, true);
        array[1] = song;
        array[2] = filterGetByGroupId_PrevAndNext(session, song, groupId, orderByComparator, false);
        return array;
    } catch (Exception e) {
        throw processException(e);
    } finally {
        closeSession(session);
    }
}

Example 19 with Song

use of org.liferay.jukebox.model.Song in project liferay-ide by liferay.

the class SongPersistenceImpl method remove.

/**
 * Removes the song with the primary key from the database. Also notifies the appropriate model listeners.
 *
 * @param primaryKey the primary key of the song
 * @return the song that was removed
 * @throws org.liferay.jukebox.NoSuchSongException if a song with the primary key could not be found
 * @throws SystemException if a system exception occurred
 */
@Override
public Song remove(Serializable primaryKey) throws NoSuchSongException, SystemException {
    Session session = null;
    try {
        session = openSession();
        Song song = (Song) session.get(SongImpl.class, primaryKey);
        if (song == null) {
            if (_log.isWarnEnabled()) {
                _log.warn(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY + primaryKey);
            }
            throw new NoSuchSongException(_NO_SUCH_ENTITY_WITH_PRIMARY_KEY + primaryKey);
        }
        return remove(song);
    } catch (NoSuchSongException nsee) {
        throw nsee;
    } catch (Exception e) {
        throw processException(e);
    } finally {
        closeSession(session);
    }
}

Example 20 with Song

use of org.liferay.jukebox.model.Song in project liferay-ide by liferay.

the class SongPersistenceImpl method findByAlbumId_First.

/**
 * Returns the first song in the ordered set where albumId = ?.
 *
 * @param albumId the album ID
 * @param orderByComparator the comparator to order the set by (optionally <code>null</code>)
 * @return the first matching song
 * @throws org.liferay.jukebox.NoSuchSongException if a matching song could not be found
 * @throws SystemException if a system exception occurred
 */
@Override
public Song findByAlbumId_First(long albumId, OrderByComparator orderByComparator) throws NoSuchSongException, SystemException {
    Song song = fetchByAlbumId_First(albumId, orderByComparator);
    if (song != null) {
        return song;
    }
    StringBundler msg = new StringBundler(4);
    msg.append(_NO_SUCH_ENTITY_WITH_KEY);
    msg.append("albumId=");
    msg.append(albumId);
    msg.append(StringPool.CLOSE_CURLY_BRACE);
    throw new NoSuchSongException(msg.toString());
}