Function deleteNestedAnswers

src/actions/answer/index.ts:141–155

(parentId: number)

    await db.$transaction(async (prisma) => {
      // Function to recursively delete answers and decrement totalReplies
      const deleteNestedAnswers = async (parentId: number) => {
        const childAnswers = await prisma.answer.findMany({
          where: { parentId },
        });

        for (const childAnswer of childAnswers) {
          await deleteNestedAnswers(childAnswer.id); // Recursively delete children
          await prisma.answer.delete({ where: { id: childAnswer.id } });
          // Decrement totalReplies for each child answer
          await prisma.answer.update({
            where: { id: parentId },
            data: { totalanswers: { decrement: 1 } },
          });
        }
      };

      // Delete all nested answers recursively
      await deleteNestedAnswers(answerId);