import csv
from datetime import datetime

today = datetime.now().strftime('%Y%m%d')
filename = f'工作台接口性能测试_{today}.csv'

print("="*100)
print("工作台接口性能测试结果")
print("="*100)

with open(filename, 'r', encoding='utf-8-sig') as f:
    reader = csv.DictReader(f)
    rows = list(reader)
    
    print(f"\n{'接口':<55} {'方法':<8} {'状态码':<10} {'耗时(ms)':<12} {'成功':<8}")
    print("-"*100)
    
    for row in rows:
        endpoint = row['endpoint'][:53]
        method = row['method']
        status = row['status_code']
        time_ms = row['elapsed_time_ms']
        success = '✓' if row['success'] == 'True' else '✗'
        
        print(f"{endpoint:<55} {method:<8} {status:<10} {time_ms:<12} {success:<8}")
    
    print("-"*100)
    
    # 统计
    times = [float(r['elapsed_time_ms']) for r in rows if r['elapsed_time_ms'] != '0']
    if times:
        print(f"\n平均耗时: {sum(times)/len(times):.2f}ms")
        print(f"最大耗时: {max(times):.2f}ms")
        print(f"最小耗时: {min(times):.2f}ms")
        
        # 按接口分类统计
        overview_times = [float(r['elapsed_time_ms']) for r in rows if 'overview' in r['endpoint']]
        recent_times = [float(r['elapsed_time_ms']) for r in rows if 'recent-publishes' in r['endpoint'] and float(r['elapsed_time_ms']) > 0]
        hot_times = [float(r['elapsed_time_ms']) for r in rows if 'hot-products' in r['endpoint'] and float(r['elapsed_time_ms']) > 0]
        
        if overview_times:
            print(f"\n工作台概览平均耗时: {sum(overview_times)/len(overview_times):.2f}ms")
        if recent_times:
            print(f"最近发布平均耗时: {sum(recent_times)/len(recent_times):.2f}ms")
        if hot_times:
            print(f"热门产品平均耗时: {sum(hot_times)/len(hot_times):.2f}ms")