public void InsertVenueTest()
{
if (database == null)
{
database = new Database(TestUtils.ConnString);
}
Assert.NotNull(database);
var venueDao = new VenueDao(database);
InsertDummyData(venueDao);
Assert.Equal(items.Count, venueDao.Count());
}
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);
items = new List<Restriction>();
items.Add(new Restriction(1, RESTRICTION1_START, RESTRICTION1_STOP, venue, category));
items.Add(new Restriction(2, RESTRICTION2_START, RESTRICTION2_STOP, venue, category));
items.Add(new Restriction(3, RESTRICTION3_START, RESTRICTION3_STOP, venue, category));
items.Add(new Restriction(4, RESTRICTION4_START, RESTRICTION4_STOP, venue, category));
}
public void FindAllVenuesTest()
{
if (database == null)
{
database = new Database(TestUtils.ConnString);
}
Assert.NotNull(database);
var venueDao = new VenueDao(database);
InsertDummyData(venueDao);
Assert.Equal(items.Count, venueDao.Count());
IList<Venue> dbVenues = venueDao.FindAll();
Assert.NotNull(dbVenues);
Assert.Equal(items.Count, dbVenues.Count);
foreach (var venue in dbVenues)
{
Assert.True(items.Contains(venue));
}
}
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 FindVenueByIdTest()
{
if (database == null)
{
database = new Database(TestUtils.ConnString);
}
Assert.NotNull(database);
var venueDao = new VenueDao(database);
InsertDummyData(venueDao);
Assert.Equal(items.Count, venueDao.Count());
var currVenue = items[0];
var myVenue = venueDao.FindById(currVenue.Id, currVenue.Location.Id);
Assert.NotNull(myVenue);
Assert.Equal(currVenue, myVenue);
venueDao.Delete(myVenue.Id, myVenue.Location.Id);
Assert.Equal(items.Count - 1, venueDao.Count());
}
public void DeleteVenueTest()
{
if (database == null)
{
database = new Database(TestUtils.ConnString);
}
Assert.NotNull(database);
var venueDao = new VenueDao(database);
InsertDummyData(venueDao);
Assert.Equal(items.Count, venueDao.Count());
foreach (var item in items)
{
venueDao.Delete(item.Id, item.Location.Id);
}
Assert.Equal(0, venueDao.Count());
}
public void UpdateVenueTest()
{
if (database == null)
{
database = new Database(TestUtils.ConnString);
}
Assert.NotNull(database);
var venueDao = new VenueDao(database);
InsertDummyData(venueDao);
Assert.Equal(items.Count, venueDao.Count());
var currVenue = items[0];
currVenue.Label = ALTER_LABEL;
venueDao.Update(currVenue);
var myNewVenue = venueDao.FindById(currVenue.Id, currVenue.Location.Id);
Assert.NotNull(myNewVenue);
Assert.Equal(ALTER_LABEL, myNewVenue.Label);
}
public void FindVenueWhereSpecatorsTest()
{
if (database == null)
{
database = new Database(TestUtils.ConnString);
}
Assert.NotNull(database);
var venueDao = new VenueDao(database);
InsertDummyData(venueDao);
Assert.Equal(items.Count, venueDao.Count());
var currVenue = items[0];
var venues = venueDao.FindWhereSpectators(50);
Assert.NotNull(venues);
Assert.Equal(2, venues.Count);
}
public void FindVenueByLocationIdTest()
{
if (database == null)
{
database = new Database(TestUtils.ConnString);
}
Assert.NotNull(database);
var venueDao = new VenueDao(database);
InsertDummyData(venueDao);
Assert.Equal(items.Count, venueDao.Count());
var currVenue = items[0];
var venues = venueDao.FindByLocationId(LOCATION_ID);
Assert.NotNull(venues);
Assert.Equal(items.Count, venues.Count);
}
