summaryrefslogtreecommitdiff
path: root/framework/db/schema/oci/COciColumnSchema.php
diff options
context:
space:
mode:
Diffstat (limited to 'framework/db/schema/oci/COciColumnSchema.php')
-rw-r--r--framework/db/schema/oci/COciColumnSchema.php66
1 files changed, 66 insertions, 0 deletions
diff --git a/framework/db/schema/oci/COciColumnSchema.php b/framework/db/schema/oci/COciColumnSchema.php
new file mode 100644
index 0000000..bad57c3
--- /dev/null
+++ b/framework/db/schema/oci/COciColumnSchema.php
@@ -0,0 +1,66 @@
+<?php
+/**
+ * COciColumnSchema class file.
+ *
+ * @author Ricardo Grana <rickgrana@yahoo.com.br>
+ * @link http://www.yiiframework.com/
+ * @copyright Copyright &copy; 2008-2011 Yii Software LLC
+ * @license http://www.yiiframework.com/license/
+ */
+
+/**
+ * COciColumnSchema class describes the column meta data of a Oracle table.
+ *
+ * @author Ricardo Grana <rickgrana@yahoo.com.br>
+ * @version $Id: COciColumnSchema.php 3515 2011-12-28 12:29:24Z mdomba $
+ * @package system.db.schema.oci
+ */
+class COciColumnSchema extends CDbColumnSchema
+{
+ /**
+ * Extracts the PHP type from DB type.
+ * @param string $dbType DB type
+ * @return string
+ */
+ protected function extractOraType($dbType){
+ if(strpos($dbType,'FLOAT')!==false) return 'double';
+
+ if (strpos($dbType,'NUMBER')!==false || strpos($dbType,'INTEGER')!==false)
+ {
+ if(strpos($dbType,'(') && preg_match('/\((.*)\)/',$dbType,$matches))
+ {
+ $values=explode(',',$matches[1]);
+ if(isset($values[1]) and (((int)$values[1]) > 0))
+ return 'double';
+ else
+ return 'integer';
+ }
+ else
+ return 'double';
+ }
+ else
+ return 'string';
+ }
+
+ /**
+ * Extracts the PHP type from DB type.
+ * @param string $dbType DB type
+ */
+ protected function extractType($dbType)
+ {
+ $this->type=$this->extractOraType($dbType);
+ }
+
+ /**
+ * Extracts the default value for the column.
+ * The value is typecasted to correct PHP type.
+ * @param mixed $defaultValue the default value obtained from metadata
+ */
+ protected function extractDefault($defaultValue)
+ {
+ if(stripos($defaultValue,'timestamp')!==false)
+ $this->defaultValue=null;
+ else
+ parent::extractDefault($defaultValue);
+ }
+}