protected void AssertTestFailLogged(string expectedColumnName, string expectedErrorMessage)
{
var qualityLogs = HmrcDataTestsRepository.GetQualityLogs().Result.ToList();
qualityLogs.Count().Should().Be(1, because: "a Quality Test Log record should have been created");
qualityLogs.First().ColumnName.Should().Be(expectedColumnName);
qualityLogs.First().ErrorMessage.Should().Be(expectedErrorMessage);
}
public void ThenValidationPassesAreNotLoggedIntoConfigurationDataQualityTests()
{
InsertPendingLoadControl();
HmrcDataTestsRepository.InsertIntoStaging(new DataStagingRecord {
SchemePAYERef = "12345"
}).Wait();
InsertQualityTestRecord(false);
HmrcDataTestsRepository.ExecuteLoadData().Wait();
HmrcDataTestsRepository.GetQualityLogs().Result.Count().Should().Be(0, because: "there should be no quality test failures");
AssertLoadCompleted();
}
public void ThenValidationPassesAreNotLoggedIntoConfigurationDataQualityTests_AndLiveTableIsInserted()
{
InsertPendingLoadControl();
HmrcDataTestsRepository.InsertIntoStaging(new DataStagingRecord {
EnglishFraction = "678.34567"
}).Wait();
InsertQualityTestRecord(stopLoadOnError: true);
HmrcDataTestsRepository.ExecuteLoadData().Wait();
HmrcDataTestsRepository.GetQualityLogs().Result.Count().Should().Be(0, because: "there should be no quality test failures");
AssertLoadCompleted();
}
public void ThenValidationPassesAreNotLoggedIntoConfigurationDataQualityTests_AndLoadTakesPlace()
{
InsertPendingLoadControl();
HmrcDataTestsRepository.InsertIntoStaging(new DataStagingRecord {
TaxPeriodMonth = "12"
}).Wait();
InsertQualityTestRecord(true);
HmrcDataTestsRepository.ExecuteLoadData().Wait();
HmrcDataTestsRepository.GetQualityLogs().Result.Count().Should().Be(0, because: "there should be no quality test failures");
AssertLoadCompleted();
}
public void AndValidationHasFlagToStopLoad_ThenValidationPassesAreNotLoggedIntoConfigurationDataQualityTestsAndLoadTakesPlace()
{
InsertPendingLoadControl();
HmrcDataTestsRepository.InsertIntoStaging(new DataStagingRecord {
TaxPeriodMonth = "2"
}).Wait();
HmrcDataTestsRepository.InsertIntoDataQualityTests(new DataQualityTestRecord
{
ColumnName = "TaxPeriodMonth",
ColumnNullable = true,
ColumnType = "INT",
RunColumnTests = true,
StopLoadIfTestIsNumeric = true
}).Wait();
HmrcDataTestsRepository.ExecuteLoadData().Wait();
HmrcDataTestsRepository.GetQualityLogs().Result.Count().Should().Be(0, because: "there should be no quality test failures");
AssertLoadCompleted();
}
