fix-share-token-index.js

const mongoose = require('mongoose');
require('dotenv').config();

async function fixShareTokenIndex() {
  try {
    // Connect to MongoDB
    await mongoose.connect(process.env.MONGODB_URI, {
      useNewUrlParser: true,
      useUnifiedTopology: true,
    });
    // Connected to MongoDB

    const db = mongoose.connection.db;
    const collection = db.collection('projects');

    // Drop the existing shareToken index
    try {
      await collection.dropIndex('shareToken_1');
      // Dropped existing shareToken index
    } catch (error) {
      // No existing shareToken index to drop
    }

    // Create the new sparse index
    await collection.createIndex({ shareToken: 1 }, { sparse: true });
    // Created new sparse shareToken index

    // Verify the index was created
    const indexes = await collection.indexes();
    const shareTokenIndex = indexes.find(index =>
      index.key && index.key.shareToken === 1
    );

    if (shareTokenIndex) {
      // ShareToken index verified
    } else {
      // ShareToken index not found
    }

    // Migration completed successfully

  } catch (error) {
    // Error fixing shareToken index
  } finally {
    await mongoose.connection.close();
    // Disconnected from MongoDB
  }
}

fixShareTokenIndex();