commit 5cacf9d40e2423909b3d523600847a8b608deeaa
author Christophe Favergeon <Christophe.Favergeon@arm.com> Wed Aug 14 10:41:17 2019 +0200
committer Christophe Favergeon <Christophe.Favergeon@arm.com> Mon Sep 02 13:32:18 2019 +0200
tree d187b50a71b3705224ae674c600407940807665d
parent 1435c792e4fec80ea2f9c96928fccd90c473cd5b

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

CMSIS/DSP/Testing/addToRegDB.py

diff --git a/CMSIS/DSP/Testing/addToRegDB.py b/CMSIS/DSP/Testing/addToRegDB.py
index 39f3bfe..50c3e76 100755
--- a/CMSIS/DSP/Testing/addToRegDB.py
+++ b/CMSIS/DSP/Testing/addToRegDB.py
@@ -20,7 +20,8 @@
 # For table creation
 MKSTRFIELD=['NAME','Regression']
 MKBOOLFIELD=['HARDFP', 'FASTMATH', 'NEON', 'UNROLL', 'ROUNDING','OPTIMIZED']
-MKINTFIELD=['ID', 'MAX','MAXREGCOEF']
+MKINTFIELD=['ID','MAX']
+MKREALFIELD=['MAXREGCOEF']
 MKDATEFIELD=['DATE']
 MKKEYFIELD=['CATEGORY', 'PLATFORM', 'CORE', 'COMPILER','TYPE']
 MKKEYFIELDID={'CATEGORY':'categoryid', 
@@ -32,7 +33,8 @@
 # For table value extraction
 VALSTRFIELD=['NAME','VERSION','Regression']
 VALBOOLFIELD=['HARDFP', 'FASTMATH', 'NEON', 'UNROLL', 'ROUNDING','OPTIMIZED']
-VALINTFIELD=['ID', 'MAX','MAXREGCOEF']
+VALINTFIELD=['ID', 'MAX']
+VALREALFIELD=['MAXREGCOEF']
 VALDATEFIELD=['DATE']
 VALKEYFIELD=['CATEGORY', 'PLATFORM', 'CORE', 'COMPILER','TYPE']
 
@@ -63,6 +65,8 @@
           colsToKeep.append(field)
        if field in MKINTFIELD:
           colsToKeep.append(field)
+       if field in MKREALFIELD:
+          colsToKeep.append(field)
        if field in MKKEYFIELD:
           colsToKeep.append(field)
        if field in MKDATEFIELD:
@@ -90,6 +94,8 @@
           sql += "%s\n  %s TEXT"  % (start,field)
        if field in MKINTFIELD:
           sql += "%s\n  %s INTEGER"  % (start,field)
+       if field in MKREALFIELD:
+          sql += "%s\n  %s REAL"  % (start,field)
        if field in MKKEYFIELD:
           sql += "%s\n  %s INTEGER"  % (start,MKKEYFIELDID[field])
        if field in MKDATEFIELD:
@@ -201,6 +207,8 @@
             
         if field in VALINTFIELD:
             keys[field]=row[field]
+        if field in VALREALFIELD:
+            keys[field]=row[field]
         if field in VALDATEFIELD:
             keys[field]=row[field]
         if field in VALBOOLFIELD:
@@ -237,7 +245,10 @@
          if field in MKSTRFIELD or field in MKDATEFIELD:
             sql += " %s\n  \"%s\""  % (start,keys[field])
          elif field in keep:
-            sql += " %s\n  %d"  % (start,keys[field])
+            if field in VALREALFIELD:
+              sql += " %s\n  %f"  % (start,keys[field])
+            else:
+              sql += " %s\n  %d"  % (start,keys[field])
          start = ","
 
        sql += "  )"