- ActiveRecord Port from Yii ... not perfect but works ^^

1 files changed, 56 insertions, 0 deletions

diff --git a/framework/Db/Schema/oci/TOciColumnSchema.php b/framework/Db/Schema/oci/TOciColumnSchema.php
new file mode 100755
index 00000000..d609d14d
--- /dev/null
+++ b/framework/Db/Schema/oci/TOciColumnSchema.php
@@ -0,0 +1,56 @@
+<?php
+/**
+ * TOciColumnSchema class file.
+ *
+ * @author Ricardo Grana <rickgrana@yahoo.com.br>
+ * @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');
+
+/**
+ * TOciColumnSchema class describes the column meta data of a Oracle table.
+ *
+ * @author Ricardo Grana <rickgrana@yahoo.com.br>
+ * @version $Id: TOciColumnSchema.php
+ * @package System.Db.Schema.oci
+ * @since 1.0.5
+ */
+class TOciColumnSchema extends TDbColumnSchema
+{
+	/**
+	 * Extracts the PHP type from DB type.
+	 * @param string DB type
+	 */
+	protected function extractOraType($dbType){
+		if(strpos($dbType,'FLOAT')!==false) return 'double';
+
+		if ((strpos($dbType,'NUMBER')!==false) or
+			(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 'string';
+		}
+	}
+	protected function extractType($dbType)
+	{
+		$this->type=$this->extractOraType($dbType);
+	}
+
+	protected function extractDefault($defaultValue)
+	{
+		if(strpos($dbType,'timestamp')!==false)
+			$this->defaultValue=null;
+		else
+			parent::extractDefault($defaultValue);
+	}
+}