47 lines
1.8 KiB
Python
47 lines
1.8 KiB
Python
|
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")
|