<div id="content"> <h1 align="center">Source for file Formatter.php</h1> <p>Documentation is available at <a href="../Doctrine/_Doctrine---Formatter.php.html">Formatter.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$</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_Connection_Module'</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"> * Doctrine_Formatter</span></div></li> <li><div class="src-line"><a name="a24"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a25"></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="a26"></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="a27"></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="a28"></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="a29"></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="a30"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@version</span><span class="src-doc"> $Revision$</span></div></li> <li><div class="src-line"><a name="a31"></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="a32"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a33"></a><span class="src-key">class </span><a href="../Doctrine/Doctrine_Formatter.html">Doctrine_Formatter</a> <span class="src-key">extends </span><a href="../Doctrine/Doctrine_Connection_Module.html">Doctrine_Connection_Module</a></div></li> <li><div class="src-line"><a name="a34"></a><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a35"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a36"></a><span class="src-doc"> * Quotes pattern (% and _) characters in a string)</span></div></li> <li><div class="src-line"><a name="a37"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a38"></a><span class="src-doc"> * EXPERIMENTAL</span></div></li> <li><div class="src-line"><a name="a39"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a40"></a><span class="src-doc"> * WARNING: this function is experimental and may change signature at</span></div></li> <li><div class="src-line"><a name="a41"></a><span class="src-doc"> * any time until labelled as non-experimental</span></div></li> <li><div class="src-line"><a name="a42"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a43"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc"> </span><span class="src-doc-type">string </span><span class="src-doc"> the input string to quote</span></div></li> <li><div class="src-line"><a name="a44"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a45"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc"> </span><span class="src-doc-type">string </span><span class="src-doc"> quoted string</span></div></li> <li><div class="src-line"><a name="a46"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a47"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Formatter.html#methodescapePattern">escapePattern</a><span class="src-sym">(</span><span class="src-var">$text</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a48"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a49"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">string_quoting</span><span class="src-sym">[</span><span class="src-str">'escape_pattern'</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="a50"></a> <span class="src-var">$tmp </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">string_quoting</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a51"></a> </div></li> <li><div class="src-line"><a name="a52"></a> <span class="src-var">$text </span>= <a href="http://www.php.net/str_replace">str_replace</a><span class="src-sym">(</span><span class="src-var">$tmp</span><span class="src-sym">[</span><span class="src-str">'escape_pattern'</span><span class="src-sym">]</span><span class="src-sym">, </span></div></li> <li><div class="src-line"><a name="a53"></a> <span class="src-var">$tmp</span><span class="src-sym">[</span><span class="src-str">'escape_pattern'</span><span class="src-sym">] </span>.</div></li> <li><div class="src-line"><a name="a54"></a> <span class="src-var">$tmp</span><span class="src-sym">[</span><span class="src-str">'escape_pattern'</span><span class="src-sym">]</span><span class="src-sym">, </span><span class="src-var">$text</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a55"></a> </div></li> <li><div class="src-line"><a name="a56"></a> <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><span class="src-var">wildcards </span><span class="src-key">as </span><span class="src-var">$wildcard</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a57"></a> <span class="src-var">$text </span>= <a href="http://www.php.net/str_replace">str_replace</a><span class="src-sym">(</span><span class="src-var">$wildcard</span><span class="src-sym">, </span><span class="src-var">$tmp</span><span class="src-sym">[</span><span class="src-str">'escape_pattern'</span><span class="src-sym">] </span>. <span class="src-var">$wildcard</span><span class="src-sym">, </span><span class="src-var">$text</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a58"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a59"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a60"></a> <span class="src-key">return </span><span class="src-var">$text</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a61"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a62"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a63"></a><span class="src-doc"> * convertBooleans</span></div></li> <li><div class="src-line"><a name="a64"></a><span class="src-doc"> * some drivers need the boolean values to be converted into integers</span></div></li> <li><div class="src-line"><a name="a65"></a><span class="src-doc"> * when using DQL API</span></div></li> <li><div class="src-line"><a name="a66"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a67"></a><span class="src-doc"> * This method takes care of that conversion</span></div></li> <li><div class="src-line"><a name="a68"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a69"></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">$item </span></div></li> <li><div class="src-line"><a name="a70"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">void </span></div></li> <li><div class="src-line"><a name="a71"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a72"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Formatter.html#methodconvertBooleans">convertBooleans</a><span class="src-sym">(</span><span class="src-var">$item</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a73"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a74"></a> <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/is_array">is_array</a><span class="src-sym">(</span><span class="src-var">$item</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a75"></a> <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$item </span><span class="src-key">as </span><span class="src-var">$k </span>=> <span class="src-var">$value</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a76"></a> <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/is_bool">is_bool</a><span class="src-sym">(</span><span class="src-var">$value</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a77"></a> <span class="src-var">$item</span><span class="src-sym">[</span><span class="src-var">$k</span><span class="src-sym">] </span>= (int) <span class="src-var">$value</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a78"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a79"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a80"></a> <span class="src-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a81"></a> <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/is_bool">is_bool</a><span class="src-sym">(</span><span class="src-var">$item</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a82"></a> <span class="src-var">$item </span>= (int) <span class="src-var">$item</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a83"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a84"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a85"></a> <span class="src-key">return </span><span class="src-var">$item</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a86"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a87"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a88"></a><span class="src-doc"> * Quote a string so it can be safely used as a table or column name</span></div></li> <li><div class="src-line"><a name="a89"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a90"></a><span class="src-doc"> * Delimiting style depends on which database driver is being used.</span></div></li> <li><div class="src-line"><a name="a91"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a92"></a><span class="src-doc"> * NOTE: just because you CAN use delimited identifiers doesn't mean</span></div></li> <li><div class="src-line"><a name="a93"></a><span class="src-doc"> * you SHOULD use them. In general, they end up causing way more</span></div></li> <li><div class="src-line"><a name="a94"></a><span class="src-doc"> * problems than they solve.</span></div></li> <li><div class="src-line"><a name="a95"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a96"></a><span class="src-doc"> * Portability is broken by using the following characters inside</span></div></li> <li><div class="src-line"><a name="a97"></a><span class="src-doc"> * delimited identifiers:</span></div></li> <li><div class="src-line"><a name="a98"></a><span class="src-doc"> * + backtick (<kbd>`</kbd>) -- due to MySQL</span></div></li> <li><div class="src-line"><a name="a99"></a><span class="src-doc"> * + double quote (<kbd>"</kbd>) -- due to Oracle</span></div></li> <li><div class="src-line"><a name="a100"></a><span class="src-doc"> * + brackets (<kbd>[</kbd> or <kbd>]</kbd>) -- due to Access</span></div></li> <li><div class="src-line"><a name="a101"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a102"></a><span class="src-doc"> * Delimited identifiers are known to generally work correctly under</span></div></li> <li><div class="src-line"><a name="a103"></a><span class="src-doc"> * the following drivers:</span></div></li> <li><div class="src-line"><a name="a104"></a><span class="src-doc"> * + mssql</span></div></li> <li><div class="src-line"><a name="a105"></a><span class="src-doc"> * + mysql</span></div></li> <li><div class="src-line"><a name="a106"></a><span class="src-doc"> * + mysqli</span></div></li> <li><div class="src-line"><a name="a107"></a><span class="src-doc"> * + oci8</span></div></li> <li><div class="src-line"><a name="a108"></a><span class="src-doc"> * + pgsql</span></div></li> <li><div class="src-line"><a name="a109"></a><span class="src-doc"> * + sqlite</span></div></li> <li><div class="src-line"><a name="a110"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a111"></a><span class="src-doc"> * InterBase doesn't seem to be able to use delimited identifiers</span></div></li> <li><div class="src-line"><a name="a112"></a><span class="src-doc"> * via PHP 4. They work fine under PHP 5.</span></div></li> <li><div class="src-line"><a name="a113"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a114"></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">$str </span><span class="src-doc"> identifier name to be quoted</span></div></li> <li><div class="src-line"><a name="a115"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">bool </span><span class="src-doc-var">$checkOption </span><span class="src-doc"> check the 'quote_identifier' option</span></div></li> <li><div class="src-line"><a name="a116"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a117"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span><span class="src-doc"> quoted identifier string</span></div></li> <li><div class="src-line"><a name="a118"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a119"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Formatter.html#methodquoteIdentifier">quoteIdentifier</a><span class="src-sym">(</span><span class="src-var">$str</span><span class="src-sym">, </span><span class="src-var">$checkOption </span>= <span class="src-id">true</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a120"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a121"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$checkOption </span>&& <span class="src-sym">! </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Connection_Module.html#var$conn">conn</a><span class="src-sym">-></span><span class="src-id">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_QUOTE_IDENTIFIER</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a122"></a> <span class="src-key">return </span><span class="src-var">$str</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a123"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a124"></a> <span class="src-var">$tmp </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">identifier_quoting</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a125"></a> <span class="src-var">$str </span>= <a href="http://www.php.net/str_replace">str_replace</a><span class="src-sym">(</span><span class="src-var">$tmp</span><span class="src-sym">[</span><span class="src-str">'end'</span><span class="src-sym">]</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a126"></a> <span class="src-var">$tmp</span><span class="src-sym">[</span><span class="src-str">'escape'</span><span class="src-sym">] </span>.</div></li> <li><div class="src-line"><a name="a127"></a> <span class="src-var">$tmp</span><span class="src-sym">[</span><span class="src-str">'end'</span><span class="src-sym">]</span><span class="src-sym">, </span><span class="src-var">$str</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a128"></a> </div></li> <li><div class="src-line"><a name="a129"></a> <span class="src-key">return </span><span class="src-var">$tmp</span><span class="src-sym">[</span><span class="src-str">'start'</span><span class="src-sym">] </span>. <span class="src-var">$str </span>. <span class="src-var">$tmp</span><span class="src-sym">[</span><span class="src-str">'end'</span><span class="src-sym">]</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a130"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a131"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a132"></a><span class="src-doc"> * quote</span></div></li> <li><div class="src-line"><a name="a133"></a><span class="src-doc"> * quotes given input parameter</span></div></li> <li><div class="src-line"><a name="a134"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a135"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">mixed </span><span class="src-doc-var">$input </span><span class="src-doc"> parameter to be quoted</span></div></li> <li><div class="src-line"><a name="a136"></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">$type </span></div></li> <li><div class="src-line"><a name="a137"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">mixed </span></div></li> <li><div class="src-line"><a name="a138"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a139"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Formatter.html#methodquote">quote</a><span class="src-sym">(</span><span class="src-var">$input</span><span class="src-sym">, </span><span class="src-var">$type </span>= <span class="src-id">null</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a140"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a141"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$type </span>== <span class="src-id">null</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a142"></a> <span class="src-var">$type </span>= <a href="http://www.php.net/gettype">gettype</a><span class="src-sym">(</span><span class="src-var">$input</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a143"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a144"></a> <span class="src-key">switch </span><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="a145"></a> <span class="src-key">case </span><span class="src-str">'integer'</span>:</div></li> <li><div class="src-line"><a name="a146"></a> <span class="src-key">case </span><span class="src-str">'enum'</span>:</div></li> <li><div class="src-line"><a name="a147"></a> <span class="src-key">case </span><span class="src-str">'boolean'</span>:</div></li> <li><div class="src-line"><a name="a148"></a> <span class="src-key">case </span><span class="src-str">'double'</span>:</div></li> <li><div class="src-line"><a name="a149"></a> <span class="src-key">case </span><span class="src-str">'float'</span>:</div></li> <li><div class="src-line"><a name="a150"></a> <span class="src-key">case </span><span class="src-str">'bool'</span>:</div></li> <li><div class="src-line"><a name="a151"></a> <span class="src-key">case </span><span class="src-str">'int'</span>:</div></li> <li><div class="src-line"><a name="a152"></a> <span class="src-key">return </span><span class="src-var">$input</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a153"></a> <span class="src-key">case </span><span class="src-str">'array'</span>:</div></li> <li><div class="src-line"><a name="a154"></a> <span class="src-key">case </span><span class="src-str">'object'</span>:</div></li> <li><div class="src-line"><a name="a155"></a> <span class="src-var">$input </span>= <a href="http://www.php.net/serialize">serialize</a><span class="src-sym">(</span><span class="src-var">$input</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a156"></a> <span class="src-key">case </span><span class="src-str">'string'</span>:</div></li> <li><div class="src-line"><a name="a157"></a> <span class="src-key">case </span><span class="src-str">'char'</span>:</div></li> <li><div class="src-line"><a name="a158"></a> <span class="src-key">case </span><span class="src-str">'varchar'</span>:</div></li> <li><div class="src-line"><a name="a159"></a> <span class="src-key">case </span><span class="src-str">'text'</span>:</div></li> <li><div class="src-line"><a name="a160"></a> <span class="src-key">case </span><span class="src-str">'gzip'</span>:</div></li> <li><div class="src-line"><a name="a161"></a> <span class="src-key">case </span><span class="src-str">'blob'</span>:</div></li> <li><div class="src-line"><a name="a162"></a> <span class="src-key">case </span><span class="src-str">'clob'</span>:</div></li> <li><div class="src-line"><a name="a163"></a> <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">connect</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="a164"></a> </div></li> <li><div class="src-line"><a name="a165"></a> <span class="src-key">return </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">getDbh</span><span class="src-sym">(</span><span class="src-sym">)</span><span class="src-sym">-></span><span class="src-id">quote</span><span class="src-sym">(</span><span class="src-var">$input</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a166"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a167"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a168"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a169"></a><span class="src-doc"> * Removes any formatting in an sequence name using the 'seqname_format' option</span></div></li> <li><div class="src-line"><a name="a170"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a171"></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">$sqn </span><span class="src-doc">string that containts name of a potential sequence</span></div></li> <li><div class="src-line"><a name="a172"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span><span class="src-doc">name of the sequence with possible formatting removed</span></div></li> <li><div class="src-line"><a name="a173"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a174"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Formatter.html#methodfixSequenceName">fixSequenceName</a><span class="src-sym">(</span><span class="src-var">$sqn</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a175"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a176"></a> <span class="src-var">$seqPattern </span>= <span class="src-str">'/^'</span>.<a href="http://www.php.net/preg_replace">preg_replace</a><span class="src-sym">(</span><span class="src-str">'/%s/'</span><span class="src-sym">, </span><span class="src-str">'([a-z0-9_]+)'</span><span class="src-sym">, </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Connection_Module.html#var$conn">conn</a><span class="src-sym">-></span><span class="src-id">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_SEQNAME_FORMAT</span><span class="src-sym">))</span>.<span class="src-str">'$/i'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a177"></a> <span class="src-var">$seqName </span>= <a href="http://www.php.net/preg_replace">preg_replace</a><span class="src-sym">(</span><span class="src-var">$seqPattern</span><span class="src-sym">, </span><span class="src-str">'\\1'</span><span class="src-sym">, </span><span class="src-var">$sqn</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a178"></a> </div></li> <li><div class="src-line"><a name="a179"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$seqName </span>&& <span class="src-sym">! </span><a href="http://www.php.net/strcasecmp">strcasecmp</a><span class="src-sym">(</span><span class="src-var">$sqn</span><span class="src-sym">, </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Formatter.html#methodgetSequenceName">getSequenceName</a><span class="src-sym">(</span><span class="src-var">$seqName</span><span class="src-sym">))) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a180"></a> <span class="src-key">return </span><span class="src-var">$seqName</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a181"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a182"></a> <span class="src-key">return </span><span class="src-var">$sqn</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a183"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a184"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a185"></a><span class="src-doc"> * Removes any formatting in an index name using the 'idxname_format' option</span></div></li> <li><div class="src-line"><a name="a186"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a187"></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">$idx </span><span class="src-doc">string that containts name of anl index</span></div></li> <li><div class="src-line"><a name="a188"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span><span class="src-doc">name of the index with possible formatting removed</span></div></li> <li><div class="src-line"><a name="a189"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a190"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Formatter.html#methodfixIndexName">fixIndexName</a><span class="src-sym">(</span><span class="src-var">$idx</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a191"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a192"></a> <span class="src-var">$indexPattern </span>= <span class="src-str">'/^'</span>.<a href="http://www.php.net/preg_replace">preg_replace</a><span class="src-sym">(</span><span class="src-str">'/%s/'</span><span class="src-sym">, </span><span class="src-str">'([a-z0-9_]+)'</span><span class="src-sym">, </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Connection_Module.html#var$conn">conn</a><span class="src-sym">-></span><span class="src-id">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_IDXNAME_FORMAT</span><span class="src-sym">))</span>.<span class="src-str">'$/i'</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a193"></a> <span class="src-var">$indexName </span>= <a href="http://www.php.net/preg_replace">preg_replace</a><span class="src-sym">(</span><span class="src-var">$indexPattern</span><span class="src-sym">, </span><span class="src-str">'\\1'</span><span class="src-sym">, </span><span class="src-var">$idx</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a194"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$indexName </span>&& <span class="src-sym">! </span><a href="http://www.php.net/strcasecmp">strcasecmp</a><span class="src-sym">(</span><span class="src-var">$idx</span><span class="src-sym">, </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Formatter.html#methodgetIndexName">getIndexName</a><span class="src-sym">(</span><span class="src-var">$indexName</span><span class="src-sym">))) </span><span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a195"></a> <span class="src-key">return </span><span class="src-var">$indexName</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a196"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a197"></a> <span class="src-key">return </span><span class="src-var">$idx</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a198"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a199"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a200"></a><span class="src-doc"> * adds sequence name formatting to a sequence name</span></div></li> <li><div class="src-line"><a name="a201"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a202"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc"> name of the sequence</span></div></li> <li><div class="src-line"><a name="a203"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span><span class="src-doc"> formatted sequence name</span></div></li> <li><div class="src-line"><a name="a204"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a205"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Formatter.html#methodgetSequenceName">getSequenceName</a><span class="src-sym">(</span><span class="src-var">$sqn</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a206"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a207"></a> <span class="src-key">return </span><a href="http://www.php.net/sprintf">sprintf</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Connection_Module.html#var$conn">conn</a><span class="src-sym">-></span><span class="src-id">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_SEQNAME_FORMAT</span><span class="src-sym">)</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a208"></a> <a href="http://www.php.net/preg_replace">preg_replace</a><span class="src-sym">(</span><span class="src-str">'/[^a-z0-9_\$.]/i'</span><span class="src-sym">, </span><span class="src-str">'_'</span><span class="src-sym">, </span><span class="src-var">$sqn</span><span class="src-sym">))</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a209"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a210"></a> <span class="src-doc">/**</span></div></li> <li><div class="src-line"><a name="a211"></a><span class="src-doc"> * adds index name formatting to a index name</span></div></li> <li><div class="src-line"><a name="a212"></a><span class="src-doc"> *</span></div></li> <li><div class="src-line"><a name="a213"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string </span><span class="src-doc"> name of the index</span></div></li> <li><div class="src-line"><a name="a214"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span><span class="src-doc"> formatted index name</span></div></li> <li><div class="src-line"><a name="a215"></a><span class="src-doc"> */</span></div></li> <li><div class="src-line"><a name="a216"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Formatter.html#methodgetIndexName">getIndexName</a><span class="src-sym">(</span><span class="src-var">$idx</span><span class="src-sym">)</span></div></li> <li><div class="src-line"><a name="a217"></a> <span class="src-sym">{</span></div></li> <li><div class="src-line"><a name="a218"></a> <span class="src-key">return </span><a href="http://www.php.net/sprintf">sprintf</a><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Connection_Module.html#var$conn">conn</a><span class="src-sym">-></span><span class="src-id">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_IDXNAME_FORMAT</span><span class="src-sym">)</span><span class="src-sym">,</span></div></li> <li><div class="src-line"><a name="a219"></a> <a href="http://www.php.net/preg_replace">preg_replace</a><span class="src-sym">(</span><span class="src-str">'/[^a-z0-9_\$]/i'</span><span class="src-sym">, </span><span class="src-str">'_'</span><span class="src-sym">, </span><span class="src-var">$idx</span><span class="src-sym">))</span><span class="src-sym">;</span></div></li> <li><div class="src-line"><a name="a220"></a> <span class="src-sym">}</span></div></li> <li><div class="src-line"><a name="a221"></a><span class="src-sym">}</span></div></li> </ol> </span></div> </div>