public async Task Read_total_competitions_supports_no_filter()
        {
            var routeNormaliser       = new Mock <IRouteNormaliser>();
            var competitionDataSource = new SqlServerCompetitionDataSource(_databaseFixture.ConnectionFactory, routeNormaliser.Object);

            var result = await competitionDataSource.ReadTotalCompetitions(null).ConfigureAwait(false);

            Assert.Equal(_databaseFixture.Competitions.Count, result);
        }
        public async Task Read_total_competitions_supports_case_insensitive_filter_by_partial_player_type()
        {
            var routeNormaliser       = new Mock <IRouteNormaliser>();
            var competitionDataSource = new SqlServerCompetitionDataSource(_databaseFixture.ConnectionFactory, routeNormaliser.Object);
            var query = new CompetitionFilter {
                Query = "JuNioR"
            };

            var result = await competitionDataSource.ReadTotalCompetitions(query).ConfigureAwait(false);

            Assert.Equal(_databaseFixture.Competitions.Count(x => x.PlayerType.ToString().Contains(query.Query, StringComparison.OrdinalIgnoreCase)), result);
        }