Changeset 22043 for main/trunk/greenstone2/common-src/src/lib/sqlitedbclass.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/sqlitedbclass.h (modified) (4 diffs)

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

@@ -3 +3 @@
  * sqlitedbclass.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:
-  sqlitedbclass() { sqlitefile = NULL; }
-  ~sqlitedbclass();
+  sqlitedbclass();
+  virtual ~sqlitedbclass();
 
   // returns true if opened
-  bool opendatabase (const text_t &filename, int mode, int num_retrys, bool need_filelock);
+  bool opendatabase (const text_t &filename, int mode, int num_retrys, 
+             bool need_filelock);
 
   void closedatabase ();
 
   void deletekey (const text_t &key);
-
-  // returns array of document OIDs
-  text_tarray get_documents_with_metadata_value (const text_tarray &metadata_element_names,
-                         const text_t &metadata_value,
-                         const text_t &sort_by_metadata_element_name);
 
   // returns file extension string
@@ -59 +56 @@
   text_tarray getkeys ();
 
+
+  // returns array of document OIDs
+  virtual text_tarray get_documents_with_metadata_value (const text_tarray &metadata_element_names,
+                             const text_t &metadata_value,
+                             const text_t &sort_by_metadata_element_name);
+
   // returns array of values
-  text_tarray get_metadata_values (const text_tarray &metadata_element_names,
-                   const text_t &metadata_value_filter,
-                   const text_t &metadata_value_grouping_expression);
+  virtual text_tarray get_metadata_values (const text_tarray &metadata_element_names,
+                       const text_t &metadata_value_filter,
+                       const text_t &metadata_value_grouping_expression);
 
   // returns true on success
@@ -71 +74 @@
   sqlite3* sqlitefile;
 
-  text_t sqlite_safe (const text_t &value_arg);
+  virtual text_t sql_safe (const text_t &value_arg);
 
-  bool sqlexec (const text_t &sql_cmd);
-  bool sqlgetarray (const text_t &sql_cmd, vector<text_tmap> &sql_results);
-  bool sqltableexists (const text_t &table_name);
+  virtual bool sqlexec (const text_t &sql_cmd);
+  virtual bool sqlgetarray (const text_t &sql_cmd, vector<text_tmap> &sql_results);
+  virtual bool sqltableexists (const text_t &table_name);
+
 };