<?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-firebird.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-firebird.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><a class="code" href="classADODB2__firebird.html">00013</a> <span class="keyword">class </span><a class="code" href="classADODB2__firebird.html">ADODB2_firebird</a> <span class="keyword">extends</span> <a class="code" href="classADODB__DataDict.html">ADODB_DataDict</a> {
<a name="l00014"></a>00014         
<a name="l00015"></a><a class="code" href="classADODB2__firebird.html#8d07d688d39538cc2ffdcc5d03c373c4">00015</a>         var <a class="code" href="classADODB2__firebird.html#8d07d688d39538cc2ffdcc5d03c373c4">$databaseType</a> = 'firebird';
<a name="l00016"></a><a class="code" href="classADODB2__firebird.html#006b15c64c85e235ef5ba38c4cf2eaaf">00016</a>         var <a class="code" href="classADODB2__firebird.html#006b15c64c85e235ef5ba38c4cf2eaaf">$seqField</a> = <span class="keyword">false</span>;
<a name="l00017"></a><a class="code" href="classADODB2__firebird.html#4abbbc708866b885f10b0b1d6305fda9">00017</a>         var <a class="code" href="classADODB2__firebird.html#4abbbc708866b885f10b0b1d6305fda9">$seqPrefix</a> = 'gen_';
<a name="l00018"></a><a class="code" href="classADODB2__firebird.html#a1350031a51fe42b975e599a45dd0fcb">00018</a>         var <a class="code" href="classADODB2__firebird.html#a1350031a51fe42b975e599a45dd0fcb">$blobSize</a> = 40000;  
<a name="l00019"></a>00019         
<a name="l00020"></a><a class="code" href="classADODB2__firebird.html#d7a3ba413b3cfd76ff2912626a28ba3a">00020</a>         function <a class="code" href="classADODB2__firebird.html#d7a3ba413b3cfd76ff2912626a28ba3a">ActualType</a>($meta)
<a name="l00021"></a>00021         {
<a name="l00022"></a>00022                 <span class="keywordflow">switch</span>($meta) {
<a name="l00023"></a>00023                 <span class="keywordflow">case</span> <span class="charliteral">'C'</span>: <span class="keywordflow">return</span> 'VARCHAR';
<a name="l00024"></a>00024                 <span class="keywordflow">case</span> 'XL': <span class="keywordflow">return</span> 'VARCHAR(32000)'; 
<a name="l00025"></a>00025                 <span class="keywordflow">case</span> <span class="charliteral">'X'</span>: <span class="keywordflow">return</span> 'VARCHAR(4000)'; 
<a name="l00026"></a>00026                 
<a name="l00027"></a>00027                 <span class="keywordflow">case</span> 'C2': <span class="keywordflow">return</span> 'VARCHAR'; <span class="comment">// up to 32K</span>
<a name="l00028"></a>00028                 <span class="keywordflow">case</span> 'X2': <span class="keywordflow">return</span> 'VARCHAR(4000)';
<a name="l00029"></a>00029                 
<a name="l00030"></a>00030                 <span class="keywordflow">case</span> <span class="charliteral">'B'</span>: <span class="keywordflow">return</span> 'BLOB';
<a name="l00031"></a>00031                         
<a name="l00032"></a>00032                 <span class="keywordflow">case</span> <span class="charliteral">'D'</span>: <span class="keywordflow">return</span> 'DATE';
<a name="l00033"></a>00033                 <span class="keywordflow">case</span> <span class="charliteral">'T'</span>: <span class="keywordflow">return</span> 'TIMESTAMP';
<a name="l00034"></a>00034                 
<a name="l00035"></a>00035                 <span class="keywordflow">case</span> <span class="charliteral">'L'</span>: <span class="keywordflow">return</span> 'SMALLINT';
<a name="l00036"></a>00036                 <span class="keywordflow">case</span> <span class="charliteral">'I'</span>: <span class="keywordflow">return</span> 'INTEGER';
<a name="l00037"></a>00037                 <span class="keywordflow">case</span> 'I1': <span class="keywordflow">return</span> 'SMALLINT';
<a name="l00038"></a>00038                 <span class="keywordflow">case</span> 'I2': <span class="keywordflow">return</span> 'SMALLINT';
<a name="l00039"></a>00039                 <span class="keywordflow">case</span> 'I4': <span class="keywordflow">return</span> 'INTEGER';
<a name="l00040"></a>00040                 <span class="keywordflow">case</span> 'I8': <span class="keywordflow">return</span> 'INTEGER';
<a name="l00041"></a>00041                 
<a name="l00042"></a>00042                 <span class="keywordflow">case</span> <span class="charliteral">'F'</span>: <span class="keywordflow">return</span> 'DOUBLE PRECISION';
<a name="l00043"></a>00043                 <span class="keywordflow">case</span> <span class="charliteral">'N'</span>: <span class="keywordflow">return</span> 'DECIMAL';
<a name="l00044"></a>00044                 <span class="keywordflow">default</span>:
<a name="l00045"></a>00045                         <span class="keywordflow">return</span> $meta;
<a name="l00046"></a>00046                 }
<a name="l00047"></a>00047         }
<a name="l00048"></a>00048         
<a name="l00049"></a><a class="code" href="classADODB2__firebird.html#fbd0055e0e77b34410e480a1d9370680">00049</a>         function <a class="code" href="classADODB2__firebird.html#fbd0055e0e77b34410e480a1d9370680">NameQuote</a>($name = NULL)
<a name="l00050"></a>00050         {
<a name="l00051"></a>00051                 <span class="keywordflow">if</span> (!is_string($name)) {
<a name="l00052"></a>00052                         <span class="keywordflow">return</span> FALSE;
<a name="l00053"></a>00053                 }
<a name="l00054"></a>00054                 
<a name="l00055"></a>00055                 $name = trim($name);
<a name="l00056"></a>00056                 
<a name="l00057"></a>00057                 <span class="keywordflow">if</span> ( !is_object($this-&gt;connection) ) {
<a name="l00058"></a>00058                         <span class="keywordflow">return</span> $name;
<a name="l00059"></a>00059                 }
<a name="l00060"></a>00060                 
<a name="l00061"></a>00061                 $quote = $this-&gt;connection-&gt;nameQuote;
<a name="l00062"></a>00062                 
<a name="l00063"></a>00063                 <span class="comment">// if name is of the form `name`, quote it</span>
<a name="l00064"></a>00064                 <span class="keywordflow">if</span> ( preg_match('/^`(.+)`$/', $name, $matches) ) {
<a name="l00065"></a>00065                         <span class="keywordflow">return</span> $quote . $matches[1] . $quote;
<a name="l00066"></a>00066                 }
<a name="l00067"></a>00067                 
<a name="l00068"></a>00068                 <span class="comment">// if name contains special characters, quote it</span>
<a name="l00069"></a>00069                 <span class="keywordflow">if</span> ( !preg_match('/^[' . $this-&gt;nameRegex . ']+$/', $name) ) {
<a name="l00070"></a>00070                         <span class="keywordflow">return</span> $quote . $name . $quote;
<a name="l00071"></a>00071                 }
<a name="l00072"></a>00072                 
<a name="l00073"></a>00073                 <span class="keywordflow">return</span> $quote . $name . $quote;
<a name="l00074"></a>00074         }
<a name="l00075"></a>00075 
<a name="l00076"></a><a class="code" href="classADODB2__firebird.html#3d3aa2673d73ab30b39e766fb64f977f">00076</a>         function <a class="code" href="classADODB2__firebird.html#3d3aa2673d73ab30b39e766fb64f977f">CreateDatabase</a>($dbname, $options=<span class="keyword">false</span>)
<a name="l00077"></a>00077         {
<a name="l00078"></a>00078                 $options = $this-&gt;<a class="code" href="classADODB__DataDict.html#b87bb4e931500ec989f7038aaf08fd0f">_Options</a>($options);
<a name="l00079"></a>00079                 $sql = array();
<a name="l00080"></a>00080                 
<a name="l00081"></a>00081                 $sql[] = <span class="stringliteral">"DECLARE EXTERNAL FUNCTION LOWER CSTRING(80) RETURNS CSTRING(80) FREE_IT ENTRY_POINT 'IB_UDF_lower' MODULE_NAME 'ib_udf'"</span>;
<a name="l00082"></a>00082                 
<a name="l00083"></a>00083                 <span class="keywordflow">return</span> $sql;
<a name="l00084"></a>00084         }
<a name="l00085"></a>00085         
<a name="l00086"></a><a class="code" href="classADODB2__firebird.html#255b5acba705686994a864a9d0a84fdf">00086</a>         function <a class="code" href="classADODB2__firebird.html#255b5acba705686994a864a9d0a84fdf">_DropAutoIncrement</a>($t)
<a name="l00087"></a>00087         {
<a name="l00088"></a>00088                 <span class="keywordflow">if</span> (strpos($t,<span class="charliteral">'.'</span>) !== <span class="keyword">false</span>) {
<a name="l00089"></a>00089                         $tarr = explode(<span class="charliteral">'.'</span>,$t);
<a name="l00090"></a>00090                         <span class="keywordflow">return</span> 'DROP GENERATOR '.$tarr[0].'.<span class="stringliteral">"gen_'.$tarr[1].'"</span>';
<a name="l00091"></a>00091                 }
<a name="l00092"></a>00092                 <span class="keywordflow">return</span> 'DROP GENERATOR <span class="stringliteral">"GEN_'.$t;</span>
<a name="l00093"></a>00093 <span class="stringliteral">        }</span>
<a name="l00094"></a>00094 <span class="stringliteral">        </span>
<a name="l00095"></a>00095 <span class="stringliteral"></span>
<a name="l00096"></a><a class="code" href="classADODB2__firebird.html#b1f6a1532e27637bcd39ab1c69e3ef26">00096</a> <span class="stringliteral">        function _CreateSuffix($fname,$ftype,$fnotnull,$fdefault,$fautoinc,$fconstraint,$funsigned)</span>
<a name="l00097"></a>00097 <span class="stringliteral">        {</span>
<a name="l00098"></a>00098 <span class="stringliteral">                $suffix = '';</span>
<a name="l00099"></a>00099 <span class="stringliteral">                </span>
<a name="l00100"></a>00100 <span class="stringliteral">                if (strlen($fdefault)) $suffix .= "</span> DEFAULT $fdefault<span class="stringliteral">";</span>
<a name="l00101"></a>00101 <span class="stringliteral">                if ($fnotnull) $suffix .= ' NOT NULL';</span>
<a name="l00102"></a>00102 <span class="stringliteral">                if ($fautoinc) $this-&gt;seqField = $fname;</span>
<a name="l00103"></a>00103 <span class="stringliteral">                if ($fconstraint) $suffix .= ' '.$fconstraint;</span>
<a name="l00104"></a>00104 <span class="stringliteral">                </span>
<a name="l00105"></a>00105 <span class="stringliteral">                return $suffix;</span>
<a name="l00106"></a>00106 <span class="stringliteral">        }</span>
<a name="l00107"></a>00107 <span class="stringliteral">        </span>
<a name="l00108"></a>00108 <span class="stringliteral">/*</span>
<a name="l00109"></a>00109 <span class="stringliteral">CREATE or replace TRIGGER jaddress_insert</span>
<a name="l00110"></a>00110 <span class="stringliteral">before insert on jaddress</span>
<a name="l00111"></a>00111 <span class="stringliteral">for each row</span>
<a name="l00112"></a>00112 <span class="stringliteral">begin</span>
<a name="l00113"></a>00113 <span class="stringliteral">IF ( NEW."</span>seqField<span class="stringliteral">" IS NULL OR NEW."</span>seqField<span class="stringliteral">" = 0 ) THEN</span>
<a name="l00114"></a>00114 <span class="stringliteral">  NEW."</span>seqField<span class="stringliteral">" = GEN_ID("</span>GEN_tabname<span class="stringliteral">", 1);</span>
<a name="l00115"></a>00115 <span class="stringliteral">end;</span>
<a name="l00116"></a>00116 <span class="stringliteral">*/</span>
<a name="l00117"></a><a class="code" href="classADODB2__firebird.html#e2913119d97d777a153f31dd976ec7e4">00117</a> <span class="stringliteral">        function _Triggers($tabname,$tableoptions)</span>
<a name="l00118"></a>00118 <span class="stringliteral">        {       </span>
<a name="l00119"></a>00119 <span class="stringliteral">                if (!$this-&gt;seqField) return array();</span>
<a name="l00120"></a>00120 <span class="stringliteral">                </span>
<a name="l00121"></a>00121 <span class="stringliteral">                $tab1 = preg_replace( '/"</span>/', '', $tabname );
<a name="l00122"></a>00122                 <span class="keywordflow">if</span> ($this-&gt;schema) {
<a name="l00123"></a>00123                         $t = strpos($tab1,<span class="charliteral">'.'</span>);
<a name="l00124"></a>00124                         <span class="keywordflow">if</span> ($t !== <span class="keyword">false</span>) $tab = substr($tab1,$t+1);
<a name="l00125"></a>00125                         <span class="keywordflow">else</span> $tab = $tab1;
<a name="l00126"></a>00126                         <a class="code" href="classADODB2__firebird.html#006b15c64c85e235ef5ba38c4cf2eaaf">$seqField</a> = $this-&gt;seqField;
<a name="l00127"></a>00127                         $seqname = $this-&gt;schema.<span class="charliteral">'.'</span>.$this-&gt;seqPrefix.$tab;
<a name="l00128"></a>00128                         $trigname = $this-&gt;schema.'.trig_'.$this-&gt;seqPrefix.$tab;
<a name="l00129"></a>00129                 } <span class="keywordflow">else</span> {
<a name="l00130"></a>00130                         <a class="code" href="classADODB2__firebird.html#006b15c64c85e235ef5ba38c4cf2eaaf">$seqField</a> = $this-&gt;seqField;
<a name="l00131"></a>00131                         $seqname = $this-&gt;seqPrefix.$tab1;
<a name="l00132"></a>00132                         $trigname = 'trig_'.$seqname;
<a name="l00133"></a>00133                 }
<a name="l00134"></a>00134                 <span class="keywordflow">if</span> (isset($tableoptions['REPLACE']))
<a name="l00135"></a>00135                 { $sql[] = <span class="stringliteral">"DROP GENERATOR \"$seqname\""</span>;
<a name="l00136"></a>00136                   $sql[] = <span class="stringliteral">"CREATE GENERATOR \"$seqname\""</span>;
<a name="l00137"></a>00137                   $sql[] = <span class="stringliteral">"ALTER TRIGGER \"$trigname\" BEFORE INSERT OR UPDATE AS BEGIN IF ( NEW.$seqField IS NULL OR NEW.$seqField = 0 ) THEN NEW.$seqField = GEN_ID(\"$seqname\", 1); END"</span>;
<a name="l00138"></a>00138                 }
<a name="l00139"></a>00139                 <span class="keywordflow">else</span>
<a name="l00140"></a>00140                 { $sql[] = <span class="stringliteral">"CREATE GENERATOR \"$seqname\""</span>;
<a name="l00141"></a>00141                   $sql[] = <span class="stringliteral">"CREATE TRIGGER \"$trigname\" FOR $tabname BEFORE INSERT OR UPDATE AS BEGIN IF ( NEW.$seqField IS NULL OR NEW.$seqField = 0 ) THEN NEW.$seqField = GEN_ID(\"$seqname\", 1); END"</span>;
<a name="l00142"></a>00142                 }
<a name="l00143"></a>00143                 
<a name="l00144"></a>00144                 $this-&gt;seqField = <span class="keyword">false</span>;
<a name="l00145"></a>00145                 <span class="keywordflow">return</span> $sql;
<a name="l00146"></a>00146         }
<a name="l00147"></a>00147 
<a name="l00148"></a>00148 }
<a name="l00149"></a>00149 
<a name="l00150"></a>00150 
<a name="l00151"></a>00151 ?&gt;
</pre></div><?php
  include_once '../doc-typo3-funcs.php';
  get_footer();
?>