CRUD Operations

A full RESTful API for a resource.

GET All and POST

typescript
// app/api/posts/route.ts
import { prisma } from '@/lib/prisma';

export async function GET() {
  const posts = await prisma.post.findMany();
  return Response.json(posts);
}

export async function POST(request: Request) {
  const data = await request.json();
  const post = await prisma.post.create({ data });
  return Response.json(post, { status: 201 });
}

GET One, PUT, DELETE

typescript
// app/api/posts/[id]/route.ts
import { prisma } from '@/lib/prisma';

export async function GET(
  request: Request,
  props: { params: Promise<{ id: string }> }
) {
  const { id } = await props.params;
  const post = await prisma.post.findUnique({
    where: { id: parseInt(id) },
  });

  if (!post) {
    return Response.json({ error: 'Not found' }, { status: 404 });
  }

  return Response.json(post);
}

export async function PUT(
  request: Request,
  props: { params: Promise<{ id: string }> }
) {
  const { id } = await props.params;
  const data = await request.json();
  const post = await prisma.post.update({
    where: { id: parseInt(id) },
    data,
  });
  return Response.json(post);
}

export async function DELETE(
  request: Request,
  props: { params: Promise<{ id: string }> }
) {
  const { id } = await props.params;
  await prisma.post.delete({
    where: { id: parseInt(id) },
  });
  return new Response(null, { status: 204 });
}