#!/usr/bin/env python3
"""Verify illustrative driver rows for FIN-DRIVER-20260823."""

from __future__ import annotations

import csv
import pathlib
import sys

EXPECTED = [
    ("price", "-140", "total_driver"),
    ("mix", "90", "total_driver"),
    ("freight", "40", "total_driver"),
    ("mapping_miss", "20", "total_driver"),
    ("rebate_true_up", "60", "component_of_price"),
]


def main() -> int:
    path = pathlib.Path(__file__).with_name("driver-table-FIN-DRIVER-20260823.csv")
    with path.open(newline="", encoding="utf-8") as handle:
        rows = [
            (row["driver"], row["variance_usd_k"], row["relationship"])
            for row in csv.DictReader(handle)
        ]
    if rows != EXPECTED:
        print("FAIL: driver rows do not match the desk log.", file=sys.stderr)
        return 1
    print("OK: driver rows match desk run FIN-DRIVER-20260823.")
    return 0


if __name__ == "__main__":
    raise SystemExit(main())