cleanup-team.js

const mongoose = require('mongoose');
require('dotenv').config();
const TeamMember = require('./models/teamMemberModel');

async function cleanupDuplicates() {
    try {
        await mongoose.connect(process.env.MONGO_URL);
        console.log('Connected to MongoDB\n');

        // Find test members or duplicates
        const testMembers = await TeamMember.find({
            $or: [
                { displayName: /test/i },
                { displayName: /john doe/i },
                { category: /test/i },
                { email: /test@/i }
            ]
        });

        console.log(`Found ${testMembers.length} test/duplicate members:\n`);
        
        testMembers.forEach((member, index) => {
            console.log(`${index + 1}. ${member.displayName} (${member.email || 'no email'})`);
            console.log(`   ID: ${member._id}`);
            console.log(`   Member ID: ${member.memberId}\n`);
        });

        if (testMembers.length === 0) {
            console.log('No test members found!');
            process.exit(0);
        }

        // Delete all test members
        const deleteResult = await TeamMember.deleteMany({
            $or: [
                { displayName: /test/i },
                { displayName: /john doe/i },
                { category: /test/i },
                { email: /test@/i }
            ]
        });

        console.log(`\n✅ Deleted ${deleteResult.deletedCount} test members`);
        
        await mongoose.disconnect();
        console.log('Disconnected from MongoDB');
        process.exit(0);

    } catch (error) {
        console.error('Error:', error);
        process.exit(1);
    }
}

cleanupDuplicates();