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 FindByIdTest()
{
var raceDataId = (await RaceDataDao.FindAllAsync()).First().Id;
var raceData = await RaceDataDao.FindByIdAsync(raceDataId);
Assert.NotNull(raceData);
Assert.NotNull(raceData?.EventType);
}
public async Task UpdateTest()
{
var raceData = (await RaceDataDao.FindAllAsync()).First();
raceData.EventTypeId = (int)Domain.Enums.RaceDataEvent.RaceCanceled;
await RaceDataDao.UpdateAsync(raceData);
Assert.AreEqual((int)Domain.Enums.RaceDataEvent.RaceCanceled, (await RaceDataDao.FindByIdAsync(raceData.Id))?.EventTypeId);
}
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 DeleteTest()
{
var raceDataId = await RaceDataDao.InsertGetIdAsync(new RaceData
{
RaceId = (await RaceDao.FindAllAsync()).First().Id,
EventDateTime = DateTime.Now,
EventTypeId = (await EventTypeDao.FindAllAsync()).First().Id
});
await RaceDataDao.DeleteAsync(raceDataId.Value);
Assert.IsNull(await RaceDataDao.FindByIdAsync(raceDataId.Value));
}
public async Task InsertTest()
{
var raceId = (await RaceDao.FindAllAsync()).First().Id;
var raceDataId = await RaceDataDao.InsertGetIdAsync(new RaceData
{
RaceId = raceId,
EventDateTime = new DateTime(1969, 4, 20),
EventTypeId = (int)Domain.Enums.RaceDataEvent.RaceFinished
});
var raceDataById = await RaceDataDao.FindByIdAsync(raceDataId.Value);
Assert.AreEqual(raceId, raceDataById.RaceId);
Assert.AreEqual(new DateTime(1969, 4, 20), raceDataById.EventDateTime);
Assert.AreEqual((int)Domain.Enums.RaceDataEvent.RaceFinished, raceDataById.EventTypeId);
}
public void DeleteAllTest() => Assert.ThrowsAsync <SqlException>(async() => await RaceDataDao.DeleteAllAsync());
public async Task FindAllTest() => Assert.AreEqual(34, (await RaceDataDao.FindAllAsync()).Count());
