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/Common/Pgsql/TPgsqlMetaData.php | 38 +++++++++++++++++++++++---
 1 file changed, 34 insertions(+), 4 deletions(-)

(limited to 'framework/Data/Common/Pgsql/TPgsqlMetaData.php')

diff --git a/framework/Data/Common/Pgsql/TPgsqlMetaData.php b/framework/Data/Common/Pgsql/TPgsqlMetaData.php
index 5ac57239..e57f1b37 100644
--- a/framework/Data/Common/Pgsql/TPgsqlMetaData.php
+++ b/framework/Data/Common/Pgsql/TPgsqlMetaData.php
@@ -4,7 +4,7 @@
  *
  * @author Wei Zhuo <weizhuo[at]gmail[dot]com>
  * @link http://www.pradosoft.com/
- * @copyright Copyright &copy; 2005-2011 PradoSoft
+ * @copyright Copyright &copy; 2005-2011 PradoSoft
  * @license http://www.pradosoft.com/license/
  * @version $Id$
  * @package System.Data.Common.Pgsql
@@ -36,6 +36,36 @@ class TPgsqlMetaData extends TDbMetaData
 		return 'TPgsqlTableInfo';
 	}
 
+	/**
+	 * 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 parent::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 parent::quoteColumnName($name, '"', '"');
+	}
+
+	/**
+	 * Quotes a column alias for use in a query.
+	 * @param string $name column alias
+	 * @return string the properly quoted column alias
+	 */
+	public function quoteColumnAlias($name)
+	{
+		return parent::quoteColumnAlias($name, '"', '"');
+	}
+
 	/**
 	 * @param string default schema.
 	 */
@@ -333,13 +363,13 @@ EOD;
 		$index = join(', ', explode(' ', $columnIndex));
 		$sql =
 <<<EOD
-    SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
+		SELECT attnum, attname FROM pg_catalog.pg_attribute WHERE
 		attrelid=(
 			SELECT oid FROM pg_catalog.pg_class WHERE relname=:table AND relnamespace=(
 				SELECT oid FROM pg_catalog.pg_namespace WHERE nspname=:schema
 			)
 		)
-        AND attnum IN ({$index})
+				AND attnum IN ({$index})
 EOD;
 		$command = $this->getDbConnection()->createCommand($sql);
 		$command->bindValue(':table', $tableName);
@@ -348,7 +378,7 @@ EOD;
 		$primary = array();
 		foreach($command->query() as $row)
 		{
-            $primary[] = $row['attname'];
+						$primary[] = $row['attname'];
 		}
 
 		return $primary;
-- 
cgit v1.2.3