public async Task Read_total_comments_supports_filter_by_match()
{
var commentsDataSource = new SqlServerMatchCommentsDataSource(_databaseFixture.ConnectionFactory);
foreach (var match in _databaseFixture.Matches)
{
var result = await commentsDataSource.ReadTotalComments(match.MatchId.Value).ConfigureAwait(false);
Assert.Equal(match.Comments.Count, result);
}
}
public async Task Read_comments_returns_newest_first()
{
var commentsDataSource = new SqlServerMatchCommentsDataSource(_databaseFixture.ConnectionFactory);
foreach (var match in _databaseFixture.Matches)
{
var results = await commentsDataSource.ReadComments(match.MatchId.Value).ConfigureAwait(false);
var previousCommentDate = DateTimeOffset.MaxValue;
foreach (var result in results)
{
Assert.True(result.CommentDate <= previousCommentDate);
previousCommentDate = result.CommentDate;
}
}
}
public async Task Read_comments_returns_basic_fields()
{
var commentsDataSource = new SqlServerMatchCommentsDataSource(_databaseFixture.ConnectionFactory);
foreach (var match in _databaseFixture.Matches)
{
var results = await commentsDataSource.ReadComments(match.MatchId.Value).ConfigureAwait(false);
Assert.Equal(match.Comments.Count, results.Count);
foreach (var comment in match.Comments)
{
var result = results.SingleOrDefault(x => x.CommentId == comment.CommentId);
Assert.NotNull(result);
Assert.Equal(comment.MemberName, result.MemberName);
Assert.Equal(comment.CommentDate, result.CommentDate);
Assert.Equal(comment.Comment, result.Comment);
}
}
}