[dts] [PATCH 1/2] framework: add new module to create email report
Qiu, Michael
michael.qiu at intel.com
Mon Feb 16 06:02:19 CET 2015
On 2/16/2015 12:45 PM, Yong Liu wrote:
> This module will parse excel result file and create email like below.
>
> Summary: Run XXX cases (PASS-Count FAIL-Count BLOCK-Count)
> Latest commit log:
> Kernel Version:
> CPU info:
> GCC Version:
Here I don't see any place try to show this field
Thanks,
Michael
> Target: x86_64-native-linuxapp-gcc FAIL:XXX/YYY
> Detail information of failed cases:
> Target: x86_64-native-linuxapp-gcc
> Test Case Result
> Case name FAILED
>
> Signed-off-by: Marvinliu <yong.liu at intel.com>
>
> diff --git a/framework/email_report.py b/framework/email_report.py
> new file mode 100644
> index 0000000..38e390c
> --- /dev/null
> +++ b/framework/email_report.py
> @@ -0,0 +1,132 @@
> +import argparse # prase arguments module
> +import smtplib # send email module
> +from email.mime.text import MIMEText
> +from email.mime.multipart import MIMEMultipart
> +
> +from excel_reporter import ExcelReporter # excel parse module
> +from texttable import Texttable # formatted output module
> +
> +rece_maillist = ["dts at dpdk.org"]
> +from_maillist = "sys_stv at intel.com"
> +
> +# Global variable
> +total_target = 0
> +global os_type
> +global test_type
> +global git_commit
> +global dut_config
> +dut_config = []
> +os_type = ""
> +test_type = ""
> +git_commit = ""
> +
> +
> +# Format of Email
> +class Email():
> +
> + def __init__(self, excel):
> + self.subject_format = "%s %s Test Report"
> + self.summary_format = "Summary: Run %d cases (PASS-%d FAIL-%d BLOCK-%d)"
> + self.result_summary_format = "Target: %-30s FAIL:%d/%d\r\n"
> + excel = ExcelReporter(excel)
> + self.result = excel.load()
> + self.smtp = smtplib.SMTP()
> + self.smtp.connect("mail.intel.com", 25)
> +
> + def subject(self):
> + return self.subject_format % (os_type, test_type)
> +
> + def summary(self):
> + total = 0
> + passed = 0
> + fail = 0
> + block = 0
> + for dut in self.result.all_duts():
> + targets = self.result.all_targets(dut)
> + for target in targets:
> + suites = self.result.get_target_suites(dut, target)
> + results = self.result.get_suites_status(suites)
> + total += len(results)
> + passed += results.count("PASSED")
> + fail += results.count("FAILED")
> + block += results.count("BLOCKED")
> +
> + return self.summary_format % (total, passed, fail, block)
> +
> + def target_summary(self):
> + summary = ""
> + for dut in self.result.all_duts():
> + targets = self.result.all_targets(dut)
> + for target in targets:
> + suites = self.result.get_target_suites(dut, target)
> + results = self.result.get_suites_status(suites)
> + summary += self.result_summary_format % (target, results.count("FAILED"), len(results))
> + return summary
> +
> + def failed_case_summary(self):
> + summary = ""
> + for dut in self.result.all_duts():
> + targets = self.result.all_targets(dut)
> + for target in targets:
> + summary += "Target: %s\r\n" % (target)
> + table = Texttable()
> + table.set_deco(Texttable.HEADER)
> + table.set_cols_align(["l", "l"])
> + table.set_cols_width([50, 10])
> + table.add_row(["Test Case", "Result"])
> + suites = self.result.get_target_suites(dut, target)
> + failed = self.result.get_cases_by_status(suites, 'FAILED')
> + blocked = self.result.get_cases_by_status(suites, 'BLOCKED')
> + for case in failed:
> + table.add_row([case, 'FAILED'])
> + for case in blocked:
> + table.add_row([case, 'BLOCKED'])
> + summary += table.draw()
> + summary += "\r\n\r\n"
> +
> + return summary
> +
> + def send(self, _from, _to, attachment):
> + content = ""
> + msg = MIMEMultipart('alternative')
> + msg['Subject'] = self.subject()
> + msg['From'] = _from
> + msg['To'] = ", ".join(_to)
> + content += self.summary()
> + content += "\r\n\r\n"
> + content += git_commit
> + content += "\r\n\r\n"
> + content += "".join(dut_config)
> + content += "\r\n\r\n"
> + content += self.target_summary()
> + content += "\r\n\r\n"
> + content += "Detail information of failed cases:\r\n"
> + content += self.failed_case_summary()
> + part2 = MIMEText(content, "plain", "utf-8")
> + msg.attach(part2)
> + fp = open(attachment, 'r')
> + part1 = MIMEText(fp.read(), 'base64', 'utf-8')
> + part1['Content-type'] = 'application/octet-stream'
> + part1['Content-Disposition'] = 'attachment;filename="output.zip"'
> + fp.close()
> + msg.attach(part1)
> + self.smtp.sendmail(
> + _from, _to, msg.as_string())
> + self.smtp.quit()
> +
> +if __name__ == '__main__':
> + parser = argparse.ArgumentParser(description="DTS Email Report Module")
> + parser.add_argument("-o", "--os_type", default="Fedora20")
> + parser.add_argument("-t", "--test_type", default="Functional")
> + parser.add_argument(
> + "-e", "--excel_file", default="output/test_results.xls")
> + parser.add_argument("-g", "--git_commit", default="test commit")
> + args = parser.parse_args()
> + os_type = args.os_type
> + test_type = args.test_type
> + git_commit = args.git_commit
> + email = Email(args.excel_file)
> + print email.subject()
> + print email.summary()
> + print email.target_summary()
> + print email.failed_case_summary()
More information about the dts
mailing list