Changeset 15633 for gsdl/trunk/lib/sqliteclass.cpp

Timestamp:

2008-05-22T13:48:55+12:00 (16 years ago)

Author:

mdewsnip

Message:

(Adding new DB support) Minor improvements to opendatabase() and an initial implementation of deletekey().

File:

• gsdl/trunk/lib/sqliteclass.cpp (modified) (2 diffs)

gsdl/trunk/lib/sqliteclass.cpp

@@ -58 +58 @@
   delete[] filename_cstr;
 
-  if (sqlitefile == NULL && logout != NULL)
+  if (sqlitefile == NULL)
   {
     outconvertclass text_t2ascii;
     (*logout) << text_t2ascii << "database open failed on: " << filename << "\n";
-  }
-
-  if (sqlitefile != NULL && mode == DB_WRITER_CREATE)
+    return false;
+  }
+
+  if (mode == DB_WRITER_CREATE)
   {
     sqlexec("CREATE TABLE data (key TEXT, value TEXT, PRIMARY KEY(key))");
   }
 
-  return (sqlitefile != NULL);
+  return true;
 }
 
@@ -187 +188 @@
 
 
-void sqliteclass::deletekey(const text_t &key)
-{
-  if (sqlitefile == NULL) return;  
-
-  // !! TO IMPLEMENT
+void sqliteclass::deletekey (const text_t &key)
+{
+  text_t sql_cmd = "DELETE FROM data WHERE key='" + key + "'";
+  sqlexec(sql_cmd);
 }