[EdgeDB] Add `Engagement` queries | refactor service/repo layers appropriately

[bryanjnelson]

Monday task

Description

• Refactor Engagement functionality to prepare for EdgeDB migration
• Create EdgeDB Engagement repository

Ready for review checklist

Use [N/A] if the item is not applicable to this PR or remove the item

• [X] Change the task url above to the actual Monday task
• [N/A] Add/update tests if needed
• [X] Add reviewers to this PR

[github-actions[bot]]

🗞 GraphQL Summary

View schema changes

```diff @@ -1449,10 +1449,10 @@ """The object's ID""" id: ID! initialEndDate: SecuredDateNullable! - lastReactivatedAt: SecuredDateTime! - lastSuspendedAt: SecuredDateTime! + lastReactivatedAt: SecuredDateTimeNullable! + lastSuspendedAt: SecuredDateTimeNullable! modifiedAt: DateTime! parent: Project! project: Project! @@ -1462,9 +1462,9 @@ startDateOverride: SecuredDateNullable! status: SecuredEngagementStatus! """The last time the engagement status was modified""" - statusModifiedAt: SecuredDateTime! + statusModifiedAt: SecuredDateTimeNullable! } input EngagementFilters { """Only engagements matching this type""" @@ -2081,10 +2081,10 @@ """The object's ID""" id: ID! initialEndDate: SecuredDateNullable! intern: SecuredUser! - lastReactivatedAt: SecuredDateTime! - lastSuspendedAt: SecuredDateTime! + lastReactivatedAt: SecuredDateTimeNullable! + lastSuspendedAt: SecuredDateTimeNullable! mentor: SecuredUser! methodologies: SecuredMethodologies! modifiedAt: DateTime! parent: InternshipProject! @@ -2097,9 +2097,9 @@ startDateOverride: SecuredDateNullable! status: SecuredEngagementStatus! """The last time the engagement status was modified""" - statusModifiedAt: SecuredDateTime! + statusModifiedAt: SecuredDateTimeNullable! } enum InternshipPosition { Administration @@ -2381,16 +2381,16 @@ disbursementCompleteDate: SecuredDateNullable! endDate: SecuredDateNullable! endDateOverride: SecuredDateNullable! firstScripture: SecuredBoolean! - historicGoal: SecuredString! + historicGoal: SecuredStringNullable! """The object's ID""" id: ID! initialEndDate: SecuredDateNullable! language: SecuredLanguage! - lastReactivatedAt: SecuredDateTime! - lastSuspendedAt: SecuredDateTime! + lastReactivatedAt: SecuredDateTimeNullable! + lastSuspendedAt: SecuredDateTimeNullable! """The latest progress report that has a report submitted""" latestProgressReportSubmitted: SecuredPeriodicReport! lukePartnership: SecuredBoolean! @@ -2400,9 +2400,9 @@ The progress report due next. This is the period currently in progress. """ nextProgressReportDue: SecuredProgressReport! openToInvestorVisit: SecuredBoolean! - paratextRegistryId: SecuredString! + paratextRegistryId: SecuredStringNullable! parent: TranslationProject! """ A list of mediums used across all of the engagement's products and their @@ -2424,9 +2424,9 @@ startDateOverride: SecuredDateNullable! status: SecuredEngagementStatus! """The last time the engagement status was modified""" - statusModifiedAt: SecuredDateTime! + statusModifiedAt: SecuredDateTimeNullable! } type LanguageEngagementListOutput implements PaginatedList { """Whether the next page exists""" ```

🚨 Breaking Changes

• Engagement.lastReactivatedAt changed type from SecuredDateTime! to SecuredDateTimeNullable!.
• Engagement.lastSuspendedAt changed type from SecuredDateTime! to SecuredDateTimeNullable!.
• Engagement.statusModifiedAt changed type from SecuredDateTime! to SecuredDateTimeNullable!.
• InternshipEngagement.lastReactivatedAt changed type from SecuredDateTime! to SecuredDateTimeNullable!.
• InternshipEngagement.lastSuspendedAt changed type from SecuredDateTime! to SecuredDateTimeNullable!.
• InternshipEngagement.statusModifiedAt changed type from SecuredDateTime! to SecuredDateTimeNullable!.
• LanguageEngagement.historicGoal changed type from SecuredString! to SecuredStringNullable!.
• LanguageEngagement.lastReactivatedAt changed type from SecuredDateTime! to SecuredDateTimeNullable!.
• LanguageEngagement.lastSuspendedAt changed type from SecuredDateTime! to SecuredDateTimeNullable!.
• LanguageEngagement.paratextRegistryId changed type from SecuredString! to SecuredStringNullable!.
• LanguageEngagement.statusModifiedAt changed type from SecuredDateTime! to SecuredDateTimeNullable!.