<?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(); ?>