Predictions confirmation worker driven by indexer events

[greatest0fallt1me]

Description

After the indexer ingests a bet_placed event, the corresponding pending row in predictions must transition to confirmed. Add a worker that joins indexer_events against predictions on txHash and advances state, emitting a webhook event.

Requirements and Context

• src/workers/predictionsConfirmer.ts runs every PREDICTION_CONFIRM_INTERVAL_MS
• Batches updates in a single transaction per tick
• Emits prediction.confirmed to the webhook dispatcher
• Stops processing a row after 3 failed attempts and records lastError
• Must be secure, tested, and documented
• Should be efficient and easy to review

Suggested Execution

1. Fork the repo and create a branch

   git checkout -b feature/predictions-confirmer

2. Implement changes
   • src/workers/predictionsConfirmer.ts
   • Extend predictions with confirmAttempts, lastError
   • Wire webhook emission
3. Test and commit
   • Insert event + matching prediction → assert transition
   • Cover edge cases
   • Include test output and notes in the PR

Example commit message

feat: pending-to-confirmed predictions worker

Acceptance Criteria

• Batch tick processes 1000 rows in < 500ms
• Failed rows do not block siblings
• Webhook emitted exactly once per confirmation

Guidelines

• Use FOR UPDATE SKIP LOCKED to allow safe horizontal scaling
• Clear documentation and inline comments
• Timeframe: 96 hours

[mikkyvans0-source]

@mikkyvans0-source has applied to work on this issue as part of the Stellar Wave Program's 6th wave.

hello would love to work on this project

ℹ️ Repo Maintainers: To accept this application, review their application or assign @mikkyvans0-source to this issue.

[drips-wave]

Congratulations, @mikkyvans0-source! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on June 30, 2026.

🧑‍💻 @mikkyvans0-source: Please resolve the issue such that the repo's maintainers have enough time to review your contribution before the due date. You'll earn Points for completing the issue on-time, which will make you eligible for a share of the Stellar Wave Program's reward pool.

Warning

When opening a PR, please link it to this issue to ensure it gets tracked accurately. Points are awarded when this issue is marked as completed by the maintainer.

🤠 Repo maintainers: Please keep an eye on the contributor's progress and review their work before the due date. You can manage this issue, including adjusting its complexity and points, here.

🌊 Happy Wave 🌊