Persistent Task CRUD API

TaskFlow Phase 11 reference snapshot

This snapshot demonstrates the phase-end shape only.
Do not copy generated Prisma Client files or migration timestamps from documentation.
Generate them from your real schema and database state.

Run from apps/api:
  pnpm exec prisma validate
  pnpm exec prisma migrate dev --name add_taskflow_domain
  pnpm exec prisma generate
  pnpm exec ts-node prisma/seed.ts
  pnpm run build
  pnpm run start:dev

generator client {
  provider     = "prisma-client"
  output       = "../src/generated/prisma"
  moduleFormat = "cjs"
}

datasource db {
  provider = "postgresql"
}

enum MembershipRole {
  OWNER
  ADMIN
  MEMBER
}

enum TaskStatus {
  TODO
  IN_PROGRESS
  DONE

import "dotenv/config";
import { PrismaPg } from "@prisma/adapter-pg";
import {
  MembershipRole,
  PrismaClient,
} from "../src/generated/prisma/client";

const connectionString = process.env.DATABASE_URL;

if (!connectionString) {
  throw new Error("DATABASE_URL is required before running the seed.");
}

const prisma = new PrismaClient({
  adapter: new PrismaPg({ connectionString }),
});

async function main() {
  const user = await prisma.user.upsert({
    where: { email: "learner@taskflow.local" },

import { Module } from "@nestjs/common";
import { ConfigModule } from "@nestjs/config";
import { HealthModule } from "./health/health.module";
import { PrismaModule } from "./prisma/prisma.module";
import { TasksModule } from "./tasks/tasks.module";

@Module({
  imports: [
    ConfigModule.forRoot({ isGlobal: true }),
    PrismaModule,
    HealthModule,
    TasksModule,
  ],
})
export class AppModule {}

import {
  Body,
  Controller,
  Delete,
  Get,
  HttpCode,
  HttpStatus,
  Param,
  Patch,
  Post,
} from "@nestjs/common";
import { TasksService } from "./tasks.service";
import {
  CreateTaskInput,
  UpdateTaskInput,
} from "./tasks.types";

@Controller("tasks")
export class TasksController {
  constructor(private readonly tasksService: TasksService) {}

import { Module } from "@nestjs/common";
import { TasksController } from "./tasks.controller";
import { TasksService } from "./tasks.service";

@Module({
  controllers: [TasksController],
  providers: [TasksService],
})
export class TasksModule {}

import {
  Injectable,
  NotFoundException,
} from "@nestjs/common";
import { Prisma } from "../generated/prisma/client";
import { PrismaService } from "../prisma/prisma.service";
import {
  CreateTaskInput,
  UpdateTaskInput,
} from "./tasks.types";

@Injectable()
export class TasksService {
  constructor(private readonly prisma: PrismaService) {}

  findAll() {
    return this.prisma.task.findMany({
      orderBy: { createdAt: "desc" },
    });
  }

import {
  TaskPriority,
  TaskStatus,
} from "../generated/prisma/client";

// These are compile-time shapes only. Phase 12 replaces this temporary
// boundary with DTOs + runtime validation.
export type CreateTaskInput = {
  projectId: string;
  title: string;
  description?: string | null;
};

export type UpdateTaskInput = {
  title?: string;
  description?: string | null;
  status?: TaskStatus;
  priority?: TaskPriority;
};

import { getTasks } from "@/lib/api/tasks";

export default async function TasksPage() {
  const tasks = await getTasks();

  return (
    <main>
      <h1>Tasks</h1>

      {tasks.length === 0 ? (
        <p>No persisted tasks yet.</p>
      ) : (
        <ul>
          {tasks.map((task) => (
            <li key={task.id}>
              <strong>{task.title}</strong>
              {" - "}
              {task.status}
            </li>
          ))}

export type Task = {
  id: string;
  projectId: string;
  title: string;
  description: string | null;
  status: "TODO" | "IN_PROGRESS" | "DONE" | "CANCELED";
  priority: "LOW" | "MEDIUM" | "HIGH" | "URGENT";
  createdAt: string;
  updatedAt: string;
};

const API_BASE_URL = process.env.API_BASE_URL;

if (!API_BASE_URL) {
  throw new Error("API_BASE_URL is required.");
}

export async function getTasks(): Promise<Task[]> {
  const response = await fetch(`${API_BASE_URL}/tasks`, {
    cache: "no-store",