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 skierEvent = (await SkierEventDao.FindAllAsync()).First(); var skierEventById = await SkierEventDao.FindByIdAsync(skierEvent.Id); Assert.AreEqual(skierEvent.RaceData?.EventTypeId, skierEventById?.RaceData?.EventTypeId); Assert.NotNull(skierEventById?.StartList); }
public async Task UpdateTest() { var skierEvent = (await SkierEventDao.FindAllAsync()).First(); var skierId = (await SkierDao.FindAllAsync()).First().Id; skierEvent.SkierId = skierId; await SkierEventDao.UpdateAsync(skierEvent); Assert.AreEqual(skierEvent.SkierId, (await SkierEventDao.FindByIdAsync(skierEvent.Id))?.SkierId); }
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 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 Test() => Assert.AreEqual(30, (await SkierEventDao.FindAllAsync()).Count());