54 parser.add_argument('-byc', action='store_true', help="Result oganized by Compiler")
138 REMOVETABLES=['TESTNAME','TESTDATE','RUN','CORE', 'PLATFORM', 'COMPILERKIND', 'COMPILER', 'TYPE', '…
196 compilerDesc="""select compiler,version from COMPILER 
201 # Get existing compiler in a table for a specific type
208 # Get existing compiler in a table for a specific core
240 # Command to get data for specific compiler 
246   INNER JOIN COMPILER USING(compilerid)
259   INNER JOIN COMPILER USING(compilerid)
266 compilersForHistory="""select distinct compilerid,compiler,version  from %s
267   INNER JOIN COMPILER USING(compilerid)
278   INNER JOIN COMPILER USING(compilerid)
290 # Command to get data for specific compiler 
296   INNER JOIN COMPILER USING(compilerid)
303 # Command to get test names for specific compiler 
306   INNER JOIN COMPILER USING(compilerid)
314 # and compiler
316   INNER JOIN COMPILER USING(compilerid)
323 # Command to get test names for specific compiler 
326   INNER JOIN COMPILER USING(compilerid)
338   INNER JOIN COMPILER USING(compilerid)
360 # for specific core and compiler (for the data)
376 # for specific typeid and compiler (for the data)
389 # Command to get data for specific compiler 
395 # Command to get data for specific compiler 
455 def getColNamesAndHistory(benchTable,compiler,core,typeid,testid):  argument
461     vals=(compiler,core,typeid,testid,runid)
493 # for specific typeid and compiler (for the data)
860 def computeRatioTable(benchName,referenceCore,typeID,compiler):  argument
861   viewParams = (benchName,referenceCore,typeID,runidVIEWcmd,compiler)
863   otherParams = (benchName,typeID,runidVIEWcmd,compiler)
870 def computeRatioTableForCore(benchName,referenceCore,otherCoreID,compiler):  argument
871   viewParams = (benchName,referenceCore,runidVIEWcmd,compiler)
873   otherParams = (benchName,otherCoreID,runidVIEWcmd,compiler)
982                for compiler in allCompilers:
983                  #print(compiler)
985 …  cols,params,ratios,testNames=computeRatioTableForCore(benchName,referenceCoreID,aCoreID,compiler)
990                        compilerName,version=getCompilerDesc(compiler)
996                     nbElems = getNbElemsInBenchAndCoreAndCompilerCmd(benchName,compiler,aCoreID)
998                     # Print test results for table, type, compiler
1000                        compilerName,version=getCompilerDesc(compiler)
1003                        cols,vals=getColNamesAndDataForCoreCompiler(benchName,compiler,aCoreID)
1004                        desc=(benchName,compiler,aCoreID)
1005                        names=getTestNamesForCoreCompiler(benchName,compiler,aCoreID)
1007 …         formatTableBy(desc,['type'],['core','version','compiler'],compilerSection,names,cols,vals)
1024                        # Print test results for table, type, compiler
1032 …                    formatTableBy(desc,['compiler','version'],['core'],coreSection,names,cols,vals)
1035                     for compiler in allCompilers:
1036 …         cols,params,ratios,testNames=computeRatioTable(benchName,referenceCoreID,aTypeID,compiler)
1041                           compilerName,version=getCompilerDesc(compiler)
1047                    ## Add report for each compiler
1049                    for compiler in allCompilers:
1050                        #print(compiler)
1051                        nbElems = getNbElemsInBenchAndTypeAndCompilerCmd(benchName,compiler,aTypeID)
1052                        # Print test results for table, type, compiler
1054                           compilerName,version=getCompilerDesc(compiler)
1057                           cols,vals=getColNamesAndDataForCompiler(benchName,compiler,aTypeID)
1058                           desc=(benchName,compiler,aTypeID)
1059                           names=getTestNamesForCompiler(benchName,compiler,aTypeID)
1060 …                formatTableBy(desc,['core'],['version','compiler'],compilerSection,names,cols,vals)