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