#!/usr/bin/env bash
# keiba.db の NL_HR（払戻）だけを MySQL payouts へ投入（回収率表示用）
#
#   ./scripts/import_keiba_payouts.sh /root/keiba.db 2020 2026
#
set -euo pipefail
SQLITE="${1:?usage: import_keiba_payouts.sh /path/to/keiba.db [from_year] [to_year]}"
FROM_Y="${2:-2020}"
TO_Y="${3:-2026}"
ROOT="$(cd "$(dirname "$0")/.." && pwd)"
cd "$ROOT"
PY=(python3.11)
command -v "${PY[0]}" &>/dev/null || PY=(python3)

echo "=== payouts before ==="
mysql keiba_ai -N -e "SELECT COUNT(*) FROM payouts;"
mysql keiba_ai -N -e "SELECT COUNT(DISTINCT race_id) FROM payouts WHERE bet_type='tansho';"

"${PY[@]}" collectors/import_jrvltsql_db.py \
  --sqlite "$SQLITE" \
  --from-year "$FROM_Y" \
  --to-year "$TO_Y" \
  --payouts-only

echo "=== payouts after ==="
mysql keiba_ai -N -e "SELECT COUNT(*) FROM payouts;"
mysql keiba_ai -N -e "SELECT COUNT(DISTINCT race_id) FROM payouts WHERE bet_type='tansho';"
mysql keiba_ai -N -e "SELECT COUNT(DISTINCT race_id) FROM payouts WHERE bet_type='umaren';"
mysql keiba_ai -N -e "SELECT COUNT(DISTINCT race_id) FROM payouts WHERE bet_type='umatan';"