Package com.pugh.sockso.music

Examples of com.pugh.sockso.music.Playlist

180
181
182
183
184
185
186
187
188
189
190
191
           
            // get sql for track query
            if ( type.equals(MusicItem.COLLECTION) )
                sql = Track.getSelectFromSql(); // select everything in the collection
            else if ( type.equals(MusicItem.PLAYLIST) ) {
                Playlist playlist = (Playlist) item;
                sql = Playlist.getSelectTracksSql(playlist.getId(),"");
            }
            else if ( type.equals(MusicItem.ARTIST) ) {
                Artist artist = (Artist) item;
                sql = Track.getSelectFromSql() +
                        " where t.artist_id = '" + artist.getId() + "' ";
View Full Code Here
110
111
112
113
114
115
116
117
118
119
120
121
       
        final int index = getSelectedIndex();
       
        if ( index != -1 ) {
           
            final Playlist playlist = (Playlist) model.getElementAt( index );
           
            cm.removePlaylist( playlist.getId() );

        }

    }
View Full Code Here
142
143
144
145
146
147
148
149
150
151
152
           
            st = db.prepare( sql );
            rs = st.executeQuery();

            while ( rs.next() )
                model.addElement( new Playlist(rs.getInt("id"),rs.getString("name")) );

        }
       
        catch ( final SQLException e ) {
            log.error( e.getMessage() );
View Full Code Here
24
25
26
27
28
29
30
31
32
33
34
35
36
37
     */
   
    public void handleRequest() throws IOException, SQLException, BadRequestException {
       
        final Database db = getDatabase();
        final Playlist playlist = Playlist.find( db, Integer.parseInt( getRequest().getUrlParam(2) ) );
       
        if ( playlist == null ) {
            throw new BadRequestException( "Invalid playlist ID" );
        }
       
        showPlaylist( playlist, playlist.getTracks(db) );
       
    }
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
    protected void playlist() throws SQLException, IOException, BadRequestException {
       
        final Request req = getRequest();
        final Database db = getDatabase();
        final int id = Integer.parseInt( req.getUrlParam(2)  );       
        final Playlist playlist = Playlist.find( db, id );
       
        if ( playlist == null ) {
            throw new BadRequestException( "Invalid playlist ID", 404 );
        }
       
        final List<Track> tracks = playlist.getTracks( db );

        showPlaylist( playlist, tracks );
       
    }
View Full Code Here
95
96
97
98
99
100
101
102
103
104
105
            st = db.prepare( sql );
            rs = st.executeQuery();
           
            final List<Playlist> userPlaylists = new ArrayList<Playlist>();
            while ( rs.next() )
                userPlaylists.add( new Playlist(
                    rs.getInt("id"), rs.getString("name"), rs.getInt("trackCount"),
                    new User( rs.getInt("userId"), rs.getString("userName") )
                ));

            return userPlaylists;
View Full Code Here
141
142
143
144
145
146
147
148
149
150
151
            rs = st.executeQuery();
           
            final List<Playlist> sitePlaylists = new ArrayList<Playlist>();

            while ( rs.next() )
                sitePlaylists.add( new Playlist(
                    rs.getInt("id"), rs.getString("name"), rs.getInt("trackCount")
                ));
           
            return sitePlaylists;
           
View Full Code Here
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
        final TestResponse res = new TestResponse();
        final Playlistser b = new Playlistser();
        final List<Playlist> sitePlaylists = new ArrayList<Playlist>();
        final List<Playlist> userPlaylists = new ArrayList<Playlist>();
        final User user = new User( 12323, "my user" );
        final Playlist sitePlaylist = new Playlist( 1, "site Play list" );
        final Playlist userPlaylist = new Playlist( 1, "USER Play list", 1, user );

        sitePlaylists.add( sitePlaylist );
        userPlaylists.add( userPlaylist );
       
        b.setResponse( res );
        b.showPlaylists( sitePlaylists, userPlaylists );
       
        final String data = res.getOutput();

        assertTrue( data.contains(sitePlaylist.getName()) );
        assertTrue( data.contains(userPlaylist.getName()) );
        assertTrue( data.contains(user.getName()) );

    }
View Full Code Here
TOP

Related Classes of com.pugh.sockso.music.Playlist

  • com.pugh.sockso.gui.PlaylistPanel
  • com.pugh.sockso.gui.Playlists
  • com.pugh.sockso.web.action.api.PlaylistAction
  • com.pugh.sockso.web.action.browse.Playlister
  • com.pugh.sockso.web.action.browse.Playlistser
  • com.pugh.sockso.web.action.browse.PlaylistserTest
  • com.pugh.sockso.web.User
  • java.sql.PreparedStatement
  • java.sql.ResultSet
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.