Function bodies 45 total

fixFirestore function · javascript · L24-L107 (84 LOC)

scripts/fix_firestore.js

async function fixFirestore() {
    console.log('🔥 Connecting to Firestore Project:', process.env.VITE_FIREBASE_PROJECT_ID);
    console.log('Scanning "business" collection for missing city/state...');

    try {
        const snapshot = await db.collection('business').get();
        if (snapshot.empty) {
            console.log('No businesses found.');
            return;
        }

        console.log(`Found ${snapshot.size} documents. Processing...`);

        let updatedCount = 0;
        let batch = db.batch();
        let batchCount = 0;
        const BATCH_SIZE = 400; // Limit is 500, playing safe

        for (const doc of snapshot.docs) {
            const b = doc.data();
            let needsUpdate = false;
            let updates = {};

            // Check if city/state is missing or clearly invalid (like numbers "15", "10" from previous bad script)
            // Or just check if we can parse better data

            // We only look at those with address
            if (b.

saveGooglePlaceToDb function · javascript · L2816-L2975 (160 LOC)

server/index_legacy.js

async function saveGooglePlaceToDb(place, defaultCity = '', defaultState = '') {
    const businessRef = db.collection('business');

    // 1. Parse Data FIRST (so we can update existing records if needed)
    let category = 'Outros';
    const types = place.types || [];
    if (types.includes('restaurant') || types.includes('food') || types.includes('meal_takeaway') || types.includes('bar') || types.includes('cafe')) category = 'Alimentação';
    else if (types.includes('bakery')) category = 'Padaria';
    else if (types.includes('pharmacy') || types.includes('drugstore')) category = 'Farmácia';
    else if (types.includes('health') || types.includes('doctor') || types.includes('hospital') || types.includes('dentist')) category = 'Saúde';
    else if (types.includes('gym')) category = 'Academia';
    else if (types.includes('supermarket') || types.includes('grocery_or_supermarket') || types.includes('convenience_store')) category = 'Mercado';
    else if (types.includes('shopping_mall

migrate function · javascript · L29-L82 (54 LOC)

server/scripts/migrate-country-code.js

async function migrate() {
  console.log('Starting migration: Add country_code to businesses...\n');

  const businessesRef = db.collection('businesses');
  const snapshot = await businessesRef.get();

  let updated = 0;
  let skipped = 0;
  let errors = 0;
  let batch = db.batch();
  let batchCount = 0;

  for (const doc of snapshot.docs) {
    const data = doc.data();

    // Skip if already has country_code
    if (data.country_code) {
      skipped++;
      continue;
    }

    try {
      batch.update(doc.ref, {
        country_code: 'BR',
        country: data.country || 'Brasil',
      });

      updated++;
      batchCount++;

      // Firestore batches have a 500 operation limit
      if (batchCount >= 499) {
        await batch.commit();
        console.log(`  Committed batch of ${batchCount} updates...`);
        batch = db.batch();
        batchCount = 0;
      }
    } catch (err) {
      console.error(`  Error updating doc ${doc.id}:`, err.message);
      errors++;
    }

seed function · javascript · L52-L76 (25 LOC)

server/seed.js

async function seed() {
    console.log('🌱 Seeding database...');

    for (const business of businesses) {
        try {
            const response = await fetch(API_URL, {
                method: 'POST',
                headers: { 'Content-Type': 'application/json' },
                body: JSON.stringify(business)
            });

            const data = await response.json();

            if (response.ok) {
                console.log(`✅ Created: ${business.name}`);
            } else {
                console.error(`❌ Failed to create ${business.name}:`, data);
            }
        } catch (error) {
            console.error(`❌ Error creating ${business.name}:`, error.message);
        }
    }

    console.log('✨ Seeding complete!');
}

CollectionReference class · javascript · L26-L110 (85 LOC)