Spaces:
Paused
Paused
File size: 1,699 Bytes
c904036 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 | /**
* Migration Script: Add hostEligibilityStatus to existing users
* Run this script once to add the hostEligibilityStatus field to all users who don't have it
*/
const mongoose = require('mongoose');
const User = require('../Models/User');
require('dotenv').config();
async function migrateHostEligibilityStatus() {
try {
// Connect to MongoDB
await mongoose.connect(process.env.MONGO_URI || 'mongodb://localhost:27017/campverse', {
useNewUrlParser: true,
useUnifiedTopology: true,
});
console.log('Connected to MongoDB');
// Find all users without hostEligibilityStatus or with null/undefined hostEligibilityStatus
const usersToUpdate = await User.find({
$or: [
{ hostEligibilityStatus: { $exists: false } },
{ hostEligibilityStatus: null },
{ 'hostEligibilityStatus.status': { $exists: false } }
]
});
console.log(`Found ${usersToUpdate.length} users to update`);
// Update each user with default hostEligibilityStatus
let updatedCount = 0;
for (const user of usersToUpdate) {
await User.findByIdAndUpdate(user._id, {
$set: {
hostEligibilityStatus: { status: 'none' }
}
});
updatedCount++;
if (updatedCount % 100 === 0) {
console.log(`Updated ${updatedCount} users...`);
}
}
console.log(`Migration completed! Updated ${updatedCount} users.`);
// Close connection
await mongoose.connection.close();
console.log('Database connection closed');
process.exit(0);
} catch (error) {
console.error('Migration failed:', error);
process.exit(1);
}
}
// Run migration
migrateHostEligibilityStatus();
|