Create src/pages/api/projects.ts

[otto-jacob]

Summary:

Create the API endpoint src/pages/api/projects.ts. Here is the description: Next.js API route for projects. Be sure to add the proper extension when creating the file. Here are the instructions:

Issue Description

In this issue, we will create a Next.js API route for managing projects. The API route will be located at src/pages/api/projects.ts. This route will handle the following actions:

• GET: Retrieve a list of all projects for the authenticated user.
• POST: Create a new project for the authenticated user.

Step-by-step Instructions

1. Create a new file named projects.ts inside the src/pages/api directory.

2. Import the necessary modules and types:

import { NextApiRequest, NextApiResponse } from "next";
import { Prisma } from "@prisma/client";
import { z } from "zod";
import { prisma } from "~/server/db";
import { getServerAuthSession } from "~/server/auth";
import { User, Project, projectSchema } from "~/src/types";

3. Define the handler function with the following signature:

const handler = async (req: NextApiRequest, res: NextApiResponse) => {
  // Implementation goes here
};

4. Inside the handler function, call getServerAuthSession({ req, res }) to retrieve the user's session. If there is no session, return a 401 Unauthorized status code and an error message:

const session = await getServerAuthSession({ req, res });
if (!session) {
  res.status(401).json({ error: "Unauthorized" });
  return;
}

5. Now, handle the different request methods (GET and POST) using a switch statement:

switch (req.method) {
  case "GET":
    // Handle GET requests
    break;
  case "POST":
    // Handle POST requests
    break;
  default:
    res.setHeader("Allow", ["GET", "POST"]);
    res.status(405).end(`Method ${req.method} Not Allowed`);
}

6. For the GET case, query the database to retrieve all projects for the authenticated user:

const projects = await prisma.project.findMany({
  where: { userId: session.user.id },
});

7. Validate the retrieved projects using the projectSchema from the types.ts file:

const validatedProjects = projects.map((project) => projectSchema.parse(project));

8. Return the validated projects as a JSON response:

res.status(200).json(validatedProjects);

9. For the POST case, first, validate the request body using a Zod schema:

const createProjectSchema = z.object({
  name: z.string(),
  description: z.string(),
});

const { name, description } = createProjectSchema.parse(req.body);

10. Create a new project in the database for the authenticated user:

const newProject = await prisma.project.create({
  data: {
    name,
    description,
    userId: session.user.id,
  },
});

11. Validate the created project using the projectSchema from the types.ts file:

const validatedProject = projectSchema.parse(newProject);

12. Return the validated project as a JSON response:

res.status(201).json(validatedProject);

13. Finally, export the handler function as the default export:

export default handler;

Summary

In this issue, we created a Next.js API route for managing projects at src/pages/api/projects.ts. The route supports GET and POST methods for retrieving a list of projects and creating a new project for the authenticated user. We used the getServerAuthSession function for authentication, Prisma for database interaction, and Zod for data validation.

[otto-jacob]

Hello human! 👋

This PR was created by Otto to address the issue Create src/pages/api/projects.ts

Next Steps

1. Please review the PR carefully. Auto-generated code can and will contain subtle bugs and mistakes.

2. If you identify code that needs to be changed, please reject the PR with a specific reason. Be as detailed as possible in your comments. Otto will take these comments, make changes to the code and push up changes. Please note that this process will take a few minutes.

3. Once the code looks good, approve the PR and merge the code.

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

Name	Status	Preview	Comments	Updated (UTC)
otto-playground	✅ Ready (Inspect)	Visit Preview	💬 Add feedback	Jun 6, 2023 7:39pm