Function deleteQuestionHandler

src/actions/question/index.ts:154–228

(
  data: DeleteTypeQuestion,
)

  }
};
const deleteQuestionHandler = async (
  data: DeleteTypeQuestion,
): Promise<ReturnTypeDelete> => {
  const session = await getServerSession(authOptions);

  if (!session || !session.user.id) {
    return { error: 'Unauthorized' };
  }
  const userExists = await db.user.findUnique({
    where: { id: session.user.id },
  });
  if (!userExists) {
    return {
      error: 'User not found.',
    };
  }
  const { questionId } = data;

  const question = await db.question.findUnique({
    where: { id: questionId },
  });

  if (
    !question ||
    (question.authorId !== session.user.id && session.user.role !== ROLES.ADMIN)
  ) {
    return {
      error: 'Unauthorized: You can only delete question you have authored',
    };
  }

  try {
    await db.$transaction(async (prisma) => {
      // Function to recursively delete answers and their responses
      const deleteAnswers = async (answerId: number) => {
        const responses = await prisma.answer.findMany({
          where: { parentId: answerId },
        });

        for (const response of responses) {
          await deleteAnswers(response.id); // Recursively delete child responses
        }

        await prisma.answer.delete({
          where: { id: answerId },
        });
      };

      // Delete all answers (and their responses) associated with the question
      const answers = await prisma.answer.findMany({
        where: { questionId },
      });
      for (const answer of answers) {
        await deleteAnswers(answer.id);
      }

      // Now delete the question itself
      await prisma.question.delete({