console.log("🔄 Detecting missing teamSeasons and loading them into the cache...");

// Fetch all teamSeasons currently in cache
const cachedTeamSeasons = await bbgm.idb.cache.teamSeasons.getAll();
const cachedSeasons = new Set(cachedTeamSeasons.map(ts => ts.season));

// Identify available seasons in IndexedDB by fetching them one by one
const allSeasons = new Set();
for (let year = 2020; year <= bbgm.g.get("season"); year++) {  // Adjust 2020 to earliest possible season
    const seasonEntries = await bbgm.idb.getCopies.teamSeasons({ season: year });

    if (seasonEntries.length > 0) {
        allSeasons.add(year);
    }
}

console.log(`📅 Seasons stored in IndexedDB: ${[...allSeasons].join(", ")}`);
console.log(`📌 Cached seasons: ${[...cachedSeasons].join(", ")}`);

// Identify missing seasons (not in cache but exist in IndexedDB)
const missingSeasons = [...allSeasons].filter(season => !cachedSeasons.has(season));

if (missingSeasons.length === 0) {
    console.log("✅ All teamSeasons are already loaded into the cache. No action needed.");
} else {
    console.log(`⚠️ Missing seasons detected: ${missingSeasons.join(", ")}`);
    let addedToCache = 0;

    for (const year of missingSeasons) {
        const seasonEntries = await bbgm.idb.getCopies.teamSeasons({ season: year });

        if (seasonEntries.length > 0) {
            for (const entry of seasonEntries) {
                await bbgm.idb.cache.teamSeasons.put(entry);
                addedToCache++;
            }
            console.log(`✅ Successfully added ${seasonEntries.length} entries for ${year} to cache.`);
        } else {
            console.log(`⚠️ No teamSeasons found for ${year}. Data may be lost.`);
        }
    }

    console.log(`🎯 Total added entries to cache: ${addedToCache}`);
}

// Re-fetch teamSeasons to verify update
const updatedTeamSeasons = await bbgm.idb.cache.teamSeasons.getAll();
const updatedSeasons = new Set(updatedTeamSeasons.map(ts => ts.season));

console.log("\n📊 Final Cached Seasons After Update:");
console.log([...updatedSeasons].join(", "));