summaryrefslogtreecommitdiff
path: root/framework/Testing/Data/Schema/oci/TOciColumnSchema.php
diff options
context:
space:
mode:
authorrojaro <>2009-07-15 07:58:26 +0000
committerrojaro <>2009-07-15 07:58:26 +0000
commitf1c27f46100582a1e52a27b616bf468e849068e7 (patch)
tree2d9a569495b67c57302c483b37beb81c5a9800b8 /framework/Testing/Data/Schema/oci/TOciColumnSchema.php
parent2ecfe49532dbfc53d75a32e68df643b7af13dc1f (diff)
moved System.Db to System.Testing.Data and updated classes accordingly
Diffstat (limited to 'framework/Testing/Data/Schema/oci/TOciColumnSchema.php')
-rwxr-xr-xframework/Testing/Data/Schema/oci/TOciColumnSchema.php56
1 files changed, 56 insertions, 0 deletions
diff --git a/framework/Testing/Data/Schema/oci/TOciColumnSchema.php b/framework/Testing/Data/Schema/oci/TOciColumnSchema.php
new file mode 100755
index 00000000..d8c77e16
--- /dev/null
+++ b/framework/Testing/Data/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.Testing.Data.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.Testing.Data.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);
+ }
+}