From bc795edf4ff146d204aa08786572e27d4323866d Mon Sep 17 00:00:00 2001 From: Matthew Lemon Date: Wed, 5 Aug 2020 16:57:27 +0100 Subject: added numfmt field to return_data table --- pkg/datamaps/db.go | 5 +++-- 1 file changed, 3 insertions(+), 2 deletions(-) (limited to 'pkg/datamaps/db.go') 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) } -- cgit v1.2.3