protected TestBase()
{
var config = new ConfigurationBuilder().AddJsonFile("appsettings.json").Build();
var section = config.GetSection("ConnectionStrings").GetSection("huraceTest");
var provider = section["ProviderName"];
var connectionString = section["ConnectionString"];
ConnectionFactory =
new ConcreteConnectionFactory(DbUtil.GetProviderFactory(provider), connectionString);
RaceDao = new RaceDao(ConnectionFactory, StatementFactory);
SeasonDao = new SeasonDao(ConnectionFactory, StatementFactory);
LocationDao = new LocationDao(ConnectionFactory, StatementFactory);
CountryDao = new CountryDao(ConnectionFactory, StatementFactory);
DisciplineDao = new DisciplineDao(ConnectionFactory, StatementFactory);
SkierDao = new SkierDao(ConnectionFactory, StatementFactory);
StartListDao = new StartListDao(ConnectionFactory, StatementFactory);
RaceEventDao = new RaceEventDao(ConnectionFactory, StatementFactory);
SkierEventDao = new SkierEventDao(ConnectionFactory, StatementFactory);
TimeDataDao = new TimeDataDao(ConnectionFactory, StatementFactory);
GenderDao = new GenderDao(ConnectionFactory, StatementFactory);
SensorDao = new SensorDao(ConnectionFactory, StatementFactory);
RaceDataDao = new RaceDataDao(ConnectionFactory, StatementFactory);
RaceStateDao = new RaceStateDao(ConnectionFactory, StatementFactory);
StartStateDao = new StartStateDao(ConnectionFactory, StatementFactory);
EventTypeDao = new EventTypeDao(ConnectionFactory, StatementFactory);
_dataGenerator = new DataGenerator.Core.DataGenerator(provider, connectionString);
}
public async Task DeleteTest()
{
var timeData = (await TimeDataDao.FindAllAsync()).First();
await TimeDataDao.DeleteAsync(timeData.SkierId, timeData.RaceId, timeData.SensorId);
Assert.IsNull(await TimeDataDao.FindByIdAsync(timeData.SkierId, timeData.RaceId, timeData.SensorId));
}
public async Task FindAllTest()
{
var timeData = (await TimeDataDao.FindAllAsync()).ToList();
Assert.AreEqual(10, timeData.Count());
Assert.AreEqual(DateTime.Today.Millisecond, timeData.First().Time);
}
public async Task GetTimeDataForStartListTest()
{
var startList = (await StartListDao.FindAllAsync()).First();
Assert.AreEqual(
2, (await TimeDataDao.GetTimeDataForStartList(startList.SkierId, startList.RaceId)).Count());
}
public async Task GetRankingForSensorTest()
{
var race = (await RaceDao.FindAllAsync()).First();
var ranking = (await TimeDataDao.GetRankingForSensor(race.Id, 1)).ToList();
Assert.AreEqual(5, ranking.Count());
Assert.IsTrue(ranking[0].Time < ranking[1].Time);
}
public async Task GetStartTimeForStartListTest()
{
var skierEvents = await SkierEventDao.FindAllAsync();
var startEvent = skierEvents.First(sk => sk.RaceData.EventTypeId == 8);
startEvent.RaceData.EventDateTime = DateTime.Today;
await RaceDataDao.UpdateAsync(startEvent.RaceData);
Assert.AreEqual(DateTime.Today,
(await TimeDataDao.GetStartTimeForStartList(startEvent.SkierId, startEvent.RaceId)).Value);
}
public async Task FindByIdTest()
{
var skier = (await SkierDao.FindAllAsync()).First();
var race = (await RaceDao.FindAllAsync()).First();
var sensor = (await SensorDao.FindAllAsync()).First();
var timeData = await TimeDataDao.FindByIdAsync(skier.Id, race.Id, sensor.Id);
Assert.NotNull(timeData);
Assert.NotNull(timeData.StartList);
Assert.NotNull(timeData?.SkierEvent);
Assert.NotNull(timeData?.SkierEvent?.RaceData);
Assert.NotNull(timeData?.Sensor);
Assert.AreEqual(DateTime.Today.Millisecond, timeData?.Time);
}
public async Task GetAverageTimeForSensorTest()
{
var race = (await RaceDao.FindAllAsync()).First();
var timeDatas = await TimeDataDao.FindAllAsync();
var tasks = timeDatas.Where(t => t.RaceId == race.Id && t.Sensor.SensorNumber == 1).Select(
async t =>
{
t.Time = 1500;
await TimeDataDao.UpdateAsync(t);
});
await Task.WhenAll(tasks);
Assert.AreEqual(1500, await TimeDataDao.GetAverageTimeForSensor(race.Id, 1));
}
public async Task UpdateTest()
{
var skier = (await SkierDao.FindAllAsync()).First();
var race = (await RaceDao.FindAllAsync()).First();
var sensor = (await SensorDao.FindAllAsync()).First();
var timeData = await TimeDataDao.FindByIdAsync(skier.Id, race.Id, sensor.Id);
if (timeData != null)
{
timeData.Time = 500;
await TimeDataDao.UpdateAsync(timeData);
timeData = await TimeDataDao.FindByIdAsync(skier.Id, race.Id, sensor.Id);
Assert.AreEqual(500, timeData?.Time);
}
else
{
Assert.Fail("TimeData was null");
}
}
public async Task InsertTest()
{
var skier = (await SkierDao.FindAllAsync()).First();
var race = (await RaceDao.FindAllAsync()).First();
var skierEventId = (await SkierEventDao.FindAllAsync()).First().Id;
var newSensorId =
await SensorDao.InsertGetIdAsync(new Sensor { RaceId = race.Id, SensorNumber = 0 });
await TimeDataDao.InsertAsync(new TimeData
{
SkierEventId = skierEventId,
RaceId = race.Id,
SensorId = newSensorId.Value,
Time = new DateTime(2019, 11, 6).Millisecond,
SkierId = skier.Id
});
var timeData = await TimeDataDao.FindByIdAsync(skier.Id, race.Id, newSensorId.Value);
Assert.NotNull(timeData);
Assert.AreEqual(new DateTime(2019, 11, 6).Millisecond, timeData?.Time);
}
public async Task DeleteAllTest()
{
await TimeDataDao.DeleteAllAsync();
Assert.AreEqual(0, (await TimeDataDao.FindAllAsync()).Count());
}
public async Task CountTimeDataForRaceTest()
{
var race = (await RaceDao.FindAllAsync()).First();
Assert.AreEqual(10, await TimeDataDao.CountTimeDataForRace(race.Id));
}
