seed.js

const mongoose = require('mongoose');
require('dotenv').config();
const Product = require('./models/product.model.js');
const User = require('./models/user.model.js');
const bcrypt = require('bcryptjs');
const axios = require('axios');

const YOUTUBE_API_KEY = process.env.YOUTUBE_API_KEY;
const SEARCH_QUERIES = [
    { q: "Full HTML Course", cat: "Programming", price: 0 },
    { q: "CSS Tailwind Course", cat: "Design", price: 19.99 },
    { q: "Python Programming Full Course", cat: "Programming", price: 29.99 },
    { q: "Machine Learning Course", cat: "Science", price: 49.99 },
    { q: "React JS Course", cat: "Programming", price: 0 }
];

mongoose.connect(process.env.MONGO_URI)
    .then(async () => {
        console.log("Connected to MongoDB");

        // 1. Setup Admin User
        await User.deleteMany({});
        const hashedPassword = await bcrypt.hash("shofi1234", 10);
        await User.create({
            email: "sayakumar9@gmail.com",
            password: hashedPassword
        });
        console.log("Admin user created: sayakumar9@gmail.com");

        // 2. Clear Products
        await Product.deleteMany({});
        console.log("Cleared existing products");

        // 3. Fetch from YouTube
        let allCourses = [];

        for (const query of SEARCH_QUERIES) {
            try {
                console.log(`Fetching videos for: ${query.q}...`);
                const response = await axios.get(`https://www.googleapis.com/youtube/v3/search`, {
                    params: {
                        part: 'snippet',
                        q: query.q,
                        type: 'video',
                        maxResults: 3, // Get top 3 for each topic
                        key: YOUTUBE_API_KEY
                    }
                });

                const videos = response.data.items.map(item => ({
                    name: item.snippet.title,
                    description: item.snippet.description,
                    price: query.price,
                    quantity: Math.floor(Math.random() * 100) + 10,
                    image: item.snippet.thumbnails.high?.url || item.snippet.thumbnails.default?.url,
                    category: query.cat,
                    videoUrl: `https://www.youtube.com/watch?v=${item.id.videoId}`
                }));

                allCourses = [...allCourses, ...videos];

            } catch (error) {
                console.error(`Failed to fetch for ${query.q}:`, error.message);
                // Fallback if quota exceeded or error
                allCourses.push({
                    name: `${query.q} (Manual Fallback)`,
                    description: `A great course about ${query.q}.`,
                    price: query.price,
                    quantity: 50,
                    image: "https://via.placeholder.com/320x180?text=Course",
                    category: query.cat,
                    videoUrl: "https://www.youtube.com"
                });
            }
        }

        await Product.insertMany(allCourses);
        console.log(`Database seeded with ${allCourses.length} courses from YouTube!`);
        process.exit(0);

    }).catch((err) => {
        console.log("Connection failed", err);
        process.exit(1);
    });