"""New editorial fixture, 2026-10-10. Synthetic data only.
Run: python3 example-check.py
This is not an original Deep Research harness or a production test.
"""
import sqlite3

db = sqlite3.connect(':memory:')
db.executescript('''
CREATE TABLE source(id TEXT PRIMARY KEY, amount INTEGER);
INSERT INTO source VALUES ('A',100),('B',200);
CREATE TABLE replay(id TEXT, amount INTEGER);
INSERT INTO replay VALUES ('A',100),('B',200),('B',200);
CREATE TABLE wrong_identity(id TEXT, amount INTEGER);
INSERT INTO wrong_identity VALUES ('B',200),('C',100);
''')
def scalar(query):
    return db.execute(query).fetchone()[0]

assert scalar('SELECT SUM(amount) FROM source') == 300
assert scalar('SELECT SUM(amount) FROM replay') == 500
assert scalar('SELECT COUNT(*) FROM replay') == 3
assert scalar('SELECT COUNT(DISTINCT id) FROM replay') == 2
# This deduplication works for this identical replay, not conflicting revisions.
assert scalar('SELECT SUM(amount) FROM (SELECT DISTINCT id,amount FROM replay)') == 300
assert scalar('SELECT SUM(amount) FROM wrong_identity') == 300
missing = db.execute('SELECT id FROM source EXCEPT SELECT id FROM wrong_identity').fetchall()
extra = db.execute('SELECT id FROM wrong_identity EXCEPT SELECT id FROM source').fetchall()
assert missing == [('A',)] and extra == [('C',)]
print('Replay: 500 rather than 300. Equal totals: 300, but A missing and C unexpected.')
print('Passed these synthetic cases only. Reconciliation needs an authoritative source.')