Changeset 22043 for main/trunk/greenstone2/common-src/src/lib/sqldbclass.h

Timestamp:

2010-05-06T12:49:54+12:00 (14 years ago)

Author:

davidb

Message:

Upgrading of database backends to allow support for sql-query support. Opportunity also taken to make calls to sql related classes (such as mssql and sqlite) to be more unified.

File:

• main/trunk/greenstone2/common-src/src/lib/sqldbclass.h (modified) (3 diffs)

main/trunk/greenstone2/common-src/src/lib/sqldbclass.h

@@ -3 +3 @@
  * sqldbclass.h -- 
  * Copyright (C) 2008  DL Consulting Ltd
+ * Copyright (C) 2010  New Zealand Digital Library Project
  *
  * A component of the Greenstone digital library software
@@ -35 +36 @@
 {
 public:
-  sqldbclass() {}
-  virtual ~sqldbclass() {}
+  sqldbclass();
+  virtual ~sqldbclass();
 
-
-  // -----------------------------------------------------------------------------------------------
-  // These functions MUST be implemented by subclasses, as they are database-specific
+  // returns array of document OIDs
+  virtual text_tarray get_documents_where (const text_t& sql_initial_cmd,
+                       const text_t& sort_by_metadata_element_name);
 
   // returns array of document OIDs
@@ -51 +52 @@
                        const text_t &metadata_value_filter,
                        const text_t &metadata_value_grouping_expression) = 0;
+
+protected:
+  virtual text_t sql_safe (const text_t &value_arg) = 0;
+
+  virtual bool sqlexec(const text_t &sql_cmd) = 0;
+  virtual bool sqlgetarray(const text_t& sql_cmd,
+               vector<text_tmap>& sql_results) = 0;
+  virtual bool sqltableexists(const text_t &table_name) = 0;
+
 };