import sqlite3 from collections import defaultdict def process_stats(log_file_path): summary = defaultdict(lambda: { 'total_count': 0 }) try: conn = sqlite3.connect(log_file_path) cursor = conn.cursor() cursor.execute('SELECT component, level, position, sample as sample, count FROM log_stats') rows = cursor.fetchall() conn.close() except Exception as e: print(f"Error processing {log_file_path}: {str(e)}") for component, level, position, log_content, count in rows: key = (component, level) entry = summary[key] # 累加总数 entry['total_count'] += count result = [] for key in summary: component, level = key entry = summary[key] result.append({ 'component': component, 'level': level, 'total': entry['total_count'] }) return result