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