#!/usr/bin/env python3
"""
Debug script for Week 4 debate case functionality
Run this script to test if student debate cases are being retrieved correctly
"""

import os
import sys
sys.path.append(os.path.join(os.path.dirname(__file__), '..', 'src'))

# Import Supabase directly for testing
from supabase import create_client, Client

def debug_week4_debate_case():
    """Debug the Week 4 debate case functionality"""
    print("🔍 Debugging Week 4 Debate Case Functionality")
    print("=" * 60)
    
    # Test 1: Supabase Connection
    print("1. Testing Supabase Connection...")
    try:
        # Get credentials from environment variables
        url = os.getenv("SUPABASE_URL")
        key = os.getenv("SUPABASE_SERVICE_ROLE_KEY")  # Use service role key
        
        if not url or not key:
            print("   ❌ Missing Supabase credentials in environment variables")
            print(f"      SUPABASE_URL: {'Set' if url else 'Missing'}")
            print(f"      SUPABASE_SERVICE_ROLE_KEY: {'Set' if key else 'Missing'}")
            print("   💡 Make sure to set SUPABASE_SERVICE_ROLE_KEY environment variable")
            return
        
        # Create Supabase client directly with service role
        supabase = create_client(url, key)
        print("   ✅ Supabase connection successful (using service role)")
        
    except Exception as e:
        print(f"   ❌ Supabase connection error: {str(e)}")
        return
    
    # Test 2: Check if table exists
    print("\n2. Testing student_debate_case table...")
    try:
        response = supabase.table('student_debate_case').select('*').limit(1).execute()
        print(f"   ✅ Table accessible, found {len(response.data)} records")
    except Exception as e:
        print(f"   ❌ Table access error: {str(e)}")
        return
    
    # Test 3: List all records
    print("\n3. Listing all debate cases in table...")
    try:
        response = supabase.table('student_debate_case').select('*').execute()
        if response.data:
            print(f"   ✅ Found {len(response.data)} debate cases:")
            for i, case in enumerate(response.data, 1):
                print(f"      {i}. Student ID: {case.get('student_id', 'N/A')}")
                print(f"         Google Doc: {case.get('google_doc_link', 'N/A')}")
                print(f"         Description: {case.get('description', 'N/A')}")
                print(f"         Created: {case.get('created_at', 'N/A')}")
                print()
        else:
            print("   ❌ No debate cases found in table")
    except Exception as e:
        print(f"   ❌ Error listing cases: {str(e)}")
    
    # Test 4: Test with specific usernames
    print("\n4. Testing with specific usernames...")
    test_usernames = ["test_student", "student1", "demo_user", "admin"]
    
    for username in test_usernames:
        try:
            # Test the query directly
            response = supabase.table('student_debate_case').select('*').eq('student_id', username).order('created_at', desc=True).limit(1).execute()
            if response.data:
                print(f"   ✅ Found case for '{username}': {response.data[0].get('google_doc_link', 'N/A')}")
            else:
                print(f"   ❌ No case found for '{username}'")
        except Exception as e:
            print(f"   ❌ Error testing '{username}': {str(e)}")
    
    # Test 5: Check environment variables
    print("\n5. Checking environment variables...")
    try:
        url = os.getenv("SUPABASE_URL")
        key = os.getenv("SUPABASE_KEY")
        
        if url:
            print(f"   ✅ SUPABASE_URL found: {url[:20]}...")
        else:
            print("   ❌ SUPABASE_URL not found")
            
        if key:
            print(f"   ✅ SUPABASE_KEY found: {key[:10]}...")
        else:
            print("   ❌ SUPABASE_KEY not found")
    except Exception as e:
        print(f"   ❌ Error checking environment: {str(e)}")

if __name__ == "__main__":
    debug_week4_debate_case()