Epic 8: Backend Integration

[Vitalisn4]

Issue #43: Set Up PostgreSQL Database (if not already set up)

Labels: epic-8, backend, database, priority-high
Milestone: Epic 8 - Backend Integration
Dependencies: None

Description:
Ensure PostgreSQL database is properly configured and accessible for frontend API.

Acceptance Criteria:

• Verify database connection string is configured
• Ensure database is accessible from frontend environment
• Run existing migrations
• Verify tables exist (people, assignments)
• Test connection with sample query
• Document connection setup

Technical Notes:

• Database may already be set up from Rust backend
• May need to expose database or create API layer

---

Issue #44: Create Database Tables (if needed)

Labels: epic-8, backend, database, priority-high
Milestone: Epic 8 - Backend Integration
Dependencies: #43

Description:
Create any additional database tables needed for frontend features (e.g., tasks table, settings table).

Acceptance Criteria:

• Review existing schema
• Identify missing tables:
  • tasks table (if task config is stored in DB)
  • settings table (for Discord webhook, schedule config)
• Create migration files
• Run migrations
• Verify table structure
• Document schema changes

Technical Notes:

• May need to add tasks table if not hardcoded
• Settings table for webhook URL, schedule interval

---

Issue #45: Create API Hooks with TanStack Query

Labels: epic-8, integration, api, priority-high
Milestone: Epic 8 - Backend Integration
Dependencies: #43, #44

Description:
Set up API layer and create React Query hooks for all data operations.

Acceptance Criteria:

• Set up API client (axios or fetch wrapper)
• Configure base URL from environment variables
• Create API hooks for:
  • People (GET, POST, PUT, DELETE, bulk update)
  • Assignments (GET current, GET history, POST manual trigger)
  • Tasks (GET, PUT)
  • Settings (GET, PUT)
  • Schedule (GET status, POST trigger)
• Add error handling
• Add request/response interceptors
• Configure query defaults (staleTime, cacheTime)
• Write unit tests for hooks
• Document API structure

Technical Notes:

• May need to create REST API backend (Node.js/Express or Rust API)
• Use TanStack Query v5
• Handle authentication if needed

---

Issue #46: Set Up Real-Time Subscriptions (Optional)

Labels: epic-8, integration, real-time, priority-low
Milestone: Epic 8 - Backend Integration
Dependencies: #45

Description:
Implement real-time updates for assignments using WebSockets or Server-Sent Events.

Acceptance Criteria:

• Set up WebSocket or SSE connection
• Subscribe to assignment updates
• Update UI when new assignments are generated
• Handle connection errors and reconnection
• Show connection status indicator
• Write unit tests

Technical Notes:

• Optional feature for live updates
• May use Socket.io or native WebSocket
• Fallback to polling if WebSocket unavailable

---

Issue #47: Implement Authentication (if needed)

Labels: epic-8, backend, auth, priority-medium
Milestone: Epic 8 - Backend Integration
Dependencies: #45

Description:
Add authentication system if the app requires user login.

Acceptance Criteria:

• Decide on auth strategy (JWT, session-based, etc.)
• Create login page
• Implement login API hook
• Add auth context/provider
• Protect routes (if needed)
• Add logout functionality
• Handle token refresh
• Write unit tests

Technical Notes:

• May not be needed if app is internal/trusted
• Use React Context or Zustand for auth state

---