Sandbox::https://github.com/china-testing/python-api-tesing/blob/master/merge_testcase

Repository navigation

#!/usr/bin/python3

# -*- coding: utf-8 -*-

# Author: xurongzhong#126.com wechat:pythontesting qq:37391319

# CreateDate: 2018-1-8

# merge_testcase_reports.py

'''

汇总多天的测试报告。

使用方法：

参数input_directory：为包含测试报告的目录。

参数：output：为汇总测试的输出文件。

'''

import traceback

import re

import shutil

import os

import glob

import pandas

from data_common import maps, produce_xls

input_directory = r"D:\test3"

output = r"d:\output.xls"

def sum_report(input_directory,type_=0):

results = {}

for name in glob.glob('{0}{1}*.xls'.format(input_directory, os.sep)):

records = pandas.read_excel(name)

for seq in range(len(records)):

index = records.iloc[seq, 0]

if re.match(r'\d+', str(index)):

if not index in results:

results[index] = []

result = [records.iloc[seq, 2], records.iloc[seq, 3],

records.iloc[seq, 4], records.iloc[seq, 5],

records.iloc[seq, 6], ]

if type_ != 0:

result.insert(0,records.iloc[seq, 1])

results[index].append(result)

return results

results = sum_report(input_directory)

produce_xls(results, output, 50)