package com.pugh.sockso.web.action.browse;
import com.pugh.sockso.db.Database;
import com.pugh.sockso.music.Album;
import com.pugh.sockso.music.Artist;
import com.pugh.sockso.music.Genre;
import com.pugh.sockso.music.Track;
import com.pugh.sockso.tests.SocksoTestCase;
import com.pugh.sockso.tests.TestDatabase;
import com.pugh.sockso.tests.TestResponse;
import com.pugh.sockso.tests.TestUtils;
import com.pugh.sockso.web.BadRequestException;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import static org.easymock.EasyMock.*;
public class AlbumerTest extends SocksoTestCase {
public void testGetAlbum() throws SQLException, BadRequestException {
// test finding an album
final ResultSet rs = createNiceMock( ResultSet.class );
expect( rs.next() ).andReturn( true );
replay( rs );
final PreparedStatement st = createMock( PreparedStatement.class );
st.setInt( 1, 123 );
expect( st.executeQuery() ).andReturn( rs ).times( 1 );
st.close();
replay( st );
final Database db = createMock( Database.class );
expect( db.prepare((String)anyObject()) ).andReturn( st ).times( 1 );
replay( db );
final Albumer b = new Albumer();
b.setDatabase( db );
final Album album = b.getAlbum( 123 );
assertNotNull( album );
verify( db );
verify( st );
verify( rs );
}
public void testGetAlbumNotFound() throws SQLException {
// test not finding album
final ResultSet rs = createNiceMock( ResultSet.class );
expect( rs.next() ).andReturn( false );
replay( rs );
final PreparedStatement st = createMock( PreparedStatement.class );
st.setInt( 1, 123 );
expect( st.executeQuery() ).andReturn( rs ).times( 1 );
st.close();
replay( st );
final Database db = createMock( Database.class );
expect( db.prepare((String)anyObject()) ).andReturn( st ).times( 1 );
replay( db );
final Albumer b = new Albumer();
b.setDatabase( db );
boolean gotException = false;
try {
b.getAlbum( 123 );
}
catch ( final BadRequestException e ) {
gotException = true;
}
assertTrue( gotException );
verify( db );
verify( st );
verify( rs );
}
public void testGetAlbumTracks() throws SQLException {
final ResultSet rs = createNiceMock( ResultSet.class );
expect( rs.next() ).andReturn( true );
expect( rs.next() ).andReturn( true );
expect( rs.next() ).andReturn( false );
replay( rs );
final PreparedStatement st = createMock( PreparedStatement.class );
st.setInt( 1, 123 );
expect( st.executeQuery() ).andReturn( rs ).times( 1 );
st.close();
replay( st );
final Database db = createMock( Database.class );
expect( db.prepare((String)anyObject()) ).andReturn( st ).times( 1 );
replay( db );
final Albumer b = new Albumer();
b.setDatabase( db );
final List<Track> tracks = b.getAlbumTracks( 123 );
assertNotNull( tracks );
assertEquals( 2, tracks.size() );
verify( db );
verify( st );
verify( rs );
}
public void testGetAlbumTracksQuery() throws Exception {
final Database db = new TestDatabase();
final Albumer b = new Albumer();
b.setDatabase( db );
b.getAlbumTracks( -1 );
}
public void testGetAlbumQuery() throws Exception {
final Database db = new TestDatabase();
final Albumer b = new Albumer();
b.setDatabase( db );
try {
b.getAlbum( -1 );
}
catch ( final BadRequestException e ) {
// this is ok, just means album not found
}
}
public void testShowAlbum() throws Exception {
final TestResponse res = new TestResponse();
final Albumer b = new Albumer();
final List<Track> tracks = new ArrayList<Track>();
final Artist artist = TestUtils.getArtist();
final Album album = TestUtils.getAlbum(artist);
final Genre genre = TestUtils.getGenre();
final Track track = TestUtils.getTrack(artist, album, genre);
tracks.add( track );
b.setResponse( res );
b.showAlbum( album, tracks );
final String data = res.getOutput();
assertTrue( data.contains(artist.getName()) );
assertTrue( data.contains(album.getName()) );
assertTrue( data.contains(track.getName()) );
}
}