<div id="content"> <h1 align="center">Source for file Informix.php</h1> <p>Documentation is available at <a href="../Doctrine/_Doctrine---DataDict---Informix.php.html">Informix.php</a></p> <div class="src-code"><span class="php"> <ol><li><div class="src-line"><a name="a1"></a><span class="src-php"><?php</span></div></li> <li><div class="src-line"><a name="a2"></a><span class="src-comm">/*</span></div></li> <li><div class="src-line"><a name="a3"></a><span class="src-comm"> * $Id: Informix.php 1273 2007-04-18 11:11:07Z zYne $</span></div></li> <li><div class="src-line"><a name="a4"></a><span class="src-comm"> *</span></div></li> <li><div class="src-line"><a name="a5"></a><span class="src-comm"> * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS</span></div></li> <li><div class="src-line"><a name="a6"></a><span class="src-comm"> * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT</span></div></li> <li><div class="src-line"><a name="a7"></a><span class="src-comm"> * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR</span></div></li> <li><div class="src-line"><a name="a8"></a><span class="src-comm"> * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT</span></div></li> <li><div class="src-line"><a name="a9"></a><span class="src-comm"> * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,</span></div></li> <li><div class="src-line"><a name="a10"></a><span class="src-comm"> * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT</span></div></li> <li><div class="src-line"><a name="a11"></a><span class="src-comm"> * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,</span></div></li> <li><div class="src-line"><a name="a12"></a><span class="src-comm"> * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY</span></div></li> <li><div class="src-line"><a name="a13"></a><span class="src-comm"> * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT</span></div></li> <li><div class="src-line"><a name="a14"></a><span class="src-comm"> * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE</span></div></li> <li><div class="src-line"><a name="a15"></a><span class="src-comm"> * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.</span></div></li> <li><div class="src-line"><a name="a16"></a><span class="src-comm"> *</span></div></li> <li><div class="src-line"><a name="a17"></a><span class="src-comm"> * This software consists of voluntary contributions made by many individuals</span></div></li> <li><div class="src-line"><a name="a18"></a><span class="src-comm"> * and is licensed under the LGPL. For more information, see</span></div></li> <li><div class="src-line"><a name="a19"></a><span class="src-comm"> * <http://www.phpdoctrine.com>.</span></div></li> <li><div class="src-line"><a name="a20"></a><span class="src-comm"> */</span></div></li> <li><div class="src-line"><a name="a21"></a><span class="src-id"><a href="../Doctrine/Doctrine.html">Doctrine</a></span><span class="src-sym">::</span><a href="../Doctrine/Doctrine.html#methodautoload">autoload</a><span class="src-sym">(</span><span class="src-str">'Doctrine_DataDict'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a22"></a><span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a23"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc"> Doctrine</span></div></li> <li><div class="src-line"><a name="a24"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@license</span><span class="src-doc"> http://www.opensource.org/licenses/lgpl-license.php LGPL</span></div></li> <li><div class="src-line"><a name="a25"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@author</span><span class="src-doc"> Konsta Vesterinen <kvesteri@cc.hut.fi></span></div></li> <li><div class="src-line"><a name="a26"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@author</span><span class="src-doc"> Lukas Smith <smith@pooteeweet.org> (PEAR MDB2 library)</span></div></li> <li><div class="src-line"><a name="a27"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@version</span><span class="src-doc"> $Revision: 1273 $</span></div></li> <li><div class="src-line"><a name="a28"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@category</span><span class="src-doc"> Object Relational Mapping</span></div></li> <li><div class="src-line"><a name="a29"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@link</span><span class="src-doc"> www.phpdoctrine.com</span></div></li> <li><div class="src-line"><a name="a30"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@since</span><span class="src-doc"> 1.0</span></div></li> <li><div class="src-line"><a name="a31"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a32"></a><span class="src-key">class </span><a href="../Doctrine/Doctrine_DataDict_Informix.html">Doctrine_DataDict_Informix</a> <span class="src-key">extends </span><a href="../Doctrine/Doctrine_DataDict.html">Doctrine_DataDict</a></div></li> <li><div class="src-line"><a name="a33"></a><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a34"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a35"></a><span class="src-doc"> * Obtain DBMS specific SQL code portion needed to declare an text type</span></div></li> <li><div class="src-line"><a name="a36"></a><span class="src-doc"> * field to be used in statements like CREATE TABLE.</span></div></li> <li><div class="src-line"><a name="a37"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a38"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">array </span><span class="src-doc-var">$field </span><span class="src-doc"> associative array with the name of the properties</span></div></li> <li><div class="src-line"><a name="a39"></a><span class="src-doc"> * of the field being declared as array indexes. Currently, the types</span></div></li> <li><div class="src-line"><a name="a40"></a><span class="src-doc"> * of supported field properties are as follows:</span></div></li> <li><div class="src-line"><a name="a41"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a42"></a><span class="src-doc"> * length</span></div></li> <li><div class="src-line"><a name="a43"></a><span class="src-doc"> * Integer value that determines the maximum length of the text</span></div></li> <li><div class="src-line"><a name="a44"></a><span class="src-doc"> * field. If this argument is missing the field should be</span></div></li> <li><div class="src-line"><a name="a45"></a><span class="src-doc"> * declared to have the longest length allowed by the DBMS.</span></div></li> <li><div class="src-line"><a name="a46"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a47"></a><span class="src-doc"> * default</span></div></li> <li><div class="src-line"><a name="a48"></a><span class="src-doc"> * Text value to be used as default for this field.</span></div></li> <li><div class="src-line"><a name="a49"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a50"></a><span class="src-doc"> * notnull</span></div></li> <li><div class="src-line"><a name="a51"></a><span class="src-doc"> * Boolean flag that indicates whether this field is constrained</span></div></li> <li><div class="src-line"><a name="a52"></a><span class="src-doc"> * to not be set to null.</span></div></li> <li><div class="src-line"><a name="a53"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a54"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span><span class="src-doc"> DBMS specific SQL code portion that should be used to</span></div></li> <li><div class="src-line"><a name="a55"></a><span class="src-doc"> * declare the specified field.</span></div></li> <li><div class="src-line"><a name="a56"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a57"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_DataDict_Informix.html#methodgetNativeDeclaration">getNativeDeclaration</a><span class="src-sym">(</span><span class="src-var">$field</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a58"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a59"></a> <span class="src-key">if </span><span class="src-sym">( </span><span class="src-sym">! </span>isset<span class="src-sym">(</span><span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'type'</span><span class="src-sym">]</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a60"></a> throw <span class="src-key">new </span><span class="src-id"><a href="../Doctrine/Doctrine_DataDict_Exception.html">Doctrine_DataDict_Exception</a></span><span class="src-sym">(</span><span class="src-str">'Missing column type.'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a61"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a62"></a> <span class="src-key">switch </span><span class="src-sym">(</span><span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'type'</span><span class="src-sym">]</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a63"></a> <span class="src-key">case </span><span class="src-str">'char'</span>:</div></li> <li><div class="src-line"><a name="a64"></a> <span class="src-key">case </span><span class="src-str">'varchar'</span>:</div></li> <li><div class="src-line"><a name="a65"></a> <span class="src-key">case </span><span class="src-str">'array'</span>:</div></li> <li><div class="src-line"><a name="a66"></a> <span class="src-key">case </span><span class="src-str">'object'</span>:</div></li> <li><div class="src-line"><a name="a67"></a> <span class="src-key">case </span><span class="src-str">'string'</span>:</div></li> <li><div class="src-line"><a name="a68"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-key">empty</span><span class="src-sym">(</span><span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'length'</span><span class="src-sym">]</span><span class="src-sym">) </span>&& <a href="http://www.php.net/array_key_exists">array_key_exists</a><span class="src-sym">(</span><span class="src-str">'default'</span><span class="src-sym">, </span><span class="src-var">$field</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a69"></a> <span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'length'</span><span class="src-sym">] </span>= <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Connection_Module.html#var$conn">conn</a><span class="src-sym">-></span><span class="src-id">varchar_max_length</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a70"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a71"></a> </div></li> <li><div class="src-line"><a name="a72"></a> <span class="src-var">$length </span>= <span class="src-sym">(</span><span class="src-sym">! </span><span class="src-key">empty</span><span class="src-sym">(</span><span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'length'</span><span class="src-sym">]</span><span class="src-sym">)) </span>? <span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'length'</span><span class="src-sym">] </span>: <span class="src-id">false</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a73"></a> <span class="src-var">$fixed </span>= <span class="src-sym">((</span>isset<span class="src-sym">(</span><span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'fixed'</span><span class="src-sym">]</span><span class="src-sym">) </span>&& <span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'fixed'</span><span class="src-sym">]</span><span class="src-sym">) </span>|| <span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'type'</span><span class="src-sym">] </span>== <span class="src-str">'char'</span><span class="src-sym">) </span>? <span class="src-id">true </span>: <span class="src-id">false</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a74"></a> </div></li> <li><div class="src-line"><a name="a75"></a> <span class="src-key">return </span><span class="src-var">$fixed </span>? <span class="src-sym">(</span><span class="src-var">$length </span>? <span class="src-str">'CHAR('</span>.<span class="src-var">$length</span>.<span class="src-str">')' </span>: <span class="src-str">'CHAR(255)'</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a76"></a> : <span class="src-sym">(</span><span class="src-var">$length </span>? <span class="src-str">'VARCHAR('</span>.<span class="src-var">$length</span>.<span class="src-str">')' </span>: <span class="src-str">'NVARCHAR'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a77"></a> <span class="src-key">case </span><span class="src-str">'clob'</span>:</div></li> <li><div class="src-line"><a name="a78"></a> <span class="src-key">return </span><span class="src-str">'TEXT'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a79"></a> <span class="src-key">case </span><span class="src-str">'blob'</span>:</div></li> <li><div class="src-line"><a name="a80"></a> <span class="src-key">return </span><span class="src-str">'BLOB'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a81"></a> <span class="src-key">case </span><span class="src-str">'integer'</span>:</div></li> <li><div class="src-line"><a name="a82"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-sym">!</span><span class="src-key">empty</span><span class="src-sym">(</span><span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'length'</span><span class="src-sym">]</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a83"></a> <span class="src-var">$length </span>= <span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'length'</span><span class="src-sym">]</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a84"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$length </span><= <span class="src-num">1</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a85"></a> <span class="src-key">return </span><span class="src-str">'SMALLINT'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a86"></a> <span class="src-sym">} </span><span class="src-key">elseif </span><span class="src-sym">(</span><span class="src-var">$length </span>== <span class="src-num">2</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a87"></a> <span class="src-key">return </span><span class="src-str">'SMALLINT'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a88"></a> <span class="src-sym">} </span><span class="src-key">elseif </span><span class="src-sym">(</span><span class="src-var">$length </span>== <span class="src-num">3 </span>|| <span class="src-var">$length </span>== <span class="src-num">4</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a89"></a> <span class="src-key">return </span><span class="src-str">'INTEGER'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a90"></a> <span class="src-sym">} </span><span class="src-key">elseif </span><span class="src-sym">(</span><span class="src-var">$length </span>> <span class="src-num">4</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a91"></a> <span class="src-key">return </span><span class="src-str">'DECIMAL(20)'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a92"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a93"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a94"></a> <span class="src-key">return </span><span class="src-str">'INT'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a95"></a> <span class="src-key">case </span><span class="src-str">'boolean'</span>:</div></li> <li><div class="src-line"><a name="a96"></a> <span class="src-key">return </span><span class="src-str">'SMALLINT'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a97"></a> <span class="src-key">case </span><span class="src-str">'date'</span>:</div></li> <li><div class="src-line"><a name="a98"></a> <span class="src-key">return </span><span class="src-str">'DATE'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a99"></a> <span class="src-key">case </span><span class="src-str">'time'</span>:</div></li> <li><div class="src-line"><a name="a100"></a> <span class="src-key">return </span><span class="src-str">'DATETIME YEAR TO SECOND'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a101"></a> <span class="src-key">case </span><span class="src-str">'timestamp'</span>:</div></li> <li><div class="src-line"><a name="a102"></a> <span class="src-key">return </span><span class="src-str">'DATETIME'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a103"></a> <span class="src-key">case </span><span class="src-str">'float'</span>:</div></li> <li><div class="src-line"><a name="a104"></a> <span class="src-key">return </span><span class="src-str">'FLOAT'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a105"></a> <span class="src-key">case </span><span class="src-str">'decimal'</span>:</div></li> <li><div class="src-line"><a name="a106"></a> <span class="src-key">return </span><span class="src-str">'DECIMAL'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a107"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a108"></a> throw <span class="src-key">new </span><span class="src-id"><a href="../Doctrine/Doctrine_DataDict_Exception.html">Doctrine_DataDict_Exception</a></span><span class="src-sym">(</span><span class="src-str">'Unknown field type \'' </span>. <span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'type'</span><span class="src-sym">] </span>. <span class="src-str">'\'.'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a109"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a110"></a><span class="src-sym">}</span></div></li> </ol> </span></div> </div>