entrypoint.sh

#!/bin/bash
set -e

# Seed the persistent volume with database files on first deploy.
# Check for a known file (hedge_funds.csv) rather than emptiness,
# since Railway volumes may contain internal metadata even when fresh.
if [ ! -f /app/database/hedge_funds.csv ]; then
    echo "📦 Seeding database volume with initial data..."
    cp -r /app/database-seed/* /app/database/
    echo "✅ Database seeded."
else
    echo "✅ Database volume already populated."
fi

# Generate .env file from Railway environment variables if it doesn't exist.
# The app reads API keys from the .env file on disk, not process env vars.
if [ ! -f /app/.env ]; then
    echo "📝 Generating .env from environment variables..."
    env_file="/app/.env"
    [ -n "$FMP_API_KEY" ]        && echo "FMP_API_KEY=$FMP_API_KEY" >> "$env_file"
    [ -n "$GOOGLE_API_KEY" ]     && echo "GOOGLE_API_KEY=$GOOGLE_API_KEY" >> "$env_file"
    [ -n "$GROQ_API_KEY" ]       && echo "GROQ_API_KEY=$GROQ_API_KEY" >> "$env_file"
    [ -n "$HF_TOKEN" ]           && echo "HF_TOKEN=$HF_TOKEN" >> "$env_file"
    [ -n "$OPENFIGI_API_KEY" ]   && echo "OPENFIGI_API_KEY=$OPENFIGI_API_KEY" >> "$env_file"
    [ -n "$OPENROUTER_API_KEY" ] && echo "OPENROUTER_API_KEY=$OPENROUTER_API_KEY" >> "$env_file"
    echo "✅ .env file created."
else
    echo "✅ .env file already exists."
fi

# Apply pending Postgres migrations (idempotent — alembic skips applied revisions).
# Skipped when DATABASE_URL is unset (e.g. CSV-only legacy mode for self-hosters).
# An explicit error message + non-zero exit makes a misconfig (wrong password,
# unreachable host, missing privileges) visible in `docker logs` instead of
# the generic Python traceback you'd get with `set -e` alone.
if [ -n "$DATABASE_URL" ]; then
    echo "🔧 Applying Alembic migrations..."
    if ! alembic upgrade head; then
        echo "❌ Alembic migration failed. Check DATABASE_URL, credentials, and that the DB is reachable." >&2
        exit 1
    fi
    echo "✅ Migrations up to date."
else
    echo "⚠️ DATABASE_URL not set — skipping migrations (CSV-only mode)."
fi

exec "$@"