Skip to content

🐸 Rybbit - open-source and privacy-friendly alternative to Google Analytics that is 10x more intuitive.

1.6 KB
Raw Blame
import { eq } from "drizzle-orm";
import { FastifyReply, FastifyRequest } from "fastify";
import { db } from "../../../db/postgres/postgres.js";
import { dashboards } from "../../../db/postgres/schema.js";

export async function deleteDashboard(
  request: FastifyRequest<{
    Params: {
      siteId: string;
      dashboardId: string;
    };
  }>,
  reply: FastifyReply
) {
  const siteId = parseInt(request.params.siteId, 10);
  const dashboardId = parseInt(request.params.dashboardId, 10);

  if (isNaN(siteId) || siteId <= 0) {
    return reply.status(400).send({ error: "Invalid site ID" });
  }
  if (isNaN(dashboardId) || dashboardId <= 0) {
    return reply.status(400).send({ error: "Invalid dashboard ID" });
  }

  try {
    const dashboardToDelete = await db.query.dashboards.findFirst({
      where: eq(dashboards.dashboardId, dashboardId),
    });

    if (!dashboardToDelete) {
      return reply.status(404).send({ error: "Dashboard not found" });
    }

    if (dashboardToDelete.siteId !== siteId) {
      return reply.status(403).send({ error: "Dashboard does not belong to the specified site" });
    }

    // The route guard enforces dashboards:write on the site.
    const result = await db
      .delete(dashboards)
      .where(eq(dashboards.dashboardId, dashboardId))
      .returning({ deleted: dashboards.dashboardId });

    if (!result || result.length === 0) {
      return reply.status(500).send({ error: "Failed to delete dashboard" });
    }

    return reply.send({ success: true });
  } catch (error) {
    request.log.error({ err: error }, "Error deleting dashboard");
    return reply.status(500).send({ error: "Failed to delete dashboard" });
  }
}