Changeset 15637

Timestamp:

2008-05-22T14:15:33+12:00 (16 years ago)

Author:

mdewsnip

Message:

(Adding new DB support) Added a sqltableexists() function to prevent errors re-creating the "data" table.

Location:

gsdl/trunk/lib

Files:

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

gsdl/trunk/lib/sqliteclass.cpp

@@ -63 +63 @@
   }
 
-  if (mode == DB_WRITER_CREATE)
+  if ((mode == DB_WRITER || mode == DB_WRITER_CREATE) && !sqltableexists("data"))
   {
     sqlexec("CREATE TABLE data (key TEXT, value TEXT, PRIMARY KEY(key))");
@@ -366 +366 @@
 
 
+// returns true if exists
+bool sqliteclass::sqltableexists(const text_t &table_name)
+{
+  text_t sql_cmd = "SELECT * FROM sqlite_master WHERE tbl_name='" + table_name + "'";
+  vector<text_tmap> sql_results;
+  if (!sqlgetarray(sql_cmd, sql_results) || sql_results.size() == 0)
+  {
+    return false;
+  }
+
+  return true;
+}
+
+
 // sleep for the given number of milliseconds
 void sleep(int m)

gsdl/trunk/lib/sqliteclass.h

@@ -63 +63 @@
             text_t &key, text_t &value);
 
+  bool sqlexec (const text_t &sql_cmd);
   bool sqlgetarray (const text_t &sql_cmd, vector<text_tmap> &sql_results);
-  bool sqlexec (const text_t &sql_cmd);
+  bool sqltableexists (const text_t &table_name);
 };