"""Contrôles locaux du cas pédagogique. Aucun appel réseau, aucune évaluation LLM."""
from pathlib import Path
import sqlite3

base = Path(__file__).resolve().parent
connection = sqlite3.connect(":memory:")
connection.executescript((base / "cas.sql").read_text())
bad_sql = (base / "requete-a-relire.sql").read_text()
good_sql = (base / "correction-reference.sql").read_text()
bad = connection.execute(bad_sql).fetchone()[0]
good = connection.execute(good_sql).fetchone()[0]
assert bad == 30000, bad
assert good == 42000, good
ids = [row[0] for row in connection.execute(
    "SELECT id FROM orders WHERE status = 'paid' "
    "AND paid_at >= '2026-08-01' AND paid_at < '2026-09-01' ORDER BY id"
)]
assert ids == [2, 3, 4, 5, 8], ids
connection.execute("DELETE FROM orders WHERE status = 'paid'")
assert connection.execute(good_sql).fetchone()[0] == 0
connection.close()
print("Cas synthétique vérifié : requête initiale 30000 ; référence 42000 centimes.")
print("Bornes du mois, statut et ensemble vide contrôlés. Aucun modèle appelé.")