"""Independent read-only SQLite comparison for Order optimistic-write rounds."""
import copy
import json
import sqlite3
import sys
from pathlib import Path

if not __debug__:
    raise RuntimeError("Order P1 oracle requires Python assertions")
database, baseline, changes = map(Path, sys.argv[1:])
before = json.loads(baseline.read_text())
committed = json.loads(changes.read_text())
assert database.is_file(), "Missing native SQLite store"
with sqlite3.connect(database.resolve().as_uri() + "?mode=ro", uri=True) as connection:
    connection.row_factory = sqlite3.Row
    assert connection.execute("PRAGMA integrity_check").fetchone()[0] == "ok"
    assert not connection.execute("PRAGMA foreign_key_check").fetchall()
    tables = {"roots": "commerce_platform_data", "statuses": "order_status_data",
              "orders": "customer_order_data", "items": "order_item_data"}
    after = {key: [dict(row) for row in connection.execute(f'SELECT * FROM "{table}" ORDER BY id')]
             for key, table in tables.items()}
expected = copy.deepcopy(before)
assert len({entry["target"] for entry in committed}) == len(committed), "Multiple committed writes to one order"
for change in committed:
    candidates = [row for row in expected["orders"] if row["order_number"] == change["target"]]
    assert len(candidates) == 1
    row = candidates[0]
    assert row["version"] == 1
    actual = next(item for item in after["orders"] if item["id"] == row["id"])
    assert actual["update_time"] is not None
    # Timestamp representations differ; unchanged timestamps are possible within clock resolution.
    row.update(order_note=change["note"], version=2, update_time=actual["update_time"])
assert after == expected, "Unexpected persistence: only winning order_note/version/update_time may change"
print(json.dumps(after, sort_keys=True))
