public void OrderBysWork() { Venue venue = new Venue(); venue.Update(); List<Event> events = new List<Event>(); for (int i = 0; i < 10; i++) { Event ev = new Event(); ev.VenueK = venue.K; ev.Update(); events.Add(ev); } Event[] childEvents = venue.ChildEvents().AllItems(); Event[] pagedChildEvents = venue.ChildEvents().Page(1, 10); for (int i = 0; i < events.Count; i++) { Assert.AreEqual(events[i].K, childEvents[i].K); } var orderBy = new Pair(Event.Columns.K, OrderBy.OrderDirection.Descending); childEvents = venue.ChildEvents(orderBy).AllItems(); pagedChildEvents = venue.ChildEvents(orderBy).Page(1, 10); for (int i = 0; i < events.Count; i++) { Assert.AreEqual(events[9 - i].K, childEvents[i].K); } }
public void AddingAChildUsingDatabaseAddsToChildren() { Venue venue = new Venue(); venue.Update(); Assert.AreEqual(0, venue.ChildEvents().Count); Event ev = new Event(); ev.VenueK = venue.K; ev.Update(); Assert.AreEqual(1, venue.ChildEvents().Count); }
public void RemovingAChildUsingDatabaseRemovesFromChildren() { Venue venue = new Venue(); venue.Update(); Venue venue2 = new Venue(); venue2.Update(); Event ev = new Event(); ev.VenueK = venue.K; ev.Update(); Assert.AreEqual(1, venue.ChildEvents().Count); ev.VenueK = venue2.K; ev.Update(); Assert.AreEqual(0, venue.ChildEvents().Count); }
public void PagingWorks() { Venue venue = new Venue(); venue.Update(); Random r = new Random(); int pageSize = r.Next(10) + 5; int numberOfItems = r.Next(50) + 50; if (numberOfItems % pageSize == 0) { numberOfItems++; } List<Event> events = new List<Event>(); for (int i = 0; i < numberOfItems; i++) { Event ev = new Event(); ev.VenueK = venue.K; ev.Update(); events.Add(ev); } Assert.AreEqual(numberOfItems, venue.ChildEvents().Count); Assert.AreEqual(pageSize, venue.ChildEvents().Page(1, pageSize).Length); int highestPageNumber = (int) Math.Ceiling((float) numberOfItems / (float)pageSize); Assert.AreEqual(numberOfItems % pageSize, venue.ChildEvents().Page(highestPageNumber, pageSize).Length); }
public void WheresWork() { Venue venue = new Venue(); venue.Update(); List<Event> events = new List<Event>(); for (int i = 0; i < 10; i++) { Event ev = new Event(); ev.VenueK = venue.K; ev.Update(); events.Add(ev); } Assert.AreEqual(0, venue.ChildEvents(new Q("1 = 0", null, null)).AllItems().Length); Assert.AreEqual(0, venue.ChildEvents(new Q("1 = 0", null, null)).Page(1, 10).Length); }