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 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 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 CheckColumn()
{
ExpectedColumn[] expectedColumns =
{
ExpectedColumn.CreateBigInt("ID", 1, false),
ExpectedColumn.CreateBigInt("JobId", 2, false),
ExpectedColumn.CreateDateTime("DateTimeUtc", 3, false),
ExpectedColumn.CreateNvarChar("Filename", 4, true),
ExpectedColumn.CreateNvarChar("Source", 5, true),
ExpectedColumn.CreateNvarChar("UserId", 6, false),
ExpectedColumn.CreateInt("Event", 7, false),
ExpectedColumn.CreateNvarChar("ExtraInfo", 8, true),
ExpectedColumn.CreateNvarChar("UkPrn", 9, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "Audit", expectedColumns, true);
}
public void CheckColumnsEASSubmission()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateUniqueIdentifier("Submission_Id", 1, false),
ExpectedColumn.CreateNvarChar("UKPRN", 2, false),
ExpectedColumn.CreateInt("CollectionPeriod", 3, false),
ExpectedColumn.CreateNvarChar("ProviderName", 4, false),
ExpectedColumn.CreateDateTime("UpdatedOn", 5, false),
ExpectedColumn.CreateBit("DeclarationChecked", 6, false),
ExpectedColumn.CreateBit("NilReturn", 7, false),
ExpectedColumn.CreateNvarChar("UpdatedBy", 8, true),
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "EAS_Submission", expectedColumns, true);
}
public void CheckColumnSource()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateVarChar("ProtectiveMarking", 1, true, 30),
ExpectedColumn.CreateInt("UKPRN", 2, false),
ExpectedColumn.CreateVarChar("SoftwareSupplier", 3, true, 40),
ExpectedColumn.CreateVarChar("SoftwarePackage", 4, true, 30),
ExpectedColumn.CreateVarChar("Release", 5, true, 20),
ExpectedColumn.CreateVarChar("SerialNo", 6, true, 2),
ExpectedColumn.CreateDateTime("DateTime", 7, true),
ExpectedColumn.CreateVarChar("ReferenceData", 8, true, 100),
ExpectedColumn.CreateVarChar("ComponentSetVersion", 9, true, 20)
};
_fixture.SchemaTests.AssertTableColumnsExist("Valid", "Source", expectedColumns, true);
}
public void CheckColumnFileDetails()
{
List <ExpectedColumn> expectedColumns = new List <ExpectedColumn>
{
ExpectedColumn.CreateBigInt("ID", 1, false),
ExpectedColumn.CreateInt("UKPRN", 2, false),
ExpectedColumn.CreateNvarChar("Filename", 3, true, 50),
ExpectedColumn.CreateBigInt("FileSizeKb", 4, true),
ExpectedColumn.CreateInt("TotalLearnersSubmitted", 5, true),
ExpectedColumn.CreateInt("TotalValidLearnersSubmitted", 6, true),
ExpectedColumn.CreateInt("TotalInvalidLearnersSubmitted", 7, true),
ExpectedColumn.CreateInt("TotalErrorCount", 8, true),
ExpectedColumn.CreateInt("TotalWarningCount", 9, true),
ExpectedColumn.CreateDateTime("SubmittedTime", 10, true),
ExpectedColumn.CreateBit("Success", 11, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "FileDetails", expectedColumns, true);
}
public void CheckColumnsValidationError()
{
List <ExpectedColumn> 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),
ExpectedColumn.CreateVarChar("FundingLine", 5, true),
ExpectedColumn.CreateVarChar("AdjustmentType", 6, true),
ExpectedColumn.CreateVarChar("CalendarYear", 7, true),
ExpectedColumn.CreateVarChar("CalendarMonth", 8, true),
ExpectedColumn.CreateVarChar("Severity", 9, true),
ExpectedColumn.CreateVarChar("ErrorMessage", 10, true),
ExpectedColumn.CreateVarChar("Value", 11, true),
ExpectedColumn.CreateDateTime("CreatedOn", 12, true),
ExpectedColumn.CreateVarChar("DevolvedAreaSoF", 13, true)
};
_fixture.SchemaTests.AssertTableColumnsExist("dbo", "ValidationError", expectedColumns, true);
}
