scripts/test-supabase.js

require('dotenv').config();
const { createClient } = require('@supabase/supabase-js');

async function main() {
  try {
    const supabase = createClient(
      process.env.SUPABASE_URL,
      process.env.SUPABASE_SERVICE_ROLE_KEY
    );
    console.log('✅ Connected to Supabase');

    // Insert test data
    const testRecords = [
      {
        date: '2026-06-24',
        gold24k: 14500.50,
        silver999: 210.00,
        source: 'Test'
      },
      {
        date: '2026-06-25',
        gold24k: 14550.75,
        silver999: 212.50,
        source: 'Test'
      },
      {
        date: '2026-06-26',
        gold24k: 14490.00,
        silver999: 208.00,
        source: 'Test'
      }
    ];

    console.log('📝 Inserting test records...');
    const { error } = await supabase
      .from('price_records')
      .upsert(testRecords);

    if (error) {
      console.error('❌ Error inserting test data:', error);
    } else {
      console.log('✅ Test records inserted successfully!');
      
      // Now fetch them back
      console.log('📥 Fetching test records...');
      const { data, error: fetchError } = await supabase
        .from('price_records')
        .select('*');
        
      if (fetchError) {
        console.error('❌ Error fetching data:', fetchError);
      } else {
        console.log('✅ Fetched records:', data);
      }
    }

    console.log('\n🎉 Supabase test complete! Everything is working!');
    process.exit(0);
  } catch (err) {
    console.error('❌ Test failed:', err);
    process.exit(1);
  }
}

main();