<?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&nbsp;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&nbsp;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>&nbsp;<u>S</u>earch&nbsp;for&nbsp;</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>&nbsp;&raquo&nbsp;<a class="el" href="dir_18071ae4545d8b3e0364d30c0659c74a.html">typo3</a>&nbsp;&raquo&nbsp;<a class="el" href="dir_57bf1ed8249c1fd5b014486d01bcb27a.html">sysext</a>&nbsp;&raquo&nbsp;<a class="el" href="dir_e81b1679233d44b74aed493d6fe8e943.html">adodb</a>&nbsp;&raquo&nbsp;<a class="el" href="dir_1f526b87ad011e46f671ba6e798564e1.html">adodb</a>&nbsp;&raquo&nbsp;<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 &lt;?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-&gt;type;
<a name="l00026"></a>00026                         $len = $fieldobj-&gt;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-&gt;<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-&gt;<a class="code" href="classADODB__DataDict.html#241128fe02ae191ba3f8df56c6efb492">_GenFields</a>($flds);
<a name="l00080"></a>00080                 $s = <span class="stringliteral">"ALTER TABLE $tabname $this-&gt;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-&gt;<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-&gt;<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-&gt;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-&gt;<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-&gt;dropCol "</span>.$this-&gt;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">    ( { &lt; column_definition &gt; </span>
<a name="l00131"></a>00131 <span class="comment">        | column_name AS computed_column_expression </span>
<a name="l00132"></a>00132 <span class="comment">        | &lt; table_constraint &gt; ::= [ 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">&lt; column_definition &gt; ::= { column_name data_type } </span>
<a name="l00141"></a>00141 <span class="comment">    [ COLLATE &lt; collation_name &gt; ] </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">    [ &lt; column_constraint &gt; ] [ ...n ] </span>
<a name="l00147"></a>00147 <span class="comment"></span>
<a name="l00148"></a>00148 <span class="comment">&lt; column_constraint &gt; ::= [ 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">&lt; table_constraint &gt; ::= [ 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 &lt; index_option &gt; [ ,...n] ] </span>
<a name="l00189"></a>00189 <span class="comment">                [ ON filegroup ]</span>
<a name="l00190"></a>00190 <span class="comment">                &lt; index_option &gt; :: = </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-&gt;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-&gt;upperName]) )
<a name="l00221"></a>00221                         $s .= $idxoptions[$this-&gt;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 ?&gt;
</pre></div><?php
  include_once '../doc-typo3-funcs.php';
  get_footer();
?>