将sysbench累积摘要转换为csv

import re
import csv

# 读取摘要文件
with open('summary.txt', 'r') as file:
    summary = file.read()

# 提取关键信息
test_type = re.search('test type: (.+)', summary).group(1)
threads = re.search('threads: (\d+)', summary).group(1)
total_time = re.search('total time: (\d+\.\d+)s', summary).group(1)
requests = re.search('total number of events: (\d+)', summary).group(1)
avg_response_time = re.search('avg:.+?(\d+\.\d+)ms', summary).group(1)

# 创建csv文件
with open('summary.csv', 'w', newline='') as file:
    writer = csv.writer(file)

    # 写入表头
    writer.writerow(['Test Type', 'Threads', 'Total Time', 'Requests', 'Avg Response Time'])

    # 写入数据
    writer.writerow([test_type, threads, total_time, requests, avg_response_time])

# 打印转换结果
print('sysbench累积摘要已成功转换为csv格式！')