From dc3bf922d9715bfd1b2105be04a9aabc84a1d7d4 Mon Sep 17 00:00:00 2001
From: wei <>
Date: Thu, 12 Apr 2007 08:05:03 +0000
Subject: Refactor and add TTableGateway, System.Data.Common,
 System.Data.DataGateway

---
 framework/Data/Common/Pgsql/TPgsqlTableColumn.php | 48 +++++++++++++++++++++++
 1 file changed, 48 insertions(+)
 create mode 100644 framework/Data/Common/Pgsql/TPgsqlTableColumn.php

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

diff --git a/framework/Data/Common/Pgsql/TPgsqlTableColumn.php b/framework/Data/Common/Pgsql/TPgsqlTableColumn.php
new file mode 100644
index 00000000..66053a63
--- /dev/null
+++ b/framework/Data/Common/Pgsql/TPgsqlTableColumn.php
@@ -0,0 +1,48 @@
+<?php
+/**
+ * TPgsqlTableColumn class file.
+ *
+ * @author Wei Zhuo <weizhuo[at]gmail[dot]com>
+ * @link http://www.pradosoft.com/
+ * @copyright Copyright &copy; 2005-2007 PradoSoft
+ * @license http://www.pradosoft.com/license/
+ * @version $Id$
+ * @package System.Data.Common.Pgsql
+ */
+
+/**
+ * Load common TDbTableCommon class.
+ */
+Prado::using('System.Data.Common.TDbTableColumn');
+
+/**
+ * Describes the column metadata of the schema for a PostgreSQL database table.
+ *
+ * @author Wei Zhuo <weizho[at]gmail[dot]com>
+ * @version $Id$
+ * @package System.Data.Common.Pgsql
+ * @since 3.1
+ */
+class TPgsqlTableColumn extends TDbTableColumn
+{
+	/**
+	 * Overrides parent implementation, returns PHP type from the db type.
+	 * @return boolean derived PHP primitive type from the column db type.
+	 */
+	public function getPHPType()
+	{
+		switch(strtolower($this->getDbType()))
+		{
+			case 'bit': case 'bit varying': case 'real': case 'serial': case 'int': case 'integer':
+				return 'integer';
+			case 'boolean':
+				return 'boolean';
+			case 'bigint': case 'bigserial': case 'double precision': case 'money': case 'numeric':
+				return 'float';
+			default:
+				return 'string';
+		}
+	}
+}
+
+?>
\ No newline at end of file
-- 
cgit v1.2.3