<div id="content">
<h1 align="center">Source for file Oracle.php</h1>
<p>Documentation is available at <a href="../Doctrine/_Doctrine---Export---Oracle.php.html">Oracle.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: Oracle.php 2288 2007-08-29 21:51:49Z Jonathan.Wage $</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_Export'</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_Export_Oracle</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">@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"> Lukas Smith <smith@pooteeweet.org> (PEAR MDB2 library)</span></div></li>
<li><div class="src-line"><a name="a28"></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="a29"></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="a30"></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="a31"></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="a32"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@version</span><span class="src-doc"> $Revision: 2288 $</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_Export_Oracle.html">Doctrine_Export_Oracle</a> <span class="src-key">extends </span><a href="../Doctrine/Doctrine_Export.html">Doctrine_Export</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"> * create a new database</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-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">object </span><span class="src-doc-var">$db </span><span class="src-doc">database object that is extended by this class</span></div></li>
<li><div class="src-line"><a name="a40"></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 of the database that should be created</span></div></li>
<li><div class="src-line"><a name="a41"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">mixed </span><span class="src-doc">MDB2_OK on success, a MDB2 error on failure</span></div></li>
<li><div class="src-line"><a name="a42"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@access</span><span class="src-doc"> public</span></div></li>
<li><div class="src-line"><a name="a43"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a44"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Export_Oracle.html#methodcreateDatabase">createDatabase</a><span class="src-sym">(</span><span class="src-var">$name</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a45"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a46"></a> <span class="src-key">if </span><span class="src-sym">( </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_EMULATE_DATABASE</span><span class="src-sym">))</span></div></li>
<li><div class="src-line"><a name="a47"></a> throw <span class="src-key">new </span><span class="src-id"><a href="../Doctrine/Doctrine_Export_Exception.html">Doctrine_Export_Exception</a></span><span class="src-sym">(</span><span class="src-str">'database creation is only supported if the "emulate_database" attribute is enabled'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a48"></a> </div></li>
<li><div class="src-line"><a name="a49"></a> <span class="src-var">$username </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_DB_NAME_FORMAT</span><span class="src-sym">)</span><span class="src-sym">, </span><span class="src-var">$name</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">$password </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">dsn</span><span class="src-sym">[</span><span class="src-str">'password'</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">dsn</span><span class="src-sym">[</span><span class="src-str">'password'</span><span class="src-sym">] </span>: <span class="src-var">$name</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">$tablespace </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_DB_NAME_FORMAT</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a53"></a> ? <span class="src-str">' DEFAULT TABLESPACE '</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_tablespace'</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="a54"></a> </div></li>
<li><div class="src-line"><a name="a55"></a> <span class="src-var">$query </span>= <span class="src-str">'CREATE USER ' </span>. <span class="src-var">$username </span>. <span class="src-str">' IDENTIFIED BY ' </span>. <span class="src-var">$password </span>. <span class="src-var">$tablespace</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a56"></a> <span class="src-var">$result </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">exec</span><span class="src-sym">(</span><span class="src-var">$query</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a57"></a> </div></li>
<li><div class="src-line"><a name="a58"></a> try <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a59"></a> <span class="src-var">$query </span>= <span class="src-str">'GRANT CREATE SESSION, CREATE TABLE, UNLIMITED TABLESPACE, CREATE SEQUENCE, CREATE TRIGGER TO ' </span>. <span class="src-var">$username</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a60"></a> <span class="src-var">$result </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">exec</span><span class="src-sym">(</span><span class="src-var">$query</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a61"></a> <span class="src-sym">} </span>catch <span class="src-sym">(</span><span class="src-id">Exception </span><span class="src-var">$e</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a62"></a> <span class="src-var">$query </span>= <span class="src-str">'DROP USER '</span>.<span class="src-var">$username</span>.<span class="src-str">' CASCADE'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a63"></a> <span class="src-var">$result2 </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">exec</span><span class="src-sym">(</span><span class="src-var">$query</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a64"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a65"></a> <span class="src-key">return </span><span class="src-id">true</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a66"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a67"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a68"></a><span class="src-doc"> * drop an existing database</span></div></li>
<li><div class="src-line"><a name="a69"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a70"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">object </span><span class="src-doc-var">$this->conn </span><span class="src-doc">database object that is extended by this class</span></div></li>
<li><div class="src-line"><a name="a71"></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 of the database that should be dropped</span></div></li>
<li><div class="src-line"><a name="a72"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">mixed </span><span class="src-doc">MDB2_OK on success, a MDB2 error on failure</span></div></li>
<li><div class="src-line"><a name="a73"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@access</span><span class="src-doc"> public</span></div></li>
<li><div class="src-line"><a name="a74"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a75"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Export_Oracle.html#methoddropDatabase">dropDatabase</a><span class="src-sym">(</span><span class="src-var">$name</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a76"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a77"></a> <span class="src-key">if </span><span class="src-sym">( </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_EMULATE_DATABASE</span><span class="src-sym">))</span></div></li>
<li><div class="src-line"><a name="a78"></a> throw <span class="src-key">new </span><span class="src-id"><a href="../Doctrine/Doctrine_Export_Exception.html">Doctrine_Export_Exception</a></span><span class="src-sym">(</span><span class="src-str">'database dropping is only supported if the</span></div></li>
<li><div class="src-line"><a name="a79"></a><span class="src-str"> "emulate_database" option is enabled'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a80"></a> </div></li>
<li><div class="src-line"><a name="a81"></a> <span class="src-var">$username </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_DB_NAME_FORMAT</span><span class="src-sym">)</span><span class="src-sym">, </span><span class="src-var">$name</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a82"></a> </div></li>
<li><div class="src-line"><a name="a83"></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">exec</span><span class="src-sym">(</span><span class="src-str">'DROP USER ' </span>. <span class="src-var">$username </span>. <span class="src-str">' CASCADE'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a84"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a85"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a86"></a><span class="src-doc"> * add an autoincrement sequence + trigger</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"> * </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 of the PK field</span></div></li>
<li><div class="src-line"><a name="a89"></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">$table </span><span class="src-doc">name of the table</span></div></li>
<li><div class="src-line"><a name="a90"></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">$start </span><span class="src-doc">start value for the sequence</span></div></li>
<li><div class="src-line"><a name="a91"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">mixed </span><span class="src-doc"> MDB2_OK on success, a MDB2 error on failure</span></div></li>
<li><div class="src-line"><a name="a92"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@access</span><span class="src-doc"> private</span></div></li>
<li><div class="src-line"><a name="a93"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a94"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Export_Oracle.html#method_makeAutoincrement">_makeAutoincrement</a><span class="src-sym">(</span><span class="src-var">$name</span><span class="src-sym">, </span><span class="src-var">$table</span><span class="src-sym">, </span><span class="src-var">$start </span>= <span class="src-num">1</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a95"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a96"></a> <span class="src-var">$sql </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="a97"></a> <span class="src-var">$table </span>= <a href="http://www.php.net/strtoupper">strtoupper</a><span class="src-sym">(</span><span class="src-var">$table</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a98"></a> <span class="src-var">$indexName </span>= <span class="src-var">$table </span>. <span class="src-str">'_AI_PK'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a99"></a> <span class="src-var">$definition </span>= <span class="src-key">array</span><span class="src-sym">(</span></div></li>
<li><div class="src-line"><a name="a100"></a> <span class="src-str">'primary' </span>=> <span class="src-id">true</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a101"></a> <span class="src-str">'fields' </span>=> <span class="src-key">array</span><span class="src-sym">(</span><span class="src-var">$name </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="a102"></a> <span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a103"></a> </div></li>
<li><div class="src-line"><a name="a104"></a> <span class="src-var">$sql</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Export.html#methodcreateConstraintSql">createConstraintSql</a><span class="src-sym">(</span><span class="src-var">$table</span><span class="src-sym">, </span><span class="src-var">$indexName</span><span class="src-sym">, </span><span class="src-var">$definition</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a105"></a> </div></li>
<li><div class="src-line"><a name="a106"></a> <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/is_null">is_null</a><span class="src-sym">(</span><span class="src-var">$start</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a107"></a> <span class="src-var">$query </span>= <span class="src-str">'SELECT MAX(' </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">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-str">') FROM ' </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">quoteIdentifier</span><span class="src-sym">(</span><span class="src-var">$table</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="a108"></a> <span class="src-var">$start </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">fetchOne</span><span class="src-sym">(</span><span class="src-var">$query</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a109"></a> </div></li>
<li><div class="src-line"><a name="a110"></a> ++<span class="src-var">$start</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a111"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a112"></a> </div></li>
<li><div class="src-line"><a name="a113"></a> <span class="src-var">$sql</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Export_Oracle.html#methodcreateSequenceSql">createSequenceSql</a><span class="src-sym">(</span><span class="src-var">$table</span><span class="src-sym">, </span><span class="src-var">$start</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a114"></a> </div></li>
<li><div class="src-line"><a name="a115"></a> <span class="src-var">$sequenceName </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">formatter</span><span class="src-sym">-></span><span class="src-id">getSequenceName</span><span class="src-sym">(</span><span class="src-var">$table</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a116"></a> <span class="src-var">$triggerName </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">quoteIdentifier</span><span class="src-sym">(</span><span class="src-var">$table </span>. <span class="src-str">'_AI_PK'</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="a117"></a> <span class="src-var">$table </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">quoteIdentifier</span><span class="src-sym">(</span><span class="src-var">$table</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="a118"></a> <span class="src-var">$name </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">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="a119"></a> <span class="src-var">$sql</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-str">'CREATE TRIGGER ' </span>. <span class="src-var">$triggerName </span>. <span class="src-str">'</span></div></li>
<li><div class="src-line"><a name="a120"></a><span class="src-str"> BEFORE INSERT</span></div></li>
<li><div class="src-line"><a name="a121"></a><span class="src-str"> ON '</span>.<span class="src-var">$table</span>.<span class="src-str">'</span></div></li>
<li><div class="src-line"><a name="a122"></a><span class="src-str"> FOR EACH ROW</span></div></li>
<li><div class="src-line"><a name="a123"></a><span class="src-str">DECLARE</span></div></li>
<li><div class="src-line"><a name="a124"></a><span class="src-str"> last_Sequence NUMBER;</span></div></li>
<li><div class="src-line"><a name="a125"></a><span class="src-str"> last_InsertID NUMBER;</span></div></li>
<li><div class="src-line"><a name="a126"></a><span class="src-str">BEGIN</span></div></li>
<li><div class="src-line"><a name="a127"></a><span class="src-str"> SELECT '</span>.<span class="src-var">$sequenceName</span>.<span class="src-str">'.NEXTVAL INTO :NEW.'</span>.<span class="src-var">$name</span>.<span class="src-str">' FROM DUAL;</span></div></li>
<li><div class="src-line"><a name="a128"></a><span class="src-str"> IF (:NEW.'</span>.<span class="src-var">$name</span>.<span class="src-str">' IS NULL OR :NEW.'</span>.<span class="src-var">$name</span>.<span class="src-str">' = 0) THEN</span></div></li>
<li><div class="src-line"><a name="a129"></a><span class="src-str"> SELECT '</span>.<span class="src-var">$sequenceName</span>.<span class="src-str">'.NEXTVAL INTO :NEW.'</span>.<span class="src-var">$name</span>.<span class="src-str">' FROM DUAL;</span></div></li>
<li><div class="src-line"><a name="a130"></a><span class="src-str"> ELSE</span></div></li>
<li><div class="src-line"><a name="a131"></a><span class="src-str"> SELECT NVL(Last_Number, 0) INTO last_Sequence</span></div></li>
<li><div class="src-line"><a name="a132"></a><span class="src-str"> FROM User_Sequences</span></div></li>
<li><div class="src-line"><a name="a133"></a><span class="src-str"> WHERE UPPER(Sequence_Name) = UPPER(\''</span>.<span class="src-var">$sequenceName</span>.<span class="src-str">'\');</span></div></li>
<li><div class="src-line"><a name="a134"></a><span class="src-str"> SELECT :NEW.id INTO last_InsertID FROM DUAL;</span></div></li>
<li><div class="src-line"><a name="a135"></a><span class="src-str"> WHILE (last_InsertID > last_Sequence) LOOP</span></div></li>
<li><div class="src-line"><a name="a136"></a><span class="src-str"> SELECT ' </span>. <span class="src-var">$sequenceName </span>. <span class="src-str">'.NEXTVAL INTO last_Sequence FROM DUAL;</span></div></li>
<li><div class="src-line"><a name="a137"></a><span class="src-str"> END LOOP;</span></div></li>
<li><div class="src-line"><a name="a138"></a><span class="src-str"> END IF;</span></div></li>
<li><div class="src-line"><a name="a139"></a><span class="src-str">END;</span></div></li>
<li><div class="src-line"><a name="a140"></a><span class="src-str">'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a141"></a> <span class="src-key">return </span><span class="src-var">$sql</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a142"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a143"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a144"></a><span class="src-doc"> * drop an existing autoincrement sequence + trigger</span></div></li>
<li><div class="src-line"><a name="a145"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a146"></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">$table </span><span class="src-doc">name of the table</span></div></li>
<li><div class="src-line"><a name="a147"></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="a148"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a149"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Export_Oracle.html#methoddropAutoincrement">dropAutoincrement</a><span class="src-sym">(</span><span class="src-var">$table</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a150"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a151"></a> <span class="src-var">$table </span>= <a href="http://www.php.net/strtoupper">strtoupper</a><span class="src-sym">(</span><span class="src-var">$table</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a152"></a> <span class="src-var">$triggerName </span>= <span class="src-var">$table </span>. <span class="src-str">'_AI_PK'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a153"></a> <span class="src-var">$trigger_name_quoted </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">quote</span><span class="src-sym">(</span><span class="src-var">$triggerName</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a154"></a> <span class="src-var">$query </span>= <span class="src-str">'SELECT trigger_name FROM user_triggers'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a155"></a> <span class="src-var">$query</span>.= <span class="src-str">' WHERE trigger_name='</span>.<span class="src-var">$trigger_name_quoted</span>.<span class="src-str">' OR trigger_name='</span>.<a href="http://www.php.net/strtoupper">strtoupper</a><span class="src-sym">(</span><span class="src-var">$trigger_name_quoted</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-var">$trigger </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">fetchOne</span><span class="src-sym">(</span><span class="src-var">$query</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a157"></a> </div></li>
<li><div class="src-line"><a name="a158"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$trigger</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a159"></a> <span class="src-var">$trigger_name </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">quoteIdentifier</span><span class="src-sym">(</span><span class="src-var">$table </span>. <span class="src-str">'_AI_PK'</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="a160"></a> <span class="src-var">$trigger_sql </span>= <span class="src-str">'DROP TRIGGER ' </span>. <span class="src-var">$trigger_name</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a161"></a> </div></li>
<li><div class="src-line"><a name="a162"></a> <span class="src-comm">// if throws exception, trigger for autoincrement PK could not be dropped</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">exec</span><span class="src-sym">(</span><span class="src-var">$trigger_sql</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-comm">// if throws exception, sequence for autoincrement PK could not be dropped</span></div></li>
<li><div class="src-line"><a name="a166"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Export.html#methoddropSequence">dropSequence</a><span class="src-sym">(</span><span class="src-var">$table</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a167"></a> </div></li>
<li><div class="src-line"><a name="a168"></a> <span class="src-var">$indexName </span>= <span class="src-var">$table </span>. <span class="src-str">'_AI_PK'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a169"></a> </div></li>
<li><div class="src-line"><a name="a170"></a> <span class="src-comm">// if throws exception, primary key for autoincrement PK could not be dropped</span></div></li>
<li><div class="src-line"><a name="a171"></a> <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Export.html#methoddropConstraint">dropConstraint</a><span class="src-sym">(</span><span class="src-var">$table</span><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="a172"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a173"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a174"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a175"></a><span class="src-doc"> * A method to return the required SQL string that fits between CREATE ... TABLE</span></div></li>
<li><div class="src-line"><a name="a176"></a><span class="src-doc"> * to create the table as a temporary table.</span></div></li>
<li><div class="src-line"><a name="a177"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a178"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span><span class="src-doc">The string required to be placed between "CREATE" and "TABLE"</span></div></li>
<li><div class="src-line"><a name="a179"></a><span class="src-doc"> * to generate a temporary table, if possible.</span></div></li>
<li><div class="src-line"><a name="a180"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a181"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Export_Oracle.html#methodgetTemporaryTableQuery">getTemporaryTableQuery</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a182"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a183"></a> <span class="src-key">return </span><span class="src-str">'GLOBAL TEMPORARY'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a184"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a185"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a186"></a><span class="src-doc"> * getAdvancedForeignKeyOptions</span></div></li>
<li><div class="src-line"><a name="a187"></a><span class="src-doc"> * Return the FOREIGN KEY query section dealing with non-standard options</span></div></li>
<li><div class="src-line"><a name="a188"></a><span class="src-doc"> * as MATCH, INITIALLY DEFERRED, ON UPDATE, ...</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-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">array </span><span class="src-doc-var">$definition </span><span class="src-doc"> foreign key definition</span></div></li>
<li><div class="src-line"><a name="a191"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span></div></li>
<li><div class="src-line"><a name="a192"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@access</span><span class="src-doc"> protected</span></div></li>
<li><div class="src-line"><a name="a193"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a194"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Export_Oracle.html#methodgetAdvancedForeignKeyOptions">getAdvancedForeignKeyOptions</a><span class="src-sym">(</span><span class="src-key">array </span><span class="src-var">$definition</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a195"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a196"></a> <span class="src-var">$query </span>= <span class="src-str">''</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a197"></a> <span class="src-key">if </span><span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$definition</span><span class="src-sym">[</span><span class="src-str">'onDelete'</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="a198"></a> <span class="src-var">$query </span>.= <span class="src-str">' ON DELETE ' </span>. <span class="src-var">$definition</span><span class="src-sym">[</span><span class="src-str">'onDelete'</span><span class="src-sym">]</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a199"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a200"></a> <span class="src-key">if </span><span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$definition</span><span class="src-sym">[</span><span class="src-str">'deferrable'</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="a201"></a> <span class="src-var">$query </span>.= <span class="src-str">' DEFERRABLE'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a202"></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="a203"></a> <span class="src-var">$query </span>.= <span class="src-str">' NOT DEFERRABLE'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a204"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a205"></a> <span class="src-key">if </span><span class="src-sym">(</span>isset<span class="src-sym">(</span><span class="src-var">$definition</span><span class="src-sym">[</span><span class="src-str">'feferred'</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="a206"></a> <span class="src-var">$query </span>.= <span class="src-str">' INITIALLY DEFERRED'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a207"></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="a208"></a> <span class="src-var">$query </span>.= <span class="src-str">' INITIALLY IMMEDIATE'</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-key">return </span><span class="src-var">$query</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a211"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a212"></a> </div></li>
<li><div class="src-line"><a name="a213"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a214"></a><span class="src-doc"> * create a new table</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-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 of the database that should be created</span></div></li>
<li><div class="src-line"><a name="a217"></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">$fields </span><span class="src-doc">Associative array that contains the definition of each field of the new table</span></div></li>
<li><div class="src-line"><a name="a218"></a><span class="src-doc"> * The indexes of the array entries are the names of the fields of the table an</span></div></li>
<li><div class="src-line"><a name="a219"></a><span class="src-doc"> * the array entry values are associative arrays like those that are meant to be</span></div></li>
<li><div class="src-line"><a name="a220"></a><span class="src-doc"> * passed with the field definitions to get[Type]Declaration() functions.</span></div></li>
<li><div class="src-line"><a name="a221"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a222"></a><span class="src-doc"> * Example</span></div></li>
<li><div class="src-line"><a name="a223"></a><span class="src-doc"> * array(</span></div></li>
<li><div class="src-line"><a name="a224"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a225"></a><span class="src-doc"> * 'id' => array(</span></div></li>
<li><div class="src-line"><a name="a226"></a><span class="src-doc"> * 'type' => 'integer',</span></div></li>
<li><div class="src-line"><a name="a227"></a><span class="src-doc"> * 'unsigned' => 1</span></div></li>
<li><div class="src-line"><a name="a228"></a><span class="src-doc"> * 'notnull' => 1</span></div></li>
<li><div class="src-line"><a name="a229"></a><span class="src-doc"> * 'default' => 0</span></div></li>
<li><div class="src-line"><a name="a230"></a><span class="src-doc"> * ),</span></div></li>
<li><div class="src-line"><a name="a231"></a><span class="src-doc"> * 'name' => array(</span></div></li>
<li><div class="src-line"><a name="a232"></a><span class="src-doc"> * 'type' => 'text',</span></div></li>
<li><div class="src-line"><a name="a233"></a><span class="src-doc"> * 'length' => 12</span></div></li>
<li><div class="src-line"><a name="a234"></a><span class="src-doc"> * ),</span></div></li>
<li><div class="src-line"><a name="a235"></a><span class="src-doc"> * 'password' => array(</span></div></li>
<li><div class="src-line"><a name="a236"></a><span class="src-doc"> * 'type' => 'text',</span></div></li>
<li><div class="src-line"><a name="a237"></a><span class="src-doc"> * 'length' => 12</span></div></li>
<li><div class="src-line"><a name="a238"></a><span class="src-doc"> * )</span></div></li>
<li><div class="src-line"><a name="a239"></a><span class="src-doc"> * );</span></div></li>
<li><div class="src-line"><a name="a240"></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">$options </span><span class="src-doc"> An associative array of table options:</span></div></li>
<li><div class="src-line"><a name="a241"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a242"></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="a243"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a244"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Export_Oracle.html#methodcreateTable">createTable</a><span class="src-sym">(</span><span class="src-var">$name</span><span class="src-sym">, </span><span class="src-key">array </span><span class="src-var">$fields</span><span class="src-sym">, </span><span class="src-key">array </span><span class="src-var">$options </span>= <span class="src-key">array</span><span class="src-sym">(</span><span class="src-sym">))</span></div></li>
<li><div class="src-line"><a name="a245"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a246"></a> <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">beginTransaction</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="a247"></a> </div></li>
<li><div class="src-line"><a name="a248"></a> <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Export_Oracle.html#methodcreateTableSql">createTableSql</a><span class="src-sym">(</span><span class="src-var">$name</span><span class="src-sym">, </span><span class="src-var">$fields</span><span class="src-sym">, </span><span class="src-var">$options</span><span class="src-sym">) </span><span class="src-key">as </span><span class="src-var">$sql</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a249"></a> <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><a href="http://www.php.net/exec">exec</a><span class="src-sym">(</span><span class="src-var">$sql</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a250"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a251"></a> </div></li>
<li><div class="src-line"><a name="a252"></a> <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">commit</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="a253"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a254"></a> </div></li>
<li><div class="src-line"><a name="a255"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a256"></a><span class="src-doc"> * create a new table</span></div></li>
<li><div class="src-line"><a name="a257"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a258"></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 of the database that should be created</span></div></li>
<li><div class="src-line"><a name="a259"></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">$fields </span><span class="src-doc">Associative array that contains the definition of each field of the new table</span></div></li>
<li><div class="src-line"><a name="a260"></a><span class="src-doc"> * The indexes of the array entries are the names of the fields of the table an</span></div></li>
<li><div class="src-line"><a name="a261"></a><span class="src-doc"> * the array entry values are associative arrays like those that are meant to be</span></div></li>
<li><div class="src-line"><a name="a262"></a><span class="src-doc"> * passed with the field definitions to get[Type]Declaration() functions.</span></div></li>
<li><div class="src-line"><a name="a263"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a264"></a><span class="src-doc"> * Example</span></div></li>
<li><div class="src-line"><a name="a265"></a><span class="src-doc"> * array(</span></div></li>
<li><div class="src-line"><a name="a266"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a267"></a><span class="src-doc"> * 'id' => array(</span></div></li>
<li><div class="src-line"><a name="a268"></a><span class="src-doc"> * 'type' => 'integer',</span></div></li>
<li><div class="src-line"><a name="a269"></a><span class="src-doc"> * 'unsigned' => 1</span></div></li>
<li><div class="src-line"><a name="a270"></a><span class="src-doc"> * 'notnull' => 1</span></div></li>
<li><div class="src-line"><a name="a271"></a><span class="src-doc"> * 'default' => 0</span></div></li>
<li><div class="src-line"><a name="a272"></a><span class="src-doc"> * ),</span></div></li>
<li><div class="src-line"><a name="a273"></a><span class="src-doc"> * 'name' => array(</span></div></li>
<li><div class="src-line"><a name="a274"></a><span class="src-doc"> * 'type' => 'text',</span></div></li>
<li><div class="src-line"><a name="a275"></a><span class="src-doc"> * 'length' => 12</span></div></li>
<li><div class="src-line"><a name="a276"></a><span class="src-doc"> * ),</span></div></li>
<li><div class="src-line"><a name="a277"></a><span class="src-doc"> * 'password' => array(</span></div></li>
<li><div class="src-line"><a name="a278"></a><span class="src-doc"> * 'type' => 'text',</span></div></li>
<li><div class="src-line"><a name="a279"></a><span class="src-doc"> * 'length' => 12</span></div></li>
<li><div class="src-line"><a name="a280"></a><span class="src-doc"> * )</span></div></li>
<li><div class="src-line"><a name="a281"></a><span class="src-doc"> * );</span></div></li>
<li><div class="src-line"><a name="a282"></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">$options </span><span class="src-doc"> An associative array of table options:</span></div></li>
<li><div class="src-line"><a name="a283"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a284"></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="a285"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a286"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Export_Oracle.html#methodcreateTableSql">createTableSql</a><span class="src-sym">(</span><span class="src-var">$name</span><span class="src-sym">, </span><span class="src-key">array </span><span class="src-var">$fields</span><span class="src-sym">, </span><span class="src-key">array </span><span class="src-var">$options </span>= <span class="src-key">array</span><span class="src-sym">(</span><span class="src-sym">))</span></div></li>
<li><div class="src-line"><a name="a287"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a288"></a> <span class="src-var">$sql </span>= <span class="src-id">parent</span><span class="src-sym">::</span><a href="../Doctrine/Doctrine_Export.html#methodcreateTableSql">createTableSql</a><span class="src-sym">(</span><span class="src-var">$name</span><span class="src-sym">, </span><span class="src-var">$fields</span><span class="src-sym">, </span><span class="src-var">$options</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a289"></a> </div></li>
<li><div class="src-line"><a name="a290"></a> <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$fields </span><span class="src-key">as </span><span class="src-var">$fieldName </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="a291"></a> <span class="src-key">if </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">'autoincrement'</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">'autoincrement'</span><span class="src-sym">] </span>||</div></li>
<li><div class="src-line"><a name="a292"></a> <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">'autoinc'</span><span class="src-sym">]</span><span class="src-sym">) </span>&& <span class="src-var">$fields</span><span class="src-sym">[</span><span class="src-str">'autoinc'</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="a293"></a> <span class="src-var">$sql </span>= <a href="http://www.php.net/array_merge">array_merge</a><span class="src-sym">(</span><span class="src-var">$sql</span><span class="src-sym">, </span><span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Export_Oracle.html#method_makeAutoincrement">_makeAutoincrement</a><span class="src-sym">(</span><span class="src-var">$fieldName</span><span class="src-sym">, </span><span class="src-var">$name</span><span class="src-sym">))</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a294"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a295"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a296"></a> </div></li>
<li><div class="src-line"><a name="a297"></a> <span class="src-key">return </span><span class="src-var">$sql</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a298"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a299"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a300"></a><span class="src-doc"> * drop an existing table</span></div></li>
<li><div class="src-line"><a name="a301"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a302"></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 of the table that should be dropped</span></div></li>
<li><div class="src-line"><a name="a303"></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="a304"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a305"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Export_Oracle.html#methoddropTable">dropTable</a><span class="src-sym">(</span><span class="src-var">$name</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a306"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a307"></a> <span class="src-comm">//$this->conn->beginNestedTransaction();</span></div></li>
<li><div class="src-line"><a name="a308"></a> <span class="src-var">$result </span>= <span class="src-var">$this</span><span class="src-sym">-></span><a href="../Doctrine/Doctrine_Export_Oracle.html#methoddropAutoincrement">dropAutoincrement</a><span class="src-sym">(</span><span class="src-var">$name</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a309"></a> <span class="src-var">$result </span>= <span class="src-id">parent</span><span class="src-sym">::</span><a href="../Doctrine/Doctrine_Export.html#methoddropTable">dropTable</a><span class="src-sym">(</span><span class="src-var">$name</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a310"></a> <span class="src-comm">//$this->conn->completeNestedTransaction();</span></div></li>
<li><div class="src-line"><a name="a311"></a> <span class="src-key">return </span><span class="src-var">$result</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a312"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a313"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a314"></a><span class="src-doc"> * alter an existing table</span></div></li>
<li><div class="src-line"><a name="a315"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a316"></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 of the table that is intended to be changed.</span></div></li>
<li><div class="src-line"><a name="a317"></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">$changes </span><span class="src-doc"> associative array that contains the details of each type</span></div></li>
<li><div class="src-line"><a name="a318"></a><span class="src-doc"> * of change that is intended to be performed. The types of</span></div></li>
<li><div class="src-line"><a name="a319"></a><span class="src-doc"> * changes that are currently supported are defined as follows:</span></div></li>
<li><div class="src-line"><a name="a320"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a321"></a><span class="src-doc"> * name</span></div></li>
<li><div class="src-line"><a name="a322"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a323"></a><span class="src-doc"> * New name for the table.</span></div></li>
<li><div class="src-line"><a name="a324"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a325"></a><span class="src-doc"> * add</span></div></li>
<li><div class="src-line"><a name="a326"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a327"></a><span class="src-doc"> * Associative array with the names of fields to be added as</span></div></li>
<li><div class="src-line"><a name="a328"></a><span class="src-doc"> * indexes of the array. The value of each entry of the array</span></div></li>
<li><div class="src-line"><a name="a329"></a><span class="src-doc"> * should be set to another associative array with the properties</span></div></li>
<li><div class="src-line"><a name="a330"></a><span class="src-doc"> * of the fields to be added. The properties of the fields should</span></div></li>
<li><div class="src-line"><a name="a331"></a><span class="src-doc"> * be the same as defined by the MDB2 parser.</span></div></li>
<li><div class="src-line"><a name="a332"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a333"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a334"></a><span class="src-doc"> * remove</span></div></li>
<li><div class="src-line"><a name="a335"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a336"></a><span class="src-doc"> * Associative array with the names of fields to be removed as indexes</span></div></li>
<li><div class="src-line"><a name="a337"></a><span class="src-doc"> * of the array. Currently the values assigned to each entry are ignored.</span></div></li>
<li><div class="src-line"><a name="a338"></a><span class="src-doc"> * An empty array should be used for future compatibility.</span></div></li>
<li><div class="src-line"><a name="a339"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a340"></a><span class="src-doc"> * rename</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"> * Associative array with the names of fields to be renamed as indexes</span></div></li>
<li><div class="src-line"><a name="a343"></a><span class="src-doc"> * of the array. The value of each entry of the array should be set to</span></div></li>
<li><div class="src-line"><a name="a344"></a><span class="src-doc"> * another associative array with the entry named name with the new</span></div></li>
<li><div class="src-line"><a name="a345"></a><span class="src-doc"> * field name and the entry named Declaration that is expected to contain</span></div></li>
<li><div class="src-line"><a name="a346"></a><span class="src-doc"> * the portion of the field declaration already in DBMS specific SQL code</span></div></li>
<li><div class="src-line"><a name="a347"></a><span class="src-doc"> * as it is used in the CREATE TABLE statement.</span></div></li>
<li><div class="src-line"><a name="a348"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a349"></a><span class="src-doc"> * change</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"> * Associative array with the names of the fields to be changed as indexes</span></div></li>
<li><div class="src-line"><a name="a352"></a><span class="src-doc"> * of the array. Keep in mind that if it is intended to change either the</span></div></li>
<li><div class="src-line"><a name="a353"></a><span class="src-doc"> * name of a field and any other properties, the change array entries</span></div></li>
<li><div class="src-line"><a name="a354"></a><span class="src-doc"> * should have the new names of the fields as array indexes.</span></div></li>
<li><div class="src-line"><a name="a355"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a356"></a><span class="src-doc"> * The value of each entry of the array should be set to another associative</span></div></li>
<li><div class="src-line"><a name="a357"></a><span class="src-doc"> * array with the properties of the fields to that are meant to be changed as</span></div></li>
<li><div class="src-line"><a name="a358"></a><span class="src-doc"> * array entries. These entries should be assigned to the new values of the</span></div></li>
<li><div class="src-line"><a name="a359"></a><span class="src-doc"> * respective properties. The properties of the fields should be the same</span></div></li>
<li><div class="src-line"><a name="a360"></a><span class="src-doc"> * as defined by the MDB2 parser.</span></div></li>
<li><div class="src-line"><a name="a361"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a362"></a><span class="src-doc"> * Example</span></div></li>
<li><div class="src-line"><a name="a363"></a><span class="src-doc"> * array(</span></div></li>
<li><div class="src-line"><a name="a364"></a><span class="src-doc"> * 'name' => 'userlist',</span></div></li>
<li><div class="src-line"><a name="a365"></a><span class="src-doc"> * 'add' => array(</span></div></li>
<li><div class="src-line"><a name="a366"></a><span class="src-doc"> * 'quota' => array(</span></div></li>
<li><div class="src-line"><a name="a367"></a><span class="src-doc"> * 'type' => 'integer',</span></div></li>
<li><div class="src-line"><a name="a368"></a><span class="src-doc"> * 'unsigned' => 1</span></div></li>
<li><div class="src-line"><a name="a369"></a><span class="src-doc"> * )</span></div></li>
<li><div class="src-line"><a name="a370"></a><span class="src-doc"> * ),</span></div></li>
<li><div class="src-line"><a name="a371"></a><span class="src-doc"> * 'remove' => array(</span></div></li>
<li><div class="src-line"><a name="a372"></a><span class="src-doc"> * 'file_limit' => array(),</span></div></li>
<li><div class="src-line"><a name="a373"></a><span class="src-doc"> * 'time_limit' => array()</span></div></li>
<li><div class="src-line"><a name="a374"></a><span class="src-doc"> * ),</span></div></li>
<li><div class="src-line"><a name="a375"></a><span class="src-doc"> * 'change' => array(</span></div></li>
<li><div class="src-line"><a name="a376"></a><span class="src-doc"> * 'name' => array(</span></div></li>
<li><div class="src-line"><a name="a377"></a><span class="src-doc"> * 'length' => '20',</span></div></li>
<li><div class="src-line"><a name="a378"></a><span class="src-doc"> * 'definition' => array(</span></div></li>
<li><div class="src-line"><a name="a379"></a><span class="src-doc"> * 'type' => 'text',</span></div></li>
<li><div class="src-line"><a name="a380"></a><span class="src-doc"> * 'length' => 20,</span></div></li>
<li><div class="src-line"><a name="a381"></a><span class="src-doc"> * ),</span></div></li>
<li><div class="src-line"><a name="a382"></a><span class="src-doc"> * )</span></div></li>
<li><div class="src-line"><a name="a383"></a><span class="src-doc"> * ),</span></div></li>
<li><div class="src-line"><a name="a384"></a><span class="src-doc"> * 'rename' => array(</span></div></li>
<li><div class="src-line"><a name="a385"></a><span class="src-doc"> * 'sex' => array(</span></div></li>
<li><div class="src-line"><a name="a386"></a><span class="src-doc"> * 'name' => 'gender',</span></div></li>
<li><div class="src-line"><a name="a387"></a><span class="src-doc"> * 'definition' => array(</span></div></li>
<li><div class="src-line"><a name="a388"></a><span class="src-doc"> * 'type' => 'text',</span></div></li>
<li><div class="src-line"><a name="a389"></a><span class="src-doc"> * 'length' => 1,</span></div></li>
<li><div class="src-line"><a name="a390"></a><span class="src-doc"> * 'default' => 'M',</span></div></li>
<li><div class="src-line"><a name="a391"></a><span class="src-doc"> * ),</span></div></li>
<li><div class="src-line"><a name="a392"></a><span class="src-doc"> * )</span></div></li>
<li><div class="src-line"><a name="a393"></a><span class="src-doc"> * )</span></div></li>
<li><div class="src-line"><a name="a394"></a><span class="src-doc"> * )</span></div></li>
<li><div class="src-line"><a name="a395"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a396"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">boolean </span><span class="src-doc-var">$check </span><span class="src-doc"> indicates whether the function should just check if the DBMS driver</span></div></li>
<li><div class="src-line"><a name="a397"></a><span class="src-doc"> * can perform the requested table alterations if the value is true or</span></div></li>
<li><div class="src-line"><a name="a398"></a><span class="src-doc"> * actually perform them otherwise.</span></div></li>
<li><div class="src-line"><a name="a399"></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="a400"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a401"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Export_Oracle.html#methodalterTable">alterTable</a><span class="src-sym">(</span><span class="src-var">$name</span><span class="src-sym">, </span><span class="src-key">array </span><span class="src-var">$changes</span><span class="src-sym">, </span><span class="src-var">$check</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a402"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a403"></a> </div></li>
<li><div class="src-line"><a name="a404"></a> <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$changes </span><span class="src-key">as </span><span class="src-var">$changeName </span>=> <span class="src-var">$change</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a405"></a> <span class="src-key">switch </span><span class="src-sym">(</span><span class="src-var">$changeName</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a406"></a> <span class="src-key">case </span><span class="src-str">'add'</span>:</div></li>
<li><div class="src-line"><a name="a407"></a> <span class="src-key">case </span><span class="src-str">'remove'</span>:</div></li>
<li><div class="src-line"><a name="a408"></a> <span class="src-key">case </span><span class="src-str">'change'</span>:</div></li>
<li><div class="src-line"><a name="a409"></a> <span class="src-key">case </span><span class="src-str">'name'</span>:</div></li>
<li><div class="src-line"><a name="a410"></a> <span class="src-key">case </span><span class="src-str">'rename'</span>:</div></li>
<li><div class="src-line"><a name="a411"></a> <span class="src-key">break</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a412"></a> <span class="src-key">default</span>:</div></li>
<li><div class="src-line"><a name="a413"></a> throw <span class="src-key">new </span><span class="src-id"><a href="../Doctrine/Doctrine_Export_Exception.html">Doctrine_Export_Exception</a></span><span class="src-sym">(</span><span class="src-str">'change type "' </span>. <span class="src-var">$changeName </span>. <span class="src-str">'" not yet supported'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a414"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a415"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a416"></a> </div></li>
<li><div class="src-line"><a name="a417"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$check</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a418"></a> <span class="src-key">return </span><span class="src-id">false</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a419"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a420"></a> </div></li>
<li><div class="src-line"><a name="a421"></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="a422"></a> </div></li>
<li><div class="src-line"><a name="a423"></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">$changes</span><span class="src-sym">[</span><span class="src-str">'add'</span><span class="src-sym">]</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">$changes</span><span class="src-sym">[</span><span class="src-str">'add'</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="a424"></a> <span class="src-var">$fields </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="a425"></a> <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$changes</span><span class="src-sym">[</span><span class="src-str">'add'</span><span class="src-sym">] </span><span class="src-key">as </span><span class="src-var">$fieldName </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="a426"></a> <span class="src-var">$fields</span><span class="src-sym">[</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><a href="../Doctrine/Doctrine_Export.html#methodgetDeclaration">getDeclaration</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-var">$fieldName</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="a427"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a428"></a> <span class="src-var">$result </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><a href="http://www.php.net/exec">exec</a><span class="src-sym">(</span><span class="src-str">'ALTER TABLE ' </span>. <span class="src-var">$name </span>. <span class="src-str">' ADD (' </span>. <a href="http://www.php.net/implode">implode</a><span class="src-sym">(</span><span class="src-str">', '</span><span class="src-sym">, </span><span class="src-var">$fields</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="a429"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a430"></a> </div></li>
<li><div class="src-line"><a name="a431"></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">$changes</span><span class="src-sym">[</span><span class="src-str">'change'</span><span class="src-sym">]</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">$changes</span><span class="src-sym">[</span><span class="src-str">'change'</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="a432"></a> <span class="src-var">$fields </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="a433"></a> <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$changes</span><span class="src-sym">[</span><span class="src-str">'change'</span><span class="src-sym">] </span><span class="src-key">as </span><span class="src-var">$fieldName </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="a434"></a> <span class="src-var">$fields</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-var">$fieldName</span>. <span class="src-str">' ' </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><a href="../Doctrine/Doctrine_Export.html#methodgetDeclaration">getDeclaration</a><span class="src-sym">(</span><span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'definition'</span><span class="src-sym">]</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-str">''</span><span class="src-sym">, </span><span class="src-var">$field</span><span class="src-sym">[</span><span class="src-str">'definition'</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="a435"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a436"></a> <span class="src-var">$result </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><a href="http://www.php.net/exec">exec</a><span class="src-sym">(</span><span class="src-str">'ALTER TABLE ' </span>. <span class="src-var">$name </span>. <span class="src-str">' MODIFY (' </span>. <a href="http://www.php.net/implode">implode</a><span class="src-sym">(</span><span class="src-str">', '</span><span class="src-sym">, </span><span class="src-var">$fields</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="a437"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a438"></a> </div></li>
<li><div class="src-line"><a name="a439"></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">$changes</span><span class="src-sym">[</span><span class="src-str">'rename'</span><span class="src-sym">]</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">$changes</span><span class="src-sym">[</span><span class="src-str">'rename'</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="a440"></a> <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$changes</span><span class="src-sym">[</span><span class="src-str">'rename'</span><span class="src-sym">] </span><span class="src-key">as </span><span class="src-var">$fieldName </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="a441"></a> <span class="src-var">$query </span>= <span class="src-str">'ALTER TABLE ' </span>. <span class="src-var">$name </span>. <span class="src-str">' RENAME COLUMN ' </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">$fieldName</span><span class="src-sym">, </span><span class="src-id">true</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a442"></a> . <span class="src-str">' TO ' </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">$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="a443"></a> </div></li>
<li><div class="src-line"><a name="a444"></a> <span class="src-var">$result </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><a href="http://www.php.net/exec">exec</a><span class="src-sym">(</span><span class="src-var">$query</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a445"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a446"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a447"></a> </div></li>
<li><div class="src-line"><a name="a448"></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">$changes</span><span class="src-sym">[</span><span class="src-str">'remove'</span><span class="src-sym">]</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">$changes</span><span class="src-sym">[</span><span class="src-str">'remove'</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="a449"></a> <span class="src-var">$fields </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="a450"></a> <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$changes</span><span class="src-sym">[</span><span class="src-str">'remove'</span><span class="src-sym">] </span><span class="src-key">as </span><span class="src-var">$fieldName </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="a451"></a> <span class="src-var">$fields</span><span class="src-sym">[</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">quoteIdentifier</span><span class="src-sym">(</span><span class="src-var">$fieldName</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="a452"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a453"></a> <span class="src-var">$result </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><a href="http://www.php.net/exec">exec</a><span class="src-sym">(</span><span class="src-str">'ALTER TABLE ' </span>. <span class="src-var">$name </span>. <span class="src-str">' DROP COLUMN ' </span>. <a href="http://www.php.net/implode">implode</a><span class="src-sym">(</span><span class="src-str">', '</span><span class="src-sym">, </span><span class="src-var">$fields</span><span class="src-sym">))</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a454"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a455"></a> </div></li>
<li><div class="src-line"><a name="a456"></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">$changes</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="a457"></a> <span class="src-var">$changeName </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">$changes</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-id">true</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a458"></a> <span class="src-var">$result </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><a href="http://www.php.net/exec">exec</a><span class="src-sym">(</span><span class="src-str">'ALTER TABLE ' </span>. <span class="src-var">$name </span>. <span class="src-str">' RENAME TO ' </span>. <span class="src-var">$changeName</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-sym">}</span></div></li>
<li><div class="src-line"><a name="a460"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a461"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a462"></a><span class="src-doc"> * create sequence</span></div></li>
<li><div class="src-line"><a name="a463"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a464"></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">$seqName </span><span class="src-doc">name of the sequence to be created</span></div></li>
<li><div class="src-line"><a name="a465"></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">$start </span><span class="src-doc">start value of the sequence; default is 1</span></div></li>
<li><div class="src-line"><a name="a466"></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">$options </span><span class="src-doc"> An associative array of table options:</span></div></li>
<li><div class="src-line"><a name="a467"></a><span class="src-doc"> * array(</span></div></li>
<li><div class="src-line"><a name="a468"></a><span class="src-doc"> * 'comment' => 'Foo',</span></div></li>
<li><div class="src-line"><a name="a469"></a><span class="src-doc"> * 'charset' => 'utf8',</span></div></li>
<li><div class="src-line"><a name="a470"></a><span class="src-doc"> * 'collate' => 'utf8_unicode_ci',</span></div></li>
<li><div class="src-line"><a name="a471"></a><span class="src-doc"> * );</span></div></li>
<li><div class="src-line"><a name="a472"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span></div></li>
<li><div class="src-line"><a name="a473"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a474"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Export_Oracle.html#methodcreateSequenceSql">createSequenceSql</a><span class="src-sym">(</span><span class="src-var">$seqName</span><span class="src-sym">, </span><span class="src-var">$start </span>= <span class="src-num">1</span><span class="src-sym">, </span><span class="src-key">array </span><span class="src-var">$options </span>= <span class="src-key">array</span><span class="src-sym">(</span><span class="src-sym">))</span></div></li>
<li><div class="src-line"><a name="a475"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a476"></a> <span class="src-var">$sequenceName </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">$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">formatter</span><span class="src-sym">-></span><span class="src-id">getSequenceName</span><span class="src-sym">(</span><span class="src-var">$seqName</span><span class="src-sym">)</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="a477"></a> <span class="src-var">$query </span>= <span class="src-str">'CREATE SEQUENCE ' </span>. <span class="src-var">$sequenceName </span>. <span class="src-str">' START WITH ' </span>. <span class="src-var">$start </span>. <span class="src-str">' INCREMENT BY 1 NOCACHE'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a478"></a> <span class="src-var">$query </span>.= <span class="src-sym">(</span><span class="src-var">$start </span>< <span class="src-num">1 </span>? <span class="src-str">' MINVALUE ' </span>. <span class="src-var">$start </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="a479"></a> <span class="src-key">return </span><span class="src-var">$query</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a480"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a481"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a482"></a><span class="src-doc"> * drop existing sequence</span></div></li>
<li><div class="src-line"><a name="a483"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a484"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">object </span><span class="src-doc-var">$this->conn </span><span class="src-doc">database object that is extended by this class</span></div></li>
<li><div class="src-line"><a name="a485"></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">$seqName </span><span class="src-doc">name of the sequence to be dropped</span></div></li>
<li><div class="src-line"><a name="a486"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">string </span></div></li>
<li><div class="src-line"><a name="a487"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a488"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Export_Oracle.html#methoddropSequenceSql">dropSequenceSql</a><span class="src-sym">(</span><span class="src-var">$seqName</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a489"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a490"></a> <span class="src-var">$sequenceName </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">$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">formatter</span><span class="src-sym">-></span><span class="src-id">getSequenceName</span><span class="src-sym">(</span><span class="src-var">$seqName</span><span class="src-sym">)</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="a491"></a> <span class="src-key">return </span><span class="src-str">'DROP SEQUENCE ' </span>. <span class="src-var">$sequenceName</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a492"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a493"></a><span class="src-sym">}</span></div></li>
</ol>
</span></div>
</div>