Added sqlite functions for populating an XML document directly

2 files changed, 27 insertions, 0 deletions

diff --git a/database/sqlite/sqlite.c b/database/sqlite/sqlite.c
index f74b4d7..c0df997 100644
--- a/database/sqlite/sqlite.c
+++ b/database/sqlite/sqlite.c
@@ -25,6 +25,10 @@
 #include <assert.h>
 #include <sqlite3.h>
 
+#ifdef HAVE_LIBXML2
+# include <libxml/tree.h>
+#endif
+
 #include <eurephia_log.h>
 #include <eurephia_nullsafe.h>
 #include <eurephia_directions.h>
@@ -469,6 +473,21 @@ char *sqlite_get_value(dbresult *res, int row, int col) {
         return NULL;
 }
 
+
+#ifdef HAVE_LIBXML2
+xmlNodePtr sqlite_xml_value(xmlNodePtr node, xmlFieldType xmltyp, char *name, dbresult *res, int row, int col) {
+        switch( xmltyp ) {
+        case XML_ATTR:
+                xmlNewProp(node, (xmlChar *)name, (xmlChar *) sqlite_get_value(res, row, col));
+                return node;
+
+        case XML_NODE:
+                return xmlNewChild(node, NULL, (xmlChar *) name, (xmlChar *)sqlite_get_value(res, row, col));
+        }
+        return NULL;
+}
+#endif
+
 // Retrieve number of tuples in current dbresult structure
 int sqlite_get_numtuples(dbresult *res) {
         return (res != NULL ? res->num_tuples : 0);
diff --git a/database/sqlite/sqlite.h b/database/sqlite/sqlite.h
index 3dfe058..4ffbfd5 100644
--- a/database/sqlite/sqlite.h
+++ b/database/sqlite/sqlite.h
@@ -22,8 +22,13 @@
 # define   	SQLITE_H_
 
 #include <stdarg.h>
+#ifdef HAVE_LIBXML2
+# include <libxml/tree.h>
+#endif
 #include <eurephiadb_mapping.h>
 
+typedef enum _xmlFieldType { XML_ATTR, XML_NODE } xmlFieldType;
+
 typedef struct __sqlite_header {
         unsigned int fieldid;
         char *name;
@@ -69,6 +74,9 @@ dbresult *sqlite_query(eurephiaCTX *ctx, const char *, ...);
 dbresult *sqlite_query_mapped(eurephiaCTX *ctx, SQLqueryType type, const char *sqlstub,
                               eDBfieldMap *valMap, eDBfieldMap *whereMap);
 char *sqlite_get_value(dbresult *res, int, int);
+#ifdef HAVE_LIBXML2
+xmlNodePtr sqlite_xml_value(xmlNodePtr node, xmlFieldType xmltyp, char *name, dbresult *res, int row, int col);
+#endif
 void sqlite_dump_result(FILE *, dbresult *);
 int sqlite_get_numtuples(dbresult *);
 #endif