public async Task Matched_PlayerIdentity_is_returned()
{
using (var connection = _databaseFixture.ConnectionFactory.CreateDatabaseConnection())
{
connection.Open();
using (var transaction = connection.BeginTransaction())
{
var dataForAnyPlayerIdentity = await connection.QuerySingleAsync <(Guid playerIdentityId, Guid playerId, string comparableName, Guid teamId)>(
$"SELECT TOP 1 PlayerIdentityId, PlayerId, ComparableName, TeamId FROM {Tables.PlayerIdentity}"
).ConfigureAwait(false);
var playerIdentity = new PlayerIdentity {
PlayerIdentityName = dataForAnyPlayerIdentity.comparableName, Team = new Team {
TeamId = dataForAnyPlayerIdentity.teamId
}
};
var repo = new SqlServerPlayerRepository(Mock.Of <IAuditRepository>(), Mock.Of <ILogger>(), Mock.Of <IRouteGenerator>(), Mock.Of <IStoolballEntityCopier>(), Mock.Of <IPlayerNameFormatter>());
var result = await repo.CreateOrMatchPlayerIdentity(playerIdentity, Guid.NewGuid(), "Member name", transaction).ConfigureAwait(false);
Assert.NotNull(result);
Assert.Equal(dataForAnyPlayerIdentity.playerIdentityId, result.PlayerIdentityId);
Assert.Equal(dataForAnyPlayerIdentity.playerId, result.Player.PlayerId);
Assert.Equal(dataForAnyPlayerIdentity.teamId, result.Team.TeamId);
Assert.Equal(dataForAnyPlayerIdentity.comparableName, result.ComparableName());
transaction.Rollback();
}
}
}
public async Task CreateOrMatchPlayerIdentity_throws_ArgumentException_if_TeamId_is_null()
{
var repo = new SqlServerPlayerRepository(Mock.Of <IAuditRepository>(), Mock.Of <ILogger>(), Mock.Of <IRouteGenerator>(), Mock.Of <IStoolballEntityCopier>(), Mock.Of <IPlayerNameFormatter>());
await Assert.ThrowsAsync <ArgumentException>(async() => await repo.CreateOrMatchPlayerIdentity(new PlayerIdentity {
PlayerIdentityName = "Player 1"
}, Guid.NewGuid(), "Member name", Mock.Of <IDbTransaction>()).ConfigureAwait(false)).ConfigureAwait(false);
}
public async Task Unmatched_PlayerIdentity_returns_new_player_and_identity()
{
using (var connection = _databaseFixture.ConnectionFactory.CreateDatabaseConnection())
{
connection.Open();
using (var transaction = connection.BeginTransaction())
{
var playerIdentity = new PlayerIdentity
{
PlayerIdentityName = $"New player {Guid.NewGuid()}",
Team = new Team {
TeamId = _databaseFixture.TestData.TeamWithFullDetails.TeamId
}
};
var playerRoute = $"/players/{playerIdentity.PlayerIdentityName.Kebaberize()}";
var copier = new Mock <IStoolballEntityCopier>();
copier.Setup(x => x.CreateAuditableCopy(playerIdentity)).Returns(playerIdentity);
var playerNameFormatter = new Mock <IPlayerNameFormatter>();
playerNameFormatter.Setup(x => x.CapitaliseName(playerIdentity.PlayerIdentityName)).Returns(playerIdentity.PlayerIdentityName);
var routeGenerator = new Mock <IRouteGenerator>();
routeGenerator.Setup(x => x.GenerateUniqueRoute("/players", playerIdentity.PlayerIdentityName, NoiseWords.PlayerRoute, It.IsAny <Func <string, Task <int> > >())).Returns(Task.FromResult(playerRoute));
var repo = new SqlServerPlayerRepository(Mock.Of <IAuditRepository>(), Mock.Of <ILogger>(), routeGenerator.Object, copier.Object, playerNameFormatter.Object);
var result = await repo.CreateOrMatchPlayerIdentity(playerIdentity, Guid.NewGuid(), "Member name", transaction).ConfigureAwait(false);
Assert.NotNull(result);
copier.Verify(x => x.CreateAuditableCopy(playerIdentity), Times.Once);
playerNameFormatter.Verify(x => x.CapitaliseName(playerIdentity.PlayerIdentityName));
routeGenerator.Verify(x => x.GenerateUniqueRoute("/players", playerIdentity.PlayerIdentityName, NoiseWords.PlayerRoute, It.IsAny <Func <string, Task <int> > >()));
var identityResult = await transaction.Connection.QuerySingleAsync <PlayerIdentityResult>(
$"SELECT PlayerId, PlayerIdentityName, ComparableName, TeamId FROM {Tables.PlayerIdentity} WHERE PlayerIdentityName = @PlayerIdentityName",
new { playerIdentity.PlayerIdentityName },
transaction).ConfigureAwait(false);
Assert.NotNull(identityResult);
Assert.Equal(playerIdentity.PlayerIdentityName, identityResult.PlayerIdentityName);
Assert.Equal(playerIdentity.ComparableName(), identityResult.ComparableName);
Assert.Equal(playerIdentity.Team.TeamId, identityResult.TeamId);
var playerResult = await transaction.Connection.QuerySingleAsync <Player>(
$"SELECT PlayerRoute FROM {Tables.Player} WHERE PlayerId = @PlayerId",
new { identityResult.PlayerId },
transaction).ConfigureAwait(false);
Assert.NotNull(playerResult);
Assert.Equal(playerRoute, playerResult.PlayerRoute);
transaction.Rollback();
}
}
}
public async Task CreateOrMatchPlayerIdentity_returns_playerIdentity_if_playerIdentityId_and_playerId_are_present()
{
var playerIdentity = new PlayerIdentity
{
Player = new Player
{
PlayerId = Guid.NewGuid()
},
PlayerIdentityId = Guid.NewGuid(),
PlayerIdentityName = "Player 1",
Team = new Team {
TeamId = Guid.NewGuid()
}
};
var repo = new SqlServerPlayerRepository(Mock.Of <IAuditRepository>(), Mock.Of <ILogger>(), Mock.Of <IRouteGenerator>(), Mock.Of <IStoolballEntityCopier>(), Mock.Of <IPlayerNameFormatter>());
var transaction = new Mock <IDbTransaction>();
var result = await repo.CreateOrMatchPlayerIdentity(playerIdentity, Guid.NewGuid(), null, transaction.Object).ConfigureAwait(false);
Assert.Equal(playerIdentity, result);
transaction.Verify(x => x.Connection, Times.Never);
}
public async Task CreateOrMatchPlayerIdentity_audits_and_logs()
{
var playerIdentity = new PlayerIdentity
{
PlayerIdentityName = $"New player {Guid.NewGuid()}",
Team = new Team {
TeamId = _databaseFixture.TestData.TeamWithFullDetails.TeamId
}
};
var copier = new Mock <IStoolballEntityCopier>();
copier.Setup(x => x.CreateAuditableCopy(playerIdentity)).Returns(playerIdentity);
var playerNameFormatter = new Mock <IPlayerNameFormatter>();
playerNameFormatter.Setup(x => x.CapitaliseName(playerIdentity.PlayerIdentityName)).Returns(playerIdentity.PlayerIdentityName);
var auditRepository = new Mock <IAuditRepository>();
var logger = new Mock <ILogger>();
var memberName = "Member name";
var memberKey = Guid.NewGuid();
var repo = new SqlServerPlayerRepository(auditRepository.Object, logger.Object, Mock.Of <IRouteGenerator>(), copier.Object, playerNameFormatter.Object);
using (var connection = _databaseFixture.ConnectionFactory.CreateDatabaseConnection())
{
connection.Open();
using (var transaction = connection.BeginTransaction())
{
var result = await repo.CreateOrMatchPlayerIdentity(playerIdentity, memberKey, memberName, transaction).ConfigureAwait(false);
transaction.Rollback();
}
}
auditRepository.Verify(x => x.CreateAudit(It.IsAny <AuditRecord>(), It.IsAny <IDbTransaction>()), Times.Once);
logger.Verify(x => x.Info(typeof(SqlServerPlayerRepository), LoggingTemplates.Created, It.IsAny <Player>(), memberName, memberKey, typeof(SqlServerPlayerRepository), nameof(SqlServerPlayerRepository.CreateOrMatchPlayerIdentity)));
}
