test2.js

const { initializeApp, cert } = require('firebase-admin/app');
const { getFirestore } = require('firebase-admin/firestore');
const fs = require('fs');

const serviceAccount = JSON.parse(fs.readFileSync('./functions/serviceAccountKey.json', 'utf8'));
initializeApp({ credential: cert(serviceAccount) });

const db = getFirestore();

async function test() {
  const tracksSnap = await db.collection("tracks").get();
  const tracks = tracksSnap.docs.map(doc => doc.data());
  
  const usersSnap = await db.collection("users").get();
  const users = new Map();
  usersSnap.forEach(doc => users.set(doc.id, doc.data()));

  const getKey = (url) => {
    if (!url) return "";
    try {
      return decodeURIComponent(new URL(url).pathname.replace(/^\//, ''));
    } catch {
      return decodeURIComponent(url.replace(/^https?:\/\/[^\/]+\//, ''));
    }
  };

  const ownersMap = {};
  
  tracks.forEach(track => {
    const ownerInfo = {
       name: users.get(track.userId)?.displayName || "Inconnu",
       id: track.userId
    };
    if (track.url) ownersMap[getKey(track.url)] = ownerInfo;
    if (track.coverUrl) ownersMap[getKey(track.coverUrl)] = ownerInfo;
  });

  console.log("Found " + Object.keys(ownersMap).length + " mapped files from tracks.");
  console.log("Mapped Keys Example:", Object.keys(ownersMap).slice(0, 3));
  console.log("-------------------");
  // Let's pretend R2 returns these keys:
  const dummyR2Keys = [
    "uploads/1783554519480-Grey afternoonBOUNCES.wav",
    "uploads/1786207189317-poutchi v1.mp3"
  ];

  dummyR2Keys.forEach(key => {
    console.log("Match for " + key + " :", ownersMap[key]);
  });
}

test().catch(console.error);