Function testQueryOptimizer

scripts/db/test-query-optimizer.ts:9–122

* Test script to verify query optimizer is working correctly

()

 */

async function testQueryOptimizer() {
  console.log("🚀 Testing Query Optimizer functionality...\n");

  try {
    const client = await mongoDb;

    // Test 1: Basic query optimizer functionality
    console.log("📊 Test 1: Basic Query Optimizer");
    const optimizer = createQueryOptimizer(client);

    // Simulate some queries
    const startTime = Date.now();

    // These would normally be separate queries, but optimizer batches them
    const db = client.db(process.env.DATABASE_NAME || 'pulse-db');
    const teamsCollection = db.collection('teams');
    const teamUsersCollection = db.collection('team-users');

    const teams = await teamsCollection.find({}).limit(5).toArray();
    const teamUsers = await teamUsersCollection.find({}).limit(5).toArray();

    const duration = Date.now() - startTime;
    const metrics = optimizer.getMetrics();

    console.log(`   ⏱️  Query duration: ${duration}ms`);
    console.log(`   📊 Metrics: ${metrics.queryCount} queries in ${metrics.duration}ms`);
    console.log(`   📁 Found ${teams.length} teams, ${teamUsers.length} team-users`);

    // Test 2: Query metrics wrapper
    console.log("\n📊 Test 2: Query Metrics Wrapper");

    const { result, metrics: wrapperMetrics } = await withQueryMetrics(client, async (opt) => {
      // Simulate fetching team data with collections
      const db = client.db(process.env.DATABASE_NAME || 'pulse-db');

      const teams = await db.collection('teams').find({}).limit(3).toArray();
      const collections = await db.collection('collections').find({}).limit(5).toArray();

      return {
        teams: teams.length,
        collections: collections.length
      };
    });

    console.log(`   📊 Wrapper result:`, result);
    console.log(`   ⏱️  Metrics: ${wrapperMetrics.queryCount} queries in ${wrapperMetrics.duration}ms`);

    // Test 3: Complex aggregation simulation (if we have data)
    if (teams.length > 0) {
      console.log("\n📊 Test 3: Complex Aggregation Performance");

      const aggregationStart = Date.now();

      // Test a complex aggregation pipeline
      const pipeline = [
        { $match: {} },
        {
          $lookup: {