<div id="content">
<h1 align="center">Source for file Sqlite.php</h1>
<p>Documentation is available at <a href="../Doctrine/_Doctrine---Import---Sqlite.php.html">Sqlite.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: Sqlite.php 1889 2007-06-28 12:11:55Z zYne $</span></div></li>
<li><div class="src-line"><a name="a4"></a><span class="src-comm"> *</span></div></li>
<li><div class="src-line"><a name="a5"></a><span class="src-comm"> * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS</span></div></li>
<li><div class="src-line"><a name="a6"></a><span class="src-comm"> * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT</span></div></li>
<li><div class="src-line"><a name="a7"></a><span class="src-comm"> * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR</span></div></li>
<li><div class="src-line"><a name="a8"></a><span class="src-comm"> * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT</span></div></li>
<li><div class="src-line"><a name="a9"></a><span class="src-comm"> * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,</span></div></li>
<li><div class="src-line"><a name="a10"></a><span class="src-comm"> * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT</span></div></li>
<li><div class="src-line"><a name="a11"></a><span class="src-comm"> * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,</span></div></li>
<li><div class="src-line"><a name="a12"></a><span class="src-comm"> * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY</span></div></li>
<li><div class="src-line"><a name="a13"></a><span class="src-comm"> * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT</span></div></li>
<li><div class="src-line"><a name="a14"></a><span class="src-comm"> * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE</span></div></li>
<li><div class="src-line"><a name="a15"></a><span class="src-comm"> * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.</span></div></li>
<li><div class="src-line"><a name="a16"></a><span class="src-comm"> *</span></div></li>
<li><div class="src-line"><a name="a17"></a><span class="src-comm"> * This software consists of voluntary contributions made by many individuals</span></div></li>
<li><div class="src-line"><a name="a18"></a><span class="src-comm"> * and is licensed under the LGPL. For more information, see</span></div></li>
<li><div class="src-line"><a name="a19"></a><span class="src-comm"> * <http://www.phpdoctrine.com>.</span></div></li>
<li><div class="src-line"><a name="a20"></a><span class="src-comm"> */</span></div></li>
<li><div class="src-line"><a name="a21"></a><span class="src-id"><a href="../Doctrine/Doctrine.html">Doctrine</a></span><span class="src-sym">::</span><a href="../Doctrine/Doctrine.html#methodautoload">autoload</a><span class="src-sym">(</span><span class="src-str">'Doctrine_Import'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a22"></a><span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a23"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@package</span><span class="src-doc"> Doctrine</span></div></li>
<li><div class="src-line"><a name="a24"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@license</span><span class="src-doc"> http://www.opensource.org/licenses/lgpl-license.php LGPL</span></div></li>
<li><div class="src-line"><a name="a25"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@author</span><span class="src-doc"> Konsta Vesterinen <kvesteri@cc.hut.fi></span></div></li>
<li><div class="src-line"><a name="a26"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@author</span><span class="src-doc"> Lukas Smith <smith@pooteeweet.org> (PEAR MDB2 library)</span></div></li>
<li><div class="src-line"><a name="a27"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@version</span><span class="src-doc"> $Revision: 1889 $</span></div></li>
<li><div class="src-line"><a name="a28"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@category</span><span class="src-doc"> Object Relational Mapping</span></div></li>
<li><div class="src-line"><a name="a29"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@link</span><span class="src-doc"> www.phpdoctrine.com</span></div></li>
<li><div class="src-line"><a name="a30"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@since</span><span class="src-doc"> 1.0</span></div></li>
<li><div class="src-line"><a name="a31"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a32"></a><span class="src-key">class </span><a href="../Doctrine/Doctrine_Import_Sqlite.html">Doctrine_Import_Sqlite</a> <span class="src-key">extends </span><a href="../Doctrine/Doctrine_Import.html">Doctrine_Import</a></div></li>
<li><div class="src-line"><a name="a33"></a><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a34"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a35"></a><span class="src-doc"> * lists all databases</span></div></li>
<li><div class="src-line"><a name="a36"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a37"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">array </span></div></li>
<li><div class="src-line"><a name="a38"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a39"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Import_Sqlite.html#methodlistDatabases">listDatabases</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a40"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a41"></a> </div></li>
<li><div class="src-line"><a name="a42"></a> <span class="src-sym">}</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-doc"> * lists all availible database functions</span></div></li>
<li><div class="src-line"><a name="a45"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a46"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">array </span></div></li>
<li><div class="src-line"><a name="a47"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a48"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Import_Sqlite.html#methodlistFunctions">listFunctions</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a49"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a50"></a> </div></li>
<li><div class="src-line"><a name="a51"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a52"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a53"></a><span class="src-doc"> * lists all database triggers</span></div></li>
<li><div class="src-line"><a name="a54"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a55"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string</span><span class="src-doc">|</span><span class="src-doc-type">null</span><span class="src-doc-var">$database </span></div></li>
<li><div class="src-line"><a name="a56"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">array </span></div></li>
<li><div class="src-line"><a name="a57"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a58"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Import_Sqlite.html#methodlistTriggers">listTriggers</a><span class="src-sym">(</span><span class="src-var">$database </span>= <span class="src-id">null</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a59"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a60"></a> </div></li>
<li><div class="src-line"><a name="a61"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a62"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a63"></a><span class="src-doc"> * lists all database sequences</span></div></li>
<li><div class="src-line"><a name="a64"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a65"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string</span><span class="src-doc">|</span><span class="src-doc-type">null</span><span class="src-doc-var">$database </span></div></li>
<li><div class="src-line"><a name="a66"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">array </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-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Import_Sqlite.html#methodlistSequences">listSequences</a><span class="src-sym">(</span><span class="src-var">$database </span>= <span class="src-id">null</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a69"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a70"></a> <span class="src-var">$query </span>= <span class="src-str">"SELECT name FROM sqlite_master WHERE type='table' AND sql NOT NULL ORDER BY name"</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a71"></a> <span class="src-var">$tableNames </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">fetchColumn</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="a72"></a> </div></li>
<li><div class="src-line"><a name="a73"></a> <span class="src-var">$result </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="a74"></a> <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$tableNames </span><span class="src-key">as </span><span class="src-var">$tableName</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a75"></a> <span class="src-key">if </span><span class="src-sym">(</span><span class="src-var">$sqn </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">fixSequenceName</span><span class="src-sym">(</span><span class="src-var">$tableName</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="a76"></a> <span class="src-var">$result</span><span class="src-sym">[</span><span class="src-sym">] </span>= <span class="src-var">$sqn</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a77"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a78"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a79"></a> <span class="src-key">if </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_PORTABILITY</span><span class="src-sym">) </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">PORTABILITY_FIX_CASE</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a80"></a> <span class="src-var">$result </span>= <a href="http://www.php.net/array_map">array_map</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_FIELD_CASE</span><span class="src-sym">) </span>== <span class="src-id">CASE_LOWER </span>? <span class="src-str">'strtolower' </span>: <span class="src-str">'strtoupper'</span><span class="src-sym">)</span><span class="src-sym">, </span><span class="src-var">$result</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a81"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a82"></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="a83"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a84"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a85"></a><span class="src-doc"> * lists table constraints</span></div></li>
<li><div class="src-line"><a name="a86"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a87"></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"> database table name</span></div></li>
<li><div class="src-line"><a name="a88"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">array </span></div></li>
<li><div class="src-line"><a name="a89"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a90"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Import_Sqlite.html#methodlistTableConstraints">listTableConstraints</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="a91"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a92"></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">quote</span><span class="src-sym">(</span><span class="src-var">$table</span><span class="src-sym">, </span><span class="src-str">'text'</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a93"></a> </div></li>
<li><div class="src-line"><a name="a94"></a> <span class="src-var">$query </span>= <span class="src-str">"SELECT sql FROM sqlite_master WHERE type='index' AND "</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a95"></a> </div></li>
<li><div class="src-line"><a name="a96"></a> <span class="src-key">if </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_PORTABILITY</span><span class="src-sym">) </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">PORTABILITY_FIX_CASE</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">$query </span>.= <span class="src-str">'LOWER(tbl_name) = ' </span>. <a href="http://www.php.net/strtolower">strtolower</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-sym">} </span><span class="src-key">else </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a99"></a> <span class="src-var">$query </span>.= <span class="src-str">'tbl_name = ' </span>. <span class="src-var">$table</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a100"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a101"></a> <span class="src-var">$query </span>.= <span class="src-str">' AND sql NOT NULL ORDER BY name'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a102"></a> <span class="src-var">$indexes </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">fetchColumn</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="a103"></a> </div></li>
<li><div class="src-line"><a name="a104"></a> <span class="src-var">$result </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="a105"></a> <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$indexes </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="a106"></a> <span class="src-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/preg_match">preg_match</a><span class="src-sym">(</span><span class="src-str">"/^create unique index ([^ ]+) on /i"</span><span class="src-sym">, </span><span class="src-var">$sql</span><span class="src-sym">, </span><span class="src-var">$tmp</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">$index </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">fixIndexName</span><span class="src-sym">(</span><span class="src-var">$tmp</span><span class="src-sym">[</span><span class="src-num">1</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="a108"></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">$index</span><span class="src-sym">)) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a109"></a> <span class="src-var">$result</span><span class="src-sym">[</span><span class="src-var">$index</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="a110"></a> <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> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a113"></a> </div></li>
<li><div class="src-line"><a name="a114"></a> <span class="src-key">if </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_PORTABILITY</span><span class="src-sym">) </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">PORTABILITY_FIX_CASE</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a115"></a> <span class="src-var">$result </span>= <a href="http://www.php.net/array_change_key_case">array_change_key_case</a><span class="src-sym">(</span><span class="src-var">$result</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_FIELD_CASE</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-sym">}</span></div></li>
<li><div class="src-line"><a name="a117"></a> <span class="src-key">return </span><a href="http://www.php.net/array_keys">array_keys</a><span class="src-sym">(</span><span class="src-var">$result</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-sym">}</span></div></li>
<li><div class="src-line"><a name="a119"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a120"></a><span class="src-doc"> * lists table constraints</span></div></li>
<li><div class="src-line"><a name="a121"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a122"></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"> database table name</span></div></li>
<li><div class="src-line"><a name="a123"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">array </span></div></li>
<li><div class="src-line"><a name="a124"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a125"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Import_Sqlite.html#methodlistTableColumns">listTableColumns</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="a126"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a127"></a> <span class="src-var">$sql </span>= <span class="src-str">'PRAGMA table_info(' </span>. <span class="src-var">$table </span>. <span class="src-str">')'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a128"></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">fetchAll</span><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="a129"></a> </div></li>
<li><div class="src-line"><a name="a130"></a> <span class="src-var">$description </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="a131"></a> <span class="src-var">$columns </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="a132"></a> <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$result </span><span class="src-key">as </span><span class="src-var">$key </span>=> <span class="src-var">$val</span><span class="src-sym">) </span><span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a133"></a> <span class="src-var">$val </span>= <a href="http://www.php.net/array_change_key_case">array_change_key_case</a><span class="src-sym">(</span><span class="src-var">$val</span><span class="src-sym">, </span><span class="src-id">CASE_LOWER</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a134"></a> <span class="src-var">$decl </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">dataDict</span><span class="src-sym">-></span><span class="src-id">getPortableDeclaration</span><span class="src-sym">(</span><span class="src-var">$val</span><span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a135"></a> </div></li>
<li><div class="src-line"><a name="a136"></a> <span class="src-var">$description </span>= <span class="src-key">array</span><span class="src-sym">(</span></div></li>
<li><div class="src-line"><a name="a137"></a> <span class="src-str">'name' </span>=> <span class="src-var">$val</span><span class="src-sym">[</span><span class="src-str">'name'</span><span class="src-sym">]</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a138"></a> <span class="src-str">'ntype' </span>=> <span class="src-var">$val</span><span class="src-sym">[</span><span class="src-str">'type'</span><span class="src-sym">]</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a139"></a> <span class="src-str">'type' </span>=> <span class="src-var">$decl</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-num">0</span><span class="src-sym">]</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a140"></a> <span class="src-str">'alltypes' </span>=> <span class="src-var">$decl</span><span class="src-sym">[</span><span class="src-str">'type'</span><span class="src-sym">]</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a141"></a> <span class="src-str">'notnull' </span>=> (bool) <span class="src-var">$val</span><span class="src-sym">[</span><span class="src-str">'notnull'</span><span class="src-sym">]</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a142"></a> <span class="src-str">'default' </span>=> <span class="src-var">$val</span><span class="src-sym">[</span><span class="src-str">'dflt_value'</span><span class="src-sym">]</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a143"></a> <span class="src-str">'primary' </span>=> (bool) <span class="src-var">$val</span><span class="src-sym">[</span><span class="src-str">'pk'</span><span class="src-sym">]</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a144"></a> <span class="src-str">'length' </span>=> <span class="src-id">null</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a145"></a> <span class="src-str">'scale' </span>=> <span class="src-id">null</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a146"></a> <span class="src-str">'precision' </span>=> <span class="src-id">null</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a147"></a> <span class="src-str">'unsigned' </span>=> <span class="src-id">null</span><span class="src-sym">,</span></div></li>
<li><div class="src-line"><a name="a148"></a> <span class="src-sym">)</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a149"></a> <span class="src-var">$columns</span><span class="src-sym">[</span><span class="src-var">$val</span><span class="src-sym">[</span><span class="src-str">'name'</span><span class="src-sym">]] </span>= <span class="src-var">$description</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-key">return </span><span class="src-var">$columns</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a152"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a153"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a154"></a><span class="src-doc"> * lists table constraints</span></div></li>
<li><div class="src-line"><a name="a155"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a156"></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"> database table name</span></div></li>
<li><div class="src-line"><a name="a157"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">array </span></div></li>
<li><div class="src-line"><a name="a158"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a159"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Import_Sqlite.html#methodlistTableIndexes">listTableIndexes</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="a160"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a161"></a> <span class="src-var">$sql </span>= <span class="src-str">'PRAGMA index_list(' </span>. <span class="src-var">$table </span>. <span class="src-str">')'</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a162"></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">fetchColumn</span><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="a163"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a164"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a165"></a><span class="src-doc"> * lists tables</span></div></li>
<li><div class="src-line"><a name="a166"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a167"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string</span><span class="src-doc">|</span><span class="src-doc-type">null</span><span class="src-doc-var">$database </span></div></li>
<li><div class="src-line"><a name="a168"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">array </span></div></li>
<li><div class="src-line"><a name="a169"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a170"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Import_Sqlite.html#methodlistTables">listTables</a><span class="src-sym">(</span><span class="src-var">$database </span>= <span class="src-id">null</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a171"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a172"></a> <span class="src-var">$sql </span>= <span class="src-str">"SELECT name FROM sqlite_master WHERE type = 'table' "</span></div></li>
<li><div class="src-line"><a name="a173"></a> . <span class="src-str">"UNION ALL SELECT name FROM sqlite_temp_master "</span></div></li>
<li><div class="src-line"><a name="a174"></a> . <span class="src-str">"WHERE type = 'table' ORDER BY name"</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a175"></a> </div></li>
<li><div class="src-line"><a name="a176"></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">fetchColumn</span><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="a177"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a178"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a179"></a><span class="src-doc"> * lists table triggers</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-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"> database table name</span></div></li>
<li><div class="src-line"><a name="a182"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">array </span></div></li>
<li><div class="src-line"><a name="a183"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a184"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Import_Sqlite.html#methodlistTableTriggers">listTableTriggers</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="a185"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a186"></a> </div></li>
<li><div class="src-line"><a name="a187"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a188"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a189"></a><span class="src-doc"> * lists table views</span></div></li>
<li><div class="src-line"><a name="a190"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a191"></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"> database table name</span></div></li>
<li><div class="src-line"><a name="a192"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">array </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_Import_Sqlite.html#methodlistTableViews">listTableViews</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="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">"SELECT name, sql FROM sqlite_master WHERE type='view' AND sql NOT NULL"</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a197"></a> <span class="src-var">$views </span>= <span class="src-var">$db</span><span class="src-sym">-></span><span class="src-id">fetchAll</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="a198"></a> </div></li>
<li><div class="src-line"><a name="a199"></a> <span class="src-var">$result </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="a200"></a> <span class="src-key">foreach </span><span class="src-sym">(</span><span class="src-var">$views </span><span class="src-key">as </span><span class="src-var">$row</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-key">if </span><span class="src-sym">(</span><a href="http://www.php.net/preg_match">preg_match</a><span class="src-sym">(</span><span class="src-str">"</span><span class="src-str">/^<span class="src-id">create</span> <span class="src-id">view</span> .* \b<span class="src-id">from</span>\b\s+\b{<span class="src-var">$table</span><span class="src-sym">}</span>\b /<span class="src-id">i</span></span><span class="src-str">"</span><span class="src-sym">, </span><span class="src-var">$row</span><span class="src-sym">[</span><span class="src-str">'sql'</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="a202"></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">$row</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="a203"></a> <span class="src-var">$result</span><span class="src-sym">[</span><span class="src-var">$row</span><span class="src-sym">[</span><span class="src-str">'name'</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="a204"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a205"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a206"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a207"></a> <span class="src-key">return </span><span class="src-var">$result</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a208"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a209"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a210"></a><span class="src-doc"> * lists database users</span></div></li>
<li><div class="src-line"><a name="a211"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a212"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">array </span></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-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Import_Sqlite.html#methodlistUsers">listUsers</a><span class="src-sym">(</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a215"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a216"></a> </div></li>
<li><div class="src-line"><a name="a217"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a218"></a> <span class="src-doc">/**</span></div></li>
<li><div class="src-line"><a name="a219"></a><span class="src-doc"> * lists database views</span></div></li>
<li><div class="src-line"><a name="a220"></a><span class="src-doc"> *</span></div></li>
<li><div class="src-line"><a name="a221"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@param </span><span class="src-doc-type">string</span><span class="src-doc">|</span><span class="src-doc-type">null</span><span class="src-doc-var">$database </span></div></li>
<li><div class="src-line"><a name="a222"></a><span class="src-doc"> * </span><span class="src-doc-coretag">@return </span><span class="src-doc-type">array </span></div></li>
<li><div class="src-line"><a name="a223"></a><span class="src-doc"> */</span></div></li>
<li><div class="src-line"><a name="a224"></a> <span class="src-key">public </span><span class="src-key">function </span><a href="../Doctrine/Doctrine_Import_Sqlite.html#methodlistViews">listViews</a><span class="src-sym">(</span><span class="src-var">$database </span>= <span class="src-id">null</span><span class="src-sym">)</span></div></li>
<li><div class="src-line"><a name="a225"></a> <span class="src-sym">{</span></div></li>
<li><div class="src-line"><a name="a226"></a> <span class="src-var">$query </span>= <span class="src-str">"SELECT name FROM sqlite_master WHERE type='view' AND sql NOT NULL"</span><span class="src-sym">;</span></div></li>
<li><div class="src-line"><a name="a227"></a> </div></li>
<li><div class="src-line"><a name="a228"></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">fetchColumn</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="a229"></a> <span class="src-sym">}</span></div></li>
<li><div class="src-line"><a name="a230"></a><span class="src-sym">}</span></div></li>
</ol>
</span></div>
</div>