<?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-sapdb.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-sapdb.inc.php</h1><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 &lt;?php
<a name="l00002"></a>00002 
<a name="l00014"></a>00014 <span class="comment">// security - hide paths</span>
<a name="l00015"></a>00015 <span class="keywordflow">if</span> (!defined('ADODB_DIR')) die();
<a name="l00016"></a>00016 
<a name="l00017"></a><a class="code" href="classADODB2__sapdb.html">00017</a> <span class="keyword">class </span><a class="code" href="classADODB2__sapdb.html">ADODB2_sapdb</a> <span class="keyword">extends</span> <a class="code" href="classADODB__DataDict.html">ADODB_DataDict</a> {
<a name="l00018"></a>00018         
<a name="l00019"></a><a class="code" href="classADODB2__sapdb.html#6898bb022c9278e7fdee9b2deb1149fa">00019</a>         var <a class="code" href="classADODB2__sapdb.html#6898bb022c9278e7fdee9b2deb1149fa">$databaseType</a> = 'sapdb';
<a name="l00020"></a><a class="code" href="classADODB2__sapdb.html#7f766d7b04c73d93eaa33d8d0291ed14">00020</a>         var <a class="code" href="classADODB2__sapdb.html#7f766d7b04c73d93eaa33d8d0291ed14">$seqField</a> = <span class="keyword">false</span>;  
<a name="l00021"></a><a class="code" href="classADODB2__sapdb.html#0e8df1f728fef5c5e955db5b287c1a6a">00021</a>         var <a class="code" href="classADODB2__sapdb.html#0e8df1f728fef5c5e955db5b287c1a6a">$renameColumn</a> = 'RENAME COLUMN %s.%s TO %s';
<a name="l00022"></a>00022         
<a name="l00023"></a><a class="code" href="classADODB2__sapdb.html#efce64727f0fb85f553d373b101ccad0">00023</a>         function <a class="code" href="classADODB2__sapdb.html#efce64727f0fb85f553d373b101ccad0">ActualType</a>($meta)
<a name="l00024"></a>00024         {
<a name="l00025"></a>00025                 <span class="keywordflow">switch</span>($meta) {
<a name="l00026"></a>00026                 <span class="keywordflow">case</span> <span class="charliteral">'C'</span>: <span class="keywordflow">return</span> 'VARCHAR';
<a name="l00027"></a>00027                 <span class="keywordflow">case</span> 'XL':
<a name="l00028"></a>00028                 <span class="keywordflow">case</span> <span class="charliteral">'X'</span>: <span class="keywordflow">return</span> 'LONG';
<a name="l00029"></a>00029                 
<a name="l00030"></a>00030                 <span class="keywordflow">case</span> 'C2': <span class="keywordflow">return</span> 'VARCHAR UNICODE';
<a name="l00031"></a>00031                 <span class="keywordflow">case</span> 'X2': <span class="keywordflow">return</span> 'LONG UNICODE';
<a name="l00032"></a>00032                 
<a name="l00033"></a>00033                 <span class="keywordflow">case</span> <span class="charliteral">'B'</span>: <span class="keywordflow">return</span> 'LONG';
<a name="l00034"></a>00034                         
<a name="l00035"></a>00035                 <span class="keywordflow">case</span> <span class="charliteral">'D'</span>: <span class="keywordflow">return</span> 'DATE';
<a name="l00036"></a>00036                 <span class="keywordflow">case</span> <span class="charliteral">'T'</span>: <span class="keywordflow">return</span> 'TIMESTAMP';
<a name="l00037"></a>00037                 
<a name="l00038"></a>00038                 <span class="keywordflow">case</span> <span class="charliteral">'L'</span>: <span class="keywordflow">return</span> 'BOOLEAN';
<a name="l00039"></a>00039                 <span class="keywordflow">case</span> <span class="charliteral">'I'</span>: <span class="keywordflow">return</span> 'INTEGER';
<a name="l00040"></a>00040                 <span class="keywordflow">case</span> 'I1': <span class="keywordflow">return</span> 'FIXED(3)';
<a name="l00041"></a>00041                 <span class="keywordflow">case</span> 'I2': <span class="keywordflow">return</span> 'SMALLINT';
<a name="l00042"></a>00042                 <span class="keywordflow">case</span> 'I4': <span class="keywordflow">return</span> 'INTEGER';
<a name="l00043"></a>00043                 <span class="keywordflow">case</span> 'I8': <span class="keywordflow">return</span> 'FIXED(20)';
<a name="l00044"></a>00044                 
<a name="l00045"></a>00045                 <span class="keywordflow">case</span> <span class="charliteral">'F'</span>: <span class="keywordflow">return</span> 'FLOAT(38)';
<a name="l00046"></a>00046                 <span class="keywordflow">case</span> <span class="charliteral">'N'</span>: <span class="keywordflow">return</span> 'FIXED';
<a name="l00047"></a>00047                 <span class="keywordflow">default</span>:
<a name="l00048"></a>00048                         <span class="keywordflow">return</span> $meta;
<a name="l00049"></a>00049                 }
<a name="l00050"></a>00050         }
<a name="l00051"></a>00051         
<a name="l00052"></a><a class="code" href="classADODB2__sapdb.html#d5f65a5e045f96b6e043a85dae76e481">00052</a>         function <a class="code" href="classADODB2__sapdb.html#d5f65a5e045f96b6e043a85dae76e481">MetaType</a>($t,$len=-1,$fieldobj=<span class="keyword">false</span>)
<a name="l00053"></a>00053         {
<a name="l00054"></a>00054                 <span class="keywordflow">if</span> (is_object($t)) {
<a name="l00055"></a>00055                         $fieldobj = $t;
<a name="l00056"></a>00056                         $t = $fieldobj-&gt;type;
<a name="l00057"></a>00057                         $len = $fieldobj-&gt;max_length;
<a name="l00058"></a>00058                 }
<a name="l00059"></a>00059                 <span class="keyword">static</span> $maxdb_type2adodb = array(
<a name="l00060"></a>00060                         'VARCHAR'       =&gt; <span class="charliteral">'C'</span>,
<a name="l00061"></a>00061                         'CHARACTER'     =&gt; <span class="charliteral">'C'</span>,
<a name="l00062"></a>00062                         'LONG'          =&gt; <span class="charliteral">'X'</span>,         <span class="comment">// no way to differ between 'X' and 'B' :-(</span>
<a name="l00063"></a>00063                         'DATE'          =&gt; <span class="charliteral">'D'</span>,
<a name="l00064"></a>00064                         'TIMESTAMP'     =&gt; <span class="charliteral">'T'</span>,
<a name="l00065"></a>00065                         'BOOLEAN'       =&gt; <span class="charliteral">'L'</span>,
<a name="l00066"></a>00066                         'INTEGER'       =&gt; 'I4',
<a name="l00067"></a>00067                         'SMALLINT'      =&gt; 'I2',
<a name="l00068"></a>00068                         'FLOAT'         =&gt; <span class="charliteral">'F'</span>,
<a name="l00069"></a>00069                         'FIXED'         =&gt; <span class="charliteral">'N'</span>,
<a name="l00070"></a>00070                 );
<a name="l00071"></a>00071                 $type = isset($maxdb_type2adodb[$t]) ? $maxdb_type2adodb[$t] : <span class="charliteral">'C'</span>;
<a name="l00072"></a>00072 
<a name="l00073"></a>00073                 <span class="comment">// convert integer-types simulated with fixed back to integer</span>
<a name="l00074"></a>00074                 <span class="keywordflow">if</span> ($t == 'FIXED' &amp;&amp; !$fieldobj-&gt;scale &amp;&amp; ($len == 20 || $len == 3)) {
<a name="l00075"></a>00075                         $type = $len == 20 ? 'I8' : 'I1';
<a name="l00076"></a>00076                 }
<a name="l00077"></a>00077                 <span class="keywordflow">if</span> ($fieldobj-&gt;auto_increment) $type = <span class="charliteral">'R'</span>;
<a name="l00078"></a>00078 
<a name="l00079"></a>00079                 <span class="keywordflow">return</span> $type;
<a name="l00080"></a>00080         }
<a name="l00081"></a>00081         
<a name="l00082"></a>00082         <span class="comment">// return string must begin with space</span>
<a name="l00083"></a><a class="code" href="classADODB2__sapdb.html#796f7f201382df4d97253b6d450edb93">00083</a>         function <a class="code" href="classADODB2__sapdb.html#796f7f201382df4d97253b6d450edb93">_CreateSuffix</a>($fname,$ftype,$fnotnull,$fdefault,$fautoinc,$fconstraint,$funsigned)
<a name="l00084"></a>00084         {       
<a name="l00085"></a>00085                 $suffix = '';
<a name="l00086"></a>00086                 <span class="keywordflow">if</span> ($funsigned) $suffix .= ' UNSIGNED';
<a name="l00087"></a>00087                 <span class="keywordflow">if</span> ($fnotnull) $suffix .= ' NOT NULL';
<a name="l00088"></a>00088                 <span class="keywordflow">if</span> ($fautoinc) $suffix .= ' DEFAULT SERIAL';
<a name="l00089"></a>00089                 elseif (strlen($fdefault)) $suffix .= <span class="stringliteral">" DEFAULT $fdefault"</span>;
<a name="l00090"></a>00090                 <span class="keywordflow">if</span> ($fconstraint) $suffix .= <span class="charliteral">' '</span>.$fconstraint;
<a name="l00091"></a>00091                 <span class="keywordflow">return</span> $suffix;
<a name="l00092"></a>00092         }
<a name="l00093"></a>00093 
<a name="l00094"></a><a class="code" href="classADODB2__sapdb.html#b4ccccfb1b045c4a9936ae71ec0df7f6">00094</a>         function <a class="code" href="classADODB2__sapdb.html#b4ccccfb1b045c4a9936ae71ec0df7f6">AddColumnSQL</a>($tabname, $flds)
<a name="l00095"></a>00095         {
<a name="l00096"></a>00096                 $tabname = $this-&gt;<a class="code" href="classADODB__DataDict.html#b89b6a7a466f8107c4d0042fae6fe642">TableName</a> ($tabname);
<a name="l00097"></a>00097                 $sql = array();
<a name="l00098"></a>00098                 list($lines,$pkey) = $this-&gt;<a class="code" href="classADODB__DataDict.html#241128fe02ae191ba3f8df56c6efb492">_GenFields</a>($flds);
<a name="l00099"></a>00099                 <span class="keywordflow">return</span> array( 'ALTER TABLE ' . $tabname . ' ADD (' . implode(', ',$lines) . <span class="charliteral">')'</span> );
<a name="l00100"></a>00100         }
<a name="l00101"></a>00101         
<a name="l00102"></a><a class="code" href="classADODB2__sapdb.html#ab942ba866b7a8f660910f81c23bdac8">00102</a>         function <a class="code" href="classADODB2__sapdb.html#ab942ba866b7a8f660910f81c23bdac8">AlterColumnSQL</a>($tabname, $flds)
<a name="l00103"></a>00103         {
<a name="l00104"></a>00104                 $tabname = $this-&gt;<a class="code" href="classADODB__DataDict.html#b89b6a7a466f8107c4d0042fae6fe642">TableName</a> ($tabname);
<a name="l00105"></a>00105                 $sql = array();
<a name="l00106"></a>00106                 list($lines,$pkey) = $this-&gt;<a class="code" href="classADODB__DataDict.html#241128fe02ae191ba3f8df56c6efb492">_GenFields</a>($flds);
<a name="l00107"></a>00107                 <span class="keywordflow">return</span> array( 'ALTER TABLE ' . $tabname . ' MODIFY (' . implode(', ',$lines) . <span class="charliteral">')'</span> );
<a name="l00108"></a>00108         }
<a name="l00109"></a>00109 
<a name="l00110"></a><a class="code" href="classADODB2__sapdb.html#df06e2e441a0b480c23d01873a5c32f6">00110</a>         function <a class="code" href="classADODB2__sapdb.html#df06e2e441a0b480c23d01873a5c32f6">DropColumnSQL</a>($tabname, $flds)
<a name="l00111"></a>00111         {
<a name="l00112"></a>00112                 $tabname = $this-&gt;<a class="code" href="classADODB__DataDict.html#b89b6a7a466f8107c4d0042fae6fe642">TableName</a> ($tabname);
<a name="l00113"></a>00113                 <span class="keywordflow">if</span> (!is_array($flds)) $flds = explode(<span class="charliteral">','</span>,$flds);
<a name="l00114"></a>00114                 foreach($flds as $k =&gt; $v) {
<a name="l00115"></a>00115                         $flds[$k] = $this-&gt;<a class="code" href="classADODB__DataDict.html#06441b9e67385e9882a553406c9a230e">NameQuote</a>($v);
<a name="l00116"></a>00116                 }
<a name="l00117"></a>00117                 <span class="keywordflow">return</span> array( 'ALTER TABLE ' . $tabname . ' DROP (' . implode(', ',$flds) . <span class="charliteral">')'</span> );
<a name="l00118"></a>00118         }       
<a name="l00119"></a>00119 }
<a name="l00120"></a>00120 
<a name="l00121"></a>00121 ?&gt;
</pre></div><?php
  include_once '../doc-typo3-funcs.php';
  get_footer();
?>