Changeset 15631

Timestamp:

2008-05-22T13:23:52+12:00 (16 years ago)

Author:

mdewsnip

Message:

(Adding new DB support) Adding an implementation of getkeys() for the sqliteclass.

Location:

gsdl/trunk/lib

Files:

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

gsdl/trunk/lib/sqliteclass.cpp

@@ -200 +200 @@
 
 
-text_t sqliteclass::getfirstkey()
-{
-  if (sqlitefile == NULL) return g_EmptyText;
-
-  // !! TO IMPLEMENT
-  return g_EmptyText;
-}
-
-
-text_t sqliteclass::getnextkey(const text_t &key)
-{
-  if (sqlitefile == NULL || key.empty()) return g_EmptyText;
-
-  // !! TO IMPLEMENT
-  return g_EmptyText;
+text_tarray sqliteclass::getkeys ()
+{
+  text_tarray keys;
+
+  // Get all the entries in the "key" column of the table
+  text_t sql_cmd = "SELECT key FROM data";
+  vector<text_tmap> sql_results;
+  if (sqlitefile == NULL || !sqlgetarray(sql_cmd, sql_results) || sql_results.size() == 0)
+  {
+    return keys;
+  }
+
+  // Iterate through the keys 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);
+    keys.push_back(sql_result["key"]);
+    sql_results_iterator++;
+  }
+
+  return keys;
 }
 

gsdl/trunk/lib/sqliteclass.h

@@ -54 +54 @@
   void deletekey (const text_t &key);
 
-  // getfirstkey and getnextkey are used for traversing the database
-  // no insertions or deletions should be carried out while traversing
-  // the database. when there are no keys left to visit in the database
-  // an empty string is returned.
-  text_t getfirstkey ();
-  text_t getnextkey (const text_t &key);
+  text_tarray getkeys ();
 
 protected: