blob: d609d14d75700b4497e562b3284ca036757cccfb (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
|
<?php
/**
* TOciColumnSchema class file.
*
* @author Ricardo Grana <rickgrana@yahoo.com.br>
* @link http://www.yiiframework.com/
* @copyright Copyright © 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);
}
}
|
