test-media-setup.ts

/**
 * Test script for Media System Setup
 *
 * This script tests:
 * 1. Database tables exist
 * 2. Storage buckets are created
 * 3. MediaService can be instantiated
 *
 * Run with: npx tsx test-media-setup.ts
 */

import { createClient } from '@supabase/supabase-js';
import type { Database } from './packages/database/src/database.types';

const SUPABASE_URL = process.env.NEXT_PUBLIC_SUPABASE_URL || '';
const SUPABASE_ANON_KEY = process.env.NEXT_PUBLIC_SUPABASE_ANON_KEY || '';

async function testMediaSetup() {
  console.log('🧪 Testing Media System Setup...\n');

  if (!SUPABASE_URL || !SUPABASE_ANON_KEY) {
    console.error('❌ Missing Supabase credentials in environment variables');
    console.log('   Make sure NEXT_PUBLIC_SUPABASE_URL and NEXT_PUBLIC_SUPABASE_ANON_KEY are set');
    process.exit(1);
  }

  const supabase = createClient<Database>(SUPABASE_URL, SUPABASE_ANON_KEY);

  // Test 1: Check if media table exists
  console.log('1️⃣  Testing media table...');
  try {
    const { data, error } = await supabase
      .from('media')
      .select('count')
      .limit(1);

    if (error) throw error;
    console.log('   ✅ Media table exists and is accessible');
  } catch (error: any) {
    console.error('   ❌ Media table error:', error.message);
    return;
  }

  // Test 2: Check if storage buckets exist
  console.log('\n2️⃣  Testing storage buckets...');
  const expectedBuckets = ['team-logos', 'user-avatars', 'league-sponsors', 'team-media', 'season-media'];

  try {
    const { data: buckets, error } = await supabase.storage.listBuckets();

    if (error) throw error;

    const bucketNames = buckets?.map(b => b.name) || [];

    for (const expectedBucket of expectedBuckets) {
      if (bucketNames.includes(expectedBucket)) {
        console.log(`   ✅ Bucket "${expectedBucket}" exists`);
      } else {
        console.log(`   ❌ Bucket "${expectedBucket}" is missing`);
      }
    }
  } catch (error: any) {
    console.error('   ❌ Storage buckets error:', error.message);
    return;
  }

  // Test 3: Check if reference columns were added
  console.log('\n3️⃣  Testing table modifications...');

  // Test teams.logo_media_id
  try {
    const { data, error } = await supabase
      .from('teams')
      .select('logo_media_id')
      .limit(1);

    if (error && error.message.includes('column')) {
      console.log('   ⚠️  teams.logo_media_id column not found (table might not exist yet)');
    } else {
      console.log('   ✅ teams.logo_media_id column exists');
    }
  } catch (error: any) {
    console.log('   ⚠️  Could not check teams table');
  }

  // Test leagues.sponsor_media_id
  try {
    const { data, error } = await supabase
      .from('leagues')
      .select('sponsor_media_id, logo_media_id')
      .limit(1);

    if (error && error.message.includes('column')) {
      console.log('   ⚠️  leagues media columns not found');
    } else {
      console.log('   ✅ leagues.sponsor_media_id and logo_media_id columns exist');
    }
  } catch (error: any) {
    console.log('   ⚠️  Could not check leagues table');
  }

  // Test 4: Try inserting a test media record (will fail without auth, but tests structure)
  console.log('\n4️⃣  Testing media table structure...');
  try {
    const testMedia = {
      filename: 'test.jpg',
      original_filename: 'test.jpg',
      file_size: 1024,
      mime_type: 'image/jpeg',
      storage_path: 'test/test.jpg',
      media_type: 'image' as const,
      context_type: 'team_logo' as const,
      team_id: '00000000-0000-0000-0000-000000000000', // Fake UUID
      is_public: true,
      tags: ['test'],
      description: 'Test media',
      metadata: {}
    };

    const { error } = await supabase
      .from('media')
      .insert(testMedia)
      .select();

    // We expect this to fail with auth or FK constraint error, not structure error
    if (error) {
      if (error.message.includes('column') || error.message.includes('does not exist')) {
        console.log('   ❌ Media table structure error:', error.message);
      } else if (error.message.includes('violates foreign key') || error.message.includes('RLS')) {
        console.log('   ✅ Media table structure is correct (RLS/FK error is expected without proper auth)');
      } else {
        console.log('   ✅ Media table structure appears correct');
        console.log('      (Error:', error.message, ')');
      }
    } else {
      console.log('   ⚠️  Test insert succeeded (unexpected - should fail without auth)');
    }
  } catch (error: any) {
    console.log('   ⚠️  Could not test insert:', error.message);
  }

  console.log('\n✨ Setup test complete!\n');
  console.log('📋 Summary:');
  console.log('   - Database migrations have been applied');
  console.log('   - Storage buckets are configured');
  console.log('   - Media table is ready for use');
  console.log('\n🎯 Next steps:');
  console.log('   - Frontend components are ready to be built');
  console.log('   - MediaService can be used in API routes');
  console.log('   - Test with actual file uploads once auth is set up');
}

testMediaSetup().catch(console.error);