前段時間幫助測試人員開發(fā)一款工具，目的是從Monkey log中提取出crash和anr的相關(guān)信息，并且輸出成Excel表。

1. 分析Monkey log文件

crash信息

可以看出，出現(xiàn)crash信息開頭是“// CRASH: ”

anr信息

可以看出，出現(xiàn)了anr信息開頭是“ANR in ” ，需要提取的項開頭有“Reason: ”的。

2. 確認提取項

對于測試人員提bug來說，需要這個工具能夠提取出進程名、報錯類型和復現(xiàn)次數(shù)數(shù)據(jù)。

3. 實現(xiàn)思路

crash和anr信息提取的思路其實是一樣的，就以提取crash為例：

1. 提取每行開頭帶有“// CRASH: ”和“// Long Msg:”的數(shù)據(jù)
2. 記錄提取的信息和相應行數(shù)
3. 如果提取的進程名下面兩行沒有對應的錯誤信息，則說明是格式錯誤的數(shù)據(jù)
4. 對數(shù)據(jù)進行統(tǒng)計計數(shù)，統(tǒng)計每個進程、每個bug的復現(xiàn)次數(shù)。
5. 將處理好的數(shù)據(jù)通過openpyxl進行處理導出Excel

4. 代碼

from openpyxl import Workbook
from openpyxl.styles import Border, Side, Font, Alignment, NamedStyle
import os
import tkinter.filedialog as filedialog
from tkinter import *

"""
作者：Blue（應用開發(fā)部）
功能：統(tǒng)計MonkeyLog的crash和anr信息
版本：1.0
"""


class MonkeyLog(object):

    log_path = ''
    info_total = []
    info_final = []

    def __init__(self):
        if os.path.exists(os.path.dirname(os.path.abspath(self.log_path)) + '\log.xlsx'):
            os.remove(os.path.dirname(os.path.abspath(self.log_path)) + '\log.xlsx')

    def get_info(self, app_name, message, index):
        name = []
        detail = []
        lines_name = []
        lines_message = []
        wrong_lines = []
        i = 0
        with open(self.log_path, 'r', encoding='utf-8') as data:
            for x in data:
                i += 1
                if x.startswith(app_name):
                    name.append(x.split(' ')[2].replace('\n', ''))
                    lines_name.append(i)
                if x.startswith(message):
                    detail.append(' '.join(x.split(' ')[index:]).replace('\n', ''))
                    lines_message.append(i)

        for x in lines_message:
            if x - 2 not in lines_name:
                del detail[lines_message.index(x)]
                wrong_lines.append(str(x))

        for x in lines_name:
            if x + 2 not in lines_message:
                del name[lines_name.index(x)]
                wrong_lines.append(str(x))

        if len(name) != len(detail):
            print("Wrong message !!!!!!!")
        for i in range(len(name)):
            temp = [name[i], detail[i]]
            self.info_total.append(temp)

        print("========================================")
        if len(wrong_lines) != 0:
            if app_name == "http:// CRASH: ":
                print("Crash數(shù)據(jù)中，log文件格式錯誤的行數(shù)：")
                print('\n'.join(wrong_lines))
            else:
                print("ANR數(shù)據(jù)中，log文件格式錯誤的行數(shù)：")
                print('\n'.join(wrong_lines))

    def analyze_info(self):
        self.info_total.sort(key=lambda x: x[0])
        each_bug_num = self.count_bug(self.info_total)
        each_app_num = self.count_app(self.info_total)
        for i in range(len(each_app_num)):
            self.info_total[i].insert(0, each_app_num[i])
        for i in range(len(each_bug_num)):
            self.info_total[i].append(each_bug_num[i])
        for x in self.info_total:
            if x not in self.info_final:
                self.info_final.append(x)

    def write_excel(self, ws, title_style, content_style, content_long_style):
        ws.append(['總數(shù)', '進程名', '錯誤信息', '復現(xiàn)次數(shù)'])
        merge_line_num = self.count_merge(self.info_final)
        length = len(merge_line_num)
        if length == 1:
            ws.merge_cells('A%s:A%s' % (2, merge_line_num[-1]))
            ws.merge_cells('B%s:B%s' % (2, merge_line_num[-1]))
        else:
            if merge_line_num[0] != 2:
                ws.merge_cells('A%s:A%s' % (2, merge_line_num[0]))
                ws.merge_cells('B%s:B%s' % (2, merge_line_num[0]))
            for i in range(length):
                if i < length - 1:
                    if merge_line_num[i + 1] - merge_line_num[i] != 1:
                        ws.merge_cells('A%s:A%s' % (merge_line_num[i] + 1, merge_line_num[i + 1]))
                        ws.merge_cells('B%s:B%s' % (merge_line_num[i] + 1, merge_line_num[i + 1]))

        for x in self.info_final:
            ws.append(x)
        self.format_excel(ws, title_style, content_style, content_long_style)
        wb.save(os.path.dirname(os.path.abspath(self.log_path)) + "\log.xlsx")
        self.info_final.clear()
        self.info_total.clear()

        print("%s表數(shù)據(jù)已經(jīng)寫入." % ws.title)
        print("========================================\n")

    def count_app(self, info):
        temp_name = []
        temp_num = []
        for x in info:
            temp_name.append(x[0])
        for x in temp_name:
            temp_num.append(temp_name.count(x))
        return temp_num

    def count_bug(self, info):
        temp_num = []
        for x in info:
            temp_num.append(self.info_total.count(x))
        return temp_num

    def count_merge(self, info):
        temp_num = []
        length = len(info)
        for i in range(length):
            if i < length - 1:
                if info[i][1] != info[i + 1][1]:
                    temp_num.append(i + 2)
            else:
                temp_num.append(length + 1)
        return temp_num

    def format_excel(self, ws, title_style, content_style, content_long_style):
        ws.column_dimensions['A'].width = 8
        ws.column_dimensions['B'].width = 30
        ws.column_dimensions['C'].width = 100
        ws.column_dimensions['D'].width = 10
        for i in range(ws.max_row):
            ws.row_dimensions[i + 1].height = 30
        for x in ws[1]:
            x.style = title_style
        for x in ws['A:B']:
            for y in x:
                y.style = content_style
        for x in ws['C'][1:]:
            x.style = content_long_style
        for x in ws['D'][1:]:
            x.style = content_style

    @staticmethod
    def open_win():
        root = Tk()
        root.title("MonkeyLog 分析")
        ws = root.winfo_screenwidth()
        hs = root.winfo_screenheight()
        x = ws/2 - 400/2
        y = hs/2 - 200/2
        root.geometry("400x200+%d+%d" % (x, y))

        def callback():
            MonkeyLog.log_path = filedialog.askopenfilename()
            entry.insert(0, MonkeyLog.log_path)
        button = Button(root, text="選擇MonkeyLog文件", command=callback)
        quit_btn = Button(root, text="確定", command=root.destroy)
        entry = Entry(root)
        entry.pack(side=TOP, anchor="nw", fill=X, pady=40)
        button.pack(side=TOP)
        quit_btn.pack(side=TOP, pady=10)
        root.mainloop()

if __name__ == '__main__':
    MonkeyLog.open_win()

    crash = MonkeyLog()
    anr = MonkeyLog()
    wb = Workbook()

    left, right, top, bottom = [Side(style='thin', color='000000')] * 4
    title = NamedStyle(name="title")
    title.font = Font(name=u'宋體', size=11)
    title.alignment = Alignment(horizontal='center', vertical='center', wrap_text=True)
    title.border = Border(left=left, right=right, top=top, bottom=bottom)
    content = NamedStyle(name="content")
    content.font = Font(name=u'宋體', size=11)
    content.alignment = Alignment(horizontal='center', vertical='center', wrap_text=True)
    content.border = Border(left=left, right=right, top=top, bottom=bottom)
    content_long = NamedStyle(name="content_long")
    content_long.font = Font(name=u'宋體', size=11)
    content_long.border = Border(left=left, right=right, top=top, bottom=bottom)
    content_long.alignment = Alignment(horizontal='left', vertical='center', wrap_text=True)

    crash.get_info('// CRASH: ', '// Long Msg:', 3)
    crash.analyze_info()
    ws_crash = wb.active
    ws_crash.title = "crash"
    crash.write_excel(ws_crash, title, content, content_long)

    anr.get_info('ANR in', 'Reason:', 1)
    anr.analyze_info()
    ws_anr = wb.create_sheet("anr")
    anr.write_excel(ws_anr, title, content, content_long)
    print("數(shù)據(jù)已經(jīng)導出完畢，請到其log文件目錄下查看log.xlsx文件！")