From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from dpdk.org (dpdk.org [92.243.14.124]) by inbox.dpdk.org (Postfix) with ESMTP id 6F8DFA09D2; Fri, 27 Nov 2020 03:56:57 +0100 (CET) Received: from [92.243.14.124] (localhost [127.0.0.1]) by dpdk.org (Postfix) with ESMTP id 4A8EACAB5; Fri, 27 Nov 2020 03:56:54 +0100 (CET) Received: from mga06.intel.com (mga06.intel.com [134.134.136.31]) by dpdk.org (Postfix) with ESMTP id 7DFE0CA9D for ; Fri, 27 Nov 2020 03:56:52 +0100 (CET) IronPort-SDR: 548kaWUpUibLyodJ90UPv00uBbDkb1xQKDCPZyIg0CZgqytcejzipdKFteC/cOjtmk/vRfphx5 uxQn0+hVb9RA== X-IronPort-AV: E=McAfee;i="6000,8403,9817"; a="233947109" X-IronPort-AV: E=Sophos;i="5.78,373,1599548400"; d="scan'208";a="233947109" X-Amp-Result: SKIPPED(no attachment in message) X-Amp-File-Uploaded: False Received: from fmsmga008.fm.intel.com ([10.253.24.58]) by orsmga104.jf.intel.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 26 Nov 2020 18:56:52 -0800 IronPort-SDR: Jm1V5JClX9zlTdXuuh5cTH9UxJpe6CI2s5b4pCaj6SwoKqYznXoj2WrvhhqF/HJcCTHwGHAyeE i8vV7s+zw0Gg== X-IronPort-AV: E=Sophos;i="5.78,373,1599548400"; d="scan'208";a="313557317" Received: from unknown (HELO localhost.localdomain) ([10.240.183.57]) by fmsmga008-auth.fm.intel.com with ESMTP/TLS/ECDHE-RSA-AES256-GCM-SHA384; 26 Nov 2020 18:56:50 -0800 From: Haiyang Zhao To: Lijuan.Tu@intel.com, dts@dpdk.org Cc: Haiyang Zhao Date: Fri, 27 Nov 2020 10:50:26 +0800 Message-Id: <20201127025029.22276-5-haiyangx.zhao@intel.com> X-Mailer: git-send-email 2.17.1 In-Reply-To: <20201127025029.22276-1-haiyangx.zhao@intel.com> References: <20201127025029.22276-1-haiyangx.zhao@intel.com> Subject: [dts] [PATCH V1 4/7] framework/excel_reporter: add dpdk version in excel result X-BeenThere: dts@dpdk.org X-Mailman-Version: 2.1.15 Precedence: list List-Id: test suite reviews and discussions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: dts-bounces@dpdk.org Sender: "dts" add dpdk version in excel result and modify the other element index. Signed-off-by: Haiyang Zhao --- framework/excel_reporter.py | 54 ++++++++++++++++++++----------------- 1 file changed, 29 insertions(+), 25 deletions(-) diff --git a/framework/excel_reporter.py b/framework/excel_reporter.py index 65d26b6..89b9a17 100644 --- a/framework/excel_reporter.py +++ b/framework/excel_reporter.py @@ -76,38 +76,40 @@ class ExcelReporter(object): def __add_header(self): self.sheet.write(0, 0, 'DUT', self.header_style) - self.sheet.write(0, 1, 'Target', self.header_style) - self.sheet.write(0, 2, 'NIC', self.header_style) - self.sheet.write(0, 3, 'Test suite', self.header_style) - self.sheet.write(0, 4, 'Test case', self.header_style) - self.sheet.write(0, 5, 'Results', self.header_style) - - self.sheet.write(0, 7, 'Pass', self.header_style) - self.sheet.write(0, 8, 'Fail', self.header_style) - self.sheet.write(0, 9, 'Blocked', self.header_style) - self.sheet.write(0, 10, 'N/A', self.header_style) - self.sheet.write(0, 11, 'Not Run', self.header_style) - self.sheet.write(0, 12, 'Total', self.header_style) - - self.sheet.write(1, 7, Formula('COUNTIF(F2:F2000,"PASSED")')) - self.sheet.write(1, 8, Formula('COUNTIF(F2:F2000,"FAILED*") + COUNTIF(F2:F2000,"IXA*")')) - self.sheet.write(1, 9, Formula('COUNTIF(F2:F2000,"BLOCKED*")')) - self.sheet.write(1, 10, Formula('COUNTIF(F2:F2000,"N/A*")')) - self.sheet.write(1, 12, Formula('H2+I2+J2+K2+L2')) + self.sheet.write(0, 1, 'DPDK version', self.header_style) + self.sheet.write(0, 2, 'Target', self.header_style) + self.sheet.write(0, 3, 'NIC', self.header_style) + self.sheet.write(0, 4, 'Test suite', self.header_style) + self.sheet.write(0, 5, 'Test case', self.header_style) + self.sheet.write(0, 6, 'Results', self.header_style) + + self.sheet.write(0, 8, 'Pass', self.header_style) + self.sheet.write(0, 9, 'Fail', self.header_style) + self.sheet.write(0, 10, 'Blocked', self.header_style) + self.sheet.write(0, 11, 'N/A', self.header_style) + self.sheet.write(0, 12, 'Not Run', self.header_style) + self.sheet.write(0, 13, 'Total', self.header_style) + + self.sheet.write(1, 8, Formula('COUNTIF(G2:G2000,"PASSED")')) + self.sheet.write(1, 9, Formula('COUNTIF(G2:G2000,"FAILED*") + COUNTIF(G2:G2000,"IXA*")')) + self.sheet.write(1, 10, Formula('COUNTIF(G2:G2000,"BLOCKED*")')) + self.sheet.write(1, 11, Formula('COUNTIF(G2:G2000,"N/A*")')) + self.sheet.write(1, 13, Formula('I2+J2+K2+L2+M2')) self.sheet.col(0).width = 4000 - self.sheet.col(1).width = 7500 - self.sheet.col(2).width = 3000 - self.sheet.col(3).width = 5000 - self.sheet.col(4).width = 8000 - self.sheet.col(5).width = 3000 - self.sheet.col(6).width = 1000 - self.sheet.col(7).width = 3000 + self.sheet.col(1).width = 4500 + self.sheet.col(2).width = 7500 + self.sheet.col(3).width = 3000 + self.sheet.col(4).width = 5000 + self.sheet.col(5).width = 8000 + self.sheet.col(6).width = 3000 + self.sheet.col(7).width = 1000 self.sheet.col(8).width = 3000 self.sheet.col(9).width = 3000 self.sheet.col(10).width = 3000 self.sheet.col(11).width = 3000 self.sheet.col(12).width = 3000 + self.sheet.col(13).width = 3000 def __styles(self): header_pattern = xlwt.Pattern() @@ -223,6 +225,8 @@ class ExcelReporter(object): if self.result.is_dut_failed(dut): self.__write_failed_dut(dut) else: + self.col = self.col + 1 + self.sheet.write(self.row, self.col, self.result.current_dpdk_version(dut), self.title_style) self.__write_targets(dut) self.row += 1 -- 2.17.1