#!/usr/bin/env python3 """Recalculate a saved public extract; never query an upstream API.""" import argparse import json from datetime import date from fractions import Fraction from pathlib import Path LEASE_ROWS=[{'id':'L1','kind':'new','monthly':80},{'id':'L2','kind':'new','monthly':80}, {'id':'L3','kind':'renewed','monthly':60},{'id':'L4','kind':'renewed','monthly':60}, {'id':'L5','kind':None,'monthly':100}] def calculate(saved): rows=[];summaries=[] for snapshot in saved['snapshots']: saved_day=date.fromisoformat(snapshot['saved_at_kst'][:10]);part=[] for index,record in enumerate(snapshot['records'],1): # Source extract has contract date and snapshot timestamp, no reporting event timestamp. contract=date.fromisoformat(record['date']);gap=(saved_day-contract).days if gap<0:raise ValueError('Contract after snapshot date') part.append({'snapshot_month':snapshot['contract_month'],'row_number':index,'contract_date':contract.isoformat(), 'snapshot_saved_at_kst':snapshot['saved_at_kst'],'calendar_day_gap':gap, 'reporting_timestamp_in_extract':False,'source_field_names':sorted(record['source_fields'])}) rows.extend(part) summaries.append({'month':snapshot['contract_month'],'records':len(part), 'min_gap':min(x['calendar_day_gap'] for x in part),'max_gap':max(x['calendar_day_gap'] for x in part), 'reporting_timestamps_in_extract':0}) scenarios=[] for assignment in [None,'new','renewed']: groups={key:[] for key in ['new','renewed','unknown']} for r in LEASE_ROWS:groups[r['kind'] or assignment or 'unknown'].append(r['monthly']) values={key:{'count':len(v),'mean_exact':str(Fraction(sum(v),len(v))) if v else None, 'mean_rounded':f'{sum(v)/len(v):.2f}' if v else None} for key,v in groups.items()} scenarios.append({'unknown_assignment':assignment,'groups':values}) assert len(rows)==36 assert [(x['records'],x['min_gap'],x['max_gap']) for x in summaries]==[(23,30,60),(13,13,35)] assert scenarios[1]['groups']['new']['mean_exact']=='260/3' assert scenarios[2]['groups']['renewed']['mean_exact']=='220/3' return {'kind':'saved extract recalculation plus explicitly synthetic lease scenarios', 'source_provenance':saved['provenance'],'source_snapshots':summaries,'calendar_rows':rows, 'limits':'Calendar gaps are not reporting delay. Reporting timestamps are absent from this stored extract; no claim about every upstream field. Lease rows are synthetic, not observed contracts.', 'lease_rows_synthetic':LEASE_ROWS,'lease_scenarios':scenarios} if __name__=='__main__': parser=argparse.ArgumentParser();parser.add_argument('--input',type=Path,required=True);parser.add_argument('--output',type=Path,required=True);args=parser.parse_args() result=calculate(json.loads(args.input.read_text())) with args.output.open('x') as output:json.dump(result,output,ensure_ascii=False,indent=2);output.write('\n')