生成认证事件审计日志

def solve():
    from pyodide.http import open_url
    from io import StringIO
    import pandas as pd, json
    keys_csv = open_url("https://data.zuihe.com/dbd/ms-iot/state_02/device_keys.csv").read()
    tokens_csv = open_url("https://data.zuihe.com/dbd/ms-iot/state_02/device_tokens.csv").read()
    keys = pd.read_csv(StringIO(keys_csv))
    tokens = pd.read_csv(StringIO(tokens_csv))
    def auth_event(device_id, event_type, result, timestamp):
        return json.dumps({'device_id':device_id,'event':event_type,'result':result,'ts':timestamp})
    events = []
    for _, k in keys.iterrows():
        evt = 'key_verified' if k['is_active'] else 'key_inactive'
        events.append(auth_event(k['device_id'], evt, 'ok' if k['is_active'] else 'rejected', 1748736000))
    revoked = tokens[tokens['is_revoked']==1]
    for _, t in revoked.iterrows():
        events.append(auth_event(t['device_id'], 'token_revoked', 'revoked', t['issued_at']))
    print(f"认证事件数: {len(events)}")
    for e in events[:5]: print(e)