#!/bin/bash
# AEP donatii scraper — runs scrape-aep-donatii.ts in a node:22-alpine container.
# Mirrors enrich-anaf.sh / scrape-regas.sh: Infisical Machine Identity → env-file
# → docker run --env-file (NEVER -e $VAR), file deleted post-launch.
#
# Idempotent (uses ON CONFLICT (source_hash) DO UPDATE). Safe to run from cron.
#
# Args via env:
#   TABLE=pj|pf|rvc|all   (default: all — fetches all 3 datasets sequentially)
#   LIMIT=<int>           (default: 0 = no limit)

set -euo pipefail

TABLE="${TABLE:-all}"
LIMIT="${LIMIT:-0}"
LOG=/var/log/vreaudigital-aep.log

log() { echo "[$(date '+%Y-%m-%d %H:%M:%S')] $1" | tee -a "$LOG"; }

log "=== AEP donatii scrape started (table=$TABLE limit=$LIMIT) ==="

if docker ps --filter name=vreaudigital-aep --format '{{.Names}}' | grep -q '^vreaudigital-aep$'; then
  log "WARN: vreaudigital-aep already running, skipping this tick"
  exit 0
fi
docker rm -f vreaudigital-aep 2>/dev/null || true

# ── Fetch DATABASE_URL via Infisical Machine Identity ──
source /opt/vreaudigital/.infisical-mi
TOKEN=$(infisical login --method=universal-auth \
  --domain="$INFISICAL_API_URL" \
  --client-id="$INFISICAL_CLIENT_ID" \
  --client-secret="$INFISICAL_CLIENT_SECRET" \
  --silent --plain)

umask 077
ENVF=$(mktemp /tmp/.vreaudigital-env.XXXXXX)
DBURL=$(infisical secrets get DATABASE_URL \
  --domain="$INFISICAL_API_URL" \
  --projectId="$INFISICAL_PROJECT_ID" \
  --env="$INFISICAL_ENV" --path="$INFISICAL_PATH" \
  --token="$TOKEN" --plain --silent)
echo "DATABASE_URL=$DBURL" > "$ENVF"
unset DBURL TOKEN

# ── Launch detached docker container ──
cd /opt/vreaudigital/services/seap-scraper

if [ ! -d node_modules/tsx ]; then
  log "Installing seap-scraper deps..."
  docker run --rm -v "$(pwd):/work" -w /work --user "$(id -u):$(id -g)" \
    node:22-alpine npm install --omit=optional 2>&1 | tee -a "$LOG" >/dev/null
fi

EXTRA_ARGS=()
[ "$LIMIT" != "0" ] && EXTRA_ARGS+=("--limit=$LIMIT")

CID=$(docker run -d \
  --name vreaudigital-aep \
  --network host \
  --env-file "$ENVF" \
  -v "$(pwd):/work" \
  -w /work \
  --user "$(id -u):$(id -g)" \
  --restart no \
  node:22-alpine \
  npx tsx src/scrape-aep-donatii.ts \
    --table="$TABLE" \
    "${EXTRA_ARGS[@]}")
log "container started: $CID"

sleep 3
rm -f "$ENVF"
log "envfile cleaned"

docker wait vreaudigital-aep >/dev/null
EXIT_CODE=$(docker inspect -f '{{.State.ExitCode}}' vreaudigital-aep 2>/dev/null || echo "?")
docker logs vreaudigital-aep 2>&1 | tail -20 | tee -a "$LOG"
docker rm -f vreaudigital-aep 2>/dev/null || true
log "=== AEP donatii scrape done (exit=$EXIT_CODE) ==="

exit "$EXIT_CODE"