summaryrefslogtreecommitdiff
path: root/framework/Db/Schema/TDbColumnSchema.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/TDbColumnSchema.php
parentb4b2c7e5e2eadd48b344538823dcf5645939ba44 (diff)
- ActiveRecord Port from Yii ... not perfect but works ^^
Diffstat (limited to 'framework/Db/Schema/TDbColumnSchema.php')
-rwxr-xr-xframework/Db/Schema/TDbColumnSchema.php145
1 files changed, 145 insertions, 0 deletions
diff --git a/framework/Db/Schema/TDbColumnSchema.php b/framework/Db/Schema/TDbColumnSchema.php
new file mode 100755
index 00000000..f2c4faaa
--- /dev/null
+++ b/framework/Db/Schema/TDbColumnSchema.php
@@ -0,0 +1,145 @@
+<?php
+/**
+ * TDbColumnSchema 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.TDbExpression');
+
+/**
+ * TDbColumnSchema class describes the column meta data of a database table.
+ *
+ * @author Qiang Xue <qiang.xue@gmail.com>
+ * @version $Id: TDbColumnSchema.php 2679 2009-06-15 07:49:42Z Christophe.Boulain $
+ * @package System.Db.Schema
+ * @since 1.0
+ */
+class TDbColumnSchema extends TComponent
+{
+ /**
+ * @var string name of this column (without quotes).
+ */
+ public $name;
+ /**
+ * @var string raw name of this column. This is the quoted name that can be used in SQL queries.
+ */
+ public $rawName;
+ /**
+ * @var boolean whether this column can be null.
+ */
+ public $allowNull;
+ /**
+ * @var string the DB type of this column.
+ */
+ public $dbType;
+ /**
+ * @var string the PHP type of this column.
+ */
+ public $type;
+ /**
+ * @var mixed default value of this column
+ */
+ public $defaultValue;
+ /**
+ * @var integer size of the column.
+ */
+ public $size;
+ /**
+ * @var integer precision of the column data, if it is numeric.
+ */
+ public $precision;
+ /**
+ * @var integer scale of the column data, if it is numeric.
+ */
+ public $scale;
+ /**
+ * @var boolean whether this column is a primary key
+ */
+ public $isPrimaryKey;
+ /**
+ * @var boolean whether this column is a foreign key
+ */
+ public $isForeignKey;
+
+
+ /**
+ * Initializes the column with its DB type and default value.
+ * This sets up the column's PHP type, size, precision, scale as well as default value.
+ * @param string the column's DB type
+ * @param mixed the default value
+ */
+ public function init($dbType, $defaultValue)
+ {
+ $this->dbType=$dbType;
+ $this->extractType($dbType);
+ $this->extractLimit($dbType);
+ if($defaultValue!==null)
+ $this->extractDefault($defaultValue);
+ }
+
+ /**
+ * Extracts the PHP type from DB type.
+ * @param string DB type
+ */
+ protected function extractType($dbType)
+ {
+ if(stripos($dbType,'int')!==false)
+ $this->type='integer';
+ else if(stripos($dbType,'bool')!==false)
+ $this->type='boolean';
+ else if(preg_match('/(real|floa|doub)/i',$dbType))
+ $this->type='double';
+ else
+ $this->type='string';
+ }
+
+ /**
+ * Extracts size, precision and scale information from column's DB type.
+ * @param string the column's DB type
+ */
+ protected function extractLimit($dbType)
+ {
+ if(strpos($dbType,'(') && preg_match('/\((.*)\)/',$dbType,$matches))
+ {
+ $values=explode(',',$matches[1]);
+ $this->size=$this->precision=(int)$values[0];
+ if(isset($values[1]))
+ $this->scale=(int)$values[1];
+ }
+ }
+
+ /**
+ * 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)
+ {
+ $this->defaultValue=$this->typecast($defaultValue);
+ }
+
+ /**
+ * Converts the input value to the type that this column is of.
+ * @param mixed input value
+ * @return mixed converted value
+ */
+ public function typecast($value)
+ {
+ if(gettype($value)===$this->type || $value===null || $value instanceof TDbExpression)
+ return $value;
+ if($value==='')
+ return $this->type==='string' ? '' : null;
+ switch($this->type)
+ {
+ case 'integer': return (integer)$value;
+ case 'boolean': return (boolean)$value;
+ case 'double': return (double)$value;
+ case 'string': return (string)$value;
+ default: return $value;
+ }
+ }
+}