<div id="content"> <h1 align="center">Source for file Pgsql.php</h1> <p>Documentation is available at <a href="../Doctrine/Doctrine_DataDict/_Doctrine---DataDict---Pgsql.php.html">Pgsql.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: Pgsql.php 2033 2007-07-21 15:17:17Z romanb $</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">@subpackage</span><span class="src-doc"> Doctrine_DataDict</span></div></li> <li><div class="src-line"><a name="a25"></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="a26"></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="a27"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@author</span><span class="src-doc"> Paul Cooper <pgc@ucecom.com></span></div></li> <li><div class="src-line"><a name="a28"></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="a29"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@version</span><span class="src-doc"> $Revision: 2033 $</span></div></li> <li><div class="src-line"><a name="a30"></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="a31"></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="a32"></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="a33"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a34"></a><span class="src-key">class </span><a href="../Doctrine/Doctrine_DataDict/Doctrine_DataDict_Pgsql.html">Doctrine_DataDict_Pgsql</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="a35"></a><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a36"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a37"></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">$reservedKeyWords </span><span class="src-doc"> an array of reserved keywords by pgsql</span></div></li> <li><div class="src-line"><a name="a38"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a39"></a> <span class="src-key">protected </span><span class="src-key">static </span><span class="src-var">$reservedKeyWords </span>= <span class="src-key">array</span><span class="src-sym">(</span></div></li> <li><div class="src-line"><a name="a40"></a> <span class="src-str">'abort'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a41"></a> <span class="src-str">'absolute'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a42"></a> <span class="src-str">'access'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a43"></a> <span class="src-str">'action'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a44"></a> <span class="src-str">'add'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a45"></a> <span class="src-str">'after'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a46"></a> <span class="src-str">'aggregate'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a47"></a> <span class="src-str">'all'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a48"></a> <span class="src-str">'alter'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a49"></a> <span class="src-str">'analyse'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a50"></a> <span class="src-str">'analyze'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a51"></a> <span class="src-str">'and'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a52"></a> <span class="src-str">'any'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a53"></a> <span class="src-str">'as'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a54"></a> <span class="src-str">'asc'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a55"></a> <span class="src-str">'assertion'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a56"></a> <span class="src-str">'assignment'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a57"></a> <span class="src-str">'at'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a58"></a> <span class="src-str">'authorization'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a59"></a> <span class="src-str">'backward'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a60"></a> <span class="src-str">'before'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a61"></a> <span class="src-str">'begin'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a62"></a> <span class="src-str">'between'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a63"></a> <span class="src-str">'bigint'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a64"></a> <span class="src-str">'binary'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a65"></a> <span class="src-str">'bit'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a66"></a> <span class="src-str">'boolean'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a67"></a> <span class="src-str">'both'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a68"></a> <span class="src-str">'by'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a69"></a> <span class="src-str">'cache'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a70"></a> <span class="src-str">'called'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a71"></a> <span class="src-str">'cascade'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a72"></a> <span class="src-str">'case'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a73"></a> <span class="src-str">'cast'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a74"></a> <span class="src-str">'chain'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a75"></a> <span class="src-str">'char'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a76"></a> <span class="src-str">'character'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a77"></a> <span class="src-str">'characteristics'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a78"></a> <span class="src-str">'check'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a79"></a> <span class="src-str">'checkpoint'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a80"></a> <span class="src-str">'class'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a81"></a> <span class="src-str">'close'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a82"></a> <span class="src-str">'cluster'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a83"></a> <span class="src-str">'coalesce'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a84"></a> <span class="src-str">'collate'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a85"></a> <span class="src-str">'column'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a86"></a> <span class="src-str">'comment'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a87"></a> <span class="src-str">'commit'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a88"></a> <span class="src-str">'committed'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a89"></a> <span class="src-str">'constraint'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a90"></a> <span class="src-str">'constraints'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a91"></a> <span class="src-str">'conversion'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a92"></a> <span class="src-str">'convert'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a93"></a> <span class="src-str">'copy'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a94"></a> <span class="src-str">'create'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a95"></a> <span class="src-str">'createdb'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a96"></a> <span class="src-str">'createuser'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a97"></a> <span class="src-str">'cross'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a98"></a> <span class="src-str">'current_date'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a99"></a> <span class="src-str">'current_time'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a100"></a> <span class="src-str">'current_timestamp'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a101"></a> <span class="src-str">'current_user'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a102"></a> <span class="src-str">'cursor'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a103"></a> <span class="src-str">'cycle'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a104"></a> <span class="src-str">'database'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a105"></a> <span class="src-str">'day'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a106"></a> <span class="src-str">'deallocate'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a107"></a> <span class="src-str">'dec'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a108"></a> <span class="src-str">'decimal'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a109"></a> <span class="src-str">'declare'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a110"></a> <span class="src-str">'default'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a111"></a> <span class="src-str">'deferrable'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a112"></a> <span class="src-str">'deferred'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a113"></a> <span class="src-str">'definer'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a114"></a> <span class="src-str">'delete'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a115"></a> <span class="src-str">'delimiter'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a116"></a> <span class="src-str">'delimiters'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a117"></a> <span class="src-str">'desc'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a118"></a> <span class="src-str">'distinct'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a119"></a> <span class="src-str">'do'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a120"></a> <span class="src-str">'domain'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a121"></a> <span class="src-str">'double'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a122"></a> <span class="src-str">'drop'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a123"></a> <span class="src-str">'each'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a124"></a> <span class="src-str">'else'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a125"></a> <span class="src-str">'encoding'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a126"></a> <span class="src-str">'encrypted'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a127"></a> <span class="src-str">'end'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a128"></a> <span class="src-str">'escape'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a129"></a> <span class="src-str">'except'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a130"></a> <span class="src-str">'exclusive'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a131"></a> <span class="src-str">'execute'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a132"></a> <span class="src-str">'exists'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a133"></a> <span class="src-str">'explain'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a134"></a> <span class="src-str">'external'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a135"></a> <span class="src-str">'extract'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a136"></a> <span class="src-str">'false'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a137"></a> <span class="src-str">'fetch'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a138"></a> <span class="src-str">'float'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a139"></a> <span class="src-str">'for'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a140"></a> <span class="src-str">'force'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a141"></a> <span class="src-str">'foreign'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a142"></a> <span class="src-str">'forward'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a143"></a> <span class="src-str">'freeze'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a144"></a> <span class="src-str">'from'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a145"></a> <span class="src-str">'full'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a146"></a> <span class="src-str">'function'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a147"></a> <span class="src-str">'get'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a148"></a> <span class="src-str">'global'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a149"></a> <span class="src-str">'grant'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a150"></a> <span class="src-str">'group'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a151"></a> <span class="src-str">'handler'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a152"></a> <span class="src-str">'having'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a153"></a> <span class="src-str">'hour'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a154"></a> <span class="src-str">'ilike'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a155"></a> <span class="src-str">'immediate'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a156"></a> <span class="src-str">'immutable'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a157"></a> <span class="src-str">'implicit'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a158"></a> <span class="src-str">'in'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a159"></a> <span class="src-str">'increment'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a160"></a> <span class="src-str">'index'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a161"></a> <span class="src-str">'inherits'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a162"></a> <span class="src-str">'initially'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a163"></a> <span class="src-str">'inner'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a164"></a> <span class="src-str">'inout'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a165"></a> <span class="src-str">'input'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a166"></a> <span class="src-str">'insensitive'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a167"></a> <span class="src-str">'insert'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a168"></a> <span class="src-str">'instead'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a169"></a> <span class="src-str">'int'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a170"></a> <span class="src-str">'integer'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a171"></a> <span class="src-str">'intersect'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a172"></a> <span class="src-str">'interval'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a173"></a> <span class="src-str">'into'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a174"></a> <span class="src-str">'invoker'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a175"></a> <span class="src-str">'is'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a176"></a> <span class="src-str">'isnull'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a177"></a> <span class="src-str">'isolation'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a178"></a> <span class="src-str">'join'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a179"></a> <span class="src-str">'key'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a180"></a> <span class="src-str">'lancompiler'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a181"></a> <span class="src-str">'language'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a182"></a> <span class="src-str">'leading'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a183"></a> <span class="src-str">'left'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a184"></a> <span class="src-str">'level'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a185"></a> <span class="src-str">'like'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a186"></a> <span class="src-str">'limit'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a187"></a> <span class="src-str">'listen'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a188"></a> <span class="src-str">'load'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a189"></a> <span class="src-str">'local'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a190"></a> <span class="src-str">'localtime'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a191"></a> <span class="src-str">'localtimestamp'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a192"></a> <span class="src-str">'location'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a193"></a> <span class="src-str">'lock'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a194"></a> <span class="src-str">'match'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a195"></a> <span class="src-str">'maxvalue'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a196"></a> <span class="src-str">'minute'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a197"></a> <span class="src-str">'minvalue'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a198"></a> <span class="src-str">'mode'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a199"></a> <span class="src-str">'month'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a200"></a> <span class="src-str">'move'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a201"></a> <span class="src-str">'names'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a202"></a> <span class="src-str">'national'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a203"></a> <span class="src-str">'natural'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a204"></a> <span class="src-str">'nchar'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a205"></a> <span class="src-str">'new'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a206"></a> <span class="src-str">'next'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a207"></a> <span class="src-str">'no'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a208"></a> <span class="src-str">'nocreatedb'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a209"></a> <span class="src-str">'nocreateuser'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a210"></a> <span class="src-str">'none'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a211"></a> <span class="src-str">'not'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a212"></a> <span class="src-str">'nothing'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a213"></a> <span class="src-str">'notify'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a214"></a> <span class="src-str">'notnull'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a215"></a> <span class="src-str">'null'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a216"></a> <span class="src-str">'nullif'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a217"></a> <span class="src-str">'numeric'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a218"></a> <span class="src-str">'of'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a219"></a> <span class="src-str">'off'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a220"></a> <span class="src-str">'offset'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a221"></a> <span class="src-str">'oids'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a222"></a> <span class="src-str">'old'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a223"></a> <span class="src-str">'on'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a224"></a> <span class="src-str">'only'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a225"></a> <span class="src-str">'operator'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a226"></a> <span class="src-str">'option'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a227"></a> <span class="src-str">'or'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a228"></a> <span class="src-str">'order'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a229"></a> <span class="src-str">'out'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a230"></a> <span class="src-str">'outer'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a231"></a> <span class="src-str">'overlaps'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a232"></a> <span class="src-str">'overlay'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a233"></a> <span class="src-str">'owner'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a234"></a> <span class="src-str">'partial'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a235"></a> <span class="src-str">'password'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a236"></a> <span class="src-str">'path'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a237"></a> <span class="src-str">'pendant'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a238"></a> <span class="src-str">'placing'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a239"></a> <span class="src-str">'position'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a240"></a> <span class="src-str">'precision'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a241"></a> <span class="src-str">'prepare'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a242"></a> <span class="src-str">'primary'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a243"></a> <span class="src-str">'prior'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a244"></a> <span class="src-str">'privileges'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a245"></a> <span class="src-str">'procedural'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a246"></a> <span class="src-str">'procedure'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a247"></a> <span class="src-str">'read'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a248"></a> <span class="src-str">'real'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a249"></a> <span class="src-str">'recheck'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a250"></a> <span class="src-str">'references'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a251"></a> <span class="src-str">'reindex'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a252"></a> <span class="src-str">'relative'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a253"></a> <span class="src-str">'rename'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a254"></a> <span class="src-str">'replace'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a255"></a> <span class="src-str">'reset'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a256"></a> <span class="src-str">'restrict'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a257"></a> <span class="src-str">'returns'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a258"></a> <span class="src-str">'revoke'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a259"></a> <span class="src-str">'right'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a260"></a> <span class="src-str">'rollback'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a261"></a> <span class="src-str">'row'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a262"></a> <span class="src-str">'rule'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a263"></a> <span class="src-str">'schema'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a264"></a> <span class="src-str">'scroll'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a265"></a> <span class="src-str">'second'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a266"></a> <span class="src-str">'security'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a267"></a> <span class="src-str">'select'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a268"></a> <span class="src-str">'sequence'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a269"></a> <span class="src-str">'serializable'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a270"></a> <span class="src-str">'session'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a271"></a> <span class="src-str">'session_user'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a272"></a> <span class="src-str">'set'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a273"></a> <span class="src-str">'setof'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a274"></a> <span class="src-str">'share'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a275"></a> <span class="src-str">'show'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a276"></a> <span class="src-str">'similar'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a277"></a> <span class="src-str">'simple'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a278"></a> <span class="src-str">'smallint'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a279"></a> <span class="src-str">'some'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a280"></a> <span class="src-str">'stable'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a281"></a> <span class="src-str">'start'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a282"></a> <span class="src-str">'statement'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a283"></a> <span class="src-str">'statistics'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a284"></a> <span class="src-str">'stdin'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a285"></a> <span class="src-str">'stdout'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a286"></a> <span class="src-str">'storage'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a287"></a> <span class="src-str">'strict'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a288"></a> <span class="src-str">'substring'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a289"></a> <span class="src-str">'sysid'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a290"></a> <span class="src-str">'table'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a291"></a> <span class="src-str">'temp'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a292"></a> <span class="src-str">'template'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a293"></a> <span class="src-str">'temporary'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a294"></a> <span class="src-str">'then'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a295"></a> <span class="src-str">'time'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a296"></a> <span class="src-str">'timestamp'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a297"></a> <span class="src-str">'to'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a298"></a> <span class="src-str">'toast'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a299"></a> <span class="src-str">'trailing'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a300"></a> <span class="src-str">'transaction'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a301"></a> <span class="src-str">'treat'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a302"></a> <span class="src-str">'trigger'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a303"></a> <span class="src-str">'trim'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a304"></a> <span class="src-str">'true'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a305"></a> <span class="src-str">'truncate'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a306"></a> <span class="src-str">'trusted'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a307"></a> <span class="src-str">'type'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a308"></a> <span class="src-str">'unencrypted'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a309"></a> <span class="src-str">'union'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a310"></a> <span class="src-str">'unique'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a311"></a> <span class="src-str">'unknown'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a312"></a> <span class="src-str">'unlisten'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a313"></a> <span class="src-str">'until'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a314"></a> <span class="src-str">'update'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a315"></a> <span class="src-str">'usage'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a316"></a> <span class="src-str">'user'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a317"></a> <span class="src-str">'using'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a318"></a> <span class="src-str">'vacuum'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a319"></a> <span class="src-str">'valid'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a320"></a> <span class="src-str">'validator'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a321"></a> <span class="src-str">'values'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a322"></a> <span class="src-str">'varchar'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a323"></a> <span class="src-str">'varying'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a324"></a> <span class="src-str">'verbose'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a325"></a> <span class="src-str">'version'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a326"></a> <span class="src-str">'view'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a327"></a> <span class="src-str">'volatile'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a328"></a> <span class="src-str">'when'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a329"></a> <span class="src-str">'where'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a330"></a> <span class="src-str">'with'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a331"></a> <span class="src-str">'without'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a332"></a> <span class="src-str">'work'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a333"></a> <span class="src-str">'write'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a334"></a> <span class="src-str">'year'</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a335"></a> <span class="src-str">'zone'</span></div></li> <li><div class="src-line"><a name="a336"></a> <span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a337"></a> </div></li> <li><div class="src-line"><a name="a338"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a339"></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="a340"></a><span class="src-doc"> * field to be used in statements like CREATE TABLE.</span></div></li> <li><div class="src-line"><a name="a341"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a342"></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="a343"></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="a344"></a><span class="src-doc"> * of supported field properties are as follows:</span></div></li> <li><div class="src-line"><a name="a345"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a346"></a><span class="src-doc"> * length</span></div></li> <li><div class="src-line"><a name="a347"></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="a348"></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="a349"></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="a350"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a351"></a><span class="src-doc"> * default</span></div></li> <li><div class="src-line"><a name="a352"></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="a353"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a354"></a><span class="src-doc"> * notnull</span></div></li> <li><div class="src-line"><a name="a355"></a><span class="src-doc"> * Boolean flag that indicates whether this field is constrained</span></div></li> <li><div class="src-line"><a name="a356"></a><span class="src-doc"> * to not be set to null.</span></div></li> <li><div class="src-line"><a name="a357"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a358"></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="a359"></a><span class="src-doc"> * declare the specified field.</span></div></li> <li><div class="src-line"><a name="a360"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a361"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_DataDict/Doctrine_DataDict_Pgsql.html#methodgetNativeDeclaration">getNativeDeclaration</a><span class="src-sym">(</span><span class="src-key">array </span><span class="src-var">$field</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a362"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a363"></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="a364"></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="a365"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a366"></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="a367"></a> <span class="src-key">case </span><span class="src-str">'char'</span>:</div></li> <li><div class="src-line"><a name="a368"></a> <span class="src-key">case </span><span class="src-str">'string'</span>:</div></li> <li><div class="src-line"><a name="a369"></a> <span class="src-key">case </span><span class="src-str">'array'</span>:</div></li> <li><div class="src-line"><a name="a370"></a> <span class="src-key">case </span><span class="src-str">'object'</span>:</div></li> <li><div class="src-line"><a name="a371"></a> <span class="src-key">case </span><span class="src-str">'varchar'</span>: </div></li> <li><div class="src-line"><a name="a372"></a> <span class="src-key">case </span><span class="src-str">'gzip'</span>:</div></li> <li><div class="src-line"><a name="a373"></a> <span class="src-var">$length </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">'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-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">null</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a374"></a> <span class="src-comm">// TODO: $this->conn->options['default_text_field_length'];</span></div></li> <li><div class="src-line"><a name="a375"></a> </div></li> <li><div class="src-line"><a name="a376"></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="a377"></a> </div></li> <li><div class="src-line"><a name="a378"></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('</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">options</span><span class="src-sym">[</span><span class="src-str">'default_text_field_length'</span><span class="src-sym">]</span>.<span class="src-str">')'</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a379"></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">'TEXT'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a380"></a> </div></li> <li><div class="src-line"><a name="a381"></a> <span class="src-key">case </span><span class="src-str">'clob'</span>:</div></li> <li><div class="src-line"><a name="a382"></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="a383"></a> <span class="src-key">case </span><span class="src-str">'blob'</span>:</div></li> <li><div class="src-line"><a name="a384"></a> <span class="src-key">return </span><span class="src-str">'BYTEA'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a385"></a> <span class="src-key">case </span><span class="src-str">'enum'</span>:</div></li> <li><div class="src-line"><a name="a386"></a> <span class="src-key">case </span><span class="src-str">'integer'</span>:</div></li> <li><div class="src-line"><a name="a387"></a> <span class="src-key">case </span><span class="src-str">'int'</span>:</div></li> <li><div class="src-line"><a name="a388"></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">'autoincrement'</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="a389"></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="a390"></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="a391"></a> <span class="src-key">if </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="a392"></a> <span class="src-key">return </span><span class="src-str">'BIGSERIAL'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a393"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a394"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a395"></a> <span class="src-key">return </span><span class="src-str">'SERIAL'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a396"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a397"></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="a398"></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="a399"></a> <span class="src-key">if </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="a400"></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="a401"></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="a402"></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="a403"></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="a404"></a> <span class="src-key">return </span><span class="src-str">'BIGINT'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a405"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a406"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a407"></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="a408"></a> <span class="src-key">case </span><span class="src-str">'boolean'</span>:</div></li> <li><div class="src-line"><a name="a409"></a> <span class="src-key">return </span><span class="src-str">'BOOLEAN'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a410"></a> <span class="src-key">case </span><span class="src-str">'date'</span>:</div></li> <li><div class="src-line"><a name="a411"></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="a412"></a> <span class="src-key">case </span><span class="src-str">'time'</span>:</div></li> <li><div class="src-line"><a name="a413"></a> <span class="src-key">return </span><span class="src-str">'TIME without time zone'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a414"></a> <span class="src-key">case </span><span class="src-str">'timestamp'</span>:</div></li> <li><div class="src-line"><a name="a415"></a> <span class="src-key">return </span><span class="src-str">'TIMESTAMP without time zone'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a416"></a> <span class="src-key">case </span><span class="src-str">'float'</span>:</div></li> <li><div class="src-line"><a name="a417"></a> <span class="src-key">case </span><span class="src-str">'double'</span>:</div></li> <li><div class="src-line"><a name="a418"></a> <span class="src-key">return </span><span class="src-str">'FLOAT8'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a419"></a> <span class="src-key">case </span><span class="src-str">'decimal'</span>:</div></li> <li><div class="src-line"><a name="a420"></a> <span class="src-var">$length </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-num">18</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a421"></a> <span class="src-var">$scale </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">'scale'</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">'scale'</span><span class="src-sym">] </span>: <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Doctrine/Doctrine_Connection_Module.html#var$conn">conn</a></span><span class="src-sym">-></span><span class="src-id">getAttribute</span><span class="src-sym">(</span><span class="src-id"><a href="../Doctrine/Doctrine.html">Doctrine</a></span><span class="src-sym">::</span><span class="src-id">ATTR_DECIMAL_PLACES</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a422"></a> <span class="src-key">return </span><span class="src-str">'NUMERIC('</span>.<span class="src-var">$length</span>.<span class="src-str">','</span>.<span class="src-var">$scale</span>.<span class="src-str">')'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a423"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a424"></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="a425"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a426"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a427"></a><span class="src-doc"> * Maps a native array description of a field to a portable Doctrine datatype and length</span></div></li> <li><div class="src-line"><a name="a428"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a429"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">array </span><span class="src-doc"> </span><span class="src-doc-var">$field </span><span class="src-doc">native field description</span></div></li> <li><div class="src-line"><a name="a430"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a431"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">array </span><span class="src-doc">containing the various possible types, length, sign, fixed</span></div></li> <li><div class="src-line"><a name="a432"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a433"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_DataDict/Doctrine_DataDict_Pgsql.html#methodgetPortableDeclaration">getPortableDeclaration</a><span class="src-sym">(</span><span class="src-key">array </span><span class="src-var">$field</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a434"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a435"></a> </div></li> <li><div class="src-line"><a name="a436"></a> <span class="src-var">$length </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">'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">null</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a437"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$length </span>== <span class="src-str">'-1' </span>&& isset<span class="src-sym">(</span><span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'atttypmod'</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="a438"></a> <span class="src-var">$length </span>= <span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'atttypmod'</span><span class="src-sym">] </span>- <span class="src-num">4</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a439"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a440"></a> <span class="src-key">if </span><span class="src-sym">(</span>(int)<span class="src-var">$length </span><= <span class="src-num">0</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a441"></a> <span class="src-var">$length </span>= <span class="src-id">null</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a442"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a443"></a> <span class="src-var">$type </span>= <span class="src-key">array</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="a444"></a> <span class="src-var">$unsigned </span>= <span class="src-var">$fixed </span>= <span class="src-id">null</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a445"></a> </div></li> <li><div class="src-line"><a name="a446"></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">'name'</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="a447"></a> <span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'name'</span><span class="src-sym">] </span>= <span class="src-str">''</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a448"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a449"></a> </div></li> <li><div class="src-line"><a name="a450"></a> <span class="src-var">$dbType </span>= <a href="http://www.php.net/strtolower">strtolower</a><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="a451"></a> </div></li> <li><div class="src-line"><a name="a452"></a> <span class="src-key">switch </span><span class="src-sym">(</span><span class="src-var">$dbType</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a453"></a> <span class="src-key">case </span><span class="src-str">'smallint'</span>:</div></li> <li><div class="src-line"><a name="a454"></a> <span class="src-key">case </span><span class="src-str">'int2'</span>:</div></li> <li><div class="src-line"><a name="a455"></a> <span class="src-var">$type</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">'integer'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a456"></a> <span class="src-var">$unsigned </span>= <span class="src-id">false</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a457"></a> <span class="src-var">$length </span>= <span class="src-num">2</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a458"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$length </span>== <span class="src-str">'2'</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a459"></a> <span class="src-var">$type</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">'boolean'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a460"></a> <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/preg_match">preg_match</a><span class="src-sym">(</span><span class="src-str">'/^(is|has)/'</span><span class="src-sym">, </span><span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'name'</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="a461"></a> <span class="src-var">$type </span>= <a href="http://www.php.net/array_reverse">array_reverse</a><span class="src-sym">(</span><span class="src-var">$type</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a462"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a463"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a464"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a465"></a> <span class="src-key">case </span><span class="src-str">'int'</span>:</div></li> <li><div class="src-line"><a name="a466"></a> <span class="src-key">case </span><span class="src-str">'int4'</span>:</div></li> <li><div class="src-line"><a name="a467"></a> <span class="src-key">case </span><span class="src-str">'integer'</span>:</div></li> <li><div class="src-line"><a name="a468"></a> <span class="src-key">case </span><span class="src-str">'serial'</span>:</div></li> <li><div class="src-line"><a name="a469"></a> <span class="src-key">case </span><span class="src-str">'serial4'</span>:</div></li> <li><div class="src-line"><a name="a470"></a> <span class="src-var">$type</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">'integer'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a471"></a> <span class="src-var">$unsigned </span>= <span class="src-id">false</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a472"></a> <span class="src-var">$length </span>= <span class="src-num">4</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a473"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a474"></a> <span class="src-key">case </span><span class="src-str">'bigint'</span>:</div></li> <li><div class="src-line"><a name="a475"></a> <span class="src-key">case </span><span class="src-str">'int8'</span>:</div></li> <li><div class="src-line"><a name="a476"></a> <span class="src-key">case </span><span class="src-str">'bigserial'</span>:</div></li> <li><div class="src-line"><a name="a477"></a> <span class="src-key">case </span><span class="src-str">'serial8'</span>:</div></li> <li><div class="src-line"><a name="a478"></a> <span class="src-var">$type</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">'integer'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a479"></a> <span class="src-var">$unsigned </span>= <span class="src-id">false</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a480"></a> <span class="src-var">$length </span>= <span class="src-num">8</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a481"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a482"></a> <span class="src-key">case </span><span class="src-str">'bool'</span>:</div></li> <li><div class="src-line"><a name="a483"></a> <span class="src-key">case </span><span class="src-str">'boolean'</span>:</div></li> <li><div class="src-line"><a name="a484"></a> <span class="src-var">$type</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">'boolean'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a485"></a> <span class="src-var">$length </span>= <span class="src-num">1</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a486"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a487"></a> <span class="src-key">case </span><span class="src-str">'text'</span>:</div></li> <li><div class="src-line"><a name="a488"></a> <span class="src-key">case </span><span class="src-str">'varchar'</span>:</div></li> <li><div class="src-line"><a name="a489"></a> <span class="src-var">$fixed </span>= <span class="src-id">false</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a490"></a> <span class="src-key">case </span><span class="src-str">'unknown'</span>:</div></li> <li><div class="src-line"><a name="a491"></a> <span class="src-key">case </span><span class="src-str">'char'</span>:</div></li> <li><div class="src-line"><a name="a492"></a> <span class="src-key">case </span><span class="src-str">'bpchar'</span>:</div></li> <li><div class="src-line"><a name="a493"></a> <span class="src-var">$type</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">'string'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a494"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$length </span>== <span class="src-str">'1'</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a495"></a> <span class="src-var">$type</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">'boolean'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a496"></a> <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/preg_match">preg_match</a><span class="src-sym">(</span><span class="src-str">'/^(is|has)/'</span><span class="src-sym">, </span><span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'name'</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="a497"></a> <span class="src-var">$type </span>= <a href="http://www.php.net/array_reverse">array_reverse</a><span class="src-sym">(</span><span class="src-var">$type</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a498"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a499"></a> <span class="src-sym">} </span><span class="src-key">elseif </span><span class="src-sym">(</span><a href="http://www.php.net/strstr">strstr</a><span class="src-sym">(</span><span class="src-var">$dbType</span><span class="src-sym">, </span><span class="src-str">'text'</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a500"></a> <span class="src-var">$type</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">'clob'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a501"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a502"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$fixed </span>!== <span class="src-id">false</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a503"></a> <span class="src-var">$fixed </span>= <span class="src-id">true</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a504"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a505"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a506"></a> <span class="src-key">case </span><span class="src-str">'date'</span>:</div></li> <li><div class="src-line"><a name="a507"></a> <span class="src-var">$type</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">'date'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a508"></a> <span class="src-var">$length </span>= <span class="src-id">null</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a509"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a510"></a> <span class="src-key">case </span><span class="src-str">'datetime'</span>:</div></li> <li><div class="src-line"><a name="a511"></a> <span class="src-key">case </span><span class="src-str">'timestamp'</span>:</div></li> <li><div class="src-line"><a name="a512"></a> <span class="src-var">$type</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">'timestamp'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a513"></a> <span class="src-var">$length </span>= <span class="src-id">null</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a514"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a515"></a> <span class="src-key">case </span><span class="src-str">'time'</span>:</div></li> <li><div class="src-line"><a name="a516"></a> <span class="src-var">$type</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">'time'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a517"></a> <span class="src-var">$length </span>= <span class="src-id">null</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a518"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a519"></a> <span class="src-key">case </span><span class="src-str">'float'</span>:</div></li> <li><div class="src-line"><a name="a520"></a> <span class="src-key">case </span><span class="src-str">'double'</span>:</div></li> <li><div class="src-line"><a name="a521"></a> <span class="src-key">case </span><span class="src-str">'real'</span>:</div></li> <li><div class="src-line"><a name="a522"></a> <span class="src-var">$type</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">'float'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a523"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a524"></a> <span class="src-key">case </span><span class="src-str">'decimal'</span>:</div></li> <li><div class="src-line"><a name="a525"></a> <span class="src-key">case </span><span class="src-str">'money'</span>:</div></li> <li><div class="src-line"><a name="a526"></a> <span class="src-key">case </span><span class="src-str">'numeric'</span>:</div></li> <li><div class="src-line"><a name="a527"></a> <span class="src-var">$type</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">'decimal'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a528"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a529"></a> <span class="src-key">case </span><span class="src-str">'tinyblob'</span>:</div></li> <li><div class="src-line"><a name="a530"></a> <span class="src-key">case </span><span class="src-str">'mediumblob'</span>:</div></li> <li><div class="src-line"><a name="a531"></a> <span class="src-key">case </span><span class="src-str">'longblob'</span>:</div></li> <li><div class="src-line"><a name="a532"></a> <span class="src-key">case </span><span class="src-str">'blob'</span>:</div></li> <li><div class="src-line"><a name="a533"></a> <span class="src-key">case </span><span class="src-str">'bytea'</span>:</div></li> <li><div class="src-line"><a name="a534"></a> <span class="src-var">$type</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">'blob'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a535"></a> <span class="src-var">$length </span>= <span class="src-id">null</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a536"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a537"></a> <span class="src-key">case </span><span class="src-str">'oid'</span>:</div></li> <li><div class="src-line"><a name="a538"></a> <span class="src-var">$type</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">'blob'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a539"></a> <span class="src-var">$type</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">'clob'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a540"></a> <span class="src-var">$length </span>= <span class="src-id">null</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a541"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a542"></a> <span class="src-key">case </span><span class="src-str">'year'</span>:</div></li> <li><div class="src-line"><a name="a543"></a> <span class="src-var">$type</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">'integer'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a544"></a> <span class="src-var">$type</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">'date'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a545"></a> <span class="src-var">$length </span>= <span class="src-id">null</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a546"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a547"></a> <span class="src-key">default</span>:</div></li> <li><div class="src-line"><a name="a548"></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 database attribute type: '</span>.<span class="src-var">$dbType</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a549"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a550"></a> </div></li> <li><div class="src-line"><a name="a551"></a> <span class="src-key">return </span><span class="src-key">array</span><span class="src-sym">(</span><span class="src-str">'type' </span>=> <span class="src-var">$type</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a552"></a> <span class="src-str">'length' </span>=> <span class="src-var">$length</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a553"></a> <span class="src-str">'unsigned' </span>=> <span class="src-var">$unsigned</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a554"></a> <span class="src-str">'fixed' </span>=> <span class="src-var">$fixed</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a555"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a556"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a557"></a><span class="src-doc"> * Obtain DBMS specific SQL code portion needed to declare an integer type</span></div></li> <li><div class="src-line"><a name="a558"></a><span class="src-doc"> * field to be used in statements like CREATE TABLE.</span></div></li> <li><div class="src-line"><a name="a559"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a560"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$name </span><span class="src-doc">name the field to be declared.</span></div></li> <li><div class="src-line"><a name="a561"></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="a562"></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="a563"></a><span class="src-doc"> * of supported field properties are as follows:</span></div></li> <li><div class="src-line"><a name="a564"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a565"></a><span class="src-doc"> * unsigned</span></div></li> <li><div class="src-line"><a name="a566"></a><span class="src-doc"> * Boolean flag that indicates whether the field should be</span></div></li> <li><div class="src-line"><a name="a567"></a><span class="src-doc"> * declared as unsigned integer if possible.</span></div></li> <li><div class="src-line"><a name="a568"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a569"></a><span class="src-doc"> * default</span></div></li> <li><div class="src-line"><a name="a570"></a><span class="src-doc"> * Integer value to be used as default for this field.</span></div></li> <li><div class="src-line"><a name="a571"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a572"></a><span class="src-doc"> * notnull</span></div></li> <li><div class="src-line"><a name="a573"></a><span class="src-doc"> * Boolean flag that indicates whether this field is constrained</span></div></li> <li><div class="src-line"><a name="a574"></a><span class="src-doc"> * to not be set to null.</span></div></li> <li><div class="src-line"><a name="a575"></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="a576"></a><span class="src-doc"> * declare the specified field.</span></div></li> <li><div class="src-line"><a name="a577"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a578"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_DataDict/Doctrine_DataDict_Pgsql.html#methodgetIntegerDeclaration">getIntegerDeclaration</a><span class="src-sym">(</span><span class="src-var">$name</span><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="a579"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a580"></a> /**</div></li> <li><div class="src-line"><a name="a581"></a> if (!empty($field['unsigned'])) {</div></li> <li><div class="src-line"><a name="a582"></a> $this->conn->warnings[] = "unsigned integer field \"$name\" is being declared as signed integer";</div></li> <li><div class="src-line"><a name="a583"></a> }</div></li> <li><div class="src-line"><a name="a584"></a> */</div></li> <li><div class="src-line"><a name="a585"></a> </div></li> <li><div class="src-line"><a name="a586"></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">'autoincrement'</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="a587"></a> <span class="src-var">$name </span>= <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Doctrine/Doctrine_Connection_Module.html#var$conn">conn</a></span><span class="src-sym">-></span><span class="src-id">quoteIdentifier</span><span class="src-sym">(</span><span class="src-var">$name</span><span class="src-sym">, </span><span class="src-id">true</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a588"></a> <span class="src-key">return </span><span class="src-var">$name </span>. <span class="src-str">' ' </span>. <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_DataDict/Doctrine_DataDict_Pgsql.html#methodgetNativeDeclaration">getNativeDeclaration</a><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="a589"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a590"></a> </div></li> <li><div class="src-line"><a name="a591"></a> <span class="src-var">$default </span>= <span class="src-str">''</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a592"></a> <span class="src-key">if </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="a593"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'default'</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="a594"></a> <span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'default'</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">'notnull'</span><span class="src-sym">]</span><span class="src-sym">) </span>? <span class="src-id">null </span>: <span class="src-num">0</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a595"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a596"></a> <span class="src-var">$default </span>= <span class="src-str">' DEFAULT '</span>.<span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Doctrine/Doctrine_Connection_Module.html#var$conn">conn</a></span><span class="src-sym">-></span><span class="src-id">quote</span><span class="src-sym">(</span><span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'default'</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-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a597"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a598"></a> /**</div></li> <li><div class="src-line"><a name="a599"></a> TODO: is this needed ?</div></li> <li><div class="src-line"><a name="a600"></a> elseif (empty($field['notnull'])) {</div></li> <li><div class="src-line"><a name="a601"></a> $default = ' DEFAULT NULL';</div></li> <li><div class="src-line"><a name="a602"></a> }</div></li> <li><div class="src-line"><a name="a603"></a> */</div></li> <li><div class="src-line"><a name="a604"></a> </div></li> <li><div class="src-line"><a name="a605"></a> <span class="src-var">$notnull </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">'notnull'</span><span class="src-sym">]</span><span class="src-sym">) </span>? <span class="src-str">'' </span>: <span class="src-str">' NOT NULL'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a606"></a> <span class="src-var">$name </span>= <span class="src-var">$this</span><span class="src-sym">-></span><span class="src-id"><a href="../Doctrine/Doctrine_Connection_Module.html#var$conn">conn</a></span><span class="src-sym">-></span><span class="src-id">quoteIdentifier</span><span class="src-sym">(</span><span class="src-var">$name</span><span class="src-sym">, </span><span class="src-id">true</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a607"></a> <span class="src-key">return </span><span class="src-var">$name </span>. <span class="src-str">' ' </span>. <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_DataDict/Doctrine_DataDict_Pgsql.html#methodgetNativeDeclaration">getNativeDeclaration</a><span class="src-sym">(</span><span class="src-var">$field</span><span class="src-sym">) </span>. <span class="src-var">$default </span>. <span class="src-var">$notnull</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a608"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a609"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a610"></a><span class="src-doc"> * parseBoolean</span></div></li> <li><div class="src-line"><a name="a611"></a><span class="src-doc"> * parses a literal boolean value and returns</span></div></li> <li><div class="src-line"><a name="a612"></a><span class="src-doc"> * proper sql equivalent</span></div></li> <li><div class="src-line"><a name="a613"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a614"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc-var">$value </span><span class="src-doc"> boolean value to be parsed</span></div></li> <li><div class="src-line"><a name="a615"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span><span class="src-doc"> parsed boolean value</span></div></li> <li><div class="src-line"><a name="a616"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a617"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_DataDict/Doctrine_DataDict_Pgsql.html#methodparseBoolean">parseBoolean</a><span class="src-sym">(</span><span class="src-var">$value</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a618"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a619"></a> <span class="src-key">return </span><span class="src-var">$value</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a620"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a621"></a><span class="src-sym">}</span></div></li> </ol> </span></div> </div>