verify_supabase.py

"""Verify data in Supabase"""
from supabase import create_client
from dotenv import load_dotenv
import os

load_dotenv()

SUPABASE_URL = os.getenv("SUPABASE_URL")
SUPABASE_KEY = os.getenv("SUPABASE_KEY")

supabase = create_client(SUPABASE_URL, SUPABASE_KEY)

print("=" * 60)
print("Verifying Supabase Data")
print("=" * 60)

try:
    # Count total species
    all_species = supabase.table("species").select("*").execute()
    print(f"\n✓ Total species in database: {len(all_species.data)}")
    
    # Count by type
    mushrooms = supabase.table("species").select("*").eq("species_type", "mushroom").execute()
    plants = supabase.table("species").select("*").eq("species_type", "plant").execute()
    
    print(f"  - Mushrooms: {len(mushrooms.data)}")
    print(f"  - Plants: {len(plants.data)}")
    
    # Show first 5 species
    print(f"\n📋 First 5 species in database:")
    print("-" * 60)
    for i, species in enumerate(all_species.data[:5], 1):
        print(f"{i}. {species['species_name']} ({species['species_type']})")
        print(f"   Location: {species['location']}")
        print(f"   Coordinates: {species['latitude']}, {species['longitude']}")
        print()
    
    # Show last 5 species
    print(f"📋 Last 5 species in database:")
    print("-" * 60)
    for i, species in enumerate(all_species.data[-5:], len(all_species.data)-4):
        print(f"{i}. {species['species_name']} ({species['species_type']})")
        print(f"   Location: {species['location']}")
        print()
    
    print("=" * 60)
    print("✓ Verification Complete!")
    print("=" * 60)
    print(f"\nYou can view your data at:")
    print(f"{SUPABASE_URL}/project/default/editor (Table Editor)")
    
except Exception as e:
    print(f"✗ Error: {e}")