public async Task ImportData() { Clock.UtcNow = new DateTime(2020, 8, 28, 0, 0, 0, DateTimeKind.Utc); // Arrange var importer = new LarsDataImporter( CosmosDbQueryDispatcher.Object, Services.GetRequiredService <IServiceScopeFactory>(), Clock, GetLogger()); // Act await importer.ImportData(); // Assert using (new AssertionScope()) { Fixture.DatabaseFixture.InMemoryDocumentStore.Frameworks.All.Count.Should().Be(0); // All expired on 31 July 2020 Fixture.DatabaseFixture.InMemoryDocumentStore.ProgTypes.All.Count.Should().Be(28); Fixture.DatabaseFixture.InMemoryDocumentStore.SectorSubjectAreaTier1s.All.Count.Should().Be(17); Fixture.DatabaseFixture.InMemoryDocumentStore.SectorSubjectAreaTier2s.All.Count.Should().Be(67); Fixture.DatabaseFixture.InMemoryDocumentStore.Standards.All.Count.Should().Be(589); Fixture.DatabaseFixture.InMemoryDocumentStore.StandardSectorCodes.All.Count.Should().Be(75); (await CountSqlRows("LARS.AwardOrgCode")).Should().Be(502); (await CountSqlRows("LARS.Category")).Should().Be(44); (await CountSqlRows("LARS.LearnAimRefType")).Should().Be(122); (await CountSqlRows("LARS.LearningDelivery")).Should().Be(117730); (await CountSqlRows("LARS.LearningDeliveryCategory")).Should().Be(82200); (await CountSqlRows("LARS.SectorSubjectAreaTier1")).Should().Be(17); (await CountSqlRows("LARS.SectorSubjectAreaTier2")).Should().Be(67); } }
public async Task ImportData() { // Arrange Clock.UtcNow = new DateTime(2020, 8, 28, 0, 0, 0, DateTimeKind.Utc); var client = CreateClient(); var importer = new LarsDataImporter( client, SqlQueryDispatcherFactory, CosmosDbQueryDispatcher.Object, Clock, GetLogger()); // Act await importer.ImportData(); // Assert using (new AssertionScope()) { Fixture.DatabaseFixture.InMemoryDocumentStore.Frameworks.All.Count.Should().Be(0); // All expired on 31 July 2020 Fixture.DatabaseFixture.InMemoryDocumentStore.ProgTypes.All.Count.Should().Be(28); Fixture.DatabaseFixture.InMemoryDocumentStore.SectorSubjectAreaTier1s.All.Count.Should().Be(17); Fixture.DatabaseFixture.InMemoryDocumentStore.SectorSubjectAreaTier2s.All.Count.Should().Be(67); Fixture.DatabaseFixture.InMemoryDocumentStore.Standards.All.Count.Should().Be(605); Fixture.DatabaseFixture.InMemoryDocumentStore.StandardSectorCodes.All.Count.Should().Be(75); (await CountSqlRows("LARS.AwardOrgCode")).Should().Be(506); (await CountSqlRows("LARS.Category")).Should().Be(44); (await CountSqlRows("LARS.LearnAimRefType")).Should().Be(122); (await CountSqlRows("LARS.LearningDelivery")).Should().Be(119593); (await CountSqlRows("LARS.LearningDeliveryCategory")).Should().Be(83914); (await CountSqlRows("LARS.SectorSubjectAreaTier1")).Should().Be(17); (await CountSqlRows("LARS.SectorSubjectAreaTier2")).Should().Be(67); (await CountSqlRows("Pttcd.Standards")).Should().Be(605); (await CountSqlRows("Pttcd.StandardSectorCodes")).Should().Be(75); } }
public Task Run(string input) => _dataImporter.ImportData();
public Task Run([TimerTrigger("0 0 4 * * *")] TimerInfo timer) => _dataImporter.ImportData();