FilesExpand file tree

 master

/

merge_testcase_reports.py

Copy path

BlameMore file actions

BlameMore file actions

Latest commit

 

History

History

History

47 lines (38 loc) · 1.26 KB

 master

/

merge_testcase_reports.py

Top

File metadata and controls

• Code
• Blame

47 lines (38 loc) · 1.26 KB

Raw

Copy raw file

Download raw file

Open symbols panel

Edit and raw actions

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

#!/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)