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

Timestamp:

2008-05-22T14:06:54+12:00 (16 years ago)

Author:

mdewsnip

Message:

(Adding new DB support) Changing the setinfo() function to use either INSERT or UPDATE, depending on whether the key already exists.

File:

• gsdl/trunk/lib/sqliteclass.cpp (modified) (1 diff)

gsdl/trunk/lib/sqliteclass.cpp

@@ -182 +182 @@
   }
 
-  outconvertclass text_t2ascii;
-  (*logout) << text_t2ascii << "Inserting for " << key << ":\n" << data << "\n";
-
-  text_t sql_cmd = "INSERT INTO data (key, value) VALUES ('" + key + "', '" + data + "')";
-  return sqlexec(sql_cmd);
+  // We need to do either an INSERT or UPDATE depending on whether the key already exists
+  if (!exists(key))
+  {
+    text_t sql_cmd = "INSERT INTO data (key, value) VALUES ('" + key + "', '" + data + "')";
+    return sqlexec(sql_cmd);
+  }
+  else
+  {
+    text_t sql_cmd = "UPDATE data SET value='" + data + "' WHERE key='" + key + "'";
+    return sqlexec(sql_cmd);
+  }
 }