Package com.pugh.sockso.db

Examples of com.pugh.sockso.db.Database

143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
        PreparedStatement st = null;
        ResultSet rs = null;

        try {

            final Database db = getDatabase();
            final String sql = Track.getSelectSql() +
                    " from ( select l.track_id " +
                            " from play_log l " +
                            " order by l.date_played desc ) r " +
                        " inner join tracks t " +
                        " on r.track_id = t.id " +
                        " inner join genres g " +
                        " on g.id = t.genre_id " +
                        " inner join artists ar " +
                        " on ar.id = t.artist_id " +
                        " inner join albums al " +
                        " on al.id = t.album_id " +
                        " group by artistId, artistName, albumId, albumName, albumYear, " +
                        "trackId, trackName, trackPath, trackNo, genreId, genreName, dateAdded " +
                    " limit ? ";

            st = db.prepare( sql );
            st.setInt( 1, total );
            rs = st.executeQuery();
           
            return Track.createListFromResultSet( rs );
View Full Code Here
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
        PreparedStatement st = null;
        ResultSet rs = null;
       
        try {
           
            final Database db = getDatabase();
            final String sql = " select al.id as albumId, al.name as albumName, al.year as albumYear, " +
                        " ar.id as artistId, ar.name as artistName, " +
                        " max(l.date_played) as mostRecent " +
                  " from play_log l " +
                      " inner join tracks t " +
                      " on t.id = l.track_id " +
                      " inner join albums al " +
                      " on al.id = t.album_id " +
                      " inner join artists ar " +
                      " on ar.id = al.artist_id " +
                  " group by albumId, albumName, albumYear, artistId, artistName " +
                  " order by mostRecent desc " +
                  " limit ? ";

            st = db.prepare( sql );
            st.setInt( 1, total );
            rs = st.executeQuery();

            final List<Album> recentAlbums = new ArrayList<Album>();
            while ( rs.next() ) {
View Full Code Here
26
27
28
29
30
31
32
33
34
35
36
37
            final PreparedStatement st = createNiceMock( PreparedStatement.class );
            expect( st.execute() ).andReturn( true );
            replay( st );
           
            Database db = createMock( Database.class );
            expect( db.prepare((String)anyObject()) ).andReturn( st ).anyTimes();
           
            replay( db );
           
            final Properties p = new DBProperties( db );
            p.save();
View Full Code Here
33
34
35
36
37
38
39
40
41
42
43
44
        final PreparedStatement st = createNiceMock( PreparedStatement.class );
        expect( st.executeQuery() ).andReturn( rs );
        st.close();
        replay( st );

        final Database db = createMock( Database.class );
        expect( db.prepare((String)anyObject()) ).andReturn( st ).times( 1 );
        replay( db );

        final Session sess = new Session( db, req, null );
        User user = sess.getCurrentUser();
View Full Code Here
120
121
122
123
124
125
126
127
128
129
130
131
       
        final PreparedStatement st = createNiceMock( PreparedStatement.class );
        expect( st.executeQuery() ).andReturn( rs );
        replay( st );
       
        final Database db = createMock( Database.class );
        expect( db.prepare((String)anyObject()) ).andReturn( st ).times( 2 );
        replay( db );
       
        final DBCollectionManager colMan = new DBCollectionManager( db, p, indexer );
       
        try {
View Full Code Here
147
148
149
150
151
152
153
154
155
156
157
158
       
    }
   
    public void testRemoveTrack() throws SQLException {
       
        final Database db = createMock( Database.class );
        expect( db.update((String)anyObject()) ).andReturn( 1 ).times( 3 );
        replay( db );
       
        final DBCollectionManager colMan = new DBCollectionManager( db, p, indexer );
        colMan.removeTrack( 123 );
       
View Full Code Here
265
266
267
268
269
270
271
272
273
274
275
       
    }

    public void testGetTrackNotFound() throws Exception {

        final Database db = new TestDatabase();
        final DBCollectionManager cm = new DBCollectionManager( db, p, indexer );

        boolean gotException = false;

        try {
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
50
        final PreparedStatement st = createMock( PreparedStatement.class );
        st.setInt( 1, 10 );
        expect( st.executeQuery() ).andReturn( rs ).times( 1 );
        replay( st );
       
        final Database db = createMock( Database.class );
        expect( db.prepare((String)anyObject()) ).andReturn( st ).times( 1 );
        replay( db );
       
        final Latester b = new Latester();
        b.setProperties( p );
        b.setDatabase( db );
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
       
    }
   
    public void testGetLatestArtistsQuery() throws Exception {
       
        final Database db = new TestDatabase();
        final Latester b = new Latester();
       
        b.setProperties( new StringProperties() );
        b.setDatabase( db );
        b.getLatestArtists();
View Full Code Here
114
115
116
117
118
119
120
121
122
123
124
125
        final PreparedStatement st = createMock( PreparedStatement.class );
        st.setInt( 1, 10 );
        expect( st.executeQuery() ).andReturn( rs ).times( 1 );
        replay( st );
       
        final Database db = createMock( Database.class );
        expect( db.prepare((String)anyObject()) ).andReturn( st ).times( 1 );
        replay( db );
       
        final Latester b = new Latester();
        b.setProperties( p );
        b.setDatabase( db );
View Full Code Here
TOP

Related Classes of com.pugh.sockso.db.Database

  • com.pugh.sockso.DBPropertiesTest
  • com.pugh.sockso.gui.action.ImportPlaylistTest
  • com.pugh.sockso.music.DBCollectionManagerTest
  • com.pugh.sockso.music.TrackTest
  • com.pugh.sockso.tests.TestResponse
  • com.pugh.sockso.web.action.AbstractCoverSearchTest
  • com.pugh.sockso.web.action.api.PlaylistAction
  • com.pugh.sockso.web.action.browse.Albumer
  • com.pugh.sockso.web.action.browse.AlbumerTest
  • com.pugh.sockso.web.action.browse.Artister
    • 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.