public void InsertPerformanceTest() { if (database == null) { database = new Database(TestUtils.ConnString); } Assert.NotNull(database); var performanceDao = new PerformanceDao(database); InsertDummyData(performanceDao); Assert.Equal(items.Count, performanceDao.Count()); }
public void FindAllPerformancesTest() { if (database == null) { database = new Database(TestUtils.ConnString); } Assert.NotNull(database); var performanceDao = new PerformanceDao(database); InsertDummyData(performanceDao); Assert.Equal(items.Count, performanceDao.Count()); IList<Performance> dbPerformance = performanceDao.FindAll(); Assert.NotNull(dbPerformance); Assert.Equal(items.Count, dbPerformance.Count); foreach (var performance in dbPerformance) { Assert.True(items.Contains(performance)); } }
public void DeletePerformanceTest() { if (database == null) { database = new Database(TestUtils.ConnString); } Assert.NotNull(database); var performanceDao = new PerformanceDao(database); InsertDummyData(performanceDao); Assert.Equal(items.Count, performanceDao.Count()); foreach (var item in items) { performanceDao.Delete(item.Id); } Assert.Equal(0, performanceDao.Count()); }
public void UpdatePerformanceTest() { 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 currPerformance = items[0]; currPerformance.Start = ALTER_START; performanceDao.Update(currPerformance); var myNewPerformance = performanceDao.FindById(currPerformance.Id); Assert.NotNull(myNewPerformance); Assert.Equal(ALTER_START, myNewPerformance.Start); }
public void FindPerformanceByIdTest() { 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 currPerformance = items[0]; var myPerformance = performanceDao.FindById(currPerformance.Id); Assert.NotNull(myPerformance); Assert.Equal(currPerformance, myPerformance); performanceDao.Delete(myPerformance.Id); Assert.Equal(items.Count - 1, performanceDao.Count()); }
public void FindPerformancesByDayTest() { if (database == null) { database = new Database(TestUtils.ConnString); } Assert.NotNull(database); var performanceDao = new PerformanceDao(database); InsertDummyData(performanceDao); Assert.Equal(items.Count, performanceDao.Count()); IList<Performance> dbPerformance = performanceDao.FindBetween(PERFORMANCE1_START, PERFORMANCE4_START); Assert.NotNull(dbPerformance); Assert.Equal(2, dbPerformance.Count); }
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)); } }