From fb494d1e299e256721cba77105a01b7480c48c08 Mon Sep 17 00:00:00 2001
From: "GODZilla0480@gmail.com" <>
Date: Sun, 28 Aug 2011 06:24:03 +0000
Subject: Add methods quoteTableName, quoteColumnName, quoteColumnAlias to
 TDbMetaData & TDbConnection and add TDbConnection:getDbMetaData [TODO:
 customize TOracleMetaData]

---
 framework/Data/TDbConnection.php | 48 ++++++++++++++++++++++++++++++++++++++++
 1 file changed, 48 insertions(+)

(limited to 'framework/Data/TDbConnection.php')

diff --git a/framework/Data/TDbConnection.php b/framework/Data/TDbConnection.php
index 69420ea1..77b15a30 100644
--- a/framework/Data/TDbConnection.php
+++ b/framework/Data/TDbConnection.php
@@ -98,6 +98,11 @@ class TDbConnection extends TComponent
 	private $_pdo=null;
 	private $_transaction;
 
+	/**
+	 * @var TDbMetaData
+	 */
+	private $_dbMeta = null;
+
 	/**
 	 * @var string
 	 * @since 3.1.7
@@ -392,6 +397,49 @@ class TDbConnection extends TComponent
 			throw new TDbException('dbconnection_connection_inactive');
 	}
 
+	/**
+	 * Quotes a table name for use in a query.
+	 * @param string $name table name
+	 * @return string the properly quoted table name
+	 */
+	public function quoteTableName($name)
+	{
+		return $this->getDbMetaData()->quoteTableName($name);
+	}
+
+	/**
+	 * Quotes a column name for use in a query.
+	 * @param string $name column name
+	 * @return string the properly quoted column name
+	 */
+	public function quoteColumnName($name)
+	{
+		return $this->getDbMetaData()->quoteColumnName($name);
+	}
+
+	/**
+	 * Quotes a column alias for use in a query.
+	 * @param string $name column name
+	 * @return string the properly quoted column alias
+	 */
+	public function quoteColumnAlias($name)
+	{
+		return $this->getDbMetaData()->quoteColumnAlias($name);
+	}
+
+	/**
+	 * @return TDbMetaData
+	 */
+	public function getDbMetaData()
+	{
+		if($this->_dbMeta===null)
+		{
+			Prado::using('System.Data.Common.TDbMetaData');
+			$this->_dbMeta = TDbMetaData::getInstance($this);
+		}
+		return $this->_dbMeta;
+	}
+
 	/**
 	 * @return TDbColumnCaseMode the case of the column names
 	 */
-- 
cgit v1.2.3