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); }