2_setup_data.js

const { connect, closeConnection } = require('./0_connection');

async function seedDatabase() {
    let db;
    try {
        db = await connect();

        // Clear existing collections
        await db.collection('users').deleteMany({});
        await db.collection('products').deleteMany({});
        await db.collection('orders').deleteMany({});
        await db.collection('comments').deleteMany({});

        // Insert sample users
        const users = await db.collection('users').insertMany([
            {
                username: "john_doe",
                email: "john@example.com",
                age: 28,
                created_at: new Date(),
                address: {
                    street: "123 Main St",
                    city: "New York",
                    country: "USA"
                },
                interests: ["tech", "sports", "reading"]
            },
            {
                username: "jane_smith",
                email: "jane@example.com",
                age: 24,
                created_at: new Date(),
                address: {
                    street: "456 Park Ave",
                    city: "Boston",
                    country: "USA"
                },
                interests: ["art", "music", "travel"]
            }
        ]);

        // Insert sample products
        const products = await db.collection('products').insertMany([
            {
                name: "Laptop Pro",
                price: 1299.99,
                description: "High-performance laptop",
                category: "Electronics",
                in_stock: true,
                tags: ["tech", "computers", "work"],
                specifications: {
                    cpu: "Intel i7",
                    ram: "16GB",
                    storage: "512GB SSD"
                }
            },
            {
                name: "Wireless Headphones",
                price: 199.99,
                description: "Noise-cancelling bluetooth headphones",
                category: "Electronics",
                in_stock: true,
                tags: ["audio", "wireless", "music"],
                specifications: {
                    battery: "20 hours",
                    connection: "Bluetooth 5.0",
                    weight: "250g"
                }
            }
        ]);

        // Insert sample orders
        await db.collection('orders').insertMany([
            {
                user_id: users.insertedIds[0],
                products: [{
                    product_id: products.insertedIds[0],
                    quantity: 1,
                    price: 1299.99
                }],
                total_amount: 1299.99,
                status: "completed",
                order_date: new Date(),
                shipping_address: {
                    street: "123 Main St",
                    city: "New York",
                    country: "USA"
                }
            }
        ]);

        // Insert sample comments
        await db.collection('comments').insertMany([
            {
                user_id: users.insertedIds[0],
                content: "Great product!",
                product_id: products.insertedIds[0],
                likes: 5,
                replies: [{
                    user_id: users.insertedIds[1],
                    content: "I agree!",
                    created_at: new Date()
                }],
                created_at: new Date()
            }
        ]);

        console.log('Database seeded successfully!');

    } catch (error) {
        console.error('Error seeding database:', error);
    } finally {
        if (db) {
            await closeConnection();
        }
    }
}

// Run the seeding function if this file is run directly
if (require.main === module) {
    seedDatabase();
}

module.exports = { seedDatabase };