test-complete-event.js

import { createClient } from '@supabase/supabase-js';

// Initialize Supabase client with service role key
const supabaseUrl = 'https://spjnakucrrjvvdsahpom.supabase.co';
const supabaseServiceKey = 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJpc3MiOiJzdXBhYmFzZSIsInJlZiI6InNwam5ha3VjcnJqdnZkc2FocG9tIiwicm9sZSI6InNlcnZpY2Vfcm9sZSIsImlhdCI6MTc1MjkwOTA4NSwiZXhwIjoyMDY4NDg1MDg1fQ.kJWcHkRz8NPuK-JfboT_Eiyqm_yMIPmQFm3kJG0PO6Y';

const supabase = createClient(supabaseUrl, supabaseServiceKey);

async function testCompleteEvent() {
  console.log('🧪 Testing complete event creation...');
  
  try {
    const { data: newEvent, error } = await supabase
      .from('events')
      .insert({
        event_name: 'Annual Sports Day',
        event_date: '2024-08-15',
        description: 'Annual sports day celebration with various competitions and activities for all students.'
      })
      .select();
      
    if (error) {
      console.log('❌ Error:', error.message);
    } else {
      console.log('✅ Event created successfully!');
      console.log('📋 Available columns:', Object.keys(newEvent[0]));
      console.log('📄 Created event:', newEvent[0]);
    }
    
  } catch (err) {
    console.error('❌ Unexpected error:', err);
  }
}

testCompleteEvent().catch(console.error);