setup-db.js

const { MongoClient } = require('mongodb');
require('dotenv').config();

const MONGODB_URI = process.env.MONGODB_URI || 'mongodb://localhost:27017';
const DB_NAME = process.env.DB_NAME || 'userdb';

async function setupDatabase() {
  let client;
  
  try {
    console.log('🔌 Connecting to MongoDB...');
    client = new MongoClient(MONGODB_URI);
    await client.connect();
    
    const db = client.db(DB_NAME);
    const usersCollection = db.collection('users');
    
    console.log('🗑️  Clearing existing users collection...');
    await usersCollection.deleteMany({});
    
    console.log('📝 Inserting sample users...');
    const sampleUsers = [
      {
        name: "John Doe",
        email: "johndoe@email.com",
        age: 30
      },
      {
        name: "Jane Smith",
        email: "janesmith@email.com",
        age: 25
      },
      {
        name: "Bob Johnson",
        email: "bobjohnson@email.com",
        age: 19
      },
      {
        name: "Alice Brown",
        email: "alicebrown@email.com",
        age: 28
      },
      {
        name: "Charlie Wilson",
        email: "charliewilson@email.com",
        age: 22
      }
    ];
    
    const result = await usersCollection.insertMany(sampleUsers);
    console.log(`✅ Successfully inserted ${result.insertedCount} users`);
    
    // Display the inserted users with their IDs
    console.log('\n📋 Sample users (with IDs):');
    const users = await usersCollection.find({}).toArray();
    users.forEach(user => {
      console.log(`   ID: ${user._id} | Name: ${user.name} | Age: ${user.age} | Email: ${user.email}`);
    });
    
    console.log('\n🎯 Users over 21 (will be returned by API):');
    const usersOver21 = users.filter(user => user.age > 21);
    usersOver21.forEach(user => {
      console.log(`   ID: ${user._id} | Name: ${user.name} | Age: ${user.age}`);
    });
    
    console.log('\n🚫 Users 21 or younger (will NOT be returned by API):');
    const usersUnder21 = users.filter(user => user.age <= 21);
    usersUnder21.forEach(user => {
      console.log(`   ID: ${user._id} | Name: ${user.name} | Age: ${user.age}`);
    });
    
    console.log('\n✨ Database setup completed!');
    console.log('💡 You can now test the API with the user IDs shown above.');
    
  } catch (error) {
    console.error('❌ Database setup failed:', error);
  } finally {
    if (client) {
      await client.close();
    }
  }
}

// Only run if this file is executed directly
if (require.main === module) {
  setupDatabase();
}

module.exports = { setupDatabase };