Update field mapping to include data type. Improved sqlite_query_mapped(...) function

The new sqlite_query_mapped(...) function will now consider the field
type when formatting the data values for SQLite.  In addition reserved
words on the DATETIME data type will be preserved without quote
encapsulation.

Improved the sqlite_query_mapped(...) to also handle UPDATE, INSERT and
DELETE in addition to SELECT.  The function now needs two eDBfieldMap
mappings.  The first one will contain update/insert values, while the
last one defines search criteria.

1 files changed, 4 insertions, 1 deletions

diff --git a/database/sqlite/sqlite.h b/database/sqlite/sqlite.h
index 2898c53..3dfe058 100644
--- a/database/sqlite/sqlite.h
+++ b/database/sqlite/sqlite.h
@@ -60,11 +60,14 @@ typedef struct __sqlite_dbresult {
         _sqlite_header *srch_headerrec;
 } dbresult;
 
+typedef enum _SQLqueryType { SQL_SELECT, SQL_INSERT, SQL_UPDATE, SQL_DELETE } SQLqueryType;
+
 #ifndef SQLITE_C
 #define sqlite_free_results(r) { _sqlite_free_results(r); r = NULL; }
 void _sqlite_free_results(dbresult *);
 dbresult *sqlite_query(eurephiaCTX *ctx, const char *, ...);
-dbresult *sqlite_query_mapped(eurephiaCTX *, char *, eDBfieldMap *);
+dbresult *sqlite_query_mapped(eurephiaCTX *ctx, SQLqueryType type, const char *sqlstub,
+                              eDBfieldMap *valMap, eDBfieldMap *whereMap);
 char *sqlite_get_value(dbresult *res, int, int);
 void sqlite_dump_result(FILE *, dbresult *);
 int sqlite_get_numtuples(dbresult *);