[Summary view] [Print] [Text view]

   1  <?php
   2  /*

   3   * Limb PHP Framework

   4   *

   5   * @link http://limb-project.com

   6   * @copyright  Copyright &copy; 2004-2007 BIT(http://bit-creative.com)

   7   * @license    LGPL http://www.gnu.org/copyleft/lesser.html

   8   */
   9  lmb_require('limb/dbal/src/drivers/lmbDbTypeInfo.class.php');
  10  
  11  /**

  12   * class lmbOciTypeInfo.

  13   * @package dbal

  14   * @version $Id: lmbOciTypeInfo.class.php 5989 2007-06-13 13:08:11Z pachanga $

  15   */
  16  class lmbOciTypeInfo extends lmbDbTypeInfo
  17  {
  18    function getNativeToColumnTypeMapping()
  19    {
  20      return array(
  21              'tinyint' => LIMB_DB_TYPE_SMALLINT,
  22              'smallint' => LIMB_DB_TYPE_SMALLINT,
  23              'mediumint' => LIMB_DB_TYPE_INTEGER,
  24              'number' => LIMB_DB_TYPE_INTEGER,
  25              'int' => LIMB_DB_TYPE_INTEGER,
  26              'int2' => LIMB_DB_TYPE_INTEGER,
  27              'int4' => LIMB_DB_TYPE_INTEGER,
  28              'int8' => LIMB_DB_TYPE_INTEGER,
  29              'integer' => LIMB_DB_TYPE_INTEGER,
  30              'bigint' => LIMB_DB_TYPE_DECIMAL,
  31              'real' => LIMB_DB_TYPE_FLOAT,
  32              'float' => LIMB_DB_TYPE_FLOAT,
  33              'float4' => LIMB_DB_TYPE_FLOAT,
  34              'float8' => LIMB_DB_TYPE_FLOAT,
  35              'cash' => LIMB_DB_TYPE_FLOAT,
  36              'money' => LIMB_DB_TYPE_FLOAT,
  37              'decimal' => LIMB_DB_TYPE_DECIMAL,
  38              'numeric' => LIMB_DB_TYPE_DECIMAL,
  39              'double' => LIMB_DB_TYPE_DOUBLE,
  40              'char' => LIMB_DB_TYPE_CHAR,
  41              'varchar' => LIMB_DB_TYPE_VARCHAR,
  42              'varchar2' => LIMB_DB_TYPE_VARCHAR,
  43              'nvarchar2' => LIMB_DB_TYPE_VARCHAR,
  44              'date' => LIMB_DB_TYPE_DATE,
  45              'time' => LIMB_DB_TYPE_TIME,
  46              'year' => LIMB_DB_TYPE_INTEGER,
  47              'datetime' => LIMB_DB_TYPE_TIMESTAMP,
  48              'timestamp' => LIMB_DB_TYPE_TIMESTAMP,
  49              'blob' => LIMB_DB_TYPE_BLOB,
  50              'clob' => LIMB_DB_TYPE_CLOB,
  51              'tinytext' => LIMB_DB_TYPE_CLOB,
  52              'mediumtext' => LIMB_DB_TYPE_CLOB,
  53              'text' => LIMB_DB_TYPE_CLOB,
  54              'longtext' => LIMB_DB_TYPE_CLOB,
  55              'enum' => LIMB_DB_TYPE_CHAR,
  56              'set' => LIMB_DB_TYPE_CHAR,
  57              'bool' => LIMB_DB_TYPE_BOOLEAN,
  58              'raw' => LIMB_DB_TYPE_CLOB
  59           );
  60    }
  61  
  62    function getColumnToNativeTypeMapping()
  63    {
  64      return array(
  65              LIMB_DB_TYPE_SMALLINT => 'number',
  66              LIMB_DB_TYPE_INTEGER => 'number',
  67              LIMB_DB_TYPE_BOOLEAN => 'number',
  68              LIMB_DB_TYPE_CHAR => 'char',
  69              LIMB_DB_TYPE_VARCHAR => 'varchar',
  70              LIMB_DB_TYPE_FLOAT => 'float',
  71              LIMB_DB_TYPE_DOUBLE => 'number',
  72              LIMB_DB_TYPE_DECIMAL => 'number',
  73              LIMB_DB_TYPE_TIMESTAMP => 'datetime',
  74              LIMB_DB_TYPE_DATE => 'date',
  75              LIMB_DB_TYPE_TIME => 'time',
  76              LIMB_DB_TYPE_BLOB => 'blob',
  77              LIMB_DB_TYPE_CLOB => 'clob',
  78          );
  79    }
  80  }
  81  ?>