summaryrefslogtreecommitdiff
path: root/framework/Db/Schema/pgsql/TPgsqlColumnSchema.php
diff options
context:
space:
mode:
authorrojaro <>2009-07-13 14:02:17 +0000
committerrojaro <>2009-07-13 14:02:17 +0000
commit78af2b4630ccde4b03659a259f739f83ae0de9ec (patch)
treef1a27cc2dbe77682143ae8243eee91187e66c6fe /framework/Db/Schema/pgsql/TPgsqlColumnSchema.php
parentb4b2c7e5e2eadd48b344538823dcf5645939ba44 (diff)
- ActiveRecord Port from Yii ... not perfect but works ^^
Diffstat (limited to 'framework/Db/Schema/pgsql/TPgsqlColumnSchema.php')
-rwxr-xr-xframework/Db/Schema/pgsql/TPgsqlColumnSchema.php58
1 files changed, 58 insertions, 0 deletions
diff --git a/framework/Db/Schema/pgsql/TPgsqlColumnSchema.php b/framework/Db/Schema/pgsql/TPgsqlColumnSchema.php
new file mode 100755
index 00000000..3677cd44
--- /dev/null
+++ b/framework/Db/Schema/pgsql/TPgsqlColumnSchema.php
@@ -0,0 +1,58 @@
+<?php
+/**
+ * TPgsqlColumnSchema class file.
+ *
+ * @author Qiang Xue <qiang.xue@gmail.com>
+ * @link http://www.yiiframework.com/
+ * @copyright Copyright &copy; 2008-2009 Yii Software LLC
+ * @license http://www.yiiframework.com/license/
+ */
+
+prado::using('System.Db.Schema.TDbColumnSchema');
+
+/**
+ * TPgsqlColumnSchema class describes the column meta data of a PostgreSQL table.
+ *
+ * @author Qiang Xue <qiang.xue@gmail.com>
+ * @version $Id: TPgsqlColumnSchema.php 2679 2009-06-15 07:49:42Z Christophe.Boulain $
+ * @package System.Db.Schema.pgsql
+ * @since 1.0
+ */
+class TPgsqlColumnSchema extends TDbColumnSchema
+{
+ /**
+ * Extracts the PHP type from DB type.
+ * @param string DB type
+ */
+ protected function extractType($dbType)
+ {
+ if(strpos($dbType,'integer')!==false || strpos($dbType,'oid')===0)
+ $this->type='integer';
+ else if(strpos($dbType,'bool')!==false)
+ $this->type='boolean';
+ else if(preg_match('/(real|float|double)/',$dbType))
+ $this->type='double';
+ else
+ $this->type='string';
+ }
+
+ /**
+ * Extracts the default value for the column.
+ * The value is typecasted to correct PHP type.
+ * @param mixed the default value obtained from metadata
+ */
+ protected function extractDefault($defaultValue)
+ {
+ if($defaultValue==='true')
+ $this->defaultValue=true;
+ else if($defaultValue==='false')
+ $this->defaultValue=false;
+ else if(strpos($defaultValue,'nextval')===0)
+ $this->defaultValue=null;
+ else if(preg_match('/\'(.*)\'::/',$defaultValue,$matches))
+ $this->defaultValue=$this->typecast(str_replace("''","'",$matches[1]));
+ else if(preg_match('/^-?\d+(\.\d*)?$/',$defaultValue,$matches))
+ $this->defaultValue=$this->typecast($defaultValue);
+ // else is null
+ }
+}