private void InsertQualityTestRecord(bool stopLoadOnError)
{
HmrcDataTestsRepository.InsertIntoDataQualityTests(new DataQualityTestRecord
{
ColumnName = "SchemePAYERef",
ColumnNullable = true,
ColumnPatternMatching = "[0-9][0-9][0-9]/[A-Z]%",
RunColumnTests = true,
StopLoadIfTestPatternMatch = stopLoadOnError
}).Wait();
}
private void InsertQualityTestRecord(bool stopLoadOnError)
{
HmrcDataTestsRepository.InsertIntoDataQualityTests(new DataQualityTestRecord
{
ColumnName = "SchemePAYERef",
ColumnNullable = true,
ColumnType = "NVARCHAR",
ColumnLength = 5,
RunColumnTests = true,
StopLoadIfTestTextLength = stopLoadOnError
}).Wait();
}
private void InsertQualityTestRecord(bool stopLoadOnError)
{
HmrcDataTestsRepository.InsertIntoDataQualityTests(new DataQualityTestRecord
{
ColumnName = "EnglishFraction",
ColumnNullable = true,
ColumnType = "DECIMAL",
ColumnLength = 18,
ColumnPrecision = 5,
RunColumnTests = true,
StopLoadIfTestDecimalPlaces = stopLoadOnError
}).Wait();
}
private void InsertQualityTestRecord(bool stopLoadOnError)
{
HmrcDataTestsRepository.InsertIntoDataQualityTests(new DataQualityTestRecord
{
ColumnName = "TaxPeriodMonth",
ColumnNullable = true,
ColumnType = "INT",
ColumnMinValue = "1",
ColumnMaxValue = "12",
RunColumnTests = true,
StopLoadIfTestValueRange = stopLoadOnError
}).Wait();
}
public void AndValidationHasFlagToStopLoad_ThenValidationFailuresAreLoggedIntoConfigurationDataQualityTestsAndLoadDoesntTakePlace()
{
InsertPendingLoadControl();
HmrcDataTestsRepository.InsertIntoStaging(new DataStagingRecord {
TaxPeriodMonth = "n"
}).Wait();
HmrcDataTestsRepository.InsertIntoDataQualityTests(new DataQualityTestRecord
{
ColumnName = "TaxPeriodMonth",
ColumnNullable = true,
ColumnType = "INT",
RunColumnTests = true,
StopLoadIfTestIsNumeric = true
}).Wait();
HmrcDataTestsRepository.ExecuteLoadData().Wait();
AssertTestFailLogged("TaxPeriodMonth", "Numeric type field not Numeric. Actual: n");
AssertLoadHalted();
}
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();
}
