added numfmt field to return_data table

1 files changed, 3 insertions, 2 deletions

diff --git a/pkg/datamaps/db.go b/pkg/datamaps/db.go
index a72a63c..80724ce 100644
--- a/pkg/datamaps/db.go
+++ b/pkg/datamaps/db.go
@@ -48,6 +48,7 @@ func setupDB(path string) (*sql.DB, error) {
 					 ret_id INTEGER,
 					 filename TEXT,
 					 value TEXT,
+					 numfmt TEXT,
 					 FOREIGN KEY (dml_id)
 					 REFERENCES datamap_line(id) 
 					 ON DELETE CASCADE
@@ -236,13 +237,13 @@ func importXLSXtoDB(dmName string, returnName string, file string, db *sql.DB) e
 			}
 
 			// TODO - here we need to store the c.NumFmt string value in a new field
-			insertStmt, err := db.Prepare("insert into return_data (dml_id, ret_id, filename, value) values(?,?,?,?)")
+			insertStmt, err := db.Prepare("insert into return_data (dml_id, ret_id, filename, value, numfmt) values(?,?,?,?,?)")
 			if err != nil {
 				log.Fatal(err)
 			}
 			defer insertStmt.Close()
 
-			_, err = insertStmt.Exec(dmlID, retID, filename, cellData.Value)
+			_, err = insertStmt.Exec(dmlID, retID, filename, cellData.Value, cellData.NumFmt)
 			if err != nil {
 				log.Fatal(err)
 			}