#!/usr/bin/env bash
set -euo pipefail

export PATH=/usr/local/bin:/usr/bin:/bin
export HOME=/home/Pi5

LOG="$HOME/market_scrape.log"
SCRIPT="/var/www/html/scripts/scrape_to_db.py"

# Try common venv locations, or fall back to the active python in subshell
CANDIDATES=(
  "/var/www/html/scripts/myenv/bin/python"
  "/var/www/html/myenv/bin/python"
  "$HOME/myenv/bin/python"
)
PY="/home/Pi5/myenv/bin/python"

for p in "${CANDIDATES[@]}"; do
  if [ -x "$p" ]; then PY="$p"; break; fi
done

# Last resort: ask a login shell for 'which python' and hope it's the venv
if [ -z "${PY}" ]; then
  PY="$(/bin/bash -lc 'which python' || true)"
fi

{
  echo "[$(date '+%F %T')] ---- START ----"
  echo "USER: $(whoami)"
  echo "HOME: $HOME"
  echo "Resolved PY: ${PY:-<none>}"
  if [ -z "${PY}" ] || [ ! -x "${PY}" ]; then
    echo "ERROR: Could not find venv python. Edit this script and set PY to your venv's python."
    exit 1
  fi
  "$PY" -V
  echo "Running: $PY $SCRIPT"
  "$PY" "$SCRIPT"
  echo "Exit code: $?"
  echo "[$(date '+%F %T')] ---- END ----"
  echo
} >> "$LOG" 2>&1