Changeset 15803 for gsdl

Timestamp:

2008-05-29T15:52:50+12:00 (16 years ago)

Author:

mdewsnip

Message:

(Adding dynamic classifiers) Added new get_documents_with_metadata_value() function, for use by the dynamic classifiers.

Location:

gsdl/trunk/lib

Files:

• sqldbclass.h (modified) (1 diff)
• sqlitedbclass.cpp (modified) (2 diffs)
• sqlitedbclass.h (modified) (1 diff)

gsdl/trunk/lib/sqldbclass.h

@@ -42 +42 @@
   // These functions MUST be implemented by subclasses, as they are database-specific
 
+  // returns array of document OIDs
+  virtual text_tarray get_documents_with_metadata_value (const text_t &metadata_element_name,
+                             const text_t &metadata_value) = 0;
+
   // returns array of values
   virtual text_tarray get_metadata_values (const text_t &metadata_element_name) = 0;

gsdl/trunk/lib/sqlitedbclass.cpp

@@ -97 +97 @@
 
 
+// returns array of document OIDs
+text_tarray sqlitedbclass::get_documents_with_metadata_value (const text_t &metadata_element_name,
+                                  const text_t &metadata_value)
+{
+  text_tarray document_OIDs;
+
+  // Check a metadata element and value has been specified
+  if (metadata_element_name == "" || metadata_value == "")
+  {
+    return document_OIDs;
+  }
+
+  // Get the entries in the "document_metadata" table where the element and value matches those specified
+  text_t sql_cmd = "SELECT docOID FROM document_metadata WHERE element='" + metadata_element_name + "' AND value='" + metadata_value + "'";
+  vector<text_tmap> sql_results;
+  if (!sqlgetarray(sql_cmd, sql_results) || sql_results.size() == 0)
+  {
+    return document_OIDs;
+  }
+
+  // Iterate through the documents 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);
+    document_OIDs.push_back(sql_result["docOID"]);
+    sql_results_iterator++;
+  }
+
+  return document_OIDs;
+}
+
+
 // returns file extension string
 text_t sqlitedbclass::getfileextension ()
@@ -157 +190 @@
   }
 
-  // Get the entries in the "value" column of the "document_metadata" table where the element matches
+  // Get the entries in the "document_metadata" table where the element matches that specified
   text_t sql_cmd = "SELECT value FROM document_metadata WHERE element='" + metadata_element_name + "'";
   vector<text_tmap> sql_results;

gsdl/trunk/lib/sqlitedbclass.h

@@ -45 +45 @@
   void deletekey (const text_t &key);
 
+  // returns array of document OIDs
+  text_tarray get_documents_with_metadata_value (const text_t &metadata_element_name,
+                         const text_t &metadata_value);
+
   // returns file extension string
   text_t getfileextension ();