Package com.pugh.sockso.tests

Examples of com.pugh.sockso.tests.TestDatabase

212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
       
    }
   
    public void testCheckArtistTagInfo() throws IOException, SQLException {

        final TestDatabase db = new TestDatabase();
        final DBCollectionManager cm = new DBCollectionManager( db, p, indexer );
        final String artistName = "My Artist";
       
        int firstArtistId = 0, secondArtistId = 0;

        db.fixture( "checkArtistTagChange" );

        Tag newTag = createMock( Tag.class );
        expect( newTag.getArtist() ).andReturn( artistName ).times(2);
        replay( newTag );

        Statement st = db.getConnection().createStatement();
        ResultSet rs = st.executeQuery("select * from albums where id = 1" );
       
        while (rs.next())
            firstArtistId = rs.getInt( "artist_id" );

        Utils.close( rs );
        Utils.close( st );

        Track track = cm.getTrack( 3 );
        cm.checkArtistTagInfo( newTag, track );
        track = cm.getTrack( 3 );

        st = db.getConnection().createStatement();
        rs = st.executeQuery("select * from albums where id = 3" );
       
        while (rs.next())
            secondArtistId = rs.getInt( "artist_id" );

View Full Code Here
252
253
254
255
256
257
258
259
260
261
262
263
264
265
    }

    public void testGetTrack() throws Exception {

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

        db.fixture( "singleTrack" );

        final Track track = cm.getTrack( 1 );
       
        assertTrue( track.getPath().equals("/music/track.mp3") );
       
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
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
    }

    public void testSaveAndRemovePlaylist() throws Exception {

        final TestDatabase db = new TestDatabase();
        final DBCollectionManager cm = new DBCollectionManager( db, p, indexer );
        final String name = Utils.getRandomString( 20 );

        db.fixture( "singleTrack" );

        final Track[] tracks = new Track[] {
            cm.getTrack( 1 )
        };
View Full Code Here
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
    }

    public void testRemoveEmptyArtists() throws Exception {

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

        // Should delete Artists with no Track or Album references
        db.fixture( "artists" );

        assertTableSize( db, "artists", 3 );
        assertTableSize( db, "albums", 0 );
        assertTableSize( db, "tracks", 0 );
View Full Code Here
11
12
13
14
15
16
17
18
19
    private TestDatabase db;

    @Override
    public void setUp() throws Exception {
        db = new TestDatabase();
        auth = new DBAuthenticator( db );
        db.fixture( "singleUser" );
    }
View Full Code Here
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
       
    }
   
    public void testUsernameExists() throws Exception {

        TestDatabase db = new TestDatabase();

        Validater v = new Validater( db );
        final String email = "rod@pu-gh.com";

        assertFalse( v.emailExists(email) );

        db.fixture( "singleUser" );

        assertTrue( v.emailExists(email) );
       
    }
View Full Code Here
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
    }


    public void testDoesNotRemoveArtistsWithAlbums() throws Exception {

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

        // Should not delete an Artist that has Albums referencing it
        db.fixture( "artistsWithAlbums" );

        assertTableSize( db, "artists", 1 );
        assertTableSize( db, "albums", 1 );
        assertTableSize( db, "tracks", 0 );
View Full Code Here
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
       
    }
   
    public void testEmailExists() throws Exception {

        TestDatabase db = new TestDatabase();

        Validater v = new Validater( db );
        final String username = "foo";

        assertFalse( v.usernameExists(username) );

        db.fixture( "singleUser" );

        assertTrue( v.usernameExists(username) );
       
    }
View Full Code Here
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
        assertTableSize( db, "tracks", 0 );
    }

    public void testDoesNotRemoveArtistsWithTracks() throws Exception {

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

        // Should not delete an Artist that has Tracks referencing it
        db.fixture( "artistsWithTracks" );

        assertTableSize( db, "artists", 1 );
        assertTableSize( db, "albums", 0 );
        assertTableSize( db, "tracks", 1 );
View Full Code Here
TOP

Related Classes of com.pugh.sockso.tests.TestDatabase

  • com.pugh.sockso.auth.DBAuthenticatorTest
  • com.pugh.sockso.commands.ColScanTest
  • com.pugh.sockso.commands.CommandExecuterTest
  • com.pugh.sockso.commands.UserActiveTest
  • com.pugh.sockso.commands.UserAddTest
  • com.pugh.sockso.commands.UserAdminTest
  • com.pugh.sockso.commands.UserDelTest
  • com.pugh.sockso.commands.UserListTest
  • com.pugh.sockso.gui.action.ImportPlaylistTest
  • com.pugh.sockso.gui.action.RequestLogClearTest
    • 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.