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