"""Synthetic renewal migration acceptance exercise; standard library only."""
from collections import Counter
from copy import deepcopy
from datetime import date, timedelta
import json

ROWS = [
    dict(id='R1', account='A1', contract='C1', owner='O1', renewal='2027-03-01', lead_days=90, status='active'),
    dict(id='R2', account='A2', contract='C2', owner='O2', renewal='2027-01-15', lead_days=30, status='active'),
    dict(id='R3', account='A1', contract='C3', owner='O1', renewal='2027-04-01', lead_days=60, status='canceled'),
]
AS_OF = date(2026, 12, 1)

def queue(rows):
    return Counter((r['id'], r['owner'], r['contract']) for r in rows
                   if r['status'] == 'active' and
                   date.fromisoformat(r['renewal']) - timedelta(days=r['lead_days']) <= AS_OF)

def exact(rows):
    return Counter(tuple(sorted(r.items())) for r in rows)

candidates = {'Correct import': deepcopy(ROWS)}
for name, field, value in [
    ('Date shifted one day', 'renewal', '2027-03-02'),
    ('Owner reassigned', 'owner', 'O2'),
    ('Wrong contract link', 'contract', 'C2'),
    ('Lead window shortened', 'lead_days', 60),
]:
    rows = deepcopy(ROWS); rows[0][field] = value; candidates[name] = rows
rows = deepcopy(ROWS); rows[2]['status'] = 'active'; candidates['Canceled renewal reactivated'] = rows
rows = deepcopy(ROWS); rows[1]['renewal'] = '2027-01-16'; candidates['Future renewal shifted'] = rows
rows = deepcopy(ROWS); rows[1] = deepcopy(rows[0]); candidates['Duplicate replaces renewal'] = rows

if __name__ == '__main__':
    results = []
    for name, rows in candidates.items():
        results.append(dict(scenario=name, count_matches=len(rows)==len(ROWS),
                            exact_matches=exact(rows)==exact(ROWS),
                            queue_matches=queue(rows)==queue(ROWS),
                            queue_count=sum(queue(rows).values())))
    assert all(r['count_matches'] for r in results)
    assert sum(r['exact_matches'] for r in results) == 1
    assert sum(not r['queue_matches'] for r in results) == 5
    assert len(queue(ROWS)) == 1
    print(json.dumps(dict(as_of=AS_OF.isoformat(), source_rows=ROWS,
                         expected_queue=[list(k) for k in queue(ROWS).elements()], results=results), indent=2))
