[Sommaire] [Imprimer]

   1  <?php
   2  /**
   3    V4.65 22 July 2005  (c) 2000-2005 John Lim (jlim@natsoft.com.my). All rights reserved.
   4    Released under both BSD license and Lesser GPL library license. 
   5    Whenever there is any discrepancy between the two licenses, 
   6    the BSD license will take precedence.
   7      
   8    Set tabs to 4 for best viewing.
   9    
  10    Modified 28 August, 2005 for use with ADOdb Lite by Mark Dickenson
  11    
  12  */
  13  
  14  // security - hide paths
  15  if (!defined('ADODB_DIR')) die();
  16  
  17  class ADODB2_sqlite extends ADODB_DataDict {
  18  
  19      var $dbtype = 'sqlite';
  20      var $seqField = false;
  21  
  22      var $metaTablesSQL = "SELECT name FROM sqlite_master WHERE type='table' ORDER BY name";
  23  
  24   	function ActualType($meta)
  25      {
  26          switch($meta) {
  27          case 'C': return 'VARCHAR';
  28          case 'XL':
  29          case 'X': return 'VARCHAR(250)';
  30          
  31          case 'C2': return 'VARCHAR';
  32          case 'X2': return 'VARCHAR(250)';
  33          
  34          case 'B': return 'VARCHAR';
  35              
  36          case 'D': return 'DATE';
  37          case 'T': return 'DATE';
  38          
  39          case 'L': return 'DECIMAL(1)';
  40          case 'I': return 'DECIMAL(10)';
  41          case 'I1': return 'DECIMAL(3)';
  42          case 'I2': return 'DECIMAL(5)';
  43          case 'I4': return 'DECIMAL(10)';
  44          case 'I8': return 'DECIMAL(20)';
  45          
  46          case 'F': return 'DECIMAL(32,8)';
  47          case 'N': return 'DECIMAL';
  48          default:
  49              return $meta;
  50          }
  51      }
  52  
  53  	function AlterColumnSQL($tabname, $flds)
  54      {
  55          if ($this->debug) $this->outp("AlterColumnSQL not supported");
  56          return array();
  57      }
  58      
  59      
  60  	function DropColumnSQL($tabname, $flds)
  61      {
  62          if ($this->debug) $this->outp("DropColumnSQL not supported");
  63          return array();
  64      }
  65  
  66  //    function MetaType($t,$len=-1,$fieldobj=false)
  67  //    {
  68  //    }
  69  
  70  //    function &MetaTables($ttype=false,$showSchema=false,$mask=false) 
  71  //    {
  72  //        global $ADODB_FETCH_MODE;
  73  //    }
  74  
  75  //    function &MetaColumns($table,$upper=true) 
  76  //    {
  77  //        global $ADODB_FETCH_MODE;
  78  //    }
  79  
  80  //    function MetaPrimaryKeys($table, $owner=false)
  81  //    {
  82  //    }
  83  
  84  //     function &MetaIndexes($table, $primary = false, $owner = false)
  85  //     {
  86  //     }
  87  
  88  }
  89  
  90  ?>