1/*
2
3Build the table with the platform, compiler and core names.
4
5*/
6.headers ON
7.mode csv
8
9
10select NB,CATEGORY.category,NAME,CYCLES,PLATFORM.platform,CORE.core,COMPILERKIND.compiler,COMPILER.version,BasicMathsBenchmarksF32.DATE
11  from BasicMathsBenchmarksF32
12  INNER JOIN CATEGORY USING(categoryid)
13  INNER JOIN PLATFORM USING(platformid)
14  INNER JOIN CORE USING(coreid)
15  INNER JOIN COMPILER USING(compilerid)
16  INNER JOIN COMPILERKIND USING(compilerkindid)
17  ;
18
19
20/*
21select Regression,MAX,MAXREGCOEF,CATEGORY.category,NAME,PLATFORM.platform,CORE.core,COMPILERKIND.compiler,COMPILER.version,BasicMathsBenchmarksF32.DATE
22  from BasicMathsBenchmarksF32
23  INNER JOIN CATEGORY USING(categoryid)
24  INNER JOIN PLATFORM USING(platformid)
25  INNER JOIN CORE USING(coreid)
26  INNER JOIN COMPILER USING(compilerid)
27  INNER JOIN COMPILERKIND USING(compilerkindid)
28  ;
29*/
30/*
31
32Compute the max cycles for a test configuration (category + name)
33
34*/
35/*
36select NAME,max(CYCLES),PLATFORM.platform,CORE.core,COMPILERKIND.compiler,COMPILER.version
37  from BasicBenchmarks
38  INNER JOIN CATEGORY USING(categoryid)
39  INNER JOIN PLATFORM USING(platformid)
40  INNER JOIN CORE USING(coreid)
41  INNER JOIN COMPILER USING(compilerid)
42  INNER JOIN COMPILERKIND USING(compilerkindid)
43  GROUP BY NAME,category
44  ;
45*/
46
47/*
48
49Get last values
50
51*/
52
53/*
54
55Better to use the ON syntax than the USING syntax.
56See diff.sql for example
57
58*/
59
60/*
61select NB,CATEGORY.category,NAME,CYCLES,PLATFORM.platform,CORE.core,COMPILERKIND.compiler,COMPILER.version,BasicMathsBenchmarksF32.DATE
62  from BasicMathsBenchmarksF32
63  INNER JOIN CATEGORY USING(categoryid)
64  INNER JOIN PLATFORM USING(platformid)
65  INNER JOIN CORE USING(coreid)
66  INNER JOIN COMPILER USING(compilerid)
67  INNER JOIN COMPILERKIND USING(compilerkindid)
68  WHERE DATE BETWEEN datetime('now','localtime','-10 minutes') AND datetime('now', 'localtime');
69*/