Implement Posts API for Course Forums

[armintalaie]

Overview

Create CRUD endpoints for managing course discussion posts with user tracking, edit history, and threading

Database Tables

• [x] posts table:

  - id: UUID
  - course_id: UUID
  - title: string
  - content: text
  - parent_id: UUID (optional)
  - created_by: UUID
  - status: enum (active, deleted)
  - timestamps

• [x] post_edits table:

  - id: UUID
  - post_id: UUID
  - edited_by: UUID
  - previous_content: text
  - new_content: text
  - edit_reason: text (optional)
  - timestamps

API Endpoints

Under /courses/{course_id}/posts:

• [x] POST: create new post

  {
  "title": "string",
  "content": "string",
  "parent_id": "UUID (optional)",
  "tags": "UUID[]"
  }

  • Track creator
  • Create embedding job

• [x] GET: list posts with metadata

  • Include post creators
  • Show last editor if edited
  • Filter/sort options
  • Edit history access

• [x] PATCH /{post_id}: update post

  • Save edit history
  • Track editor
  • Require edit reason for others' posts
  • Permission checks

• [x] DELETE /{post_id}: Hard delete (for now)

  • Track who deleted
  • Keep history

Tasks:

• [x] Write migrations
• [x] Add user tracking
• [x] Implement edit history
• [x] Add permission logic