Skip to content

Allow HE quals with no link to dfeta_hequalification table #2320

Allow HE quals with no link to dfeta_hequalification table

Allow HE quals with no link to dfeta_hequalification table #2320

GitHub Actions / DQT integration test results succeeded Mar 29, 2024 in 1s

76 passed, 0 failed and 0 skipped

Tests passed successfully

✅ TeachingRecordSystem/tests/TeachingRecordSystem.Core.Dqt.CrmIntegrationTests/TestResults/_fv-az1424-392_2024-03-29_12_30_55.trx

76 tests were completed in 93s with 76 passed, 0 failed and 0 skipped.

Test suite Passed Failed Skipped Time
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.ApproveIncidentTests 1✅ 24s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.CancelIncidentTests 1✅ 41s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.CloseSanctionTests 1✅ 22s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.CreateDateOfBirthChangeIncidentTests 1✅ 37s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.CreateNameChangeIncidentTests 1✅ 38s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.CreateSanctionTests 1✅ 34s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.CreateTeacherTests 5✅ 60s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.FindExistingTeacherQueryTests 1✅ 26s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetActiveIncidentsTests 1✅ 37s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllEarlyYearsStatusesTests 1✅ 1s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllHeQualificationsTests 1✅ 858ms
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllHeSubjectsTests 1✅ 2s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllMqEstablishmentsTests 1✅ 869ms
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllSanctionCodesTests 1✅ 902ms
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllSpecialismsTests 1✅ 879ms
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllSubjectsTests 1✅ 873ms
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllTeacherStatusesTests 1✅ 869ms
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetContactByTrnTests 2✅ 34s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetContactDetailByIdTests 3✅ 41s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetContactDetailByTrnTests 3✅ 44s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetContactsByDateOfBirthTests 6✅ 73s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetContactsByLastNameAndDateOfBirthTests 1✅ 46s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetContactsByNameTests 6✅ 6s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetDocumentByIdTests 2✅ 31s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetIncidentByTicketNumberTests 3✅ 43s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetNotesByContactIdTests 9✅ 73s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetQualificationsByContactIdTests 4✅ 52s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetSanctionDetailsByContactIdTests 2✅ 49s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetSanctionDetailsBySanctionIdTests 1✅ 20s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetSanctionsByContactIdsTests 1✅ 57s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetSystemUserByAzureActiveDirectoryObjectIdTests 2✅ 1s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.RejectIncidentTests 1✅ 24s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.UpdateContactDateOfBirthTests 1✅ 27s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.UpdateContactNameTests 1✅ 25s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.UpdateSanctionStateTests 2✅ 43s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.Services.DqtReporting.DqtReportingServiceTests 5✅ 3s

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.ApproveIncidentTests

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.CancelIncidentTests

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.CloseSanctionTests

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.CreateDateOfBirthChangeIncidentTests

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.CreateNameChangeIncidentTests

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.CreateSanctionTests

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.CreateTeacherTests

✅ QueryExecutesSuccessfully
✅ QueryWithDigits_ExecutesSuccessfully_CreatesTask(firstNameStr: "", middleNameStr: "", lastNameStr: "1", description: "Last name contains a digit")
✅ QueryWithDigits_ExecutesSuccessfully_CreatesTask(firstNameStr: "", middleNameStr: "1", lastNameStr: "", description: "Middle name contains a digit")
✅ QueryWithDigits_ExecutesSuccessfully_CreatesTask(firstNameStr: "1", middleNameStr: "", lastNameStr: "", description: "First name contains a digit")
✅ QueryWithMatchedDuplicateContactName_ExecutesSuccessfully_CreatesTask

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.FindExistingTeacherQueryTests

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetActiveIncidentsTests

✅ ReturnsActiveIncidentsOnly

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllEarlyYearsStatusesTests

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllHeQualificationsTests

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllHeSubjectsTests

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllMqEstablishmentsTests

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllSanctionCodesTests

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllSpecialismsTests

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllSubjectsTests

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllTeacherStatusesTests

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetContactByTrnTests

✅ WhenCalled_WithTrnForExistingContact_ReturnsContactDetail
✅ WhenCalled_WithTrnForNonExistentContact_ReturnsNull

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetContactDetailByIdTests

✅ WhenCalled_WithContactIdForExistingContact_ReturnsContactDetail
✅ WhenCalled_WithContactIdForExistingContactWithPreviousName_ReturnsContactDetailIncludingPreviousNames
✅ WhenCalled_WithContactIdForNonExistentContact_ReturnsNull

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetContactDetailByTrnTests

✅ WhenCalled_WithTrnForExistingContact_ReturnsContactDetail
✅ WhenCalled_WithTrnForExistingContactWithPreviousName_ReturnsContactDetailIncludingPreviousNames
✅ WhenCalled_WithTrnForNonExistentContact_ReturnsNull

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetContactsByDateOfBirthTests

✅ ReturnsMatchingContactsFromCrmInExpectedSortOrder(testScenarioData: ContactSearchSortScenarioData { IsAscending = False, Selector = Func`2 { Method = System.String <GetContactSearchSortScenarioData>b__5_1(TeachingRecordSystem.Core.Dqt.Models.Contact), Target = <>c { ··· } }, SortBy = LastNameDescending })
✅ ReturnsMatchingContactsFromCrmInExpectedSortOrder(testScenarioData: ContactSearchSortScenarioData { IsAscending = False, Selector = Func`2 { Method = System.String <GetContactSearchSortScenarioData>b__5_3(TeachingRecordSystem.Core.Dqt.Models.Contact), Target = <>c { ··· } }, SortBy = FirstNameDescending })
✅ ReturnsMatchingContactsFromCrmInExpectedSortOrder(testScenarioData: ContactSearchSortScenarioData { IsAscending = False, Selector = Func`2 { Method = System.String <GetContactSearchSortScenarioData>b__5_5(TeachingRecordSystem.Core.Dqt.Models.Contact), Target = <>c { ··· } }, SortBy = DateOfBirthDescending })
✅ ReturnsMatchingContactsFromCrmInExpectedSortOrder(testScenarioData: ContactSearchSortScenarioData { IsAscending = True, Selector = Func`2 { Method = System.String <GetContactSearchSortScenarioData>b__5_0(TeachingRecordSystem.Core.Dqt.Models.Contact), Target = <>c { ··· } }, SortBy = LastNameAscending })
✅ ReturnsMatchingContactsFromCrmInExpectedSortOrder(testScenarioData: ContactSearchSortScenarioData { IsAscending = True, Selector = Func`2 { Method = System.String <GetContactSearchSortScenarioData>b__5_2(TeachingRecordSystem.Core.Dqt.Models.Contact), Target = <>c { ··· } }, SortBy = FirstNameAscending })
✅ ReturnsMatchingContactsFromCrmInExpectedSortOrder(testScenarioData: ContactSearchSortScenarioData { IsAscending = True, Selector = Func`2 { Method = System.String <GetContactSearchSortScenarioData>b__5_4(TeachingRecordSystem.Core.Dqt.Models.Contact), Target = <>c { ··· } }, SortBy = DateOfBirthAscending })

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetContactsByLastNameAndDateOfBirthTests

✅ ReturnsMatchingContactsFromCrm

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetContactsByNameTests

✅ ReturnsMatchingContactsFromCrmInExpectedSortOrder(testScenarioData: ContactSearchSortScenarioData { IsAscending = False, Selector = Func`2 { Method = System.String <GetContactSearchSortScenarioData>b__5_1(TeachingRecordSystem.Core.Dqt.Models.Contact), Target = <>c { ··· } }, SortBy = LastNameDescending })
✅ ReturnsMatchingContactsFromCrmInExpectedSortOrder(testScenarioData: ContactSearchSortScenarioData { IsAscending = False, Selector = Func`2 { Method = System.String <GetContactSearchSortScenarioData>b__5_3(TeachingRecordSystem.Core.Dqt.Models.Contact), Target = <>c { ··· } }, SortBy = FirstNameDescending })
✅ ReturnsMatchingContactsFromCrmInExpectedSortOrder(testScenarioData: ContactSearchSortScenarioData { IsAscending = False, Selector = Func`2 { Method = System.String <GetContactSearchSortScenarioData>b__5_5(TeachingRecordSystem.Core.Dqt.Models.Contact), Target = <>c { ··· } }, SortBy = DateOfBirthDescending })
✅ ReturnsMatchingContactsFromCrmInExpectedSortOrder(testScenarioData: ContactSearchSortScenarioData { IsAscending = True, Selector = Func`2 { Method = System.String <GetContactSearchSortScenarioData>b__5_0(TeachingRecordSystem.Core.Dqt.Models.Contact), Target = <>c { ··· } }, SortBy = LastNameAscending })
✅ ReturnsMatchingContactsFromCrmInExpectedSortOrder(testScenarioData: ContactSearchSortScenarioData { IsAscending = True, Selector = Func`2 { Method = System.String <GetContactSearchSortScenarioData>b__5_2(TeachingRecordSystem.Core.Dqt.Models.Contact), Target = <>c { ··· } }, SortBy = FirstNameAscending })
✅ ReturnsMatchingContactsFromCrmInExpectedSortOrder(testScenarioData: ContactSearchSortScenarioData { IsAscending = True, Selector = Func`2 { Method = System.String <GetContactSearchSortScenarioData>b__5_4(TeachingRecordSystem.Core.Dqt.Models.Contact), Target = <>c { ··· } }, SortBy = DateOfBirthAscending })

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetDocumentByIdTests

✅ WhenCalled_WithDocumentIdForExistingDocument_ReturnsDocument
✅ WhenCalled_WithDocumentIdForNonExistentDocument_ReturnsNull

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetIncidentByTicketNumberTests

✅ WhenCalled_ForIncidentWithMultipleDocument_ReturnsSingleIncidentAndMultipleDocuments
✅ WhenCalled_ForIncidentWithSingleDocument_ReturnsSingleIncidentAndSingleDocument
✅ WhenCalled_WithTicketNumberForNonExistentIncident_ReturnsNull

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetNotesByContactIdTests

✅ WhenCalled_WithContactIdForContactWithNoNotes_ReturnsResultWithNotes(hasAnnotations: False, hasTasks: False, hasIncidentResolutions: False)
✅ WhenCalled_WithContactIdForContactWithNoNotes_ReturnsResultWithNotes(hasAnnotations: False, hasTasks: False, hasIncidentResolutions: True)
✅ WhenCalled_WithContactIdForContactWithNoNotes_ReturnsResultWithNotes(hasAnnotations: False, hasTasks: True, hasIncidentResolutions: False)
✅ WhenCalled_WithContactIdForContactWithNoNotes_ReturnsResultWithNotes(hasAnnotations: False, hasTasks: True, hasIncidentResolutions: True)
✅ WhenCalled_WithContactIdForContactWithNoNotes_ReturnsResultWithNotes(hasAnnotations: True, hasTasks: False, hasIncidentResolutions: False)
✅ WhenCalled_WithContactIdForContactWithNoNotes_ReturnsResultWithNotes(hasAnnotations: True, hasTasks: False, hasIncidentResolutions: True)
✅ WhenCalled_WithContactIdForContactWithNoNotes_ReturnsResultWithNotes(hasAnnotations: True, hasTasks: True, hasIncidentResolutions: False)
✅ WhenCalled_WithContactIdForContactWithNoNotes_ReturnsResultWithNotes(hasAnnotations: True, hasTasks: True, hasIncidentResolutions: True)
✅ WhenCalled_WithContactIdForNonExistentContact_ReturnsResultWithEmptyProperties

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetQualificationsByContactIdTests

✅ WhenCalled_ForContactWithoutQualifications_ReturnsEmptyArray
✅ WhenCalled_ForContactWithQualifications_ReturnsQualificationsAsExpected
✅ WhenCalledWithIncludeHigherEducationDetails_ForContactWithHeQualifications_ReturnsHeQualificationDetailsAsExpected(includeHeEducationDetails: False)
✅ WhenCalledWithIncludeHigherEducationDetails_ForContactWithHeQualifications_ReturnsHeQualificationDetailsAsExpected(includeHeEducationDetails: True)

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetSanctionDetailsByContactIdTests

✅ WhenCalled_ForContactWithoutSanctions_ReturnsEmptyArray
✅ WhenCalled_ForContactWithSanctions_ReturnsSanctionsAsExpected

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetSanctionDetailsBySanctionIdTests

✅ WhenCalled_ForSanction_ReturnsSanctionAsExpected

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetSanctionsByContactIdsTests

✅ ReturnsSanctionsForEachContactIdSpecified

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetSystemUserByAzureActiveDirectoryObjectIdTests

✅ WhenCalled_WithAzureActiveDirectoryObjectIdForExistingUser_ReturnsSystemUserInfo
✅ WhenCalled_WithAzureActiveDirectoryObjectIdForNonExistentUser_ReturnsNull

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.RejectIncidentTests

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.UpdateContactDateOfBirthTests

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.UpdateContactNameTests

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.UpdateSanctionStateTests

✅ QueryExecutesSuccessfully(setActive: False)
✅ QueryExecutesSuccessfully(setActive: True)

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.Services.DqtReporting.DqtReportingServiceTests

✅ ProcessChangesForEntityType_DeletesRemovedRecordFromDatabase
✅ ProcessChangesForEntityType_SameRecordMultipleTimesInBatch_WritesMostRecentUpdate(contactExistsPreSync: False)
✅ ProcessChangesForEntityType_SameRecordMultipleTimesInBatch_WritesMostRecentUpdate(contactExistsPreSync: True)
✅ ProcessChangesForEntityType_WritesNewRecordToDatabase
✅ ProcessChangesForEntityType_WritesUpdatedRecordToDatabase