From cd98ff1eafabf5b10ff67594b65d979a943afe09 Mon Sep 17 00:00:00 2001
From: Bart Visscher <bartv@thisnet.nl>
Date: Mon, 25 Feb 2013 08:19:49 +0100
Subject: Move db prefix handling to Connection wrapper

---
 lib/db/connection.php | 12 ++++++++++--
 1 file changed, 10 insertions(+), 2 deletions(-)

(limited to 'lib/db')

diff --git a/lib/db/connection.php b/lib/db/connection.php
index 5466609e671..40809330da6 100644
--- a/lib/db/connection.php
+++ b/lib/db/connection.php
@@ -14,7 +14,6 @@ use Doctrine\Common\EventManager;
 
 class Connection extends \Doctrine\DBAL\Connection {
 	protected $table_prefix;
-	protected $sequence_suffix;
 
 	protected $adapter;
 
@@ -32,8 +31,12 @@ class Connection extends \Doctrine\DBAL\Connection {
 		if (!isset($params['adapter'])) {
 			throw new Exception('adapter not set');
 		}
+		if (!isset($params['table_prefix'])) {
+			throw new Exception('table_prefix not set');
+		}
 		parent::__construct($params, $driver, $config, $eventManager);
 		$this->adapter = new $params['adapter']($this);
+		$this->table_prefix = $params['table_prefix'];
 	}
 
 	/**
@@ -43,7 +46,7 @@ class Connection extends \Doctrine\DBAL\Connection {
 	 * @return \Doctrine\DBAL\Driver\Statement The prepared statement.
 	 */
 	public function prepare( $statement, $limit=null, $offset=null ) {
-		// TODO: prefix
+		$statement = $this->replaceTablePrefix($statement);
 		// TODO: limit & offset
 		// TODO: prepared statement cache
 		return parent::prepare($statement);
@@ -85,4 +88,9 @@ class Connection extends \Doctrine\DBAL\Connection {
 		// TODO: prefix
 		return parent::executeUpdate($query, $params, $types);
 	}
+
+	// internal use
+	public function replaceTablePrefix($statement) {
+		return str_replace( '*PREFIX*', $this->table_prefix, $statement );
+	}
 }
-- 
cgit v1.2.3