TYPO3 CMS  TYPO3_6-2
•All Classes Namespaces Files Functions Variables Pages
adodb-pdo_oci.inc.php
Go to the documentation of this file.
1 <?php
2 
3 
4 /*
5 V5.19 23-Apr-2014 (c) 2000-2014 John Lim (jlim#natsoft.com). All rights reserved.
6  Released under both BSD license and Lesser GPL library license.
7  Whenever there is any discrepancy between the two licenses,
8  the BSD license will take precedence.
9  Set tabs to 8.
10 
11 */
12 
13 class ADODB_pdo_oci extends ADODB_pdo_base {
14 
15  var $concat_operator='||';
16  var $sysDate = "TRUNC(SYSDATE)";
17  var $sysTimeStamp = 'SYSDATE';
18  var $NLS_DATE_FORMAT = 'YYYY-MM-DD'; // To include time, use 'RRRR-MM-DD HH24:MI:SS'
19  var $random = "abs(mod(DBMS_RANDOM.RANDOM,10000001)/10000000)";
20  var $metaTablesSQL = "select table_name,table_type from cat where table_type in ('TABLE','VIEW')";
21  var $metaColumnsSQL = "select cname,coltype,width, SCALE, PRECISION, NULLS, DEFAULTVAL from col where tname='%s' order by colno";
22 
23  var $_initdate = true;
24  var $_hasdual = true;
25 
26  function _init($parentDriver)
27  {
28  $parentDriver->_bindInputArray = true;
29  $parentDriver->_nestedSQL = true;
30  if ($this->_initdate) {
31  $parentDriver->Execute("ALTER SESSION SET NLS_DATE_FORMAT='".$this->NLS_DATE_FORMAT."'");
32  }
33  }
34 
35  function MetaTables($ttype=false,$showSchema=false,$mask=false)
36  {
37  if ($mask) {
38  $save = $this->metaTablesSQL;
39  $mask = $this->qstr(strtoupper($mask));
40  $this->metaTablesSQL .= " AND table_name like $mask";
41  }
42  $ret = ADOConnection::MetaTables($ttype,$showSchema);
43 
44  if ($mask) {
45  $this->metaTablesSQL = $save;
46  }
47  return $ret;
48  }
49 
50  function MetaColumns($table,$normalize=true)
51  {
52  global $ADODB_FETCH_MODE;
53 
54  $false = false;
55  $save = $ADODB_FETCH_MODE;
56  $ADODB_FETCH_MODE = ADODB_FETCH_NUM;
57  if ($this->fetchMode !== false) $savem = $this->SetFetchMode(false);
58 
59  $rs = $this->Execute(sprintf($this->metaColumnsSQL,strtoupper($table)));
60 
61  if (isset($savem)) $this->SetFetchMode($savem);
62  $ADODB_FETCH_MODE = $save;
63  if (!$rs) {
64  return $false;
65  }
66  $retarr = array();
67  while (!$rs->EOF) { //print_r($rs->fields);
68  $fld = new ADOFieldObject();
69  $fld->name = $rs->fields[0];
70  $fld->type = $rs->fields[1];
71  $fld->max_length = $rs->fields[2];
72  $fld->scale = $rs->fields[3];
73  if ($rs->fields[1] == 'NUMBER' && $rs->fields[3] == 0) {
74  $fld->type ='INT';
75  $fld->max_length = $rs->fields[4];
76  }
77  $fld->not_null = (strncmp($rs->fields[5], 'NOT',3) === 0);
78  $fld->binary = (strpos($fld->type,'BLOB') !== false);
79  $fld->default_value = $rs->fields[6];
80 
81  if ($ADODB_FETCH_MODE == ADODB_FETCH_NUM) $retarr[] = $fld;
82  else $retarr[strtoupper($fld->name)] = $fld;
83  $rs->MoveNext();
84  }
85  $rs->Close();
86  if (empty($retarr))
87  return $false;
88  else
89  return $retarr;
90  }
91 }
ADODB_pdo_oci\$_hasdual
$_hasdual
Definition: adodb-pdo_oci.inc.php:24
ADODB_pdo_oci\_init
_init($parentDriver)
Definition: adodb-pdo_oci.inc.php:26
ADODB_pdo_oci\MetaColumns
MetaColumns($table, $normalize=true)
Definition: adodb-pdo_oci.inc.php:50
ADODB_pdo_base
Definition: adodb-pdo.inc.php:417
$rs
if(isset($_REQUEST['nrows'])) else $rs
Definition: server.php:92
ADODB_pdo_oci\$_initdate
$_initdate
Definition: adodb-pdo_oci.inc.php:23
ADODB_pdo_oci\$random
$random
Definition: adodb-pdo_oci.inc.php:19
ADODB_pdo_oci\$sysTimeStamp
$sysTimeStamp
Definition: adodb-pdo_oci.inc.php:17
ADODB_pdo_oci\$sysDate
$sysDate
Definition: adodb-pdo_oci.inc.php:16
ADODB_pdo_oci\$metaTablesSQL
$metaTablesSQL
Definition: adodb-pdo_oci.inc.php:20
ADODB_pdo_oci\MetaTables
MetaTables($ttype=false, $showSchema=false, $mask=false)
Definition: adodb-pdo_oci.inc.php:35
ADODB_pdo_oci\$NLS_DATE_FORMAT
$NLS_DATE_FORMAT
Definition: adodb-pdo_oci.inc.php:18
ADODB_pdo_oci\$metaColumnsSQL
$metaColumnsSQL
Definition: adodb-pdo_oci.inc.php:21
ADODB_pdo_oci\$concat_operator
$concat_operator
Definition: adodb-pdo_oci.inc.php:15
ADODB_pdo_oci
Definition: adodb-pdo_oci.inc.php:13