<?php
include_once '../doc-typo3-funcs.php';
$doxygen_vars = array( "title" => "TYPO3 4.0.1: typo3_src-4.0.1/typo3/sysext/adodb/adodb/datadict/datadict-sybase.inc.php Source File",
"datetime" => "Sat Dec 2 19:22:25 2006",
"date" => "2 Dec 2006",
"doxygenversion" => "1.4.6",
"projectname" => "TYPO3 4.0.1",
"projectnumber" => "4.0.1"
);
get_header($doxygen_vars);
?>
<!-- Generated by Doxygen 1.4.6 -->
<div class="tabs">
<ul>
<li><a href="main.html"><span>Main Page</span></a></li>
<li><a href="namespaces.html"><span>Namespaces</span></a></li>
<li><a href="classes.html"><span>Classes</span></a></li>
<li id="current"><a href="files.html"><span>Files</span></a></li>
<li><a href="dirs.html"><span>Directories</span></a></li>
<li><a href="pages.html"><span>Related Pages</span></a></li>
<li><a href="examples.html"><span>Examples</span></a></li>
<li>
<form action="search.php" method="get">
<table cellspacing="0" cellpadding="0" border="0">
<tr>
<td><label> <u>S</u>earch for </label></td>
<td><input type="text" name="query" value="" size="20" accesskey="s"/></td>
</tr>
</table>
</form>
</li>
</ul></div>
<div class="nav">
<a class="el" href="dir_c8daf1ad746050abf985cc546c89e248.html">typo3_src-4.0.1</a> » <a class="el" href="dir_18071ae4545d8b3e0364d30c0659c74a.html">typo3</a> » <a class="el" href="dir_57bf1ed8249c1fd5b014486d01bcb27a.html">sysext</a> » <a class="el" href="dir_e81b1679233d44b74aed493d6fe8e943.html">adodb</a> » <a class="el" href="dir_1f526b87ad011e46f671ba6e798564e1.html">adodb</a> » <a class="el" href="dir_dc23b322957e53f3cb80639e4dbbdbeb.html">datadict</a></div>
<h1>datadict-sybase.inc.php</h1><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 <?php
<a name="l00002"></a>00002
<a name="l00013"></a>00013 <span class="comment">// security - hide paths</span>
<a name="l00014"></a>00014 <span class="keywordflow">if</span> (!defined('ADODB_DIR')) die();
<a name="l00015"></a>00015
<a name="l00016"></a><a class="code" href="classADODB2__sybase.html">00016</a> <span class="keyword">class </span><a class="code" href="classADODB2__sybase.html">ADODB2_sybase</a> <span class="keyword">extends</span> <a class="code" href="classADODB__DataDict.html">ADODB_DataDict</a> {
<a name="l00017"></a><a class="code" href="classADODB2__sybase.html#24f2e05cc8de8bb3a838efa74f121f44">00017</a> var <a class="code" href="classADODB2__sybase.html#24f2e05cc8de8bb3a838efa74f121f44">$databaseType</a> = 'sybase';
<a name="l00018"></a>00018
<a name="l00019"></a><a class="code" href="classADODB2__sybase.html#6989807e036f67a87cef83ed29c5bd03">00019</a> var <a class="code" href="classADODB2__sybase.html#6989807e036f67a87cef83ed29c5bd03">$dropIndex</a> = 'DROP INDEX %2$s.%1$s';
<a name="l00020"></a>00020
<a name="l00021"></a><a class="code" href="classADODB2__sybase.html#5730454295faaa90190b7b0ea2cdd3fe">00021</a> function <a class="code" href="classADODB2__sybase.html#5730454295faaa90190b7b0ea2cdd3fe">MetaType</a>($t,$len=-1,$fieldobj=<span class="keyword">false</span>)
<a name="l00022"></a>00022 {
<a name="l00023"></a>00023 <span class="keywordflow">if</span> (is_object($t)) {
<a name="l00024"></a>00024 $fieldobj = $t;
<a name="l00025"></a>00025 $t = $fieldobj->type;
<a name="l00026"></a>00026 $len = $fieldobj->max_length;
<a name="l00027"></a>00027 }
<a name="l00028"></a>00028
<a name="l00029"></a>00029 $len = -1; <span class="comment">// mysql max_length is not accurate</span>
<a name="l00030"></a>00030 <span class="keywordflow">switch</span> (strtoupper($t)) {
<a name="l00031"></a>00031
<a name="l00032"></a>00032 <span class="keywordflow">case</span> 'INT':
<a name="l00033"></a>00033 <span class="keywordflow">case</span> 'INTEGER': <span class="keywordflow">return</span> <span class="charliteral">'I'</span>;
<a name="l00034"></a>00034 <span class="keywordflow">case</span> 'BIT':
<a name="l00035"></a>00035 <span class="keywordflow">case</span> 'TINYINT': <span class="keywordflow">return</span> 'I1';
<a name="l00036"></a>00036 <span class="keywordflow">case</span> 'SMALLINT': <span class="keywordflow">return</span> 'I2';
<a name="l00037"></a>00037 <span class="keywordflow">case</span> 'BIGINT': <span class="keywordflow">return</span> 'I8';
<a name="l00038"></a>00038
<a name="l00039"></a>00039 <span class="keywordflow">case</span> 'REAL':
<a name="l00040"></a>00040 <span class="keywordflow">case</span> 'FLOAT': <span class="keywordflow">return</span> <span class="charliteral">'F'</span>;
<a name="l00041"></a>00041 <span class="keywordflow">default</span>: <span class="keywordflow">return</span> parent::MetaType($t,$len,$fieldobj);
<a name="l00042"></a>00042 }
<a name="l00043"></a>00043 }
<a name="l00044"></a>00044
<a name="l00045"></a><a class="code" href="classADODB2__sybase.html#c2d53f27bac92293bcbd4ba6e4b70cd5">00045</a> function <a class="code" href="classADODB2__sybase.html#c2d53f27bac92293bcbd4ba6e4b70cd5">ActualType</a>($meta)
<a name="l00046"></a>00046 {
<a name="l00047"></a>00047 <span class="keywordflow">switch</span>(strtoupper($meta)) {
<a name="l00048"></a>00048 <span class="keywordflow">case</span> <span class="charliteral">'C'</span>: <span class="keywordflow">return</span> 'VARCHAR';
<a name="l00049"></a>00049 <span class="keywordflow">case</span> 'XL':
<a name="l00050"></a>00050 <span class="keywordflow">case</span> <span class="charliteral">'X'</span>: <span class="keywordflow">return</span> 'TEXT';
<a name="l00051"></a>00051
<a name="l00052"></a>00052 <span class="keywordflow">case</span> 'C2': <span class="keywordflow">return</span> 'NVARCHAR';
<a name="l00053"></a>00053 <span class="keywordflow">case</span> 'X2': <span class="keywordflow">return</span> 'NTEXT';
<a name="l00054"></a>00054
<a name="l00055"></a>00055 <span class="keywordflow">case</span> <span class="charliteral">'B'</span>: <span class="keywordflow">return</span> 'IMAGE';
<a name="l00056"></a>00056
<a name="l00057"></a>00057 <span class="keywordflow">case</span> <span class="charliteral">'D'</span>: <span class="keywordflow">return</span> 'DATETIME';
<a name="l00058"></a>00058 <span class="keywordflow">case</span> <span class="charliteral">'T'</span>: <span class="keywordflow">return</span> 'DATETIME';
<a name="l00059"></a>00059 <span class="keywordflow">case</span> <span class="charliteral">'L'</span>: <span class="keywordflow">return</span> 'BIT';
<a name="l00060"></a>00060
<a name="l00061"></a>00061 <span class="keywordflow">case</span> <span class="charliteral">'I'</span>: <span class="keywordflow">return</span> 'INT';
<a name="l00062"></a>00062 <span class="keywordflow">case</span> 'I1': <span class="keywordflow">return</span> 'TINYINT';
<a name="l00063"></a>00063 <span class="keywordflow">case</span> 'I2': <span class="keywordflow">return</span> 'SMALLINT';
<a name="l00064"></a>00064 <span class="keywordflow">case</span> 'I4': <span class="keywordflow">return</span> 'INT';
<a name="l00065"></a>00065 <span class="keywordflow">case</span> 'I8': <span class="keywordflow">return</span> 'BIGINT';
<a name="l00066"></a>00066
<a name="l00067"></a>00067 <span class="keywordflow">case</span> <span class="charliteral">'F'</span>: <span class="keywordflow">return</span> 'REAL';
<a name="l00068"></a>00068 <span class="keywordflow">case</span> <span class="charliteral">'N'</span>: <span class="keywordflow">return</span> 'NUMERIC';
<a name="l00069"></a>00069 <span class="keywordflow">default</span>:
<a name="l00070"></a>00070 <span class="keywordflow">return</span> $meta;
<a name="l00071"></a>00071 }
<a name="l00072"></a>00072 }
<a name="l00073"></a>00073
<a name="l00074"></a>00074
<a name="l00075"></a><a class="code" href="classADODB2__sybase.html#f1056203091ac02899ccb7b5b56d411e">00075</a> function <a class="code" href="classADODB2__sybase.html#f1056203091ac02899ccb7b5b56d411e">AddColumnSQL</a>($tabname, $flds)
<a name="l00076"></a>00076 {
<a name="l00077"></a>00077 $tabname = $this-><a class="code" href="classADODB__DataDict.html#b89b6a7a466f8107c4d0042fae6fe642">TableName</a> ($tabname);
<a name="l00078"></a>00078 $f = array();
<a name="l00079"></a>00079 list($lines,$pkey) = $this-><a class="code" href="classADODB__DataDict.html#241128fe02ae191ba3f8df56c6efb492">_GenFields</a>($flds);
<a name="l00080"></a>00080 $s = <span class="stringliteral">"ALTER TABLE $tabname $this->addCol"</span>;
<a name="l00081"></a>00081 foreach($lines as $v) {
<a name="l00082"></a>00082 $f[] = <span class="stringliteral">"\n $v"</span>;
<a name="l00083"></a>00083 }
<a name="l00084"></a>00084 $s .= implode(', ',$f);
<a name="l00085"></a>00085 $sql[] = $s;
<a name="l00086"></a>00086 <span class="keywordflow">return</span> $sql;
<a name="l00087"></a>00087 }
<a name="l00088"></a>00088
<a name="l00089"></a><a class="code" href="classADODB2__sybase.html#27a7f96b65b956336f720e5fb79c51ff">00089</a> function <a class="code" href="classADODB2__sybase.html#27a7f96b65b956336f720e5fb79c51ff">AlterColumnSQL</a>($tabname, $flds)
<a name="l00090"></a>00090 {
<a name="l00091"></a>00091 $tabname = $this-><a class="code" href="classADODB__DataDict.html#b89b6a7a466f8107c4d0042fae6fe642">TableName</a> ($tabname);
<a name="l00092"></a>00092 $sql = array();
<a name="l00093"></a>00093 list($lines,$pkey) = $this-><a class="code" href="classADODB__DataDict.html#241128fe02ae191ba3f8df56c6efb492">_GenFields</a>($flds);
<a name="l00094"></a>00094 foreach($lines as $v) {
<a name="l00095"></a>00095 $sql[] = <span class="stringliteral">"ALTER TABLE $tabname $this->alterCol $v"</span>;
<a name="l00096"></a>00096 }
<a name="l00097"></a>00097
<a name="l00098"></a>00098 <span class="keywordflow">return</span> $sql;
<a name="l00099"></a>00099 }
<a name="l00100"></a>00100
<a name="l00101"></a><a class="code" href="classADODB2__sybase.html#b95981ee9dbaeb304755409493bb7e50">00101</a> function <a class="code" href="classADODB2__sybase.html#b95981ee9dbaeb304755409493bb7e50">DropColumnSQL</a>($tabname, $flds)
<a name="l00102"></a>00102 {
<a name="l00103"></a>00103 $tabname = $this-><a class="code" href="classADODB__DataDict.html#b89b6a7a466f8107c4d0042fae6fe642">TableName</a>($tabname);
<a name="l00104"></a>00104 <span class="keywordflow">if</span> (!is_array($flds)) $flds = explode(<span class="charliteral">','</span>,$flds);
<a name="l00105"></a>00105 $f = array();
<a name="l00106"></a>00106 $s = <span class="stringliteral">"ALTER TABLE $tabname"</span>;
<a name="l00107"></a>00107 foreach($flds as $v) {
<a name="l00108"></a>00108 $f[] = <span class="stringliteral">"\n$this->dropCol "</span>.$this->NameQuote($v);
<a name="l00109"></a>00109 }
<a name="l00110"></a>00110 $s .= implode(', ',$f);
<a name="l00111"></a>00111 $sql[] = $s;
<a name="l00112"></a>00112 <span class="keywordflow">return</span> $sql;
<a name="l00113"></a>00113 }
<a name="l00114"></a>00114
<a name="l00115"></a>00115 <span class="comment">// return string must begin with space</span>
<a name="l00116"></a><a class="code" href="classADODB2__sybase.html#726d8a63f0975d3dc058e4faa01febe3">00116</a> function <a class="code" href="classADODB2__sybase.html#726d8a63f0975d3dc058e4faa01febe3">_CreateSuffix</a>($fname,$ftype,$fnotnull,$fdefault,$fautoinc,$fconstraint)
<a name="l00117"></a>00117 {
<a name="l00118"></a>00118 $suffix = '';
<a name="l00119"></a>00119 <span class="keywordflow">if</span> (strlen($fdefault)) $suffix .= <span class="stringliteral">" DEFAULT $fdefault"</span>;
<a name="l00120"></a>00120 <span class="keywordflow">if</span> ($fautoinc) $suffix .= ' DEFAULT AUTOINCREMENT';
<a name="l00121"></a>00121 <span class="keywordflow">if</span> ($fnotnull) $suffix .= ' NOT NULL';
<a name="l00122"></a>00122 <span class="keywordflow">else</span> <span class="keywordflow">if</span> ($suffix == '') $suffix .= ' NULL';
<a name="l00123"></a>00123 <span class="keywordflow">if</span> ($fconstraint) $suffix .= <span class="charliteral">' '</span>.$fconstraint;
<a name="l00124"></a>00124 <span class="keywordflow">return</span> $suffix;
<a name="l00125"></a>00125 }
<a name="l00126"></a>00126
<a name="l00127"></a>00127 <span class="comment">/*</span>
<a name="l00128"></a>00128 <span class="comment">CREATE TABLE </span>
<a name="l00129"></a>00129 <span class="comment"> [ database_name.[ owner ] . | owner. ] table_name </span>
<a name="l00130"></a>00130 <span class="comment"> ( { < column_definition > </span>
<a name="l00131"></a>00131 <span class="comment"> | column_name AS computed_column_expression </span>
<a name="l00132"></a>00132 <span class="comment"> | < table_constraint > ::= [ CONSTRAINT constraint_name ] }</span>
<a name="l00133"></a>00133 <span class="comment"></span>
<a name="l00134"></a>00134 <span class="comment"> | [ { PRIMARY KEY | UNIQUE } [ ,...n ] </span>
<a name="l00135"></a>00135 <span class="comment"> ) </span>
<a name="l00136"></a>00136 <span class="comment"></span>
<a name="l00137"></a>00137 <span class="comment">[ ON { filegroup | DEFAULT } ] </span>
<a name="l00138"></a>00138 <span class="comment">[ TEXTIMAGE_ON { filegroup | DEFAULT } ] </span>
<a name="l00139"></a>00139 <span class="comment"></span>
<a name="l00140"></a>00140 <span class="comment">< column_definition > ::= { column_name data_type } </span>
<a name="l00141"></a>00141 <span class="comment"> [ COLLATE < collation_name > ] </span>
<a name="l00142"></a>00142 <span class="comment"> [ [ DEFAULT constant_expression ] </span>
<a name="l00143"></a>00143 <span class="comment"> | [ IDENTITY [ ( seed , increment ) [ NOT FOR REPLICATION ] ] ]</span>
<a name="l00144"></a>00144 <span class="comment"> ] </span>
<a name="l00145"></a>00145 <span class="comment"> [ ROWGUIDCOL] </span>
<a name="l00146"></a>00146 <span class="comment"> [ < column_constraint > ] [ ...n ] </span>
<a name="l00147"></a>00147 <span class="comment"></span>
<a name="l00148"></a>00148 <span class="comment">< column_constraint > ::= [ CONSTRAINT constraint_name ] </span>
<a name="l00149"></a>00149 <span class="comment"> { [ NULL | NOT NULL ] </span>
<a name="l00150"></a>00150 <span class="comment"> | [ { PRIMARY KEY | UNIQUE } </span>
<a name="l00151"></a>00151 <span class="comment"> [ CLUSTERED | NONCLUSTERED ] </span>
<a name="l00152"></a>00152 <span class="comment"> [ WITH FILLFACTOR = fillfactor ] </span>
<a name="l00153"></a>00153 <span class="comment"> [ON {filegroup | DEFAULT} ] ] </span>
<a name="l00154"></a>00154 <span class="comment"> ] </span>
<a name="l00155"></a>00155 <span class="comment"> | [ [ FOREIGN KEY ] </span>
<a name="l00156"></a>00156 <span class="comment"> REFERENCES ref_table [ ( ref_column ) ] </span>
<a name="l00157"></a>00157 <span class="comment"> [ ON DELETE { CASCADE | NO ACTION } ] </span>
<a name="l00158"></a>00158 <span class="comment"> [ ON UPDATE { CASCADE | NO ACTION } ] </span>
<a name="l00159"></a>00159 <span class="comment"> [ NOT FOR REPLICATION ] </span>
<a name="l00160"></a>00160 <span class="comment"> ] </span>
<a name="l00161"></a>00161 <span class="comment"> | CHECK [ NOT FOR REPLICATION ] </span>
<a name="l00162"></a>00162 <span class="comment"> ( logical_expression ) </span>
<a name="l00163"></a>00163 <span class="comment"> } </span>
<a name="l00164"></a>00164 <span class="comment"></span>
<a name="l00165"></a>00165 <span class="comment">< table_constraint > ::= [ CONSTRAINT constraint_name ] </span>
<a name="l00166"></a>00166 <span class="comment"> { [ { PRIMARY KEY | UNIQUE } </span>
<a name="l00167"></a>00167 <span class="comment"> [ CLUSTERED | NONCLUSTERED ] </span>
<a name="l00168"></a>00168 <span class="comment"> { ( column [ ASC | DESC ] [ ,...n ] ) } </span>
<a name="l00169"></a>00169 <span class="comment"> [ WITH FILLFACTOR = fillfactor ] </span>
<a name="l00170"></a>00170 <span class="comment"> [ ON { filegroup | DEFAULT } ] </span>
<a name="l00171"></a>00171 <span class="comment"> ] </span>
<a name="l00172"></a>00172 <span class="comment"> | FOREIGN KEY </span>
<a name="l00173"></a>00173 <span class="comment"> [ ( column [ ,...n ] ) ] </span>
<a name="l00174"></a>00174 <span class="comment"> REFERENCES ref_table [ ( ref_column [ ,...n ] ) ] </span>
<a name="l00175"></a>00175 <span class="comment"> [ ON DELETE { CASCADE | NO ACTION } ] </span>
<a name="l00176"></a>00176 <span class="comment"> [ ON UPDATE { CASCADE | NO ACTION } ] </span>
<a name="l00177"></a>00177 <span class="comment"> [ NOT FOR REPLICATION ] </span>
<a name="l00178"></a>00178 <span class="comment"> | CHECK [ NOT FOR REPLICATION ] </span>
<a name="l00179"></a>00179 <span class="comment"> ( search_conditions ) </span>
<a name="l00180"></a>00180 <span class="comment"> } </span>
<a name="l00181"></a>00181 <span class="comment"></span>
<a name="l00182"></a>00182 <span class="comment"></span>
<a name="l00183"></a>00183 <span class="comment"> */</span>
<a name="l00184"></a>00184
<a name="l00185"></a>00185 <span class="comment">/*</span>
<a name="l00186"></a>00186 <span class="comment"> CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name </span>
<a name="l00187"></a>00187 <span class="comment"> ON { table | view } ( column [ ASC | DESC ] [ ,...n ] ) </span>
<a name="l00188"></a>00188 <span class="comment"> [ WITH < index_option > [ ,...n] ] </span>
<a name="l00189"></a>00189 <span class="comment"> [ ON filegroup ]</span>
<a name="l00190"></a>00190 <span class="comment"> < index_option > :: = </span>
<a name="l00191"></a>00191 <span class="comment"> { PAD_INDEX | </span>
<a name="l00192"></a>00192 <span class="comment"> FILLFACTOR = fillfactor | </span>
<a name="l00193"></a>00193 <span class="comment"> IGNORE_DUP_KEY | </span>
<a name="l00194"></a>00194 <span class="comment"> DROP_EXISTING | </span>
<a name="l00195"></a>00195 <span class="comment"> STATISTICS_NORECOMPUTE | </span>
<a name="l00196"></a>00196 <span class="comment"> SORT_IN_TEMPDB </span>
<a name="l00197"></a>00197 <span class="comment"> }</span>
<a name="l00198"></a>00198 <span class="comment">*/</span>
<a name="l00199"></a><a class="code" href="classADODB2__sybase.html#6eba253058d3d3039b694260431f09e8">00199</a> function <a class="code" href="classADODB2__sybase.html#6eba253058d3d3039b694260431f09e8">_IndexSQL</a>($idxname, $tabname, $flds, $idxoptions)
<a name="l00200"></a>00200 {
<a name="l00201"></a>00201 $sql = array();
<a name="l00202"></a>00202
<a name="l00203"></a>00203 <span class="keywordflow">if</span> ( isset($idxoptions['REPLACE']) || isset($idxoptions['DROP']) ) {
<a name="l00204"></a>00204 $sql[] = sprintf ($this->dropIndex, $idxname, $tabname);
<a name="l00205"></a>00205 <span class="keywordflow">if</span> ( isset($idxoptions['DROP']) )
<a name="l00206"></a>00206 <span class="keywordflow">return</span> $sql;
<a name="l00207"></a>00207 }
<a name="l00208"></a>00208
<a name="l00209"></a>00209 <span class="keywordflow">if</span> ( empty ($flds) ) {
<a name="l00210"></a>00210 <span class="keywordflow">return</span> $sql;
<a name="l00211"></a>00211 }
<a name="l00212"></a>00212
<a name="l00213"></a>00213 $unique = isset($idxoptions['UNIQUE']) ? ' UNIQUE' : '';
<a name="l00214"></a>00214 $clustered = isset($idxoptions['CLUSTERED']) ? ' CLUSTERED' : '';
<a name="l00215"></a>00215
<a name="l00216"></a>00216 <span class="keywordflow">if</span> ( is_array($flds) )
<a name="l00217"></a>00217 $flds = implode(', ',$flds);
<a name="l00218"></a>00218 $s = 'CREATE' . $unique . $clustered . ' INDEX ' . $idxname . ' ON ' . $tabname . ' (' . $flds . <span class="charliteral">')'</span>;
<a name="l00219"></a>00219
<a name="l00220"></a>00220 <span class="keywordflow">if</span> ( isset($idxoptions[$this->upperName]) )
<a name="l00221"></a>00221 $s .= $idxoptions[$this->upperName];
<a name="l00222"></a>00222
<a name="l00223"></a>00223 $sql[] = $s;
<a name="l00224"></a>00224
<a name="l00225"></a>00225 <span class="keywordflow">return</span> $sql;
<a name="l00226"></a>00226 }
<a name="l00227"></a>00227 }
<a name="l00228"></a>00228 ?>
</pre></div><?php
include_once '../doc-typo3-funcs.php';
get_footer();
?>