setup.sh

#!/bin/bash
set -e

echo "CodeArena setup starting..."

# 1. Check Docker
if ! command -v docker &> /dev/null; then
  echo "Docker is not installed. Please install Docker first."
  exit 1
fi

if ! command -v docker-compose &> /dev/null; then
  echo "docker-compose is not installed."
  exit 1
fi

echo "Docker found"

# 2. Start core services
echo "Starting Postgres and Redis..."
docker-compose up -d postgres redis

# 3. Wait for Postgres
echo "Waiting for Postgres to be ready..."
sleep 5

# 4. Apply DB schema
echo "Applying database schema..."
docker exec -i codearena-postgres-1 psql -U rankforge rankforge < db/schema.sql
docker exec -i codearena-postgres-1 psql -U rankforge rankforge < db/penalties.sql
docker exec -i codearena-postgres-1 psql -U rankforge rankforge < db/leaderboard_events.sql

# 5. Grant permissions
echo "Granting DB permissions..."
docker exec -i codearena-postgres-1 psql -U rankforge rankforge <<EOF
GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO rankforge;
ALTER DEFAULT PRIVILEGES IN SCHEMA public GRANT ALL ON TABLES TO rankforge;
EOF

echo "Database ready"

# 6. Final instructions
echo ""
echo "Setup complete!"
echo ""
echo "Next steps:"
echo "  docker-compose up --build"
echo ""
echo "Frontend: http://localhost:3001"
echo "API:      http://localhost:3000"