Generate API Route

Generate a complete Next.js App Router API endpoint following Health Tracker 9000 patterns.

Usage

When user requests to create a new API endpoint, ask for:

1. Resource name (e.g., "water-intake", "sleep-log", "weight-tracking")
2. HTTP methods needed (GET, POST, DELETE, PUT, etc.)
3. Whether daily summary recalculation is needed (yes for health data, no for reference data)
4. Special validation or business logic needed

Implementation Pattern

Based on src/app/api/meals/route.ts pattern.

File Structure

Create file: src/app/api/{resource-name}/route.ts

import { NextResponse } from 'next/server';
import { ResourceRepository } from '@/lib/database/repositories/resourceRepository';
import { DailySummaryRepository } from '@/lib/database/repositories/dailySummaryRepository';
import { ProfileRepository } from '@/lib/database/repositories/profileRepository';
import { calculateHealthScore } from '@/lib/utils/healthScoring';
import { getDatabase } from '@/lib/database/connection';

export async function POST(request: Request) {
  const resourceRepo = new ResourceRepository();
  const summaryRepo = new DailySummaryRepository();

  try {
    const body = await request.json();
    const { date, ...otherFields } = body;

    const newRecord = resourceRepo.addResource({
      date,
      ...otherFields,
    });

    // Update daily summary if this is health-related data
    const summary = await summaryRepo.getDailySummary(date);
    if (summary) {
      const profileRepo = new ProfileRepository();
      const targets = profileRepo.calculateNutritionalTargets();

      const records = resourceRepo.getResourcesByDate(date);
      const dailyTotals = summaryRepo.calculateDailyTotals(records, summary.supplements);

      const scoreBreakdown = calculateHealthScore(dailyTotals, targets, {
        ...summary,
        records,
        totalNutrition: dailyTotals,
      });

      summaryRepo.saveDailySummary({
        date,
        totalNutrition: dailyTotals,
        healthScore: scoreBreakdown.total,
      });
    }

    return NextResponse.json(newRecord);
  } catch (error: any) {
    console.error('API Error:', error);
    return NextResponse.json({ error: error.message || 'Internal Server Error' }, { status: 500 });
  }
}

export async function DELETE(request: Request) {
  const { searchParams } = new URL(request.url);
  const id = searchParams.get('id');

  if (!id) return NextResponse.json({ error: 'ID required' }, { status: 400 });

  const resourceRepo = new ResourceRepository();
  const summaryRepo = new DailySummaryRepository();

  try {
    // Get date before deleting to update summary
    const stmt = getDatabase().prepare('SELECT date FROM table_name WHERE id = ?');
    const row = stmt.get(id) as any;
    const date = row?.date;

    resourceRepo.deleteResource(id);

    if (date) {
      const summary = await summaryRepo.getDailySummary(date);
      if (summary) {
        const profileRepo = new ProfileRepository();
        const targets = profileRepo.calculateNutritionalTargets();

        const records = resourceRepo.getResourcesByDate(date);
        const dailyTotals = summaryRepo.calculateDailyTotals(records, summary.supplements);

        const scoreBreakdown = calculateHealthScore(dailyTotals, targets, {
          ...summary,
          records,
          totalNutrition: dailyTotals,
        });

        summaryRepo.saveDailySummary({
          date,
          totalNutrition: dailyTotals,
          healthScore: scoreBreakdown.total,
        });
      }
    }

    return NextResponse.json({ success: true });
  } catch (error) {
    console.error('API Error:', error);
    return NextResponse.json({ error: 'Internal Server Error' }, { status: 500 });
  }
}

Key Conventions

• Use NextResponse.json() for all responses
• Always include try-catch with console.error('API Error:', error)
• Return proper HTTP status codes (400 for bad request, 500 for errors)
• Repository instances created at top of each handler
• Daily summary updates for date-based health data only
• DELETE endpoint should get date before deleting to update summary
• Use getDatabase().prepare() for raw SQL when needed

Steps

1. Ask user for resource name, HTTP methods, and whether daily summary recalculation needed
2. Create directory: src/app/api/{resource-name}/
3. Create file: route.ts in that directory
4. Generate imports based on methods needed
5. Generate handlers for requested HTTP methods
6. Add daily summary recalculation if health-related data
7. Format with Prettier (project uses Prettier)

Implementation Checklist

• [ ] Resource repository imported correctly
• [ ] Error handling with try-catch wrapper
• [ ] Daily summary updated (if applicable)
• [ ] Proper HTTP status codes
• [ ] ID validation in DELETE
• [ ] JSON response formatting