Added sqlite functions for populating an XML document directly

1 files changed, 19 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);