Changeset 15941 for gsdl/trunk/src/lib

Timestamp:

2008-06-09T17:15:24+12:00 (16 years ago)

Author:

mdewsnip

Message:

(Adding dynamic classifiers) Added a new "metadata value filter" argument to the SQL browse filter requests, in order to support hierarchical dynamic classifiers.

Location:

gsdl/trunk/src/lib

Files:

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

gsdl/trunk/src/lib/sqldbclass.h

@@ -48 +48 @@
 
   // returns array of values
-  virtual text_tarray get_metadata_values (const text_t &metadata_element_name) = 0;
+  virtual text_tarray get_metadata_values (const text_t &metadata_element_name,
+                       const text_t &metadata_value_filter) = 0;
 };
 

gsdl/trunk/src/lib/sqlitedbclass.cpp

@@ -193 +193 @@
 
 // returns array of values
-text_tarray sqlitedbclass::get_metadata_values (const text_t &metadata_element_name)
+text_tarray sqlitedbclass::get_metadata_values (const text_t &metadata_element_name,
+                        const text_t &metadata_value_filter)
 {
   text_tarray metadata_values;
@@ -205 +206 @@
   // 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='" + sqlite_safe(metadata_element_name) + "'";
+
+  // Add value filter, if one has been defined
+  if (metadata_value_filter != "")
+  {
+    sql_cmd += " AND value LIKE '" + metadata_value_filter + "'";
+  }
+
   vector<text_tmap> sql_results;
   if (!sqlgetarray(sql_cmd, sql_results) || sql_results.size() == 0)

gsdl/trunk/src/lib/sqlitedbclass.h

@@ -60 +60 @@
 
   // returns array of values
-  text_tarray get_metadata_values (const text_t &metadata_element_name);
+  text_tarray get_metadata_values (const text_t &metadata_element_name,
+                   const text_t &metadata_value_filter);
 
   // returns true on success