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));
}
}
private void CreateTestData()
{
var loc = new Location(LOCATION_ID, LOCATION);
var locationDao = new LocationDao(database);
locationDao.Insert(loc);
var venue = new Venue(VENUE_ID, VENUE_LABEL, VENUE_SPECTATORS, loc, 0, 0);
var venueDao = new VenueDao(database);
venueDao.Insert(venue);
var category = new Category(CATEGORY_ID, CATEGORY_LABEL);
var categoryDao = new CategoryDao(database);
categoryDao.Insert(category);
var artist = new Artist(ARTIST_ID, ARTIST_NAME, ARTIST_COUNTRY, ARTIST_MAIL, "", "", "", "", category, false);
var artistDao = new ArtistDao(database);
artistDao.Insert(artist);
items = new List<Performance>();
items.Add(new Performance(1, PERFORMANCE1_START, artist, venue));
items.Add(new Performance(2, PERFORMANCE2_START, artist, venue));
items.Add(new Performance(3, PERFORMANCE3_START, artist, venue));
items.Add(new Performance(4, PERFORMANCE4_START, artist, venue));
}
public void FindPerformancesByArtistIdTest()
{
if (database == null)
{
database = new Database(TestUtils.ConnString);
}
Assert.NotNull(database);
var performanceDao = new PerformanceDao(database);
InsertDummyData(performanceDao);
Assert.Equal(items.Count, performanceDao.Count());
var artistDao = new ArtistDao(database);
var artists = artistDao.FindByName(ARTIST_NAME);
Assert.NotNull(artists);
Assert.NotEqual(0, artists.Count);
IList<Performance> dbPerformance = performanceDao.FindByArtistId(artists[0].Id);
Assert.NotNull(dbPerformance);
Assert.Equal(items.Count, dbPerformance.Count);
foreach (var performance in dbPerformance)
{
Assert.True(items.Contains(performance));
}
}
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);
}
