#!/bin/bash
# Run analytics migration on Supabase
set -e

cd /workspace/maya3_data

# Load .env
if [ -f .env ]; then
    export $(grep -v '^#' .env | xargs)
fi

if [ -z "$DATABASE_URL" ]; then
    echo "ERROR: DATABASE_URL not set"
    exit 1
fi

echo "Connecting to database..."
echo "Running analytics migration (Steps 8-15)..."

# Extract analytics section and run it
sed -n '118,313p' scripts/supabase_migrations.sql | psql "$DATABASE_URL" -v ON_ERROR_STOP=1

echo "Migration complete!"
echo ""
echo "Verifying tables..."
psql "$DATABASE_URL" -c "SELECT table_name FROM information_schema.tables WHERE table_schema='public' AND table_name IN ('worker_heartbeats', 'worker_metrics', 'processing_events', 'error_logs');"