feat: add `GET /reports` endpoint — list previously generated reports with download links

[BigBen-7]

Description

POST /generate-daily-report saves files to the reports/ directory and returns the file path, but there is no way to list or re-download previously generated reports without direct filesystem access. In a containerised environment the path is ephemeral anyway — reports must be accessible via the API.

Requirements & context

• GET /reports (ADMIN) returns a list of generated reports:

  { "reports": [ { "filename": "daily_report_2025-01-01_...", "report_date": "2025-01-01", "format": "csv", "size_bytes": 4096, "generated_at": "ISO", "download_url": "/reports/download/daily_report_..." } ] }

• GET /reports/download/{filename} (ADMIN) streams the file as a FileResponse
• Store report metadata in a generated_reports Postgres table instead of relying on the filesystem
• On startup, scan reports/ and populate the table with any existing files
• Write tests for list and download endpoints

Suggested execution

git checkout -b feat/reports-list-download-api

• Create generated_reports table
• Add routes to src/main.py
• Update generate_daily_report_csv to insert metadata row
• Write tests

Guidelines

• Cap listing at 100 most recent reports
• PR must include: Closes #[issue_id]
• Timeframe: 72 hours

[devJaja]

@devJaja has applied to work on this issue as part of the Stellar Wave Program's 3rd wave.

Hello! I’m a smart contract and full-stack developer with experience across 30+ blockchain projects, including work on Stellar. I’d love to contribute to this issue.

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

[habdullhigh]

@habdullhigh has applied to work on this issue as part of the Stellar Wave Program's 3rd wave.

i would like to work on this together with the caching of reports issu also so it can be done quicker and integrated much more smoothly

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

[Kaylahray]

@Kaylahray has applied to work on this issue as part of the Stellar Wave Program's 3rd wave.

Hello maintainer, I can add the GET /reports endpoint. please assign

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

[drips-wave]

Congratulations, @Kaylahray! 🎉 Your application was accepted by the repo's maintainers, and the issue is due on March 30, 2026.

🧑‍💻 @Kaylahray: 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 🌊

[drips-wave]

This issue has been completed by @Kaylahray as part of the Stellar Wave Program's 3rd Wave 🥳

😎 @Kaylahray: You earned 200 Points for completing this issue! After the current Wave ends, you'll be eligible for a percentage of the Wave's reward pool based on the percentage of total points you've earned. Learn more here. You can also Leave a review to share your experience working on this issue.

🧑‍💻 Repo maintainers: How'd the contributor do? Leave a review to share your experience working with them.