CMSIS-DSP: Testing framework and database
Added example sql script to compute ratios frrom database.
Modified build so that currentConfig.csv is per build folder.
Modified script to use the new location of currentConfig.csv
diff --git a/CMSIS/DSP/Testing/diff.sql b/CMSIS/DSP/Testing/diff.sql
new file mode 100755
index 0000000..66fd1ae
--- /dev/null
+++ b/CMSIS/DSP/Testing/diff.sql
@@ -0,0 +1,48 @@
+.headers ON
+/*
+
+Select the core to be used as reference. Only last day of measurements is used.
+
+*/
+CREATE TEMP VIEW if not exists refCore AS select *
+ from Unary
+ where coreid=5 AND DATE BETWEEN datetime('now','localtime','-23 hours') AND datetime('now', 'localtime');
+ ;
+
+/*
+
+Select the cores to be benchmarked compared with the reference. Only last day of measurements is used.
+
+*/
+CREATE TEMP VIEW if not exists otherCores AS select *
+ from Unary
+ where coreid != 5 AND DATE BETWEEN datetime('now','localtime','-23 hours') AND datetime('now', 'localtime');
+ ;
+
+/*
+
+Using regression database, compute the ratio using max cycles
+and max degree regression coefficient.
+
+Change name of columns for result
+
+*/
+select temp.otherCores.ID as ID,
+ CATEGORY.category as CATEGORY,
+ temp.otherCores.NAME as NAME,
+ PLATFORM.platform as PLATFORM,
+ CORE.core as CORE,
+ COMPILERKIND.compiler as COMPILER,
+ COMPILER.version as COMPILERVERSION,
+ TYPE.type as TYPE,
+ temp.otherCores.DATE as DATE,
+ (1.0*temp.refCore.MAX / temp.otherCores.MAX) as MAXRATIO,
+ (1.0*temp.refCore.MAXREGCOEF / temp.otherCores.MAXREGCOEF) as REGRESSIONRATIO
+ from temp.otherCores
+ INNER JOIN temp.refCore USING(ID,categoryid,NAME)
+ INNER JOIN CATEGORY USING(categoryid)
+ INNER JOIN PLATFORM USING(platformid)
+ INNER JOIN CORE USING(coreid)
+ INNER JOIN COMPILER USING(compilerid)
+ INNER JOIN COMPILERKIND USING(compilerkindid)
+ INNER JOIN TYPE USING(typeid)
\ No newline at end of file