Skip to content

Sync changes from TRS DB into DQT reporting database #231

Sync changes from TRS DB into DQT reporting database

Sync changes from TRS DB into DQT reporting database #231

GitHub Actions / DQT integration test results failed Aug 23, 2024 in 1s

135 passed, 1 failed and 0 skipped

Tests failed

❌ TeachingRecordSystem/tests/TeachingRecordSystem.Core.Dqt.CrmIntegrationTests/TestResults/_fv-az1773-217_2024-08-23_08_13_19.trx

136 tests were completed in 481s with 135 passed, 1 failed and 0 skipped.

Test suite Passed Failed Skipped Time
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.PluginTests.QTSRegistrationDeleteTests 4✅ 117s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.PluginTests.UpdateInductionStatusTests 21✅ 407s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.PluginTests.UpdateQtlsDateSetTests 2✅ 93s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.ApproveIncidentTests 1✅ 53s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.CancelIncidentTests 1✅ 14s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.CreateContactTests 5✅ 141s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.CreateDateOfBirthChangeIncidentTests 1✅ 34s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.CreateNameChangeIncidentTests 1✅ 10s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.CreateReviewTaskTests 1✅ 39s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.CreateTrnRequestTaskTests 1✅ 2s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.DeleteAnnotationTests 1✅ 32s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.FindPotentialDuplicateContactsTests 2✅ 88s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetActiveContactByTrnTests 2✅ 42s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetActiveContactDetailByIdTests 3✅ 87s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetActiveContactDetailByTrnTests 3✅ 84s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetActiveContactsByLastNameAndDateOfBirthTests 1✅ 85s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetActiveContactsByNameTests 6✅ 6s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetActiveIncidentsTests 1✅ 47s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllEarlyYearsStatusesTests 1✅ 1s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllHeQualificationsTests 1✅ 1s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllHeSubjectsTests 1✅ 5s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllMqEstablishmentsTests 1✅ 1s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllSanctionCodesTests 1✅ 1s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllSpecialismsTests 1✅ 1s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllSubjectsTests 1✅ 1s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetAllTeacherStatusesTests 1✅ 2s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetContactByTrnRequestIdTests 2✅ 43s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetContactsByDateOfBirthTests 6✅ 382s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetDocumentByIdTests 2✅ 48s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetIncidentByTicketNumberTests 3✅ 74s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetInductionByContactIdTests 24✅ 412s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetNotesByContactIdTests 9✅ 331s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetOpenTasksForEmailAddressTests 4✅ 107s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetQualificationsByContactIdTests 4✅ 127s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetSanctionsByContactIdsTests 1✅ 101s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetSystemUserByAzureActiveDirectoryObjectIdTests 2✅ 4s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.RejectIncidentTests 1✅ 30s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.SetQtlsDateTests 2✅ 65s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.UpdateContactDateOfBirthTests 1✅ 27s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.UpdateContactNameTests 1✅ 6s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.UpdateSanctionStateTests 2✅ 75s
TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.Services.DqtReporting.DqtReportingServiceTests 6✅ 1❌ 111s

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.PluginTests.QTSRegistrationDeleteTests

✅ WhenCreatingTeacherWithQtlsDate_QtsDateIsSet
✅ WhenCreatingTeacherWithQts_QtsDateIsSet
✅ WhenCreatingTeacherWithQtsAndQtls_QtlsDateIsChosen
✅ WhenCreatingTeacherWithQtsAndQtls_QtsDateIsChosen

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.PluginTests.UpdateInductionStatusTests

✅ WhenCalled_WithoutTRAInductionStatusAndQTLSDate_ReturnsExpectedResults
✅ WhenCalled_WithoutTRAInductionStatusStatusAndQTLSDate_ReturnsExpectedResults
✅ WhenCalled_WithoutTRAQTLSDate_ReturnsExpectedResults(inductionStatus: Exempt, exemptionReason: Exempt, expectedInductionStatus: Exempt)
✅ WhenCalled_WithoutTRAQTLSDate_ReturnsExpectedResults(inductionStatus: Fail, exemptionReason: null, expectedInductionStatus: Fail)
✅ WhenCalled_WithoutTRAQTLSDate_ReturnsExpectedResults(inductionStatus: FailedinWales, exemptionReason: null, expectedInductionStatus: FailedinWales)
✅ WhenCalled_WithoutTRAQTLSDate_ReturnsExpectedResults(inductionStatus: InductionExtended, exemptionReason: null, expectedInductionStatus: InductionExtended)
✅ WhenCalled_WithoutTRAQTLSDate_ReturnsExpectedResults(inductionStatus: InProgress, exemptionReason: null, expectedInductionStatus: InProgress)
✅ WhenCalled_WithoutTRAQTLSDate_ReturnsExpectedResults(inductionStatus: NotYetCompleted, exemptionReason: null, expectedInductionStatus: NotYetCompleted)
✅ WhenCalled_WithoutTRAQTLSDate_ReturnsExpectedResults(inductionStatus: Pass, exemptionReason: null, expectedInductionStatus: Pass)
✅ WhenCalled_WithoutTRAQTLSDate_ReturnsExpectedResults(inductionStatus: PassedinWales, exemptionReason: null, expectedInductionStatus: PassedinWales)
✅ WhenCalled_WithoutTRAQTLSDate_ReturnsExpectedResults(inductionStatus: RequiredtoComplete, exemptionReason: null, expectedInductionStatus: RequiredtoComplete)
✅ WhenCalled_WithQTLSDate_ReturnsExpectedResults
✅ WhenCalled_WithTRAInductionStatusAndQTLSDate_ReturnsExpectedResults(inductionStatus: Exempt, exemptionReason: Exempt, qtls: "01/04/2018", expectedInductionStatus: Exempt)
✅ WhenCalled_WithTRAInductionStatusAndQTLSDate_ReturnsExpectedResults(inductionStatus: Fail, exemptionReason: null, qtls: "01/04/2018", expectedInductionStatus: Fail)
✅ WhenCalled_WithTRAInductionStatusAndQTLSDate_ReturnsExpectedResults(inductionStatus: FailedinWales, exemptionReason: null, qtls: "01/04/2018", expectedInductionStatus: Exempt)
✅ WhenCalled_WithTRAInductionStatusAndQTLSDate_ReturnsExpectedResults(inductionStatus: InductionExtended, exemptionReason: null, qtls: "01/04/2018", expectedInductionStatus: Exempt)
✅ WhenCalled_WithTRAInductionStatusAndQTLSDate_ReturnsExpectedResults(inductionStatus: InProgress, exemptionReason: null, qtls: "01/04/2018", expectedInductionStatus: Exempt)
✅ WhenCalled_WithTRAInductionStatusAndQTLSDate_ReturnsExpectedResults(inductionStatus: NotYetCompleted, exemptionReason: null, qtls: "01/04/2018", expectedInductionStatus: Exempt)
✅ WhenCalled_WithTRAInductionStatusAndQTLSDate_ReturnsExpectedResults(inductionStatus: Pass, exemptionReason: null, qtls: "01/04/2018", expectedInductionStatus: Pass)
✅ WhenCalled_WithTRAInductionStatusAndQTLSDate_ReturnsExpectedResults(inductionStatus: PassedinWales, exemptionReason: null, qtls: "01/04/2018", expectedInductionStatus: PassedinWales)
✅ WhenCalled_WithTRAInductionStatusAndQTLSDate_ReturnsExpectedResults(inductionStatus: RequiredtoComplete, exemptionReason: null, qtls: "01/04/2018", expectedInductionStatus: Exempt)

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.PluginTests.UpdateQtlsDateSetTests

✅ WhenCreatingTeacherWithoutQtlsDate_QtlsHasBeenSetIsFalse
✅ WhenCreatingTeacherWithQtlsDate_QtlsHasBeenSetIsTrue

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

✅ QueryExecutesSuccessfully

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

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.CreateContactTests

✅ 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.CreateDateOfBirthChangeIncidentTests

✅ QueryExecutesSuccessfully

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

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.CreateReviewTaskTests

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.CreateTrnRequestTaskTests

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.DeleteAnnotationTests

✅ QueryExecutesSuccessfully

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.FindPotentialDuplicateContactsTests

✅ MatchOnEmail_ReturnsMatch
✅ MatchOnNameAndDob_ReturnsMatch

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetActiveContactByTrnTests

✅ WhenCalled_WithTrnForExistingContact_ReturnsContactDetail
✅ WhenCalled_WithTrnForNonExistentContact_ReturnsNull

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetActiveContactDetailByIdTests

✅ WhenCalled_WithContactIdForExistingContact_ReturnsContactDetail
✅ WhenCalled_WithContactIdForExistingContactWithPreviousName_ReturnsContactDetailIncludingPreviousNames
✅ WhenCalled_WithContactIdForNonExistentContact_ReturnsNull

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetActiveContactDetailByTrnTests

✅ WhenCalled_WithTrnForExistingContact_ReturnsContactDetail
✅ WhenCalled_WithTrnForExistingContactWithPreviousName_ReturnsContactDetailIncludingPreviousNames
✅ WhenCalled_WithTrnForNonExistentContact_ReturnsNull

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetActiveContactsByLastNameAndDateOfBirthTests

✅ ReturnsMatchingContactsFromCrm

✅ TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.QueryTests.GetActiveContactsByNameTests

✅ 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.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.GetContactByTrnRequestIdTests

✅ WhenCalled_WithTrnForExistingContact_ReturnsContactDetail
✅ 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.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.GetInductionByContactIdTests

✅ WhenCalled_WithContactIdForNonExistentContact_ReturnsNullInductionAndInductionPeriods
✅ WhenCalled_WithContactWithInduction_ReturnsResultWithInductionAndNullInductionPeriods
✅ WhenCalled_WithInductionAndInductionPeriod_ReturnsExpectedResults
✅ WhenCalled_WithoutTRAInductionStatusAndQTLSDate_ReturnsExpectedResults
✅ WhenCalled_WithoutTRAInductionStatusStatusAndQTLSDate_ReturnsExpectedResults
✅ WhenCalled_WithoutTRAQTLSDate_ReturnsExpectedResults(inductionStatus: Exempt, exemptionReason: Exempt, expectedInductionStatus: Exempt)
✅ WhenCalled_WithoutTRAQTLSDate_ReturnsExpectedResults(inductionStatus: Fail, exemptionReason: null, expectedInductionStatus: Fail)
✅ WhenCalled_WithoutTRAQTLSDate_ReturnsExpectedResults(inductionStatus: FailedinWales, exemptionReason: null, expectedInductionStatus: FailedinWales)
✅ WhenCalled_WithoutTRAQTLSDate_ReturnsExpectedResults(inductionStatus: InductionExtended, exemptionReason: null, expectedInductionStatus: InductionExtended)
✅ WhenCalled_WithoutTRAQTLSDate_ReturnsExpectedResults(inductionStatus: InProgress, exemptionReason: null, expectedInductionStatus: InProgress)
✅ WhenCalled_WithoutTRAQTLSDate_ReturnsExpectedResults(inductionStatus: NotYetCompleted, exemptionReason: null, expectedInductionStatus: NotYetCompleted)
✅ WhenCalled_WithoutTRAQTLSDate_ReturnsExpectedResults(inductionStatus: Pass, exemptionReason: null, expectedInductionStatus: Pass)
✅ WhenCalled_WithoutTRAQTLSDate_ReturnsExpectedResults(inductionStatus: PassedinWales, exemptionReason: null, expectedInductionStatus: PassedinWales)
✅ WhenCalled_WithoutTRAQTLSDate_ReturnsExpectedResults(inductionStatus: RequiredtoComplete, exemptionReason: null, expectedInductionStatus: RequiredtoComplete)
✅ WhenCalled_WithQTLSDate_ReturnsExpectedResults
✅ WhenCalled_WithTRAInductionStatusAndQTLSDate_ReturnsExpectedResults(inductionStatus: Exempt, exemptionReason: Exempt, qtls: "01/04/2018", expectedInductionStatus: Exempt)
✅ WhenCalled_WithTRAInductionStatusAndQTLSDate_ReturnsExpectedResults(inductionStatus: Fail, exemptionReason: null, qtls: "01/04/2018", expectedInductionStatus: Fail)
✅ WhenCalled_WithTRAInductionStatusAndQTLSDate_ReturnsExpectedResults(inductionStatus: FailedinWales, exemptionReason: null, qtls: "01/04/2018", expectedInductionStatus: Exempt)
✅ WhenCalled_WithTRAInductionStatusAndQTLSDate_ReturnsExpectedResults(inductionStatus: InductionExtended, exemptionReason: null, qtls: "01/04/2018", expectedInductionStatus: Exempt)
✅ WhenCalled_WithTRAInductionStatusAndQTLSDate_ReturnsExpectedResults(inductionStatus: InProgress, exemptionReason: null, qtls: "01/04/2018", expectedInductionStatus: Exempt)
✅ WhenCalled_WithTRAInductionStatusAndQTLSDate_ReturnsExpectedResults(inductionStatus: NotYetCompleted, exemptionReason: null, qtls: "01/04/2018", expectedInductionStatus: Exempt)
✅ WhenCalled_WithTRAInductionStatusAndQTLSDate_ReturnsExpectedResults(inductionStatus: Pass, exemptionReason: null, qtls: "01/04/2018", expectedInductionStatus: Pass)
✅ WhenCalled_WithTRAInductionStatusAndQTLSDate_ReturnsExpectedResults(inductionStatus: PassedinWales, exemptionReason: null, qtls: "01/04/2018", expectedInductionStatus: PassedinWales)
✅ WhenCalled_WithTRAInductionStatusAndQTLSDate_ReturnsExpectedResults(inductionStatus: RequiredtoComplete, exemptionReason: null, qtls: "01/04/2018", expectedInductionStatus: Exempt)

✅ 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.GetOpenTasksForEmailAddressTests

✅ WhenCalled_WithEmailWithCancelledTasks_ReturnsEmpty
✅ WhenCalled_WithEmailWithCompletedTasks_ReturnsEmpty
✅ WhenCalled_WithEmailWithNoOpenTasks_ReturnsEmpty
✅ WhenCalled_WithEmailWithOpenTasks_ReturnsTasks

✅ 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.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.SetQtlsDateTests

✅ QueryExecutesSuccessfully
✅ WhenClearingExistingQtlsDate_DoesNotSetQtlsDateHasBeenSet

✅ 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
✅ ProcessTrsChanges_ExistingRow_IsUpdatedInDbWithCorrectValues
❌ ProcessTrsChanges_NewRow_IsInsertedIntoDbWithCorrectValues
	System.OperationCanceledException : Query was cancelled
	---- Npgsql.PostgresException : 57014: canceling statement due to user request

Annotations

Check failure on line 494 in TeachingRecordSystem/src/TeachingRecordSystem.Core/Services/DqtReporting/DqtReportingService.cs

See this annotation in the file changed.

@github-actions github-actions / DQT integration test results

TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.Services.DqtReporting.DqtReportingServiceTests ► ProcessTrsChanges_NewRow_IsInsertedIntoDbWithCorrectValues

Failed test found in:
  TeachingRecordSystem/tests/TeachingRecordSystem.Core.Dqt.CrmIntegrationTests/TestResults/_fv-az1773-217_2024-08-23_08_13_19.trx
Error:
  System.OperationCanceledException : Query was cancelled
  ---- Npgsql.PostgresException : 57014: canceling statement due to user request
Raw output
System.OperationCanceledException : Query was cancelled
---- Npgsql.PostgresException : 57014: canceling statement due to user request
   at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)
   at System.Runtime.CompilerServices.PoolingAsyncValueTaskMethodBuilder`1.StateMachineBox`1.System.Threading.Tasks.Sources.IValueTaskSource<TResult>.GetResult(Int16 token)
   at Npgsql.Replication.ReplicationConnection.StartReplicationInternal(String command, Boolean bypassingStream, CancellationToken cancellationToken)+MoveNext()
   at Npgsql.Replication.ReplicationConnection.StartReplicationInternal(String command, Boolean bypassingStream, CancellationToken cancellationToken)+MoveNext()
   at Npgsql.Replication.ReplicationConnection.StartReplicationInternal(String command, Boolean bypassingStream, CancellationToken cancellationToken)+System.Threading.Tasks.Sources.IValueTaskSource<System.Boolean>.GetResult()
   at Npgsql.Replication.Internal.LogicalReplicationConnectionExtensions.<StartLogicalReplication>g__StartLogicalReplicationInternal|1_0(LogicalReplicationConnection connection, LogicalReplicationSlot slot, CancellationToken cancellationToken, Nullable`1 walLocation, IEnumerable`1 options, Boolean bypassingStream)+MoveNext()
   at Npgsql.Replication.Internal.LogicalReplicationConnectionExtensions.<StartLogicalReplication>g__StartLogicalReplicationInternal|1_0(LogicalReplicationConnection connection, LogicalReplicationSlot slot, CancellationToken cancellationToken, Nullable`1 walLocation, IEnumerable`1 options, Boolean bypassingStream)+System.Threading.Tasks.Sources.IValueTaskSource<System.Boolean>.GetResult()
   at Npgsql.Replication.PgOutput.PgOutputAsyncEnumerable.StartReplicationInternal(CancellationToken cancellationToken)+MoveNext()
   at Npgsql.Replication.PgOutput.PgOutputAsyncEnumerable.StartReplicationInternal(CancellationToken cancellationToken)+MoveNext()
   at Npgsql.Replication.PgOutput.PgOutputAsyncEnumerable.StartReplicationInternal(CancellationToken cancellationToken)+System.Threading.Tasks.Sources.IValueTaskSource<System.Boolean>.GetResult()
   at TeachingRecordSystem.Core.Services.DqtReporting.DqtReportingService.ProcessTrsChanges(CancellationToken cancellationToken, IObserver`1 observer) in /home/runner/work/teaching-record-system/teaching-record-system/TeachingRecordSystem/src/TeachingRecordSystem.Core/Services/DqtReporting/DqtReportingService.cs:line 494
   at TeachingRecordSystem.Core.Services.DqtReporting.DqtReportingService.ProcessTrsChanges(CancellationToken cancellationToken, IObserver`1 observer) in /home/runner/work/teaching-record-system/teaching-record-system/TeachingRecordSystem/src/TeachingRecordSystem.Core/Services/DqtReporting/DqtReportingService.cs:line 494
   at TeachingRecordSystem.Core.Services.DqtReporting.DqtReportingService.ProcessTrsChanges(CancellationToken cancellationToken, IObserver`1 observer) in /home/runner/work/teaching-record-system/teaching-record-system/TeachingRecordSystem/src/TeachingRecordSystem.Core/Services/DqtReporting/DqtReportingService.cs:line 494
   at TeachingRecordSystem.Core.Services.DqtReporting.DqtReportingService.ProcessTrsChanges(CancellationToken cancellationToken, IObserver`1 observer) in /home/runner/work/teaching-record-system/teaching-record-system/TeachingRecordSystem/src/TeachingRecordSystem.Core/Services/DqtReporting/DqtReportingService.cs:line 494
   at TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.Services.DqtReporting.DqtReportingServiceTests.<>c__DisplayClass9_1.<<ProcessTrsChangesSingle>g__ConsumeSingleMessage|2>d.MoveNext() in /home/runner/work/teaching-record-system/teaching-record-system/TeachingRecordSystem/tests/TeachingRecordSystem.Core.Dqt.CrmIntegrationTests/Services/DqtReporting/DqtReportingServiceTests.cs:line 282
--- End of stack trace from previous location ---
   at TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.Services.DqtReporting.DqtReportingServiceTests.<ProcessTrsChanges_NewRow_IsInsertedIntoDbWithCorrectValues>b__7_0(Task singleMessageConsumed) in /home/runner/work/teaching-record-system/teaching-record-system/TeachingRecordSystem/tests/TeachingRecordSystem.Core.Dqt.CrmIntegrationTests/Services/DqtReporting/DqtReportingServiceTests.cs:line 179
   at TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.Services.DqtReporting.DqtReportingServiceTests.<ProcessTrsChanges_NewRow_IsInsertedIntoDbWithCorrectValues>b__7_0(Task singleMessageConsumed) in /home/runner/work/teaching-record-system/teaching-record-system/TeachingRecordSystem/tests/TeachingRecordSystem.Core.Dqt.CrmIntegrationTests/Services/DqtReporting/DqtReportingServiceTests.cs:line 192
   at TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.Services.DqtReporting.DqtReportingServiceTests.<>c__DisplayClass9_0.<<ProcessTrsChangesSingle>b__0>d.MoveNext() in /home/runner/work/teaching-record-system/teaching-record-system/TeachingRecordSystem/tests/TeachingRecordSystem.Core.Dqt.CrmIntegrationTests/Services/DqtReporting/DqtReportingServiceTests.cs:line 291
--- End of stack trace from previous location ---
   at TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.Services.DqtReporting.DqtReportingServiceTests.<>c__DisplayClass9_0.<<ProcessTrsChangesSingle>b__0>d.MoveNext() in /home/runner/work/teaching-record-system/teaching-record-system/TeachingRecordSystem/tests/TeachingRecordSystem.Core.Dqt.CrmIntegrationTests/Services/DqtReporting/DqtReportingServiceTests.cs:line 296
--- End of stack trace from previous location ---
   at TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.Services.DqtReporting.DqtReportingServiceTests.<>c__DisplayClass9_0.<<ProcessTrsChangesSingle>b__0>d.MoveNext() in /home/runner/work/teaching-record-system/teaching-record-system/TeachingRecordSystem/tests/TeachingRecordSystem.Core.Dqt.CrmIntegrationTests/Services/DqtReporting/DqtReportingServiceTests.cs:line 301
--- End of stack trace from previous location ---
   at TeachingRecordSystem.Core.Dqt.CrmIntegrationTests.Services.DqtReporting.DqtReportingFixture.WithService(Func`3 action) in /home/runner/work/teaching-record-system/teaching-record-system/TeachingRecordSystem/tests/TeachingRecordSystem.Core.Dqt.CrmIntegrationTests/Services/DqtReporting/DqtReportingFixture.cs:line 74
----- Inner Stack Trace -----
   at Npgsql.Internal.NpgsqlConnector.ReadMessageLong(Boolean async, DataRowLoadingMode dataRowLoadingMode, Boolean readingNotifications, Boolean isReadingPrependedMessage)