debug_conditions.py

"""Debug: fetch first live game id and query its conditions."""
import os
import json
import requests
from dotenv import load_dotenv
load_dotenv()

url = (os.getenv("AZURO_SUBGRAPH_URL") or "").strip()
if not url:
    print("AZURO_SUBGRAPH_URL not set")
    exit(1)
# Get one game id from live query
q_live = """
query Live($from: Int!, $to: Int!) {
  games(first: 1, where: { sport_: { slug: "football" }, startsAt_gte: $from, startsAt_lte: $to }, subgraphError: allow) {
    id
    gameId
    startsAt
    participants { name sortOrder }
  }
}
"""
import time
now = int(time.time())
r = requests.post(url, json={"query": q_live, "variables": {"from": now - 7200, "to": now + 900}}, timeout=15)
print("Live games status:", r.status_code)
data = r.json()
if data.get("errors"):
    print("Errors:", data["errors"])
games = (data.get("data") or {}).get("games") or []
if not games:
    print("No games")
    exit(0)
g = games[0]
game_id = g.get("id")
print("Game id:", game_id)
# Query conditions
# Try without status filter (data-feed subgraph may use different schema)
q_cond = """
query GameConditions($id: String!) {
  game(id: $id) {
    id
    conditions {
      conditionId
      outcomes { outcomeId currentOdds }
    }
  }
}
"""
r2 = requests.post(url, json={"query": q_cond, "variables": {"id": game_id}}, timeout=15)
print("Conditions status:", r2.status_code)
print(json.dumps(r2.json(), indent=2)[:2000])