41 lines
2.5 KiB
Python
41 lines
2.5 KiB
Python
"""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()))
|