public void InsertArtistTest()
{
if (database == null)
{
database = new Database(TestUtils.ConnString);
}
Assert.NotNull(database);
var artistDao = new ArtistDao(database);
InsertDummyData(artistDao);
Assert.Equal(items.Count, artistDao.Count());
}
public void FindAllArtistsTest()
{
if (database == null)
{
database = new Database(TestUtils.ConnString);
}
Assert.NotNull(database);
var artistDao = new ArtistDao(database);
InsertDummyData(artistDao);
Assert.Equal(items.Count, artistDao.Count());
IList<Artist> dbArtists = artistDao.FindAll();
Assert.NotNull(dbArtists);
Assert.Equal(items.Count, dbArtists.Count);
foreach (var artist in dbArtists)
{
Assert.True(items.Contains(artist));
}
}
public void FindArtistByIdTest()
{
if (database == null)
{
database = new Database(TestUtils.ConnString);
}
Assert.NotNull(database);
var artistDao = new ArtistDao(database);
InsertDummyData(artistDao);
Assert.Equal(items.Count, artistDao.Count());
var currArtist = items[0];
var myArtist = artistDao.FindById(currArtist.Id);
Assert.NotNull(myArtist);
Assert.Equal(currArtist, myArtist);
artistDao.Delete(myArtist.Id);
Assert.Equal(items.Count - 1, artistDao.Count());
}
public void DeleteArtistTest()
{
if (database == null)
{
database = new Database(TestUtils.ConnString);
}
Assert.NotNull(database);
var artistDao = new ArtistDao(database);
InsertDummyData(artistDao);
Assert.Equal(items.Count, artistDao.Count());
foreach (var item in items)
{
artistDao.Delete(item.Id);
}
Assert.Equal(0, artistDao.Count());
}
public void UpdateArtistTest()
{
if (database == null)
{
database = new Database(TestUtils.ConnString);
}
Assert.NotNull(database);
var artistDao = new ArtistDao(database);
InsertDummyData(artistDao);
Assert.Equal(items.Count, artistDao.Count());
var currArtist = items[0];
currArtist.Name = "AlteredName";
artistDao.Update(currArtist);
var myNewArtist = artistDao.FindById(currArtist.Id);
Assert.NotNull(myNewArtist);
Assert.Equal("AlteredName", myNewArtist.Name);
}
public void FindArtistByCategoryIdTest()
{
if (database == null)
{
database = new Database(TestUtils.ConnString);
}
Assert.NotNull(database);
var artistDao = new ArtistDao(database);
InsertDummyData(artistDao);
Assert.Equal(items.Count, artistDao.Count());
var artists = artistDao.FindByCategoryId(COMEDY_ID);
Assert.NotNull(artists);
Assert.Equal(items.Count, artists.Count);
}
public void FindArtistByCountryTest()
{
if (database == null)
{
database = new Database(TestUtils.ConnString);
}
Assert.NotNull(database);
var artistDao = new ArtistDao(database);
InsertDummyData(artistDao);
Assert.Equal(items.Count, artistDao.Count());
var artists = artistDao.FindByCountry(ARTIST2_COUNTRY);
Assert.NotNull(artists);
Assert.Equal(1, artists.Count);
}