BaseTools: skip updating temporary variable.

[mirror_edk2.git] / BaseTools / Source / Python / Table / TableReport.py

diff --git a/BaseTools/Source/Python/Table/TableReport.py b/BaseTools/Source/Python/Table/TableReport.py
index 042c1b7e9e792e61f7dbd34c40b30a1a814e04ca..4af0e98d86b4e01c8a7a313ecd261010f93cf5ec 100644 (file)
--- a/BaseTools/Source/Python/Table/TableReport.py
+++ b/BaseTools/Source/Python/Table/TableReport.py
@@ -1,8 +1,8 @@
 ## @file\r
 # This file is used to create/update/query/erase table for ECC reports\r
 #\r
-# Copyright (c) 2008, Intel Corporation\r
-# All rights reserved. This program and the accompanying materials\r
+# Copyright (c) 2008 - 2015, Intel Corporation. All rights reserved.<BR>\r
+# This program and the accompanying materials\r
 # are licensed and made available under the terms and conditions of the BSD License\r
 # which accompanies this distribution.  The full text of the license may be found at\r
 # http://opensource.org/licenses/bsd-license.php\r
@@ -15,11 +15,12 @@
 # Import Modules\r
 #\r
 import Common.EdkLogger as EdkLogger\r
-import os, time\r
+import Common.LongFilePathOs as os, time\r
 from Table import Table\r
 from Common.String import ConvertToSqlString2\r
 import EccToolError as EccToolError\r
 import EccGlobalData as EccGlobalData\r
+from Common.LongFilePathSupport import OpenLongFilePath as open\r
 \r
 ## TableReport\r
 #\r
@@ -67,14 +68,14 @@ class TableReport(Table):
     # @param Enabled:        If this error enabled\r
     # @param Corrected:      if this error corrected\r
     #\r
-    def Insert(self, ErrorID, OtherMsg = '', BelongsToTable = '', BelongsToItem = -1, Enabled = 0, Corrected = -1):\r
+    def Insert(self, ErrorID, OtherMsg='', BelongsToTable='', BelongsToItem= -1, Enabled=0, Corrected= -1):\r
         self.ID = self.ID + 1\r
         SqlCommand = """insert into %s values(%s, %s, '%s', '%s', %s, %s, %s)""" \\r
                      % (self.Table, self.ID, ErrorID, ConvertToSqlString2(OtherMsg), BelongsToTable, BelongsToItem, Enabled, Corrected)\r
         Table.Insert(self, SqlCommand)\r
-        \r
+\r
         return self.ID\r
-    \r
+\r
     ## Query table\r
     #\r
     # @retval:       A recordSet of all found records \r
@@ -84,13 +85,20 @@ class TableReport(Table):
                         where Enabled > -1 order by ErrorID, BelongsToItem""" % (self.Table)\r
         return self.Exec(SqlCommand)\r
 \r
+    ## Update table\r
+    #\r
+    def UpdateBelongsToItemByFile(self, ItemID=-1, File=""):\r
+        SqlCommand = """update Report set BelongsToItem=%s where BelongsToTable='File' and BelongsToItem=-2\r
+                        and OtherMsg like '%%%s%%'""" % (ItemID, File)\r
+        return self.Exec(SqlCommand)\r
+\r
     ## Convert to CSV\r
     #\r
     # Get all enabled records from table report and save them to a .csv file\r
     #\r
     # @param Filename:  To filename to save the report content\r
     #\r
-    def ToCSV(self, Filename = 'Report.csv'):\r
+    def ToCSV(self, Filename='Report.csv'):\r
         try:\r
             File = open(Filename, 'w+')\r
             File.write("""No, Error Code, Error Message, File, LineNo, Other Error Message\n""")\r
@@ -105,7 +113,7 @@ class TableReport(Table):
                 IsCorrected = Record[5]\r
                 SqlCommand = ''\r
                 if BelongsToTable == 'File':\r
-                    SqlCommand = """select 0, FullPath from %s where ID = %s\r
+                    SqlCommand = """select 1, FullPath from %s where ID = %s\r
                              """ % (BelongsToTable, BelongsToItem)\r
                 else:\r
                     SqlCommand = """select A.StartLine, B.FullPath from %s as A, File as B\r
@@ -114,7 +122,8 @@ class TableReport(Table):
                 NewRecord = self.Exec(SqlCommand)\r
                 if NewRecord != []:\r
                     File.write("""%s,%s,"%s",%s,%s,"%s"\n""" % (Index, ErrorID, EccToolError.gEccErrorMessage[ErrorID], NewRecord[0][1], NewRecord[0][0], OtherMsg))\r
-            \r
+                    EdkLogger.quiet("%s(%s): [%s]%s %s" % (NewRecord[0][1], NewRecord[0][0], ErrorID, EccToolError.gEccErrorMessage[ErrorID], OtherMsg))\r
+\r
             File.close()\r
         except IOError:\r
             NewFilename = 'Report_' + time.strftime("%Y%m%d_%H%M%S.csv", time.localtime())\r