#!/usr/bin/env python3
import sqlite3

DB_PATH = "/home/h3r7/turf_scraper/turf.db"
conn = sqlite3.connect(DB_PATH)
c = conn.cursor()

# Add yesterday's Grok picks (from email)
picks = [
    ("2026-02-23", "Quinte Auteuil", "PASSIONATA", 8.1, 1),
    ("2026-02-23", "Quinte Auteuil", "GABISON", 7.5, 2),
    ("2026-02-23", "Quinte Auteuil", "EMSILORD", 5.2, 3),
]

for date, race, horse, odds, rank in picks:
    c.execute("INSERT INTO grok_predictions (date, race_name, horse_name, odds, rank) VALUES (?, ?, ?, ?, ?)",
              (date, race, horse, odds, rank))

conn.commit()
print("OK - Grok predictions added")

# Verify
c.execute("SELECT * FROM grok_predictions")
for row in c.fetchall():
    print(row)

conn.close()
