Server : Apache/2 System : Linux server-15-235-50-60 5.15.0-164-generic #174-Ubuntu SMP Fri Nov 14 20:25:16 UTC 2025 x86_64 User : gositeme ( 1004) PHP Version : 8.2.29 Disable Function : exec,system,passthru,shell_exec,proc_close,proc_open,dl,popen,show_source,posix_kill,posix_mkfifo,posix_getpwuid,posix_setpgid,posix_setsid,posix_setuid,posix_setgid,posix_seteuid,posix_setegid,posix_uname Directory :  /home/gositeme/domains/lavocat.quebec/private_html/scripts/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

const { PrismaClient } = require('@prisma/client');

const prisma = new PrismaClient();

async function deleteCaseComments() {
  try {
    const caseId = 'cmcpzyax8000avjz0ao7zkw1g';
    
    console.log('Checking comments for case:', caseId);
    
    // Find all comments for this case
    const comments = await prisma.caseComment.findMany({
      where: { caseId },
      include: { user: true }
    });
    
    console.log(`Found ${comments.length} comments for case ${caseId}:`);
    
    if (comments.length === 0) {
      console.log('No comments found to delete.');
      return;
    }
    
    // Show all comments
    comments.forEach((comment, index) => {
      console.log(`${index + 1}. ID: ${comment.id}`);
      console.log(`   User: ${comment.user.name} (${comment.user.email})`);
      console.log(`   Content: ${comment.content.substring(0, 100)}...`);
      console.log(`   Deleted: ${comment.isDeleted}`);
      console.log(`   Created: ${comment.createdAt}`);
      console.log('');
    });
    
    // Delete all comments
    console.log('Deleting all comments...');
    
    for (const comment of comments) {
      await prisma.caseComment.update({
        where: { id: comment.id },
        data: { isDeleted: true }
      });
      console.log(`✓ Deleted comment: ${comment.id}`);
    }
    
    console.log(`\nSuccessfully deleted ${comments.length} comments for case ${caseId}`);
    
  } catch (error) {
    console.error('Error:', error);
  } finally {
    await prisma.$disconnect();
  }
}

deleteCaseComments();