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());