Changeset 4791 for trunk/include/dblayer

Timestamp:

Jan 29, 2010, 12:36:54 PM (15 years ago)

Author:

nikrou

Message:

Feature 511 : improve installation for sqlite
fatal error if database cannot be accessed
fix problem with booleans

File:

• trunk/include/dblayer/functions_sqlite.inc.php (modified) (4 diffs)

trunk/include/dblayer/functions_sqlite.inc.php

@@ -40 +40 @@
   $db_file = sprintf('%s/%s.db', $conf['local_data_dir'], $database);
 
-  $link = new SQLite3($db_file);
+  if (script_basename()=='install') 
+  {
+    $sqlite_open_mode = SQLITE3_OPEN_READWRITE | SQLITE3_OPEN_CREATE;
+  }
+  else 
+  {
+    $sqlite_open_mode = SQLITE3_OPEN_READWRITE;
+  }
+  try {
+    $link = new SQLite3($db_file, $sqlite_open_mode);
+  } catch (Exception $e) {
+    my_error('sqlite::open', true);
+  }
+
   $link->createFunction('now', 'pwg_now', 0);
   $link->createFunction('md5', 'md5', 1);
@@ -418 +431 @@
 {
   $boolean = true;
-  if ('f' == $string || 'false' == $string)
+  if ('f' === $string || 'false' === $string)
   {
     $boolean = false;
@@ -433 +446 @@
 function boolean_to_string($var)
 {
-  if (!empty($var) && ($var == 't'))
+  if (!empty($var) && ($var == 'true'))
   {
     return 'true';
@@ -513 +526 @@
   global $pwg_db_link;
 
-  $error = '[sqlite error]'.$pwg_db_link->lastErrorMsg()."\n";
+  $error = '';
+  if (isset($pwg_db_link)) 
+  {
+    $error .= '[sqlite error]'.$pwg_db_link->lastErrorMsg()."\n";
+  }
+
   $error .= $header;