public async Task TestSoftDeleteServiceSetSoftDeleteViaKeysOk()
{
//SETUP
var options = SqliteInMemory.CreateOptions <SingleSoftDelDbContext>();
using (var context = new SingleSoftDelDbContext(options))
{
context.Database.EnsureCreated();
var book = context.AddBookWithReviewToDb();
var config = new ConfigSoftDeleteWithUserId(context);
var service = new SingleSoftDeleteServiceAsync <ISingleSoftDelete>(config);
//ATTEMPT
var status = await service.SetSoftDeleteViaKeysAsync <Book>(book.Id);
//VERIFY
status.IsValid.ShouldBeTrue(status.GetAllErrors());
status.Result.ShouldEqual(1);
context.ChangeTracker.Clear();
context.Books.Count().ShouldEqual(0);
context.Books.IgnoreQueryFilters().Count().ShouldEqual(1);
}
}
public async Task TestSoftDeleteServiceSetSoftDddDeleteViaKeysOk()
{
//SETUP
var options = SqliteInMemory.CreateOptions <SingleSoftDelDbContext>();
using (var context = new SingleSoftDelDbContext(options))
{
context.Database.EnsureCreated();
var bookDdd = new BookDDD("Test");
context.Add(bookDdd);
context.SaveChanges();
var config = new ConfigSoftDeleteDDD(context);
var service = new SingleSoftDeleteServiceAsync <ISingleSoftDeletedDDD>(config);
//ATTEMPT
var status = await service.SetSoftDeleteViaKeysAsync <BookDDD>(bookDdd.Id);
//VERIFY
status.IsValid.ShouldBeTrue(status.GetAllErrors());
status.Result.ShouldEqual(1);
}
using (var context = new SingleSoftDelDbContext(options))
{
context.BookDdds.Count().ShouldEqual(0);
context.BookDdds.IgnoreQueryFilters().Count().ShouldEqual(1);
}
}
public async Task TestSoftDeleteAsyncOrderWithAddressOk()
{
//SETUP
var options = SqliteInMemory.CreateOptions <SingleSoftDelDbContext>();
using var context = new SingleSoftDelDbContext(options);
context.Database.EnsureCreated();
context.Add(new Order
{
OrderRef = "123",
UserAddress = new Address {
FullAddress = "xxx"
}
});
context.SaveChanges();
context.ChangeTracker.Clear();
var config = new ConfigSoftDeleteWithUserId(context);
var service = new SingleSoftDeleteServiceAsync <ISingleSoftDelete>(config);
//ATTEMPT
var status = await service.SetSoftDeleteViaKeysAsync <Order>(1);
//VERIFY
status.IsValid.ShouldBeTrue(status.GetAllErrors());
context.Orders.Count().ShouldEqual(0);
context.Addresses.Count().ShouldEqual(1);
}
public async Task <IActionResult> SoftDelete(int id, [FromServices] SingleSoftDeleteServiceAsync <ISoftDelete> service)
{
Request.ThrowErrorIfNotLocal();
var status = await service.SetSoftDeleteViaKeysAsync <Book>(id);
SetupTraceInfo();
return(View("BookUpdated", status.IsValid ? status.Message : status.GetAllErrors()));
}
public async Task TestSoftDeleteServiceSetSoftDeleteViaKeysNotFoundBad()
{
//SETUP
var options = SqliteInMemory.CreateOptions <SingleSoftDelDbContext>();
using (var context = new SingleSoftDelDbContext(options))
{
context.Database.EnsureCreated();
var config = new ConfigSoftDeleteWithUserId(context);
var service = new SingleSoftDeleteServiceAsync <ISingleSoftDelete>(config);
//ATTEMPT
var status = await service.SetSoftDeleteViaKeysAsync <Book>(123);
//VERIFY
status.IsValid.ShouldBeFalse();
status.GetAllErrors().ShouldEqual("Could not find the entry you ask for.");
status.Result.ShouldEqual(0);
}
}
public async Task TestSoftDeleteServiceSetSoftDeleteViaKeysNotFoundReturnsZero()
{
//SETUP
var options = SqliteInMemory.CreateOptions <SingleSoftDelDbContext>();
using (var context = new SingleSoftDelDbContext(options))
{
context.Database.EnsureCreated();
var config = new ConfigSoftDeleteWithUserId(context)
{
NotFoundIsNotAnError = true
};
var service = new SingleSoftDeleteServiceAsync <ISingleSoftDelete>(config);
//ATTEMPT
var status = await service.SetSoftDeleteViaKeysAsync <Book>(123);
//VERIFY
status.IsValid.ShouldBeTrue(status.GetAllErrors());
status.Result.ShouldEqual(0);
}
}
public async Task TestSoftDeleteServiceSetSoftDeleteViaKeysBadNumberOfKeys()
{
//SETUP
var options = SqliteInMemory.CreateOptions <SingleSoftDelDbContext>();
using (var context = new SingleSoftDelDbContext(options))
{
context.Database.EnsureCreated();
var book = context.AddBookWithReviewToDb();
var config = new ConfigSoftDeleteWithUserId(context);
var service = new SingleSoftDeleteServiceAsync <ISingleSoftDelete>(config);
//ATTEMPT
var ex = await Assert.ThrowsAsync <ArgumentException>(async() => await service.SetSoftDeleteViaKeysAsync <Book>(1, 2));
//VERIFY
ex.Message.ShouldEqual("Mismatch in keys: your provided 2 key(s) and the entity has 1 key(s) (Parameter 'keyValues')");
}
}
public async Task TestSoftDeleteServiceSetSoftDeleteViaKeysBadKeyType()
{
//SETUP
var options = SqliteInMemory.CreateOptions <SingleSoftDelDbContext>();
using (var context = new SingleSoftDelDbContext(options))
{
context.Database.EnsureCreated();
var book = context.AddBookWithReviewToDb();
var config = new ConfigSoftDeleteWithUserId(context);
var service = new SingleSoftDeleteServiceAsync <ISingleSoftDelete>(config);
//ATTEMPT
var ex = await Assert.ThrowsAsync <ArgumentException>(async() => await service.SetSoftDeleteViaKeysAsync <Book>(book));
//VERIFY
ex.Message.ShouldEqual("Mismatch in keys: your provided key 1 (of 1) is of type Book but entity key's type is System.Int32 (Parameter 'keyValues')");
}
}
public async Task TestSoftDeleteServiceSetSoftDeleteOneToOneBad()
{
//SETUP
var options = SqliteInMemory.CreateOptions <SingleSoftDelDbContext>();
using (var context = new SingleSoftDelDbContext(options))
{
context.Database.EnsureCreated();
context.AddBookWithReviewToDb();
var config = new ConfigSoftDeleteWithUserId(context);
var service = new SingleSoftDeleteServiceAsync <ISingleSoftDelete>(config);
//ATTEMPT
var ex = await Assert.ThrowsAsync <InvalidOperationException>(async() => await service.SetSoftDeleteViaKeysAsync <OneToOne>(1));
//VERIFY
ex.Message.ShouldEqual("You cannot soft delete a one-to-one relationship. It causes problems if you try to create a new version.");
}
}