Summary
Delivered a user-facing task platform around phone verification, task creation, shared worker-table integration, SSE status updates, quota ledger, Alipay upgrade, and admin operations.
Business Value
Separated the customer worker from the user-facing platform while keeping task creation, progress tracking, result download, and quota management coherent.
Engineering Depth
Covers async task contracts, PostgreSQL triggers, LISTEN/NOTIFY, SSE, quota ledgers, payment callbacks, layered FastAPI services, React modules, and automated tests.
Evidence
本地仓库 README / docs/架构说明 / docs/交付文档 / apps/api / apps/web / tests
Repository · Confidence High · Verified 2026-05-17
- Evidence level: strict review (core sections only show verifiable metrics)
- Source type: Repository / code records
- Source link: no public link provided, review against delivery records
- Verified at: 2026-05-17 (31 days ago, fresh evidence)
Rationale: High confidence: organized under strict evidence rules, traceable to repository or code records, verified 31 days ago.
Background
The customer already had a worker process for paper retrieval, while the user-facing platform needed to manage account, quota, progress, and payment workflows.
Challenge
The worker should remain isolated, but users still needed clear task creation, progress tracking, and result download paths.
Action and Results
Solution
- Defined a shared tasks-table contract for worker integration.
- Built FastAPI layers for auth, tasks, quota, payment callbacks, and admin operations.
- Used PostgreSQL LISTEN/NOTIFY and SSE for realtime progress.
- Added pytest, Vitest, and Playwright regression coverage.
Result
Created an acceptance-ready platform that lowered cross-team integration risk while keeping the production path clear.
Key Signals
Built user, admin, task, payment, quota, and health-check modules with FastAPI and React. Integrated with the customer worker through a shared database contract instead of direct coupling. Used PostgreSQL triggers, LISTEN/NOTIFY, and SSE to keep task status visible. Tech Stack
PythonFastAPIAsyncIOSQLAlchemyPostgreSQLRedisAlembicReact 19TypeScriptViteZustandSWRPlaywright