Changeset 15752 for gsdl

Timestamp:

2008-05-28T14:48:39+12:00 (16 years ago)

Author:

mdewsnip

Message:

(Adding dynamic classifiers) Added getmetadatavalues() function, which will not be part of dbclass because it cannot be implemented efficiently by gdbmclass.

Location:

gsdl/trunk/lib

Files:

• sqlitedbclass.cpp (modified) (1 diff)
• sqlitedbclass.h (modified) (1 diff)

gsdl/trunk/lib/sqlitedbclass.cpp

@@ -138 +138 @@
 
 
+text_tarray sqlitedbclass::getmetadatavalues (const text_t &metadata_element_name)
+{
+  text_tarray metadata_values;
+
+  // Get all the entries in the "value" column of the "document_metadata" table
+  text_t sql_cmd = "SELECT value FROM document_metadata WHERE element='" + metadata_element_name + "'";
+  vector<text_tmap> sql_results;
+  if (!sqlgetarray(sql_cmd, sql_results) || sql_results.size() == 0)
+  {
+    return metadata_values;
+  }
+
+  // Iterate through the values and add them to the array to be returned
+  vector<text_tmap>::iterator sql_results_iterator = sql_results.begin();
+  while (sql_results_iterator != sql_results.end())
+  {
+    text_tmap sql_result = (*sql_results_iterator);
+    metadata_values.push_back(sql_result["value"]);
+    sql_results_iterator++;
+  }
+
+  return metadata_values;
+}
+
+
 // returns true on success
 bool sqlitedbclass::setkeydata (const text_t &key, const text_t &data)

gsdl/trunk/lib/sqlitedbclass.h

@@ -54 +54 @@
   text_tarray getkeys ();
 
+  // returns array of values
+  text_tarray getmetadatavalues (const text_t &metadata_element_name);
+
   // returns true on success
   bool setkeydata (const text_t &key, const text_t &data);