#!/usr/bin/env bash
# keiba.db の NL_O1（確定単勝オッズ）を odds_lines / race_entries.odds_win へ投入
#
#   ./scripts/import_keiba_odds.sh /root/keiba.db 2020 2026
#
set -euo pipefail
SQLITE="${1:?usage: import_keiba_odds.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 "=== odds before ==="
mysql keiba_ai -N -e "SELECT COUNT(*) FROM odds_lines WHERE odds_type='tansho';"
mysql keiba_ai -N -e "SELECT COUNT(DISTINCT race_id) FROM odds_lines WHERE odds_type='tansho';"

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

echo "=== odds after ==="
mysql keiba_ai -N -e "SELECT COUNT(*) FROM odds_lines WHERE odds_type='tansho';"
mysql keiba_ai -N -e "SELECT COUNT(DISTINCT race_id) FROM odds_lines WHERE odds_type='tansho';"