[FEAT]: Implement Comment System API Routes

[coxmars]

Implement Comment System API Routes

Description

Create API routes for Comment model to enable payout commenting.
Implement full CRUD operations with authentication, payout relationships, and proper error handling.

---

Requirements

API Routes Structure

• src/app/api/(comment)/comment/create/route.ts → POST for comment creation
• src/app/api/(comment)/comment/find-by-payout/[payout_id]/route.ts → GET comments for a payout
• src/app/api/(comment)/comment/update/[id]/route.ts → PATCH comment editing
• src/app/api/(comment)/comment/delete/[id]/route.ts → DELETE comment removal

Database Operations

• Use @/lib/prisma + error handling patterns
• Optimize with indexes: payout_id, user_id, created_at
• Include User relation for comment author
• Return comments ordered chronologically (created_at)

Authorization & Security

• Users can only update/delete their own comments
• Validate payout existence before comment creation
• Follow existing API authentication patterns
• Proper user context validation

---

Components

• src/app/api/(comment)/comment/ directory structure (new)
• Follow consistent error handling & response patterns

---

Validations

• Comments link to existing Payout and User records
• User can only edit/delete own comments
• Comments display in chronological order
• Database queries optimized with proper indexing

---

⚠️ Follow guidelines for issues, commits, and PRs. Otherwise, they will be ignored.

[D240021]

Hi! 👋

I’m currently a Computer Science student and I’m starting to get into the world of open source contributions. I’m very interested in this issue and would like to work on it to gain experience, build confidence, and expand my CV.

Could you please assign it to me? 🙂

Thank you! 🚀

[Bosun-Josh121]

I am applying to this issue via OnlyDust platform.

My background and how it can be leveraged:
software engineering background, backend & smart contract dev (https://app.onlydust.com/users/Bosun-Josh121/overview)
with robust experience with similar tasks

I am confident in fulfilling the stated requirements and functions. Will work on feedback & recommendation ensuring contact. Can deliver within 48hrs upon assignment

Recommended by OnlyDust for high-quality and dependable contributions.

[bernardev254]

Hey @maintainer,
I’ll implement the Comment System API for payouts—full CRUD with auth, relationships, and tight error handling. Right now, there’s no way to attach comments to payouts, which blocks collaboration.

My plan:

1. API routes (structured in src/app/api/(comment)/):

• POST /create → Add comment (validates payout/user).
• GET /find-by-payout/[payout_id] → Fetch comments (ordered by created_at).
  -PATCH /update/[id] + DELETE /delete/[id] → User-owned edits only.

2. DB ops:

• Prisma queries with indexes (payout_id, user_id, created_at).
  -Include User relation for author context.

3. Auth/security:

• Reuse existing auth patterns.
• Validate payout existence + user ownership.
  i'll get started on assignment

Recommended by OnlyDust for exceptional experience, quality, and reliability.

[henrynnamani]

It is something I am familiar with, and implement often
Let my code and it's functionality speak

[ayomideadeniran]

I am applying for the 'Implement Comment System API Routes' issue, confident in my ability to deliver full CRUD operations with Next.js App Router, leverage Prisma for indexed database operations including user and payout relations, implement robust authentication and authorization (allowing users to manage only their own comments and validating payout existence), and ensure comprehensive error handling, all within the specified API structure.

[FabianSanchezD]

Hi @coxmars, I'm Fabian and I'd like to take this issue! I have experience in backend and the implementation of CRUD functionalities.
My ETA is less than 3 days.

Thanks!

[coxmars]

Hi @FabianSanchezD if you need help just let me know, and also wait for this issue #123 once it is merged you can work in this one 🫡