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/backups/lavocat.quebec/backup-20250730-021618/scripts/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

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

const prisma = new PrismaClient();

async function testProfileAPI() {
  try {
    console.log('🔍 Testing Profile API...\n');

    // Get first user
    const user = await prisma.user.findFirst({
      select: {
        id: true,
        name: true,
        email: true,
        role: true,
        profilePicture: true,
        bio: true,
        isVerified: true,
        experience: true,
        languages: true,
        specializations: true,
        hourlyRate: true,
        averageRating: true,
        totalCases: true,
        wonCases: true,
        xpPoints: true,
        level: true
      }
    });

    if (!user) {
      console.log('❌ No users found in database');
      return;
    }

    console.log('✅ Found user:', user.name, `(${user.id})`);
    console.log('📧 Email:', user.email);
    console.log('👤 Role:', user.role);
    console.log('🏷️ Verified:', user.isVerified);
    console.log('⭐ XP Points:', user.xpPoints);
    console.log('📊 Level:', user.level);
    console.log('💼 Experience:', user.experience);
    console.log('🌍 Languages:', user.languages);
    console.log('🎯 Specializations:', user.specializations);
    console.log('💰 Hourly Rate:', user.hourlyRate);
    console.log('📈 Average Rating:', user.averageRating);
    console.log('📋 Total Cases:', user.totalCases);
    console.log('🏆 Won Cases:', user.wonCases);
    console.log('📝 Bio:', user.bio?.substring(0, 50) + '...');
    console.log('🖼️ Profile Picture:', user.profilePicture);

    // Test friends count
    const friendsCount = await prisma.friendship.count({
      where: { userId: user.id, status: 'accepted' }
    });
    console.log('👥 Friends:', friendsCount);

    // Test endorsements count
    const endorsementsCount = await prisma.endorsement.count({
      where: { endorsedUserId: user.id }
    });
    console.log('👍 Endorsements:', endorsementsCount);

    // Test cases count
    const casesCount = await prisma.legalCase.count({
      where: {
        OR: [
          { createdBy: user.id },
          { clientId: user.id },
          { leadLawyerId: user.id },
          { primaryLawyerId: user.id },
          { assistantLawyerId: user.id },
          { secretaryId: user.id }
        ]
      }
    });
    console.log('⚖️ Cases:', casesCount);

    console.log('\n✅ Profile API test completed successfully!');
    console.log(`\n🔗 Test URL: http://localhost:3000/profile/${user.id}`);

  } catch (error) {
    console.error('❌ Error testing profile API:', error);
  } finally {
    await prisma.$disconnect();
  }
}

testProfileAPI();