/// <summary> /// For SampleTest2 /// </summary> /// <returns></returns> private Team55LibraryContext MakeMediumLibrary() { /*MOCK DATABASE SETUP*/ var optionsBuilder = new DbContextOptionsBuilder <Team55LibraryContext>(); Team55LibraryContext db = new Team55LibraryContext(optionsBuilder.UseInMemoryDatabase("medium_library").Options); /*END MOCK DATABASE SETUP*/ /*Add in data*/ Titles profilesInCourage = new Titles { Isbn = "978-0062278791", Title = "Profiles in Courage", Author = "Kennedy" }; Titles theLorax = new Titles { Isbn = "978-0394823379", Title = "The Lorax", Author = "Seuss" }; Titles dune = new Titles { Isbn = "978-0441172719", Title = "Dune", Author = "Herbert" }; Patrons dan = new Patrons { Name = "Dan", CardNum = 4 }; Inventory inv = new Inventory { Serial = 1001, Isbn = "978-0441172719" }; Inventory inv2 = new Inventory { Serial = 1002, Isbn = "978-0441172719" }; Inventory invPIC = new Inventory { Serial = 1006, Isbn = profilesInCourage.Isbn }; db.Titles.Add(dune); db.Patrons.Add(dan); db.Inventory.Add(inv); db.Inventory.Add(inv2); db.Inventory.Add(invPIC); db.SaveChanges(); return(db); }
/// <summary> /// For SampleTest1 /// </summary> /// <returns></returns> private Team55LibraryContext MakeTinyLibrary() { /*MOCK DATABASE SETUP*/ var optionsBuilder = new DbContextOptionsBuilder <Team55LibraryContext>(); Team55LibraryContext db = new Team55LibraryContext(optionsBuilder.UseInMemoryDatabase("tiny_library").Options); /*END MOCK DATABASE SETUP*/ /*Add in data*/ Titles t = new Titles(); t.Author = "Tony Diep"; t.Title = "Tony's Life"; t.Isbn = "978-1111111111"; db.Titles.Add(t); db.SaveChanges(); return(db); }
public void CanCheckoutBookSuccessfully() { HomeController c = new HomeController(); Team55LibraryContext db = MakeMediumLibrary(); c.UseTeam55LibraryContext(db); c.CheckLogin("Dan", 4); c.CheckOutBook(1001); //Verify if the CheckedOut table has one new row var query = from co in db.CheckedOut select co; Assert.Equal(1, query.Count()); Assert.Equal((uint)4, query.ToArray()[0].CardNum); }
/// <summary> /// For mock database configuration /// </summary> /// <param name="ctx"></param> public void UseTeam55LibraryContext(Team55LibraryContext ctx) { db = ctx; }
/// <summary> /// Constructor /// </summary> public HomeController() { db = new Team55LibraryContext(); }