public void TestSoftDeleteServiceResetSoftDeleteViaKeysOk() { //SETUP int bookId; var options = SqliteInMemory.CreateOptions <SingleSoftDelDbContext>(); using (var context = new SingleSoftDelDbContext(options)) { context.Database.EnsureCreated(); bookId = context.AddBookWithReviewToDb().Id; var config = new ConfigSoftDeleteWithUserId(context); var service = new SingleSoftDeleteService <ISingleSoftDelete>(context, config); var status1 = service.SetSoftDeleteViaKeys <Book>(bookId); status1.IsValid.ShouldBeTrue(status1.GetAllErrors()); //ATTEMPT var status2 = service.ResetSoftDeleteViaKeys <Book>(bookId); //VERIFY status2.IsValid.ShouldBeTrue(status2.GetAllErrors()); status2.Result.ShouldEqual(1); } using (var context = new SingleSoftDelDbContext(options)) { context.Books.Count().ShouldEqual(1); context.Books.IgnoreQueryFilters().Count().ShouldEqual(1); } }
public void TestHardDeleteViaKeysWithUserIdOk() { //SETUP var currentUser = Guid.NewGuid(); int orderId; var options = SqliteInMemory.CreateOptions <SingleSoftDelDbContext>(); options.StopNextDispose(); using (var context = new SingleSoftDelDbContext(options, currentUser)) { context.Database.EnsureCreated(); var order1 = new Order { OrderRef = "Cur user Order, soft del", SoftDeleted = true, UserId = currentUser }; var order2 = new Order { OrderRef = "Cur user Order", SoftDeleted = false, UserId = currentUser }; var order3 = new Order { OrderRef = "Diff user Order", SoftDeleted = true, UserId = Guid.NewGuid() }; var order4 = new Order { OrderRef = "Diff user Order", SoftDeleted = false, UserId = Guid.NewGuid() }; context.AddRange(order1, order2, order3, order4); context.SaveChanges(); orderId = order1.Id; } using (var context = new SingleSoftDelDbContext(options, currentUser)) { var config = new ConfigSoftDeleteWithUserId(context); var service = new SingleSoftDeleteService <ISingleSoftDelete>(config); //ATTEMPT var status = service.ResetSoftDeleteViaKeys <Order>(orderId); //VERIFY status.IsValid.ShouldBeTrue(status.GetAllErrors()); status.Result.ShouldEqual(1); context.ChangeTracker.Clear(); context.Orders.IgnoreQueryFilters().Count().ShouldEqual(4); context.Orders.Count().ShouldEqual(2); } }
public void TestHardDeleteViaKeysWithWrongUserIdBad() { //SETUP var currentUser = Guid.NewGuid(); int bookId; var options = SqliteInMemory.CreateOptions <SingleSoftDelDbContext>(); using (var context = new SingleSoftDelDbContext(options)) { context.Database.EnsureCreated(); var order1 = new Order { OrderRef = "Cur user Order, soft del", SoftDeleted = true, UserId = currentUser }; var order2 = new Order { OrderRef = "Cur user Order", SoftDeleted = false, UserId = currentUser }; var order3 = new Order { OrderRef = "Diff user Order", SoftDeleted = true, UserId = Guid.NewGuid() }; var order4 = new Order { OrderRef = "Diff user Order", SoftDeleted = false, UserId = Guid.NewGuid() }; context.AddRange(order1, order2, order3, order4); context.SaveChanges(); bookId = order3.Id; } using (var context = new SingleSoftDelDbContext(options, currentUser)) { var config = new ConfigSoftDeleteWithUserId(context); var service = new SingleSoftDeleteService <ISingleSoftDelete>(context, config); //ATTEMPT var status = service.ResetSoftDeleteViaKeys <Order>(bookId); //VERIFY status.IsValid.ShouldBeFalse(); status.GetAllErrors().ShouldEqual("Could not find the entry you ask for."); context.Orders.IgnoreQueryFilters().Count().ShouldEqual(4); context.Orders.Count().ShouldEqual(1); } }