🫧💦 ↝ Weekly Milestone Automation
Open
@Gizmotronn is already working on this.
Since Jul 21, 2025.
enhancement
good first issue
- Dominant language
- Go
- Stars
- 0
- Forks
- 0
- PR merge metrics
- No merged PRs in 30d
Description
This task sets up a backend process to clear and reset the user_milestones table every week, as well as assigning new milestones
✅ Requirements
- Add a
user_milestonesSQL table to track per-user milestone assignments - Build a Go program to delete expired milestone rows weekly (based on
week_start) - Add logging to the cleanup script
- Create a GitHub Action that:
- Runs every Sunday 00:01 AEST
Later: We’ll add milestone assignment logic based on player activity (e.g., past 2 weeks).
File
- Go file:
jobs/reset_user_milestones.go - Workflow:
.github/workflows/reset_user_milestones.yml
Contributor guide
No contributing guide indexed for this repository
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Assessment
This issue has not been assessed yet.