Feature: Add Transaction Outbox and Job Delivery Foundation

[3m1n3nc3]

Description

Create transaction and outbox primitives for work spanning PostgreSQL, queues, notifications, and blockchain providers.

File Location

learnault-api/prisma/schema.prisma, learnault-api/src/lib/transactions/, learnault-api/src/jobs/, and migrations

Design Reference

API Roadmap Phase 0: Add Transaction Outbox and Job Delivery Foundation.

Dependencies

• Status: Blocked
• Blocked by: Feature: Define Backend Domain Module Boundaries #60 (Define Backend Domain Module Boundaries) — done; Feature: Introduce Typed Status Enums and Transition Guards #65 (Introduce Typed Status Enums and Transition Guards) — done
• Blocks: Wallet, email, reward, credential, and notification jobs

Tasks

• Add outbox event and job-attempt models with stable IDs and typed status
• Write domain changes and outbox events in one transaction
• Implement lease, retry, backoff, dead-letter, and idempotent completion
• Recover abandoned leases and stop workers gracefully
• Version and validate event payloads
• Test rollback, duplicate delivery, crashes, retries, and dead letters

Acceptance Criteria

• Rolled-back domain changes emit no event
• Duplicate processing creates no duplicate side effect
• Abandoned work becomes retryable
• Lifecycle tests and metrics pass

Verification Evidence

• Attach migration output and rollback, duplicate, crash, and retry tests

Difficulty

Advanced

[ReinaMaze]

GM Maintainer, Can I get assigned to work on this?
I’ve gone through the issue and understand the transaction outbox and job delivery requirements, including atomic event creation, retries, leases, dead-letter handling, idempotency, and recovery.I’ll also cover the required lifecycle and failure-case tests and include the migration/test evidence in the PR.

ETA: 72 hours.

[grantfox-oss]

🦊 GrantFox — @ReinaMaze has been assigned to this issue as part of the Third Campaign campaign!

Next steps:

1. Open a Pull Request referencing this issue (e.g., Closes #122)
2. Your PR will be reviewed by the learnault maintainers

Good luck! Track your progress on GrantFox.