public void CheckColumnValidationError()
{
var expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("SourceFileId", 1, false),
ExpectedColumn.CreateInt("ValidationError_Id", 2, false),
ExpectedColumn.CreateUniqueIdentifier("RowId", 3, true),
ExpectedColumn.CreateVarChar("RuleId", 4, true, 50),
ExpectedColumn.CreateVarChar("ConRefNumber", 5, true),
ExpectedColumn.CreateVarChar("DeliverableCode", 6, true),
ExpectedColumn.CreateVarChar("CalendarYear", 7, true),
ExpectedColumn.CreateVarChar("CalendarMonth", 8, true),
ExpectedColumn.CreateVarChar("CostType", 9, true),
ExpectedColumn.CreateVarChar("ReferenceType", 10, true),
ExpectedColumn.CreateVarChar("Reference", 11, true),
ExpectedColumn.CreateVarChar("StaffName", 12, true),
ExpectedColumn.CreateVarChar("ULN", 13, true),
ExpectedColumn.CreateVarChar("Severity", 14, true, 2),
ExpectedColumn.CreateVarChar("ErrorMessage", 15, true),
ExpectedColumn.CreateVarChar("ProviderSpecifiedReference", 16, true),
ExpectedColumn.CreateVarChar("Value", 17, true),
ExpectedColumn.CreateVarChar("HourlyRate", 18, true),
ExpectedColumn.CreateVarChar("TotalHoursWorked", 19, true),
ExpectedColumn.CreateVarChar("ProjectHours", 20, true),
ExpectedColumn.CreateVarChar("OrgHours", 21, true),
ExpectedColumn.CreateDateTime("CreatedOn", 22, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "ValidationError", expectedColumns, true);
}
public void CheckColumnLearningDeliveryHE()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("UKPRN", 1, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 2, false, 12),
ExpectedColumn.CreateInt("AimSeqNumber", 3, false),
ExpectedColumn.CreateVarChar("NUMHUS", 4, true, 20),
ExpectedColumn.CreateVarChar("SSN", 5, true, 13),
ExpectedColumn.CreateVarChar("QUALENT3", 6, true, 3),
ExpectedColumn.CreateInt("SOC2000", 7, true),
ExpectedColumn.CreateInt("SEC", 8, true),
ExpectedColumn.CreateVarChar("UCASAPPID", 9, true, 9),
ExpectedColumn.CreateInt("TYPEYR", 10, false),
ExpectedColumn.CreateInt("MODESTUD", 11, false),
ExpectedColumn.CreateInt("FUNDLEV", 12, false),
ExpectedColumn.CreateInt("FUNDCOMP", 13, false),
ExpectedColumn.CreateDecimal("STULOAD", 14, true, 4, 1),
ExpectedColumn.CreateInt("YEARSTU", 15, false),
ExpectedColumn.CreateInt("MSTUFEE", 16, false),
ExpectedColumn.CreateDecimal("PCOLAB", 17, true, 4, 1),
ExpectedColumn.CreateDecimal("PCFLDCS", 18, true, 4, 1),
ExpectedColumn.CreateDecimal("PCSLDCS", 19, true, 4, 1),
ExpectedColumn.CreateDecimal("PCTLDCS", 20, true, 4, 1),
ExpectedColumn.CreateInt("SPECFEE", 21, false),
ExpectedColumn.CreateInt("NETFEE", 22, true),
ExpectedColumn.CreateInt("GROSSFEE", 23, true),
ExpectedColumn.CreateVarChar("DOMICILE", 24, true, 2),
ExpectedColumn.CreateInt("ELQ", 25, true),
ExpectedColumn.CreateVarChar("HEPostCode", 26, true, 8)
};
_fixture.SchemaTests.AssertTableColumnsExist("Valid", "LearningDeliveryHE", expectedColumns, true);
}
public void CheckColumnSupplementaryDataModel()
{
var expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("SupplementaryDataId", 1, false),
ExpectedColumn.CreateVarChar("ConRefNumber", 2, false, 20),
ExpectedColumn.CreateVarChar("DeliverableCode", 3, false, 10),
ExpectedColumn.CreateInt("CalendarYear", 4, false),
ExpectedColumn.CreateInt("CalendarMonth", 5, false),
ExpectedColumn.CreateVarChar("CostType", 6, false, 20),
ExpectedColumn.CreateVarChar("StaffName", 7, true, 100),
ExpectedColumn.CreateVarChar("ReferenceType", 8, false, 20),
ExpectedColumn.CreateVarChar("Reference", 9, false, 100),
ExpectedColumn.CreateBigInt("ULN", 10, true),
ExpectedColumn.CreateVarChar("ProviderSpecifiedReference", 11, true, 200),
ExpectedColumn.CreateDecimal("Value", 12, true, 8, 2),
ExpectedColumn.CreateDecimal("HourlyRate", 13, true, 8, 2),
ExpectedColumn.CreateDecimal("TotalHoursWorked", 14, true, 8, 2),
ExpectedColumn.CreateDecimal("ProjectHours", 15, true, 8, 2),
ExpectedColumn.CreateDecimal("OrgHours", 16, true, 8, 2),
ExpectedColumn.CreateInt("SourceFileId", 17, false)
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "SupplementaryData", expectedColumns, true);
}
public static void Compare(SqlTableDefinition definition, ExpectedTable expectedTable)
{
Assert.Equal(expectedTable.Name, definition.TableName);
Assert.Equal(expectedTable.Columns.Count, definition.Columns.Count);
if (expectedTable.Columns.All(s => !s.IsRowId))
{
Assert.Null(definition.RowIdColumn);
}
for (int i = 0; i < expectedTable.Columns.Count; i++)
{
SqlTableColumn actual = definition.Columns.ElementAt(i);
ExpectedColumn expected = expectedTable.Columns[i];
Assert.Equal(expected.ClrType, actual.DetectedType);
Assert.Equal(expected.Name, actual.Name);
Assert.Equal(expected.SqlType, actual.TypeName);
Assert.Equal(expected.IsPrimaryKey, actual.IsPartOfPrimaryKey);
if (expected.IsRowId)
{
Assert.Same(actual, definition.RowIdColumn);
}
}
}
public void CheckColumnLearningProvider()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("UKPRN", 1, false)
};
_fixture.SchemaTests.AssertTableColumnsExist("Valid", "LearningProvider", expectedColumns, true);
}
public void CheckColumnsContractType()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("Id", 1, false),
ExpectedColumn.CreateNvarChar("Name", 2, false)
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "ContractType", expectedColumns, true);
}
public void CheckColumnsFundingLineContractTypeMapping()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("FundingLineId", 1, false),
ExpectedColumn.CreateInt("ContractTypeId", 2, false)
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "FundingLineContractTypeMapping", expectedColumns, true);
}
public void CheckColumnVersionInfo()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("Version", 1, false),
ExpectedColumn.CreateDate("Date", 2, false)
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "VersionInfo", expectedColumns, true);
}
public void CheckColumnLearnerDestinationandProgression()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("UKPRN", 1, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 2, false, 12),
ExpectedColumn.CreateBigInt("ULN", 3, false)
};
_fixture.SchemaTests.AssertTableColumnsExist("Valid", "LearnerDestinationandProgression", expectedColumns, true);
}
public void CheckValidationErrorMessage()
{
var expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("ValidationErrorMessageId", 1, false),
ExpectedColumn.CreateVarChar("RuleName", 2, true),
ExpectedColumn.CreateVarChar("ErrorMessage", 3, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "ValidationErrorMessage", expectedColumns, true);
}
public void CheckColumnCollectionDetails()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("UKPRN", 1, false),
ExpectedColumn.CreateVarChar("Collection", 2, false, 3),
ExpectedColumn.CreateVarChar("Year", 3, false, 4),
ExpectedColumn.CreateDate("FilePreparationDate", 4, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("Valid", "CollectionDetails", expectedColumns, true);
}
public void CheckColumnLearnerHE()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("UKPRN", 1, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 2, false, 12),
ExpectedColumn.CreateVarChar("UCASPERID", 3, true, 10),
ExpectedColumn.CreateInt("TTACCOM", 4, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("Valid", "LearnerHE", expectedColumns, true);
}
public void CheckColumnsValidationErrorRules()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateNvarChar("RuleId", 1, false),
ExpectedColumn.CreateNvarChar("Severity", 2, false),
ExpectedColumn.CreateNvarChar("Message", 3, false),
ExpectedColumn.CreateNvarChar("SeverityFIS", 4, false)
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "ValidationErrorRules", expectedColumns, true);
}
public void CheckColumnLLDDandHealthProblem()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("UKPRN", 1, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 2, false, 12),
ExpectedColumn.CreateInt("LLDDCat", 3, false),
ExpectedColumn.CreateInt("PrimaryLLDD", 4, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("Valid", "LLDDandHealthProblem", expectedColumns, true);
}
public void CheckColumnProviderSpecLearnerMonitoring()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("UKPRN", 1, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 2, false, 12),
ExpectedColumn.CreateVarChar("ProvSpecLearnMonOccur", 3, false, 1),
ExpectedColumn.CreateVarChar("ProvSpecLearnMon", 4, false, 20)
};
_fixture.SchemaTests.AssertTableColumnsExist("Valid", "ProviderSpecLearnerMonitoring", expectedColumns, true);
}
public void CheckColumnContactPreference()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("UKPRN", 1, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 2, false, 12),
ExpectedColumn.CreateVarChar("ContPrefType", 3, false, 3),
ExpectedColumn.CreateInt("ContPrefCode", 4, false)
};
_fixture.SchemaTests.AssertTableColumnsExist("Valid", "ContactPreference", expectedColumns, true);
}
public void CheckColumnLearnerHEFinancialSupport()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("UKPRN", 1, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 2, false, 12),
ExpectedColumn.CreateInt("FINTYPE", 3, false),
ExpectedColumn.CreateInt("FINAMOUNT", 4, false)
};
_fixture.SchemaTests.AssertTableColumnsExist("Valid", "LearnerHEFinancialSupport", expectedColumns, true);
}
public void CheckColumnsSourceFile()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("SourceFileId", 1, false),
ExpectedColumn.CreateNvarChar("FileName", 2, false),
ExpectedColumn.CreateDateTime("FilePreparationDate", 3, false),
ExpectedColumn.CreateNvarChar("UKPRN", 4, false),
ExpectedColumn.CreateDateTime("DateTime", 5, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "SourceFile", expectedColumns, true);
}
public void CheckColumnProcessingData()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateBigInt("Id", 1, false),
ExpectedColumn.CreateInt("UKPRN", 2, false),
ExpectedColumn.CreateBigInt("FileDetailsID", 3, false),
ExpectedColumn.CreateNvarChar("ProcessingStep", 4, false, 100),
ExpectedColumn.CreateNvarChar("ExecutionTime", 5, false, 20)
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "ProcessingData", expectedColumns, true);
}
public void CheckColumnsEASSubmissionValues()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateUniqueIdentifier("Submission_Id", 1, false),
ExpectedColumn.CreateInt("CollectionPeriod", 2, false),
ExpectedColumn.CreateInt("Payment_Id", 3, false),
ExpectedColumn.CreateDecimal("PaymentValue", 4, false, 10, 2),
ExpectedColumn.CreateInt("DevolvedAreaSoF", 5, false)
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "EAS_Submission_Values", expectedColumns, true);
}
public void CheckColumnEmploymentStatusMonitoring()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("UKPRN", 1, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 2, false, 12),
ExpectedColumn.CreateDate("DateEmpStatApp", 3, false),
ExpectedColumn.CreateVarChar("ESMType", 4, false, 3),
ExpectedColumn.CreateInt("ESMCode", 5, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("Valid", "EmploymentStatusMonitoring", expectedColumns, true);
}
public void CheckColumnLearnerEmploymentStatus()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("UKPRN", 1, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 2, false, 12),
ExpectedColumn.CreateInt("EmpStat", 3, false),
ExpectedColumn.CreateDate("DateEmpStatApp", 4, false),
ExpectedColumn.CreateInt("EmpId", 5, true),
ExpectedColumn.CreateVarChar("AgreeId", 6, true, 6)
};
_fixture.SchemaTests.AssertTableColumnsExist("Valid", "LearnerEmploymentStatus", expectedColumns, true);
}
public void CheckColumnLearnerFAM()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("LearnerFAM_Id", 1, false),
ExpectedColumn.CreateInt("Learner_Id", 2, true),
ExpectedColumn.CreateInt("UKPRN", 3, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 4, true, 100),
ExpectedColumn.CreateVarChar("LearnFAMType", 5, true, 1000),
ExpectedColumn.CreateBigInt("LearnFAMCode", 6, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("Invalid", "LearnerFAM", expectedColumns, true);
}
public void CheckColumnsPayment_Types()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("Payment_Id", 1, false),
ExpectedColumn.CreateNvarChar("PaymentName", 2, false),
ExpectedColumn.CreateBit("FM36", 3, false),
ExpectedColumn.CreateNvarChar("PaymentTypeDescription", 4, true),
ExpectedColumn.CreateInt("FundingLineId", 5, true),
ExpectedColumn.CreateInt("AdjustmentTypeId", 6, true),
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "Payment_Types", expectedColumns, true);
}
public void CheckColumnDPOutcome()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("UKPRN", 1, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 2, false, 12),
ExpectedColumn.CreateVarChar("OutType", 3, false, 3),
ExpectedColumn.CreateInt("OutCode", 4, false),
ExpectedColumn.CreateDate("OutStartDate", 5, false),
ExpectedColumn.CreateDate("OutEndDate", 6, true),
ExpectedColumn.CreateDate("OutCollDate", 7, false)
};
_fixture.SchemaTests.AssertTableColumnsExist("Valid", "DPOutcome", expectedColumns, true);
}
public void CheckColumnProviderSpecDeliveryMonitoring()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("ProviderSpecDeliveryMonitoring_Id", 1, false),
ExpectedColumn.CreateInt("UKPRN", 2, false),
ExpectedColumn.CreateInt("LearningDelivery_Id", 3, true),
ExpectedColumn.CreateVarChar("LearnRefNumber", 4, true, 100),
ExpectedColumn.CreateBigInt("AimSeqNumber", 5, true),
ExpectedColumn.CreateVarChar("ProvSpecDelMonOccur", 6, true, 100),
ExpectedColumn.CreateVarChar("ProvSpecDelMon", 7, true, 1000)
};
_fixture.SchemaTests.AssertTableColumnsExist("Invalid", "ProviderSpecDeliveryMonitoring", expectedColumns, true);
}
public void CheckColumnAppFinRecord()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("UKPRN", -1, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 2, false, 12),
ExpectedColumn.CreateInt("AimSeqNumber", 3, false),
ExpectedColumn.CreateVarChar("AFinType", 4, false),
ExpectedColumn.CreateInt("AFinCode", 5, false),
ExpectedColumn.CreateDate("AFinDate", 6, false),
ExpectedColumn.CreateInt("AFinAmount", 7, false)
};
_fixture.SchemaTests.AssertTableColumnsExist("Valid", "AppFinRecord", expectedColumns, true);
}
public void CheckColumnSourceFile()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("UKPRN", 1, false),
ExpectedColumn.CreateVarChar("SourceFileName", 2, false, 50),
ExpectedColumn.CreateDate("FilePreparationDate", 3, true),
ExpectedColumn.CreateVarChar("SoftwareSupplier", 4, true, 40),
ExpectedColumn.CreateVarChar("SoftwarePackage", 5, true, 30),
ExpectedColumn.CreateVarChar("Release", 6, true, 20),
ExpectedColumn.CreateVarChar("SerialNo", 7, true, 2),
ExpectedColumn.CreateDateTime("DateTime", 8, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("Valid", "SourceFile", expectedColumns, true);
}
public void CheckColumnLearningDeliveryFAM()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("LearningDeliveryFAM_Id", 1, false),
ExpectedColumn.CreateInt("UKPRN", 2, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 3, false, 12),
ExpectedColumn.CreateInt("AimSeqNumber", 4, false),
ExpectedColumn.CreateVarChar("LearnDelFAMType", 5, false, 3),
ExpectedColumn.CreateVarChar("LearnDelFAMCode", 6, false, 5),
ExpectedColumn.CreateDate("LearnDelFAMDateFrom", 7, true),
ExpectedColumn.CreateDate("LearnDelFAMDateTo", 8, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("Valid", "LearningDeliveryFAM", expectedColumns, true);
}
public void CheckColumnLearningDeliveryWorkPlacement()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateInt("UKPRN", 1, false),
ExpectedColumn.CreateVarChar("LearnRefNumber", 2, false, 12),
ExpectedColumn.CreateInt("AimSeqNumber", 3, false),
ExpectedColumn.CreateDate("WorkPlaceStartDate", 4, false),
ExpectedColumn.CreateDate("WorkPlaceEndDate", 5, true),
ExpectedColumn.CreateInt("WorkPlaceHours", 6, true),
ExpectedColumn.CreateInt("WorkPlaceMode", 7, false),
ExpectedColumn.CreateInt("WorkPlaceEmpId", 8, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("Valid", "LearningDeliveryWorkPlacement", expectedColumns, true);
}
