public void ShouldThrowDependencyExceptionOnRetrieveAllWhenSqlExceptionOccursAndLogIt()
{
// given
SqlException sqlException = GetSqlException();
var failedUserStorageException =
new FailedUserStorageException(sqlException);
var expectedUserDependencyException =
new UserDependencyException(failedUserStorageException);
this.userManagementBrokerMock.Setup(broker =>
broker.SelectAllUsers())
.Throws(sqlException);
// when . then
Assert.Throws <UserDependencyException>(() =>
this.userService.RetrieveAllUsers());
this.loggingBrokerMock.Verify(broker =>
broker.LogCritical(It.Is(SameExceptionAs(expectedUserDependencyException))),
Times.Once);
this.userManagementBrokerMock.Verify(broker =>
broker.SelectAllUsers(),
Times.Once);
this.dateTimeBrokerMock.Verify(broker =>
broker.GetCurrentDateTime(),
Times.Never);
this.dateTimeBrokerMock.VerifyNoOtherCalls();
this.loggingBrokerMock.VerifyNoOtherCalls();
this.userManagementBrokerMock.VerifyNoOtherCalls();
}
private async ValueTask <User> TryCatch(ReturningUserFunction returningUserFunction)
{
try
{
return(await returningUserFunction());
}
catch (NullUserException nullUserException)
{
throw CreateAndLogValidationException(nullUserException);
}
catch (InvalidUserException invalidUserException)
{
throw CreateAndLogValidationException(invalidUserException);
}
catch (NotFoundUserException nullUserException)
{
throw CreateAndLogValidationException(nullUserException);
}
catch (DuplicateKeyException duplicateKeyException)
{
var alreadyExistsUserException =
new AlreadyExistsUserException(duplicateKeyException);
throw CreateAndLogValidationException(alreadyExistsUserException);
}
catch (SqlException sqlException)
{
var failedUserStorageException =
new FailedUserStorageException(sqlException);
throw CreateAndLogCriticalDependencyException(failedUserStorageException);
}
catch (DbUpdateConcurrencyException dbUpdateConcurrencyException)
{
var lockedUserException =
new LockedUserException(dbUpdateConcurrencyException);
throw CreateAndLogDependencyException(lockedUserException);
}
catch (DbUpdateException dbUpdateException)
{
var failedUserStorageException =
new FailedUserStorageException(dbUpdateException);
throw CreateAndLogDependencyException(failedUserStorageException);
}
catch (Exception exception)
{
var failedUserServiceException =
new FailedUserServiceException(exception);
throw CreateAndLogServiceException(failedUserServiceException);
}
}
public async Task ShouldThrowDependencyExceptionOnModifyIfDbUpdateExceptionOccursAndLogItAsync()
{
// given
int randomNegativeNumber = GetNegativeRandomNumber();
DateTimeOffset randomDateTime = GetRandomDateTime();
User randomUser = CreateRandomUser(randomDateTime);
User someUser = randomUser;
someUser.CreatedDate = randomDateTime.AddMinutes(randomNegativeNumber);
var databaseUpdateException = new DbUpdateException();
var failedUserStorageException =
new FailedUserStorageException(databaseUpdateException);
var expectedUserDependencyException =
new UserDependencyException(failedUserStorageException);
this.userManagementBrokerMock.Setup(broker =>
broker.SelectUserByIdAsync(It.IsAny <Guid>()))
.ThrowsAsync(databaseUpdateException);
this.dateTimeBrokerMock.Setup(broker =>
broker.GetCurrentDateTime())
.Returns(randomDateTime);
// when
ValueTask <User> modifyUserTask =
this.userService.ModifyUserAsync(someUser);
// then
await Assert.ThrowsAsync <UserDependencyException>(() =>
modifyUserTask.AsTask());
this.dateTimeBrokerMock.Verify(broker =>
broker.GetCurrentDateTime(),
Times.Once);
this.userManagementBrokerMock.Verify(broker =>
broker.SelectUserByIdAsync(It.IsAny <Guid>()),
Times.Once);
this.loggingBrokerMock.Verify(broker =>
broker.LogError(It.Is(SameExceptionAs(
expectedUserDependencyException))),
Times.Once);
this.loggingBrokerMock.VerifyNoOtherCalls();
this.userManagementBrokerMock.VerifyNoOtherCalls();
this.dateTimeBrokerMock.VerifyNoOtherCalls();
}
public async Task ShouldThrowDependencyExceptionOnCreateWhenDbExceptionOccursAndLogItAsync()
{
// given
DateTimeOffset dateTime = GetRandomDateTime();
User randomUser = CreateRandomUser(dates: dateTime);
User inputUser = randomUser;
var databaseUpdateException = new DbUpdateException();
string password = GetRandomPassword();
var failedUserStorageException =
new FailedUserStorageException(databaseUpdateException);
var expectedUserDependencyException =
new UserDependencyException(failedUserStorageException);
this.dateTimeBrokerMock.Setup(broker =>
broker.GetCurrentDateTime())
.Returns(dateTime);
this.userManagementBrokerMock.Setup(broker =>
broker.InsertUserAsync(It.IsAny <User>(), It.IsAny <string>()))
.ThrowsAsync(databaseUpdateException);
// when
ValueTask <User> registerUserTask =
this.userService.RegisterUserAsync(inputUser, password);
// then
await Assert.ThrowsAsync <UserDependencyException>(() =>
registerUserTask.AsTask());
this.dateTimeBrokerMock.Verify(broker =>
broker.GetCurrentDateTime(),
Times.Once);
this.loggingBrokerMock.Verify(broker =>
broker.LogError(It.Is(SameExceptionAs(
expectedUserDependencyException))),
Times.Once);
this.userManagementBrokerMock.Verify(broker =>
broker.InsertUserAsync(It.IsAny <User>(), It.IsAny <string>()),
Times.Once);
this.dateTimeBrokerMock.VerifyNoOtherCalls();
this.loggingBrokerMock.VerifyNoOtherCalls();
this.userManagementBrokerMock.VerifyNoOtherCalls();
}
private IQueryable <User> TryCatch(ReturningQueryableUserFunction returningQueryableUserFunction)
{
try
{
return(returningQueryableUserFunction());
}
catch (SqlException sqlException)
{
var failedUserStorageException =
new FailedUserStorageException(sqlException);
throw CreateAndLogCriticalDependencyException(failedUserStorageException);
}
catch (Exception exception)
{
throw CreateAndLogServiceException(exception);
}
}
public async Task ShouldThrowDependencyExceptionOnDeleteWhenDbExceptionOccursAndLogItAsync()
{
// given
Guid randomUserId = Guid.NewGuid();
Guid inputUserId = randomUserId;
var databaseUpdateException = new DbUpdateException();
var failedUserStorageException =
new FailedUserStorageException(databaseUpdateException);
var expectedUserDependencyException =
new UserDependencyException(failedUserStorageException);
this.userManagementBrokerMock.Setup(broker =>
broker.SelectUserByIdAsync(It.IsAny <Guid>()))
.ThrowsAsync(databaseUpdateException);
// when
ValueTask <User> deleteUserTask =
this.userService.RemoveUserByIdAsync(inputUserId);
// then
await Assert.ThrowsAsync <UserDependencyException>(() =>
deleteUserTask.AsTask());
this.loggingBrokerMock.Verify(broker =>
broker.LogError(It.Is(SameExceptionAs(
expectedUserDependencyException))),
Times.Once);
this.userManagementBrokerMock.Verify(broker =>
broker.SelectUserByIdAsync(It.IsAny <Guid>()),
Times.Once);
this.dateTimeBrokerMock.VerifyNoOtherCalls();
this.loggingBrokerMock.VerifyNoOtherCalls();
this.userManagementBrokerMock.VerifyNoOtherCalls();
}
public async Task ShouldThrowDependencyExceptionOnRetrieveWhenSqlExceptionOccursAndLogItAsync()
{
// given
Guid randomUserId = Guid.NewGuid();
Guid inputUserId = randomUserId;
SqlException sqlException = GetSqlException();
var failedUserStorageException =
new FailedUserStorageException(sqlException);
var expectedUserDependencyException =
new UserDependencyException(failedUserStorageException);
this.userManagementBrokerMock.Setup(broker =>
broker.SelectUserByIdAsync(inputUserId))
.ThrowsAsync(sqlException);
// when
ValueTask <User> retrieveUserTask =
this.userService.RetrieveUserByIdAsync(inputUserId);
// then
await Assert.ThrowsAsync <UserDependencyException>(() =>
retrieveUserTask.AsTask());
this.loggingBrokerMock.Verify(broker =>
broker.LogCritical(It.Is(SameExceptionAs(expectedUserDependencyException))),
Times.Once);
this.userManagementBrokerMock.Verify(broker =>
broker.SelectUserByIdAsync(inputUserId),
Times.Once);
this.dateTimeBrokerMock.VerifyNoOtherCalls();
this.loggingBrokerMock.VerifyNoOtherCalls();
this.userManagementBrokerMock.VerifyNoOtherCalls();
}
