23 runIDDetails="""SELECT distinct core FROM %s 
24 INNER JOIN CORE USING(coreid)
61 parser.add_argument('-ratio', action='store_true', help="Compute ratios for regression by core inst…
75 coreidSQL="select distinct coreid from CORE where coredef==?"
81     print("Unrecognized reference core \"%s\"" % corename)
138 REMOVETABLES=['TESTNAME','TESTDATE','RUN','CORE', 'PLATFORM', 'COMPILERKIND', 'COMPILER', 'TYPE', '…
199 coreDesc="""select core from CORE WHERE coreid=?"""
208 # Get existing compiler in a table for a specific core
209 # (In case report is structured by core)
245   INNER JOIN CORE USING(coreid)
253 # Command to get data for specific core 
258   INNER JOIN CORE USING(coreid)
272 # Command to get data for specific core 
277   INNER JOIN CORE USING(coreid)
285 coresForHistory="""select distinct coreid,core from %s
286   INNER JOIN CORE USING(coreid)
295   INNER JOIN CORE USING(coreid)
313 # Command to get test names for specific core 
337   INNER JOIN CORE USING(coreid)
360 # for specific core and compiler (for the data)
361 def getTestNamesForCoreCompiler(benchTable,compilerid,core):  argument
362     vals=(core,compilerid) + runidval
368 # for specific typeid and core (for the data)
369 def getTestNamesForCore(benchTable,core,typeid):  argument
370     vals=(core,typeid) + runidval
383 # Command to get data for specific core 
455 def getColNamesAndHistory(benchTable,compiler,core,typeid,testid):  argument
461     vals=(compiler,core,typeid,testid,runid)
468 def getColNamesAndDataForCore(benchTable,core,typeid):  argument
474     vals=(core,typeid) + runidval
481 def getColNamesAndDataForCoreCompiler(benchTable,compilerid,core):  argument
487     vals=(core,compilerid) + runidval
600           corepos = result[0].index('core')
764 ratioSQL="""select name,otherCore.compilerid as compilerid,CORE.core as core,%s(CAST(otherCore.MAX …
773  INNER JOIN CORE USING(coreid)
797  INNER JOIN CORE USING(coreid)
857      return(['name','compilerid','core'] + cols,params,ratio,testNames)
859 # Compute for all core for a given type
922          data=ref.pivot_table(index=toSort, columns=['core'], 
942 …ratioSection.addContent(Text("A bigger ratio means the reference core \"%s\" is better" % refCoreN…
1007 …         formatTableBy(desc,['type'],['core','version','compiler'],compilerSection,names,cols,vals)
1019                    ## Add report for each core
1021                    for core in allCores:
1022                        #print(core)
1023                        nbElems = getNbElemsInBenchAndTypeAndCoreCmd(benchName,core,aTypeID)
1026                           coreName=getCoreDesc(core)
1029                           cols,vals=getColNamesAndDataForCore(benchName,core,aTypeID)
1030                           desc=(benchName,core,aTypeID)
1031                           names=getTestNamesForCore(benchName,core,aTypeID)
1032 …                    formatTableBy(desc,['compiler','version'],['core'],coreSection,names,cols,vals)
1060 …                formatTableBy(desc,['core'],['version','compiler'],compilerSection,names,cols,vals)
1114         section.addContent(Text("Reference core for the ratio is %s" % refCoreName))