testReport.py

#!/usr/bin/env python
# -*- coding: utf-8 -*-

from app import db
from utils.mango import *
from utils import common
from utils.helpers import ExcelHelper
import xlsxwriter
from io import BytesIO
import ast
import datetime
from bson import ObjectId

test_report_summary_map = {
    'projectName': '测试项目',
    'testDomain': '测试环境',
    'testCount': '用例总数',
    'passCount': '通过数',
    'failedCount': '失败数',
    'passRate': '通过率',
    'comeFrom': '报告来源',
    'executorNickName': '执行人',
    'createAt': '生成时间',
    'totalTestSpendingTimeInSec': '总耗时/s'
}

# 使用 dic_get 定位数据
test_report_detail_map = {
    "['testBaseInfo', 'name']": '用例名称',
    "['testBaseInfo', 'requestMethod']": '请求方法',
    "['testBaseInfo', 'url']": '请求地址',
    "['testBaseInfo', 'headers']": '请求头',
    "['testBaseInfo', 'cookies']": '请求Cookie',
    "['testBaseInfo', 'presendParams']": '请求参数',
    "['testBaseInfo', 'curl']": '复现 curl',
    "['testBaseInfo', 'checkHttpCode']": '状态码校验',
    "['responseHttpStatusCode']": '实际状态码',
    "['testBaseInfo', 'checkResponseData']": '数据校验',
    "['testBaseInfo', 'checkResponseNumber']": '数值校验',
    "['testBaseInfo', 'checkResponseSimilarity']": '相似度校验',
    "['responseData']": '实际数据',
    "['testConclusion']": '测试结论',
    "['testStartTime']": '测试开始时间',
    "['testBaseInfo', 'checkResponseTime']": '耗时校验/s',
    "['spendingTimeInSec']": '测试耗时/s',
}


# 类名定义 collection
class TestReport(Model):

    class Meta:
        database = db
        collection = 'testReport'


    # 字段
    _id = ObjectIdField()
    isDeleted = BooleanField(field_name='isDeleted', default=False)
    projectId = ObjectIdField()
    projectName = StringField()
    testDomain = StringField()
    createAt = DateField()
    lastUpdateTime = DateField()
    totalTestSpendingTimeInSec = FloatField()
    testCount = IntField()
    passCount = IntField()
    failedCount = IntField()
    passRate = StringField()
    testDetail = ArrayField()
    comeFrom = StringField()
    executorNickName = StringField()
    cronId = StringField()

    @classmethod
    def get_test_report_excel_bytes_io(cls, report_id):
        test_report = cls.find_one({'_id': ObjectId(report_id)})
        test_report = common.format_response_in_dic(test_report)

        bytes_io = BytesIO()
        workbook = xlsxwriter.Workbook(bytes_io, {'in_memory': True})

        summary_sheet = workbook.add_worksheet(u'测试报告概览')
        summary_sheet.freeze_panes(1, 0)
        detail_sheet = workbook.add_worksheet(u'测试报告详情')
        detail_sheet.freeze_panes(1, 0)

        # 设置测试报告表头 format

        header_style = workbook.add_format()
        header_style.set_bg_color("#00CCFF")
        header_style.set_color("#FFFFFF")
        header_style.set_bold()
        header_style.set_border()

        # 测试报告概览表头
        for index, value in enumerate(test_report_summary_map.values()):
            summary_sheet.write(0, index, value, header_style)

        # 设置测试报告概览每列宽度
        [ExcelHelper.ExcelSheetHelperFunctions.set_column_auto_width(summary_sheet, i)
         for i in range(len(test_report_summary_map.values()))]

        # 测试报告概览数据
        for index, value in enumerate(test_report_summary_map.keys()):
            summary_sheet.write(1, index, str(test_report.get(value, '(暂无此数据)')))

        test_details = test_report['testDetail']

        # 测试报告详情表头
        for index, value in enumerate(test_report_detail_map.values()):
            detail_sheet.write(0, index, value, header_style)

        # 设置测试报告详情每列宽度
        [ExcelHelper.ExcelSheetHelperFunctions.set_column_auto_width(detail_sheet, i)
         for i in range(len(test_report_detail_map.values()))]

        test_result_pass_style = workbook.add_format()
        test_result_pass_style.set_bg_color("#00ff44")
        test_result_pass_style.set_color("#FFFFFF")
        test_result_pass_style.set_bold()
        # test_result_pass_style.set_border()

        test_result_failed_style = workbook.add_format()
        test_result_failed_style.set_bg_color("#ff0026")
        test_result_failed_style.set_color("#FFFFFF")
        test_result_failed_style.set_bold()
        # test_result_failed_style.set_border()

        failed_curl_style = workbook.add_format()
        failed_curl_style.set_bg_color("#ffee00")
        # failed_curl_style.set_color("#FFFFFF")
        failed_curl_style.set_bold()
        # failed_curl_style.set_border()

        # 测试报告详情数据
        for index, locator in enumerate(test_report_detail_map.keys()):
            locator = ast.literal_eval(locator)
            for col_index, detail in enumerate(test_details):
                if 'testConclusion' in str(locator):
                    test_result = str(common.dict_get(detail, locator))
                    if '测试通过' in test_result:
                        detail_sheet.write(col_index + 1, index,
                                           test_result, test_result_pass_style)
                    else:
                        detail_sheet.write(col_index + 1, index,
                                           test_result, test_result_failed_style)
                elif 'curl' in str(locator):
                    test_result_status = str(common.dict_get(detail, ['status']))
                    if test_result_status == 'failed':
                        detail_sheet.write(col_index + 1, index,
                                           str(common.dict_get(detail, locator)), failed_curl_style)
                    else:
                        detail_sheet.write(col_index + 1, index, str(common.dict_get(detail, locator)))
                else:
                    pre_write_value = str(common.dict_get(detail, locator))
                    pre_write_value = '(空)' if pre_write_value == 'None' else pre_write_value
                    detail_sheet.write(col_index + 1, index, pre_write_value)

        workbook.close()

        bytes_io.seek(0)

        return bytes_io

    def __str__(self):
        return "createAt:{}"\
            .format(self.createAt)


if __name__ == '__main__':
    pass