ADODB2_oci8 Klassenreferenz

Klassendiagramm für ADODB2_oci8:

Zusammengehörigkeiten von ADODB2_oci8:

Öffentliche Methoden
	MetaType ($t, $len=-1)
	ActualType ($meta)
	CreateDatabase ($dbname, $options=false)
	AddColumnSQL ($tabname, $flds)
	AlterColumnSQL ($tabname, $flds)
	DropColumnSQL ($tabname, $flds)
	_DropAutoIncrement ($t)
	_CreateSuffix ($fname, &$ftype, $fnotnull, $fdefault, $fautoinc, $fconstraint, $funsigned)
	_Triggers ($tabname, $tableoptions)
	_IndexSQL ($idxname, $tabname, $flds, $idxoptions)
	GetCommentSQL ($table, $col)
	in other words, we use a text area for editting.
	SetCommentSQL ($table, $col, $cmt)
Datenfelder
	$databaseType = 'oci8'
	$seqField = false
	$seqPrefix = 'SEQ_'
	$dropTable = "DROP TABLE %s CASCADE CONSTRAINTS"
	$trigPrefix = 'TRIG_'
	$alterCol = ' MODIFY '
	$typeX = 'VARCHAR(4000)'
	$typeXL = 'CLOB'

Ausführliche Beschreibung

Definiert in Zeile 16 der Datei datadict-oci8.inc.php.

Dokumentation der Elementfunktionen

_CreateSuffix	(	$	fname,
		&$	ftype,
		$	fnotnull,
		$	fdefault,
		$	fautoinc,
		$	fconstraint,
		$	funsigned
	)

Erneute Implementation von ADODB_DataDict.

Definiert in Zeile 166 der Datei datadict-oci8.inc.php.

00167         {
00168                 $suffix = '';
00169                 
00170                 if ($fdefault == "''" && $fnotnull) {// this is null in oracle
00171                         $fnotnull = false;
00172                         if ($this->debug) ADOConnection::outp("NOT NULL and DEFAULT='' illegal in Oracle");
00173                 }
00174                 
00175                 if (strlen($fdefault)) $suffix .= " DEFAULT $fdefault";
00176                 if ($fnotnull) $suffix .= ' NOT NULL';
00177                 
00178                 if ($fautoinc) $this->seqField = $fname;
00179                 if ($fconstraint) $suffix .= ' '.$fconstraint;
00180                 
00181                 return $suffix;
00182         }

_DropAutoIncrement ( $ t )

Erneute Implementation von ADODB_DataDict.

Definiert in Zeile 156 der Datei datadict-oci8.inc.php.

00157         {
00158                 if (strpos($t,'.') !== false) {
00159                         $tarr = explode('.',$t);
00160                         return "drop sequence ".$tarr[0].".seq_".$tarr[1];
00161                 }
00162                 return "drop sequence seq_".$t;
00163         }

_IndexSQL	(	$	idxname,
		$	tabname,
		$	flds,
		$	idxoptions
	)

Erneute Implementation von ADODB_DataDict.

Definiert in Zeile 246 der Datei datadict-oci8.inc.php.

00248 00249 00250 00251 00252 00253 00254 00255 00256 00257 00258 00259 00260 00261 00262 00263 00264 00265 00266 00267 00268 00269 00270 00271 00272 00273 00274 00275 00276 00277 00278 00279 00280 00281 00282         }

class="fragment">00247 { $sql = array(); if ( isset($idxoptions['REPLACE']) || isset($idxoptions['DROP']) ) { $sql[] = sprintf ($this->dropIndex, $idxname, $tabname); if ( isset($idxoptions['DROP']) ) return $sql; } if ( empty ($flds) ) { return $sql; } if (isset($idxoptions['BITMAP'])) { $unique = ' BITMAP'; } elseif (isset($idxoptions['UNIQUE'])) { $unique = ' UNIQUE'; } else { $unique = ''; } if ( is_array($flds) ) $flds = implode(', ',$flds); $s = 'CREATE' . $unique . ' INDEX ' . $idxname . ' ON ' . $tabname . ' (' . $flds . ')'; if ( isset($idxoptions[$this->upperName]) ) $s .= $idxoptions[$this->upperName]; if (isset($idxoptions['oci8'])) $s .= $idxoptions['oci8']; $sql[] = $s; return $sql;

_Triggers	(	$	tabname,
		$	taboptions
	)

GENERATE TRIGGERS IF NEEDED used when table has auto-incrementing field that is emulated using triggers

Erneute Implementation von ADODB_DataDict.

Definiert in Zeile 192 der Datei datadict-oci8.inc.php.

00193         {
00194                 if (!$this->seqField) return array();
00195                 
00196                 if ($this->schema) {
00197                         $t = strpos($tabname,'.');
00198                         if ($t !== false) $tab = substr($tabname,$t+1);
00199                         else $tab = $tabname;
00200                         $seqname = $this->schema.'.'.$this->seqPrefix.$tab;
00201                         $trigname = $this->schema.'.'.$this->trigPrefix.$this->seqPrefix.$tab;
00202                 } else {
00203                         $seqname = $this->seqPrefix.$tabname;
00204                         $trigname = $this->trigPrefix.$seqname;
00205                 }
00206                 
00207                 if (strlen($seqname) > 30) {
00208                         $seqname = $this->seqPrefix.uniqid('');
00209                 } // end if
00210                 if (strlen($trigname) > 30) {
00211                         $trigname = $this->trigPrefix.uniqid('');
00212                 } // end if
00213 
00214                 if (isset($tableoptions['REPLACE'])) $sql[] = "DROP SEQUENCE $seqname";
00215                 $seqCache = '';
00216                 if (isset($tableoptions['SEQUENCE_CACHE'])){$seqCache = $tableoptions['SEQUENCE_CACHE'];}
00217                 $seqIncr = '';
00218                 if (isset($tableoptions['SEQUENCE_INCREMENT'])){$seqIncr = ' INCREMENT BY '.$tableoptions['SEQUENCE_INCREMENT'];}
00219                 $seqStart = '';
00220                 if (isset($tableoptions['SEQUENCE_START'])){$seqIncr = ' START WITH '.$tableoptions['SEQUENCE_START'];}
00221                 $sql[] = "CREATE SEQUENCE $seqname $seqStart $seqIncr $seqCache";
00222                 $sql[] = "CREATE OR REPLACE TRIGGER $trigname BEFORE insert ON $tabname FOR EACH ROW WHEN (NEW.$this->seqField IS NULL OR NEW.$this->seqField = 0) BEGIN select $seqname.nextval into :new.$this->seqField from dual; END;";
00223                 
00224                 $this->seqField = false;
00225                 return $sql;
00226         }

ActualType ( $ meta )

Returns the actual type given a character code.

C: varchar X: CLOB (character large object) or largest varchar size if CLOB is not supported C2: Multibyte varchar X2: Multibyte CLOB

B: BLOB (binary large object)

D: Date T: Date-time L: Integer field suitable for storing booleans (0 or 1) I: Integer F: Floating point number N: Numeric or decimal number

Erneute Implementation von ADODB_DataDict.

Definiert in Zeile 74 der Datei datadict-oci8.inc.php.

00075         {
00076                 switch($meta) {
00077                 case 'C': return 'VARCHAR';
00078                 case 'X': return $this->typeX;
00079                 case 'XL': return $this->typeXL;
00080                 
00081                 case 'C2': return 'NVARCHAR2';
00082                 case 'X2': return 'NVARCHAR2(4000)';
00083                 
00084                 case 'B': return 'BLOB';
00085                 
00086                 case 'TS':
00087                                 return 'TIMESTAMP';
00088                                 
00089                 case 'D': 
00090                 case 'T': return 'DATE';
00091                 case 'L': return 'NUMBER(1)';
00092                 case 'I1': return 'NUMBER(3)';
00093                 case 'I2': return 'NUMBER(5)';
00094                 case 'I':
00095                 case 'I4': return 'NUMBER(10)';
00096                 
00097                 case 'I8': return 'NUMBER(20)';
00098                 case 'F': return 'NUMBER';
00099                 case 'N': return 'NUMBER';
00100                 case 'R': return 'NUMBER(20)';
00101                 default:
00102                         return $meta;
00103                 }       
00104         }

AddColumnSQL	(	$	tabname,
		$	flds
	)

Erneute Implementation von ADODB_DataDict.

Definiert in Zeile 117 der Datei datadict-oci8.inc.php.

00118         {
00119                 $f = array();
00120                 list($lines,$pkey) = $this->_GenFields($flds);
00121                 $s = "ALTER TABLE $tabname ADD (";
00122                 foreach($lines as $v) {
00123                         $f[] = "\n $v";
00124                 }
00125                 
00126                 $s .= implode(', ',$f).')';
00127                 $sql[] = $s;
00128                 return $sql;
00129         }

AlterColumnSQL	(	$	tabname,
		$	flds
	)

Definiert in Zeile 131 der Datei datadict-oci8.inc.php.

00132         {
00133                 $f = array();
00134                 list($lines,$pkey) = $this->_GenFields($flds);
00135                 $s = "ALTER TABLE $tabname MODIFY(";
00136                 foreach($lines as $v) {
00137                         $f[] = "\n $v";
00138                 }
00139                 $s .= implode(', ',$f).')';
00140                 $sql[] = $s;
00141                 return $sql;
00142         }

CreateDatabase	(	$	dbname,
		$	options = `false`
	)

Erneute Implementation von ADODB_DataDict.

Definiert in Zeile 106 der Datei datadict-oci8.inc.php.

00107         {
00108                 $options = $this->_Options($options);
00109                 $password = isset($options['PASSWORD']) ? $options['PASSWORD'] : 'tiger';
00110                 $tablespace = isset($options["TABLESPACE"]) ? " DEFAULT TABLESPACE ".$options["TABLESPACE"] : '';
00111                 $sql[] = "CREATE USER ".$dbname." IDENTIFIED BY ".$password.$tablespace;
00112                 $sql[] = "GRANT CREATE SESSION, CREATE TABLE,UNLIMITED TABLESPACE,CREATE SEQUENCE TO $dbname";
00113                 
00114                 return $sql;
00115         }

DropColumnSQL	(	$	tabname,
		$	flds
	)

Definiert in Zeile 144 der Datei datadict-oci8.inc.php.

00145         {
00146                 if (!is_array($flds)) $flds = explode(',',$flds);
00147                 foreach ($flds as $k => $v) $flds[$k] = $this->NameQuote($v);
00148                 
00149                 $sql = array();
00150                 $s = "ALTER TABLE $tabname DROP(";
00151                 $s .= implode(', ',$flds).') CASCADE CONSTRAINTS';
00152                 $sql[] = $s;
00153                 return $sql;
00154         }

GetCommentSQL	(	$	table,
		$	col
	)

in other words, we use a text area for editting.

any varchar/char field this size or greater is treated as a blob

Erneute Implementation von ADODB_DataDict.

Definiert in Zeile 284 der Datei datadict-oci8.inc.php.

00285         {
00286                 $table = $this->connection->qstr($table);
00287                 $col = $this->connection->qstr($col);   
00288                 return "select comments from USER_COL_COMMENTS where TABLE_NAME=$table and COLUMN_NAME=$col";
00289         }

MetaType	(	$	t,
		$	len = `-1`
	)

Definiert in Zeile 27 der Datei datadict-oci8.inc.php.

00028         {
00029                 if (is_object($t)) {
00030                         $fieldobj = $t;
00031                         $t = $fieldobj->type;
00032                         $len = $fieldobj->max_length;
00033                 }
00034                 switch (strtoupper($t)) {
00035                 case 'VARCHAR':
00036                 case 'VARCHAR2':
00037                 case 'CHAR':
00038                 case 'VARBINARY':
00039                 case 'BINARY':
00040                         if (isset($this) && $len <= $this->blobSize) return 'C';
00041                         return 'X';
00042                 
00043                 case 'NCHAR':
00044                 case 'NVARCHAR2':
00045                 case 'NVARCHAR':
00046                         if (isset($this) && $len <= $this->blobSize) return 'C2';
00047                         return 'X2';
00048                         
00049                 case 'NCLOB':
00050                 case 'CLOB':
00051                         return 'XL';
00052                 
00053                 case 'LONG RAW':
00054                 case 'LONG VARBINARY':
00055                 case 'BLOB':
00056                         return 'B';
00057                 
00058                 case 'TIMESTAMP':
00059                         return 'TS';
00060                         
00061                 case 'DATE': 
00062                         return 'T';
00063                 
00064                 case 'INT': 
00065                 case 'SMALLINT':
00066                 case 'INTEGER': 
00067                         return 'I';
00068                         
00069                 default:
00070                         return 'N';
00071                 }
00072         }

SetCommentSQL	(	$	table,
		$	col,
		$	cmt
	)

Erneute Implementation von ADODB_DataDict.

Definiert in Zeile 291 der Datei datadict-oci8.inc.php.

00292         {
00293                 $cmt = $this->connection->qstr($cmt);
00294                 return  "COMMENT ON COLUMN $table.$col IS $cmt";
00295         }

Dokumentation der Datenelemente

$alterCol = ' MODIFY '

Erneute Implementation von ADODB_DataDict.

Definiert in Zeile 23 der Datei datadict-oci8.inc.php.

$databaseType = 'oci8'

Definiert in Zeile 18 der Datei datadict-oci8.inc.php.

$dropTable = "DROP TABLE %s CASCADE CONSTRAINTS"

Erneute Implementation von ADODB_DataDict.

Definiert in Zeile 21 der Datei datadict-oci8.inc.php.

$seqField = false

Definiert in Zeile 19 der Datei datadict-oci8.inc.php.

$seqPrefix = 'SEQ_'

Definiert in Zeile 20 der Datei datadict-oci8.inc.php.

$trigPrefix = 'TRIG_'

Definiert in Zeile 22 der Datei datadict-oci8.inc.php.

$typeX = 'VARCHAR(4000)'

Definiert in Zeile 24 der Datei datadict-oci8.inc.php.

$typeXL = 'CLOB'

Definiert in Zeile 25 der Datei datadict-oci8.inc.php.

Die Dokumentation für diese Klasse wurde erzeugt aufgrund der Datei:

datadict-oci8.inc.php



Copyright © 2003 - 2010 MyOOS [Shopsystem]. All rights reserved. MyOOS [Shopsystem] is Free Software released under the GNU/GPL License. Webmaster: info@r23.de (Impressum)

ADODB2_oci8 Klassenreferenz

Öffentliche Methoden

Datenfelder

Ausführliche Beschreibung

Dokumentation der Elementfunktionen

Dokumentation der Datenelemente