index.js

import express from "express";
import { PrismaClient } from "@prisma/client";

const app = express();
const prisma = new PrismaClient();
app.use(express.json());
//get all users
app.get("/users", async (req, res) => {
  const users = await prisma.user.findMany();
  res.json(users);
});

//get a user by id
app.get("/users/:id", async (req, res) => {
  const { id } = req.params;
  try{
  const user = await prisma.user.findUnique({
    where: { id: parseInt(id) },
  });
  if (!user) {
    return res.status(404).send("User not found");
  }
  res.json(user);
  } catch (error) {
    res.status(500).send(error);
  }
});
//create a user
app.post("/users", async (req, res) => {
  const { name, email, age } = req.body;
  try{
  const user = await prisma.user.create({
    data: { name, email, age },
  });
  } catch (error) {
    res.status(500).send(error);
  }
});

//update a user (full update)
app.put("/users/:id", async (req, res) => {
  const { id } = req.params;
  const { name, email, age } = req.body;
  try{
  const user = await prisma.user.update({
    where: { id: parseInt(id) },
    data: { name, email, age },
  });
  res.json(user);
  } catch (error) {
    res.status(500).send(error);
  }
});
//update a user (partial update)
app.patch("/users/:id", async (req, res) => {
  const { id } = req.params;
  const { name, email, age } = req.body;
  try{
  const user = await prisma.user.update({
    where: { id: parseInt(id) },
    data: { name, email, age },
  });
  res.json(user);
  } catch (error) {
    res.status(500).send(error);
  }
});
//delete a user
app.delete("/users/:id", async (req, res) => {
  const { id } = req.params;
  try{
  const deletedUser = await prisma.user.delete({
    where: { id: parseInt(id) },
  });
  res.send(`User ${deletedUser.name} `);
  } catch (error) {
    res.status(404).send(error);
  }
});

app.listen(5432, () => {
  console.log("Server is running on port 5432");
});