[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  define('LIMB_DB_TYPE_SMALLINT',   10);
  10  define('LIMB_DB_TYPE_INTEGER',    11);
  11  
  12  define('LIMB_DB_TYPE_BOOLEAN',    20);
  13  
  14  define('LIMB_DB_TYPE_CHAR',       30);
  15  define('LIMB_DB_TYPE_VARCHAR',    31);
  16  
  17  define('LIMB_DB_TYPE_FLOAT',      40);
  18  define('LIMB_DB_TYPE_DOUBLE',     41);
  19  define('LIMB_DB_TYPE_DECIMAL',    42);
  20  
  21  define('LIMB_DB_TYPE_TIMESTAMP',  50);
  22  define('LIMB_DB_TYPE_DATE',       51);
  23  define('LIMB_DB_TYPE_TIME',       52);
  24  
  25  define('LIMB_DB_TYPE_BLOB',       60);
  26  define('LIMB_DB_TYPE_CLOB',       70);
  27  
  28  /**

  29   * class lmbDbTypeInfo.

  30   *

  31   * @package dbal

  32   * @version $Id: lmbDbTypeInfo.class.php 5945 2007-06-06 08:31:43Z pachanga $

  33   */
  34  class lmbDbTypeInfo
  35  {
  36    function getColumnTypeList()
  37    {
  38      return array(
  39        LIMB_DB_TYPE_SMALLINT,
  40        LIMB_DB_TYPE_INTEGER,
  41        LIMB_DB_TYPE_BOOLEAN,
  42        LIMB_DB_TYPE_CHAR,
  43        LIMB_DB_TYPE_VARCHAR,
  44        LIMB_DB_TYPE_FLOAT,
  45        LIMB_DB_TYPE_DOUBLE,
  46        LIMB_DB_TYPE_DECIMAL,
  47        LIMB_DB_TYPE_TIMESTAMP,
  48        LIMB_DB_TYPE_DATE,
  49        LIMB_DB_TYPE_TIME,
  50        LIMB_DB_TYPE_BLOB,
  51        LIMB_DB_TYPE_CLOB
  52      );
  53    }
  54  
  55    function getNativeToColumnTypeMapping()
  56    {
  57      return array(
  58        'tinyint' => LIMB_DB_TYPE_SMALLINT,
  59        'smallint' => LIMB_DB_TYPE_SMALLINT,
  60        'mediumint' => LIMB_DB_TYPE_INTEGER,
  61        'number' => LIMB_DB_TYPE_INTEGER,
  62        'int' => LIMB_DB_TYPE_INTEGER,
  63        'int2' => LIMB_DB_TYPE_INTEGER,
  64        'int4' => LIMB_DB_TYPE_INTEGER,
  65        'int8' => LIMB_DB_TYPE_INTEGER,
  66        'integer' => LIMB_DB_TYPE_INTEGER,
  67        'bigint' => LIMB_DB_TYPE_DECIMAL,
  68        'real' => LIMB_DB_TYPE_FLOAT,
  69        'float' => LIMB_DB_TYPE_FLOAT,
  70        'float4' => LIMB_DB_TYPE_FLOAT,
  71        'float8' => LIMB_DB_TYPE_FLOAT,
  72        'cash' => LIMB_DB_TYPE_FLOAT,
  73        'money' => LIMB_DB_TYPE_FLOAT,
  74        'decimal' => LIMB_DB_TYPE_DECIMAL,
  75        'numeric' => LIMB_DB_TYPE_DECIMAL,
  76        'double' => LIMB_DB_TYPE_DOUBLE,
  77        'char' => LIMB_DB_TYPE_CHAR,
  78        'varchar' => LIMB_DB_TYPE_VARCHAR,
  79        'varchar2' => LIMB_DB_TYPE_VARCHAR,
  80        'nvarchar2' => LIMB_DB_TYPE_VARCHAR,
  81        'date' => LIMB_DB_TYPE_DATE,
  82        'time' => LIMB_DB_TYPE_TIME,
  83        'year' => LIMB_DB_TYPE_INTEGER,
  84        'datetime' => LIMB_DB_TYPE_TIMESTAMP,
  85        'timestamp' => LIMB_DB_TYPE_TIMESTAMP,
  86        'blob' => LIMB_DB_TYPE_BLOB,
  87        'tinytext' => LIMB_DB_TYPE_CLOB,
  88        'mediumtext' => LIMB_DB_TYPE_CLOB,
  89        'text' => LIMB_DB_TYPE_CLOB,
  90        'longtext' => LIMB_DB_TYPE_CLOB,
  91        'enum' => LIMB_DB_TYPE_CHAR,
  92        'set' => LIMB_DB_TYPE_CHAR,
  93        'bool' => LIMB_DB_TYPE_BOOLEAN
  94       );
  95    }
  96  
  97    function getColumnTypeAccessors()
  98    {
  99      return array(
 100        LIMB_DB_TYPE_SMALLINT => 'setInteger',
 101        LIMB_DB_TYPE_INTEGER => 'setInteger',
 102        LIMB_DB_TYPE_BOOLEAN => 'setBoolean',
 103        LIMB_DB_TYPE_CHAR => 'setChar',
 104        LIMB_DB_TYPE_VARCHAR => 'setChar',
 105        LIMB_DB_TYPE_FLOAT => 'setFloat',
 106        LIMB_DB_TYPE_DOUBLE => 'setDouble',
 107        LIMB_DB_TYPE_DECIMAL => 'setDecimal',
 108        LIMB_DB_TYPE_TIMESTAMP => 'setTimeStamp',
 109        LIMB_DB_TYPE_DATE => 'setDate',
 110        LIMB_DB_TYPE_TIME => 'setTime',
 111        LIMB_DB_TYPE_BLOB => 'setBlob',
 112        LIMB_DB_TYPE_CLOB => 'setClob',
 113      );
 114    }
 115  
 116    function getColumnTypeGetters()
 117    {
 118      return array(
 119        LIMB_DB_TYPE_SMALLINT => 'getInteger',
 120        LIMB_DB_TYPE_INTEGER => 'getInteger',
 121        LIMB_DB_TYPE_BOOLEAN => 'getBoolean',
 122        LIMB_DB_TYPE_CHAR => 'getString',
 123        LIMB_DB_TYPE_VARCHAR => 'getString',
 124        LIMB_DB_TYPE_FLOAT => 'getFloat',
 125        LIMB_DB_TYPE_DOUBLE => 'getFloat',
 126        LIMB_DB_TYPE_DECIMAL => 'getFloat',
 127        LIMB_DB_TYPE_TIMESTAMP => 'getIntegerTimeStamp',
 128        LIMB_DB_TYPE_DATE => 'getStringDate',
 129        LIMB_DB_TYPE_TIME => 'getStringTime',
 130        LIMB_DB_TYPE_BLOB => 'getBlob',
 131        LIMB_DB_TYPE_CLOB => 'getClob',
 132      );
 133    }
 134  }
 135  ?>