Replace the string [table_name] with {$prefix}table_name. Slowly

working through setting up the database access to support table
prefixes. (Ticket#68)

Before going ahead, just wanted to check this approach... whatcha think?

1 files changed, 16 insertions, 0 deletions

diff --git a/core/libraries/MY_Database.php b/core/libraries/MY_Database.php
index f5e412a6..7d6c3ece 100644
--- a/core/libraries/MY_Database.php
+++ b/core/libraries/MY_Database.php
@@ -42,4 +42,20 @@ class Database extends Database_Core {
 
     throw new Kohana_Database_Exception('database.missing_open_paren');
   }
+
+  /**
+   * Parse the query string and convert any strings of the form `\([a-zA-Z0-9_]*?)\]
+   * table prefix . $1
+   */
+  public function query($sql = '') {
+    if (!empty($sql)) {
+      $sql = $this->add_table_prefixes($sql);
+    }
+    return parent::query($sql);
+  }
+
+  public function add_table_prefixes($sql) {
+    $prefix = $this->config["table_prefix"];
+    return preg_replace("#\[([a-zA-Z0-9_]+)\]#", "{$prefix}$1", $sql);
+  }
 }
\ No newline at end of file