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