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