#!/usr/bin/env python3
"""Check every cell in this 12-row fixture. Reads local CSVs; never edits files."""
import csv,json,sys
from pathlib import Path
HEAD=['RowID','Item','Category','Quantity','Shelf','Status']
TARGETS={'003','007','011'}
def read(path):
    with Path(path).open(encoding='utf-8-sig',newline='') as f:return list(csv.reader(f))
def compare(before,after):
    if len(before)!=13 or before[0]!=HEAD or any(len(r)!=6 for r in before):
        raise ValueError('Original must be the six-column, twelve-record fixture.')
    if [r[0] for r in before[1:]]!=[f'{i:03}' for i in range(1,13)] or any(r[5]!='Pending' for r in before[1:]):
        raise ValueError('Original IDs/order/statuses do not match the untouched fixture.')
    expected=[r[:] for r in before]
    for row in expected[1:]:
        if row[0] in TARGETS:row[5]='Reviewed'
    changes=[];unexpected=[]
    for ri in range(max(len(before),len(after))):
        b=before[ri] if ri<len(before) else [];a=after[ri] if ri<len(after) else []
        for ci in range(max(len(b),len(a))):
            old=b[ci] if ci<len(b) else None;new=a[ci] if ci<len(a) else None
            if old!=new:
                change={'csv_row':ri+1,'row_id':b[0] if ri and b else None,'column':HEAD[ci] if ci<6 else f'extra_{ci+1}','before':old,'after':new}
                changes.append(change)
                if not (0<ri<13 and ci==5 and b[0] in TARGETS and new=='Reviewed'):unexpected.append(change)
    missing=sum(1 for ri in [3,7,11] if ri>=len(after) or len(after[ri])<6 or after[ri][0]!=before[ri][0] or after[ri][5]!='Reviewed')
    data_changes=sum(1 for c in changes if 1<c['csv_row']<=13 and c['column'] in HEAD)
    return {'success':after==expected,'records_expected':12,'records_observed':max(len(after)-1,0),'data_cells_checked':72,'header_cells_checked':6,'changed_data_cells':data_changes,'unchanged_data_cells':72-data_changes,'unchanged_records':sum(1 for i in range(1,13) if i<len(after) and before[i]==after[i]),'row_ids_and_order_preserved':len(after)==13 and all(after[i] and after[i][0]==before[i][0] for i in range(1,13)),'headers_preserved':bool(after) and after[0]==HEAD,'missing_expected_changes':missing,'unexpected_changes':unexpected,'actual_changes':changes}
def main():
    if len(sys.argv)!=3:
        print(json.dumps({'error':'Usage: python3 verify-row-edits.py fixture.csv your-after.csv'}));return 2
    try:report=compare(read(sys.argv[1]),read(sys.argv[2]))
    except (OSError,ValueError,csv.Error) as e:
        print(json.dumps({'error':str(e)}));return 2
    print(json.dumps(report,indent=2));return 0 if report['success'] else 1
if __name__=='__main__':sys.exit(main())
