check_audit.py

import os
from supabase import create_client
from dotenv import load_dotenv

load_dotenv()
url = os.getenv('SUPABASE_URL')
key = os.getenv('SUPABASE_KEY')
supabase = create_client(url, key)

chat_data = supabase.table('chats').select('id, topics_json').eq('id', 66).execute().data
audit = chat_data[0].get('topics_json', {}).get('aacsb_audit', {})
print(f"Total papers in audit summary: {audit.get('summary', {}).get('total_papers')}")
print(f"Total papers returned in array: {len(audit.get('papers', []))}")