"""Minimal approval audit; no action bodies, tokens, names or card text.""" import hashlib from .crypto import canonical EVENTS={'created','approved','rejected','consumed','expired','cancelled','card_bound', 'card_send_unknown','payload_purged'} STATES={'pending','approved','rejected','consumed','expired','cancelled'} ACTION_CLASSES={'work_api_read','work_api_write','work_api_delete','unknown'} class ApprovalAudit: def __init__(self,db,clock): self.db,self.clock=db,clock with db: db.execute('''CREATE TABLE IF NOT EXISTS work_approval_audit_v1( event_key TEXT PRIMARY KEY,environment TEXT NOT NULL,app_id TEXT NOT NULL, approval_id TEXT NOT NULL,task_scope TEXT NOT NULL,actor_scope TEXT NOT NULL, device_scope TEXT NOT NULL,binding_generation BIGINT NOT NULL, operation_digest TEXT NOT NULL,event TEXT NOT NULL,state TEXT NOT NULL,action_class TEXT NOT NULL, created_at DOUBLE PRECISION NOT NULL)''') db.execute('''CREATE INDEX IF NOT EXISTS work_approval_audit_time_v1 ON work_approval_audit_v1(environment,app_id,created_at)''') def record(self,row,event,action_class=None): # Caller owns the approval transaction and owner lock. Failure rolls # back the associated decision/consume instead of losing its audit. if event not in EVENTS or row['state']not in STATES:raise ValueError('invalid_approval_audit') scope=[row['environment'],row['app_id']] if action_class is None: created=self.db.execute('''SELECT action_class FROM work_approval_audit_v1 WHERE environment=? AND app_id=? AND approval_id=? AND event='created' ''', (*scope,row['approval_id'])).fetchone() action_class=created['action_class']if created else'unknown' if action_class not in ACTION_CLASSES:raise ValueError('invalid_approval_audit_class') def digest(kind,value):return hashlib.sha256(canonical([*scope,kind,value])).hexdigest() key=digest('audit',[row['approval_id'],event]) self.db.execute('''INSERT INTO work_approval_audit_v1 VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?) ON CONFLICT DO NOTHING''',(key,*scope,row['approval_id'],digest('task',row['task_id']), digest('actor',row['owner']),digest('device',row['host_id']),row['binding_generation'], row['operation_digest'],event,row['state'],action_class,self.clock()))