#!/usr/bin/env bash
# odds_o1_*.db / odds_o2_*.db -> MySQL odds_lines
#
#   ./scripts/import_odds_sqlite.sh
#   ./scripts/import_odds_sqlite.sh /root/odds_o1_2020_2026.db /root/odds_o2_2020_2026.db
#
set -euo pipefail
O1="${1:-/root/odds_o1_2020_2026.db}"
O2="${2:-/root/odds_o2_2020_2026.db}"
ROOT="$(cd "$(dirname "$0")/.." && pwd)"
cd "$ROOT"
PY=(python3.11)
command -v "${PY[0]}" &>/dev/null || PY=(python3)

echo "=== MySQL before ==="
mysql keiba_ai -N -e "SELECT COUNT(DISTINCT race_id) FROM odds_lines WHERE odds_type='tansho';"
mysql keiba_ai -N -e "SELECT COUNT(DISTINCT race_id) FROM odds_lines WHERE odds_type='umaren';"

"${PY[@]}" collectors/import_odds_sqlite.py --o1 "$O1" --o2 "$O2" --from-year 2020 --to-year 2026

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