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

Timestamp:

2008-05-20T17:19:33+12:00 (16 years ago)

Author:

mdewsnip

Message:

(Adding new DB support) Quick implementation of setinfo().

File:

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

gsdl/trunk/lib/sqliteclass.cpp

@@ -63 +63 @@
   }
 
+  if (sqlitefile != NULL && mode == DB_WRITER_CREATE)
+  {
+    sqlexec("CREATE TABLE data (key TEXT, value TEXT, PRIMARY KEY(key))");
+  }
+
   return (sqlitefile != NULL);
 }
@@ -80 +85 @@
 bool sqliteclass::getinfo(const text_t& key, infodbclass &info)
 {
-  text_t sql_cmd = "SELECT value FROM table WHERE key=" + key;
+  text_t sql_cmd = "SELECT value FROM data WHERE key='" + key + "'";
 
   vector<text_tmap> sql_results;
@@ -109 +114 @@
   if (sqlitefile == NULL) return false;
 
-  // !! TO IMPLEMENT
-  return false;
+  text_t subkey;
+  text_t data;
+
+  // get all the keys and values
+  infodbclass::const_iterator info_here = info.begin();
+  infodbclass::const_iterator info_end = info.end();
+  while (info_here != info_end) {
+    // add the key
+    subkey.clear();
+    subkey.push_back('<');
+    text_t::const_iterator subkey_here = (*info_here).first.begin();
+    text_t::const_iterator subkey_end = (*info_here).first.end();
+    while (subkey_here != subkey_end) {
+      if (*subkey_here == '>') {
+    subkey.push_back('\\'); subkey.push_back('>');
+      } else if (*subkey_here == '\n') {
+    subkey.push_back('\\'); subkey.push_back('n');
+      } else if (*subkey_here == '\r') {
+    subkey.push_back('\\'); subkey.push_back('r');
+      } else if (*subkey_here == '\\') {
+    subkey.push_back('\\'); subkey.push_back('\\');
+      } else {
+    subkey.push_back (*subkey_here);
+      }
+      ++subkey_here;
+    }
+    subkey.push_back('>');
+
+    // add the values
+    text_tarray::const_iterator subvalue_here = (*info_here).second.begin();
+    text_tarray::const_iterator subvalue_end = (*info_here).second.end();
+    while (subvalue_here != subvalue_end) {
+      data += subkey;
+      
+      text_t::const_iterator thissubvalue_here = (*subvalue_here).begin();
+      text_t::const_iterator thissubvalue_end = (*subvalue_here).end();
+      while (thissubvalue_here != thissubvalue_end) {
+    if (*thissubvalue_here == '>') {
+      data.push_back('\\'); data.push_back('>');
+    } else if (*thissubvalue_here == '\n') {
+      data.push_back('\\'); data.push_back('n');
+    } else if (*thissubvalue_here == '\r') {
+      data.push_back('\\'); data.push_back('r');
+    } else if (*thissubvalue_here == '\\') {
+      data.push_back('\\'); data.push_back('\\');
+    } else {
+      data.push_back (*thissubvalue_here);
+    }
+    
+    ++thissubvalue_here;
+      }
+      
+      data.push_back('\n');
+      ++subvalue_here;
+    }
+
+    ++info_here;
+  }
+
+  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);
 }
 
@@ -116 +183 @@
 void sqliteclass::deletekey(const text_t &key)
 {
-  if (sqlitefile == NULL) return;
+  if (sqlitefile == NULL) return;  
 
   // !! TO IMPLEMENT