Create a Golang script and GitHub Action that deletes all entries from the linked_anomalies table in Supabase every Sunday at 00:01 AEST (Saturday 14:01 UTC). This will help reset user discoveries at the start of each new gameplay week.
Acceptance Criteria
Go script uses DELETE /rest/v1/linked_anomalies via Supabase HTTP API
Authenticated using SUPABASE_SERVICE_ROLE_KEY as a GitHub secret
Action runs weekly on schedule (cron: '1 14 * * 6')
Logs successful or failed deletion with fmt.Println
Uses SUPABASE_URL and SUPABASE_SERVICE_ROLE_KEY from env
GitHub Action runs standalone and is included in .github/workflows/delete-linked-anomalies.yml
Create a Golang script and GitHub Action that deletes all entries from the
linked_anomaliestable in Supabase every Sunday at 00:01 AEST (Saturday 14:01 UTC). This will help reset user discoveries at the start of each new gameplay week.Acceptance Criteria
Go script uses DELETE /rest/v1/linked_anomalies via Supabase HTTP API
Authenticated using SUPABASE_SERVICE_ROLE_KEY as a GitHub secret
Action runs weekly on schedule (cron: '1 14 * * 6')
Logs successful or failed deletion with fmt.Println
Uses SUPABASE_URL and SUPABASE_SERVICE_ROLE_KEY from env
GitHub Action runs standalone and is included in .github/workflows/delete-linked-anomalies.yml