Assignee
N/A
Start Date
N/A
End Date (Target)
N/A
Description
Develop an automated mechanism to update the service allocation sheet based on Pull Request (PR) activity.
Currently, junior/senior leads are responsible for manually monitoring PRs or waiting for students to notify them before updating the service allocation Excel sheet status to "PR-Review". This process is manual, time-consuming, and prone to delays or inconsistencies.
The proposed solution should automatically detect PR events and update the corresponding service status in the allocation excel sheet. The system must also continuously monitor PR states and revert statuses when necessary.
Additionally, another function should be implemented to run at the end of each trimester. This function should validate all services against their corresponding PRs and update statuses accordingly.
Students can refer to and reuse ideas from the existing mechanism implemented in #354 . This implementation includes automated validation checks to determine whether a PR is ready for review (missing documentation checks, correct branch naming validation, etc.).
The new automation should integrate with this logic as follows -
- If a PR is labeled "CI-approved" → update the service status to "PR-Review"
- If a PR is labeled "CI-Review_Required" → do not update/add the PR to the sheet
Objectives / Expected Outcome
- Automate and streamline service allocation status management by integrating PR activity monitoring with the service allocation workflow.
Steps / Action Items
- Develop a mechanism to automatically detect PR creation events
- Update the corresponding service status to "PR-Review" only if the PR is labeled "CI-approved"
- Ignore PRs labeled "CI-Review_Required"
- Implement continuous monitoring of PR state changes.
- Develop an end-of-trimester reconciliation function to validate all services against their PRs
- Apply the following reconciliation logic -
If a valid PR exists → "PR-Review"
If a PR exists and is approved/merged→ "PR-Review"
If a PR exists but is not close to merging → "In-progress"
Keep "Done" and "Unassigned" statuses unchanged
Dependencies
No response
Related Links
Related PR link
Status
Not started
Assignee
N/A
Start Date
N/A
End Date (Target)
N/A
Description
Develop an automated mechanism to update the service allocation sheet based on Pull Request (PR) activity.
Currently, junior/senior leads are responsible for manually monitoring PRs or waiting for students to notify them before updating the service allocation Excel sheet status to "PR-Review". This process is manual, time-consuming, and prone to delays or inconsistencies.
The proposed solution should automatically detect PR events and update the corresponding service status in the allocation excel sheet. The system must also continuously monitor PR states and revert statuses when necessary.
Additionally, another function should be implemented to run at the end of each trimester. This function should validate all services against their corresponding PRs and update statuses accordingly.
Students can refer to and reuse ideas from the existing mechanism implemented in #354 . This implementation includes automated validation checks to determine whether a PR is ready for review (missing documentation checks, correct branch naming validation, etc.).
The new automation should integrate with this logic as follows -
Objectives / Expected Outcome
Steps / Action Items
If a valid PR exists → "PR-Review"
If a PR exists and is approved/merged→ "PR-Review"
If a PR exists but is not close to merging → "In-progress"
Keep "Done" and "Unassigned" statuses unchanged
Dependencies
No response
Related Links
Related PR link
Status
Not started