public async Task Read_total_schools_supports_no_filter()
{
var schoolDataSource = new SqlServerSchoolDataSource(_databaseFixture.ConnectionFactory, Mock.Of <IRouteNormaliser>());
var result = await schoolDataSource.ReadTotalSchools(null).ConfigureAwait(false);
Assert.Equal(_databaseFixture.TestData.Schools.Count, result);
}
public async Task Read_total_schools_supports_case_insensitive_filter_by_partial_name()
{
var schoolDataSource = new SqlServerSchoolDataSource(_databaseFixture.ConnectionFactory, Mock.Of <IRouteNormaliser>());
var schoolName = PartialNameOfAnySchool();
var query = new SchoolFilter {
Query = schoolName.ToLower(CultureInfo.CurrentCulture)
};
var result = await schoolDataSource.ReadTotalSchools(query).ConfigureAwait(false);
Assert.Equal(SchoolsMatchingQuery(query.Query).Count, result);
}
public async Task Read_total_schools_supports_case_insensitive_filter_by_town()
{
var schoolDataSource = new SqlServerSchoolDataSource(_databaseFixture.ConnectionFactory, Mock.Of <IRouteNormaliser>());
var schoolWithTown = _databaseFixture.TestData.Schools.First(x => x.Teams.Any(t => t.MatchLocations.Any(ml => !string.IsNullOrEmpty(ml.Town))));
var locality = schoolWithTown.Teams.First(x => x.MatchLocations.Any(ml => !string.IsNullOrEmpty(ml.Town))).MatchLocations.First(ml => !string.IsNullOrEmpty(ml.Town)).Town;
var query = new SchoolFilter {
Query = locality.ToLower(CultureInfo.CurrentCulture)
};
var result = await schoolDataSource.ReadTotalSchools(query).ConfigureAwait(false);
Assert.Equal(SchoolsMatchingQuery(query.Query).Count, result);
}
