Function testDatabaseConnection

scripts/db/test-optimization.ts:10–87

* Test script to verify database optimizations are working * Usage: npx tsx ./scripts/db/test-optimization.ts

()

 */

async function testDatabaseConnection() {
  console.log("🔍 Testing database connection and optimizations...\n");

  try {
    const client = await mongoDb;
    console.log("✅ Database connection successful");

    // Test connection pool with ping
    const adminDb = client.db('admin');
    const pingResult = await adminDb.command({ ping: 1 });
    console.log("✅ Database ping successful:", pingResult);

    // List existing collections
    const db = client.db(process.env.DATABASE_NAME || 'pulse-db');
    const collections = await db.listCollections().toArray();
    console.log("📦 Existing collections:", collections.map(c => c.name));

    if (collections.length === 0) {
      console.log("ℹ️  No collections exist yet - this is normal for new databases");
      console.log("   Indexes will be created automatically when collections are first used");
      return;
    }

    // Check indexes on existing collections
    console.log("\n🔍 Checking indexes on existing collections:");
    for (const collection of collections) {
      const coll = db.collection(collection.name);
      try {
        const indexes = await coll.indexes();
        console.log(`\n📁 Collection: ${collection.name}`);
        console.log(`   Indexes (${indexes.length}):`, indexes.map(i => i.name).join(', '));

        // Show custom indexes (not the default _id_ index)
        const customIndexes = indexes.filter(i => i.name !== '_id_');
        if (customIndexes.length > 0) {
          console.log("   ✅ Custom indexes found:", customIndexes.length);
        } else {
          console.log("   ⚠️  No custom indexes found");
        }
      } catch (error) {
        console.log(`   ❌ Could not get indexes for ${collection.name}:`, error);
      }
    }

    // Test query performance with a simple operation
    console.log("\n🚀 Testing query performance...");
    const startTime = Date.now();

    // Try to query existing collections
    for (const collection of collections) {
      const coll = db.collection(collection.name);
      try {
        const count = await coll.countDocuments({});
        console.log(`   📊 ${collection.name}: ${count} documents`);
      } catch (error) {
        console.log(`   ⚠️  Could not count documents in ${collection.name}`);
      }
    }