#!/usr/bin/env bash
# jrvltsql の keiba.db を MySQL races へ投入し件数確認
#
#   ./scripts/import_keiba_db.sh /tmp/keiba.db 2020 2026
#
set -euo pipefail
SQLITE="${1:?usage: import_keiba_db.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 "=== before ==="
mysql keiba_ai -N -e "SELECT YEAR(race_date),COUNT(*) FROM races WHERE circuit='JRA' AND YEAR(race_date) BETWEEN ${FROM_Y} AND ${TO_Y} GROUP BY 1 ORDER BY 1;"

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

echo "=== after ==="
mysql keiba_ai -N -e "SELECT YEAR(race_date),COUNT(*) FROM races WHERE circuit='JRA' AND YEAR(race_date) BETWEEN ${FROM_Y} AND ${TO_Y} GROUP BY 1 ORDER BY 1;"
mysql keiba_ai -N -e "SELECT COUNT(*) FROM races WHERE circuit='JRA' AND YEAR(race_date)=2020;"
mysql keiba_ai -N -e "SELECT COUNT(*) AS payouts_total, COUNT(DISTINCT race_id) AS races_with_tansho FROM payouts WHERE bet_type='tansho';"