<?xml version="1.0" encoding="ascii"?> <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <title>BioSQL.DBUtils</title> <link rel="stylesheet" href="epydoc.css" type="text/css" /> <script type="text/javascript" src="epydoc.js"></script> </head> <body bgcolor="white" text="black" link="blue" vlink="#204080" alink="#204080"> <!-- ==================== NAVIGATION BAR ==================== --> <table class="navbar" border="0" width="100%" cellpadding="0" bgcolor="#a0c0ff" cellspacing="0"> <tr valign="middle"> <!-- Tree link --> <th> <a href="module-tree.html">Trees</a> </th> <!-- Index link --> <th> <a href="identifier-index.html">Indices</a> </th> <!-- Help link --> <th> <a href="help.html">Help</a> </th> <th class="navbar" width="100%"></th> </tr> </table> <table width="100%" cellpadding="0" cellspacing="0"> <tr valign="top"> <td width="100%"> <span class="breadcrumbs"> <a href="BioSQL-module.html">Package BioSQL</a> :: Module DBUtils </span> </td> <td> <table cellpadding="0" cellspacing="0"> <!-- hide/show private --> <tr><td align="right"><span class="options">[<a href="javascript:void(0);" class="privatelink" onclick="toggle_private();">hide private</a>]</span></td></tr> <tr><td align="right"><span class="options" >[<a href="frames.html" target="_top">frames</a >] | <a href="BioSQL.DBUtils-pysrc.html" target="_top">no frames</a>]</span></td></tr> </table> </td> </tr> </table> <h1 class="epydoc">Source Code for <a href="BioSQL.DBUtils-module.html">Module BioSQL.DBUtils</a></h1> <pre class="py-src"> <a name="L1"></a><tt class="py-lineno"> 1</tt> <tt class="py-line"><tt class="py-comment"># Copyright 2002 by Andrew Dalke. All rights reserved.</tt> </tt> <a name="L2"></a><tt class="py-lineno"> 2</tt> <tt class="py-line"><tt class="py-comment"># Revisions 2007-2010 copyright by Peter Cock. All rights reserved.</tt> </tt> <a name="L3"></a><tt class="py-lineno"> 3</tt> <tt class="py-line"><tt class="py-comment"># Revisions 2009 copyright by Brad Chapman. All rights reserved.</tt> </tt> <a name="L4"></a><tt class="py-lineno"> 4</tt> <tt class="py-line"><tt class="py-comment"># This code is part of the Biopython distribution and governed by its</tt> </tt> <a name="L5"></a><tt class="py-lineno"> 5</tt> <tt class="py-line"><tt class="py-comment"># license. Please see the LICENSE file that should have been included</tt> </tt> <a name="L6"></a><tt class="py-lineno"> 6</tt> <tt class="py-line"><tt class="py-comment"># as part of this package.</tt> </tt> <a name="L7"></a><tt class="py-lineno"> 7</tt> <tt class="py-line"><tt class="py-comment">#</tt> </tt> <a name="L8"></a><tt class="py-lineno"> 8</tt> <tt class="py-line"><tt class="py-comment"># Note that BioSQL (including the database schema and scripts) is</tt> </tt> <a name="L9"></a><tt class="py-lineno"> 9</tt> <tt class="py-line"><tt class="py-comment"># available and licensed separately. Please consult www.biosql.org</tt> </tt> <a name="L10"></a><tt class="py-lineno"> 10</tt> <tt class="py-line"> </tt> <a name="L11"></a><tt class="py-lineno"> 11</tt> <tt class="py-line"><tt id="link-0" class="py-name" targets="Variable BioSQL.DBUtils._dbutils=BioSQL.DBUtils-module.html#_dbutils"><a title="BioSQL.DBUtils._dbutils" class="py-name" href="#" onclick="return doclink('link-0', '_dbutils', 'link-0');">_dbutils</a></tt> <tt class="py-op">=</tt> <tt class="py-op">{</tt><tt class="py-op">}</tt> </tt> <a name="L12"></a><tt class="py-lineno"> 12</tt> <tt class="py-line"> </tt> <a name="Generic_dbutils"></a><div id="Generic_dbutils-def"><a name="L13"></a><tt class="py-lineno"> 13</tt> <a class="py-toggle" href="#" id="Generic_dbutils-toggle" onclick="return toggle('Generic_dbutils');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="BioSQL.DBUtils.Generic_dbutils-class.html">Generic_dbutils</a><tt class="py-op">:</tt> </tt> </div><div id="Generic_dbutils-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="Generic_dbutils-expanded"><a name="L14"></a><tt class="py-lineno"> 14</tt> <tt class="py-line"> <tt class="py-docstring">"""Default database utilities."""</tt> </tt> <a name="Generic_dbutils.__init__"></a><div id="Generic_dbutils.__init__-def"><a name="L15"></a><tt class="py-lineno"> 15</tt> <a class="py-toggle" href="#" id="Generic_dbutils.__init__-toggle" onclick="return toggle('Generic_dbutils.__init__');">-</a><tt class="py-line"> <tt class="py-keyword">def</tt> <a class="py-def-name" href="BioSQL.DBUtils.Generic_dbutils-class.html#__init__">__init__</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt> </div><div id="Generic_dbutils.__init__-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="Generic_dbutils.__init__-expanded"><a name="L16"></a><tt class="py-lineno"> 16</tt> <tt class="py-line"> <tt class="py-keyword">pass</tt> </tt> </div><a name="L17"></a><tt class="py-lineno"> 17</tt> <tt class="py-line"> </tt> <a name="Generic_dbutils.tname"></a><div id="Generic_dbutils.tname-def"><a name="L18"></a><tt class="py-lineno"> 18</tt> <a class="py-toggle" href="#" id="Generic_dbutils.tname-toggle" onclick="return toggle('Generic_dbutils.tname');">-</a><tt class="py-line"> <tt class="py-keyword">def</tt> <a class="py-def-name" href="BioSQL.DBUtils.Generic_dbutils-class.html#tname">tname</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">table</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt> </div><div id="Generic_dbutils.tname-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="Generic_dbutils.tname-expanded"><a name="L19"></a><tt class="py-lineno"> 19</tt> <tt class="py-line"> <tt class="py-keyword">if</tt> <tt class="py-name">table</tt> <tt class="py-op">!=</tt> <tt class="py-string">'biosequence'</tt><tt class="py-op">:</tt> <tt class="py-keyword">return</tt> <tt class="py-name">table</tt> </tt> <a name="L20"></a><tt class="py-lineno"> 20</tt> <tt class="py-line"> <tt class="py-keyword">else</tt><tt class="py-op">:</tt> <tt class="py-keyword">return</tt> <tt class="py-string">'bioentry'</tt> </tt> </div><a name="L21"></a><tt class="py-lineno"> 21</tt> <tt class="py-line"> </tt> <a name="Generic_dbutils.last_id"></a><div id="Generic_dbutils.last_id-def"><a name="L22"></a><tt class="py-lineno"> 22</tt> <a class="py-toggle" href="#" id="Generic_dbutils.last_id-toggle" onclick="return toggle('Generic_dbutils.last_id');">-</a><tt class="py-line"> <tt class="py-keyword">def</tt> <a class="py-def-name" href="BioSQL.DBUtils.Generic_dbutils-class.html#last_id">last_id</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">cursor</tt><tt class="py-op">,</tt> <tt class="py-param">table</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt> </div><div id="Generic_dbutils.last_id-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="Generic_dbutils.last_id-expanded"><a name="L23"></a><tt class="py-lineno"> 23</tt> <tt class="py-line"> <tt class="py-comment"># XXX: Unsafe without transactions isolation</tt> </tt> <a name="L24"></a><tt class="py-lineno"> 24</tt> <tt class="py-line"> <tt class="py-name">table</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-1" class="py-name" targets="Method BioSQL.DBUtils.Generic_dbutils.tname()=BioSQL.DBUtils.Generic_dbutils-class.html#tname"><a title="BioSQL.DBUtils.Generic_dbutils.tname" class="py-name" href="#" onclick="return doclink('link-1', 'tname', 'link-1');">tname</a></tt><tt class="py-op">(</tt><tt class="py-name">table</tt><tt class="py-op">)</tt> </tt> <a name="L25"></a><tt class="py-lineno"> 25</tt> <tt class="py-line"> <tt class="py-name">sql</tt> <tt class="py-op">=</tt> <tt class="py-string">r"select max(%s_id) from %s"</tt> <tt class="py-op">%</tt> <tt class="py-op">(</tt><tt class="py-name">table</tt><tt class="py-op">,</tt> <tt class="py-name">table</tt><tt class="py-op">)</tt> </tt> <a name="L26"></a><tt class="py-lineno"> 26</tt> <tt class="py-line"> <tt id="link-2" class="py-name" targets="Method Bio.DocSQL.Query.cursor()=Bio.DocSQL.Query-class.html#cursor,Method Bio.DocSQL.QuerySingle.cursor()=Bio.DocSQL.QuerySingle-class.html#cursor"><a title="Bio.DocSQL.Query.cursor Bio.DocSQL.QuerySingle.cursor" class="py-name" href="#" onclick="return doclink('link-2', 'cursor', 'link-2');">cursor</a></tt><tt class="py-op">.</tt><tt id="link-3" class="py-name" targets="Method BioSQL.BioSeqDatabase.Adaptor.execute()=BioSQL.BioSeqDatabase.Adaptor-class.html#execute,Method BioSQL.DBUtils.Generic_dbutils.execute()=BioSQL.DBUtils.Generic_dbutils-class.html#execute,Method BioSQL.DBUtils.Sqlite_dbutils.execute()=BioSQL.DBUtils.Sqlite_dbutils-class.html#execute"><a title="BioSQL.BioSeqDatabase.Adaptor.execute BioSQL.DBUtils.Generic_dbutils.execute BioSQL.DBUtils.Sqlite_dbutils.execute" class="py-name" href="#" onclick="return doclink('link-3', 'execute', 'link-3');">execute</a></tt><tt class="py-op">(</tt><tt class="py-name">sql</tt><tt class="py-op">)</tt> </tt> <a name="L27"></a><tt class="py-lineno"> 27</tt> <tt class="py-line"> <tt class="py-name">rv</tt> <tt class="py-op">=</tt> <tt id="link-4" class="py-name"><a title="Bio.DocSQL.Query.cursor Bio.DocSQL.QuerySingle.cursor" class="py-name" href="#" onclick="return doclink('link-4', 'cursor', 'link-2');">cursor</a></tt><tt class="py-op">.</tt><tt class="py-name">fetchone</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt> <a name="L28"></a><tt class="py-lineno"> 28</tt> <tt class="py-line"> <tt class="py-keyword">return</tt> <tt class="py-name">rv</tt><tt class="py-op">[</tt><tt class="py-number">0</tt><tt class="py-op">]</tt> </tt> </div><a name="L29"></a><tt class="py-lineno"> 29</tt> <tt class="py-line"> </tt> <a name="Generic_dbutils.execute"></a><div id="Generic_dbutils.execute-def"><a name="L30"></a><tt class="py-lineno"> 30</tt> <a class="py-toggle" href="#" id="Generic_dbutils.execute-toggle" onclick="return toggle('Generic_dbutils.execute');">-</a><tt class="py-line"> <tt class="py-keyword">def</tt> <a class="py-def-name" href="BioSQL.DBUtils.Generic_dbutils-class.html#execute">execute</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">cursor</tt><tt class="py-op">,</tt> <tt class="py-param">sql</tt><tt class="py-op">,</tt> <tt class="py-param">args</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt> </div><div id="Generic_dbutils.execute-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="Generic_dbutils.execute-expanded"><a name="L31"></a><tt class="py-lineno"> 31</tt> <tt class="py-line"> <tt class="py-docstring">"""Just execute an sql command.</tt> </tt> <a name="L32"></a><tt class="py-lineno"> 32</tt> <tt class="py-line"><tt class="py-docstring"> """</tt> </tt> <a name="L33"></a><tt class="py-lineno"> 33</tt> <tt class="py-line"> <tt id="link-5" class="py-name"><a title="Bio.DocSQL.Query.cursor Bio.DocSQL.QuerySingle.cursor" class="py-name" href="#" onclick="return doclink('link-5', 'cursor', 'link-2');">cursor</a></tt><tt class="py-op">.</tt><tt id="link-6" class="py-name"><a title="BioSQL.BioSeqDatabase.Adaptor.execute BioSQL.DBUtils.Generic_dbutils.execute BioSQL.DBUtils.Sqlite_dbutils.execute" class="py-name" href="#" onclick="return doclink('link-6', 'execute', 'link-3');">execute</a></tt><tt class="py-op">(</tt><tt class="py-name">sql</tt><tt class="py-op">,</tt> <tt class="py-name">args</tt> <tt class="py-keyword">or</tt> <tt class="py-op">(</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt> </div><a name="L34"></a><tt class="py-lineno"> 34</tt> <tt class="py-line"> </tt> <a name="Generic_dbutils.autocommit"></a><div id="Generic_dbutils.autocommit-def"><a name="L35"></a><tt class="py-lineno"> 35</tt> <a class="py-toggle" href="#" id="Generic_dbutils.autocommit-toggle" onclick="return toggle('Generic_dbutils.autocommit');">-</a><tt class="py-line"> <tt class="py-keyword">def</tt> <a class="py-def-name" href="BioSQL.DBUtils.Generic_dbutils-class.html#autocommit">autocommit</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">conn</tt><tt class="py-op">,</tt> <tt class="py-param">y</tt> <tt class="py-op">=</tt> <tt class="py-number">1</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt> </div><div id="Generic_dbutils.autocommit-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="Generic_dbutils.autocommit-expanded"><a name="L36"></a><tt class="py-lineno"> 36</tt> <tt class="py-line"> <tt class="py-comment"># Let's hope it was not really needed</tt> </tt> <a name="L37"></a><tt class="py-lineno"> 37</tt> <tt class="py-line"> <tt class="py-keyword">pass</tt> </tt> </div></div><a name="L38"></a><tt class="py-lineno"> 38</tt> <tt class="py-line"> </tt> <a name="L39"></a><tt class="py-lineno"> 39</tt> <tt class="py-line"> </tt> <a name="Sqlite_dbutils"></a><div id="Sqlite_dbutils-def"><a name="L40"></a><tt class="py-lineno"> 40</tt> <a class="py-toggle" href="#" id="Sqlite_dbutils-toggle" onclick="return toggle('Sqlite_dbutils');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="BioSQL.DBUtils.Sqlite_dbutils-class.html">Sqlite_dbutils</a><tt class="py-op">(</tt><tt class="py-base-class">Generic_dbutils</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt> </div><div id="Sqlite_dbutils-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="Sqlite_dbutils-expanded"><a name="L41"></a><tt class="py-lineno"> 41</tt> <tt class="py-line"> <tt class="py-docstring">"""Custom database utilities for SQLite."""</tt> </tt> <a name="Sqlite_dbutils.execute"></a><div id="Sqlite_dbutils.execute-def"><a name="L42"></a><tt class="py-lineno"> 42</tt> <a class="py-toggle" href="#" id="Sqlite_dbutils.execute-toggle" onclick="return toggle('Sqlite_dbutils.execute');">-</a><tt class="py-line"> <tt class="py-keyword">def</tt> <a class="py-def-name" href="BioSQL.DBUtils.Sqlite_dbutils-class.html#execute">execute</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">cursor</tt><tt class="py-op">,</tt> <tt class="py-param">sql</tt><tt class="py-op">,</tt> <tt class="py-param">args</tt><tt class="py-op">=</tt><tt class="py-name">None</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt> </div><div id="Sqlite_dbutils.execute-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="Sqlite_dbutils.execute-expanded"><a name="L43"></a><tt class="py-lineno"> 43</tt> <tt class="py-line"> <tt class="py-docstring">"""Execute SQL command, replacing %s with ? for variable substitution in sqlite3.</tt> </tt> <a name="L44"></a><tt class="py-lineno"> 44</tt> <tt class="py-line"><tt class="py-docstring"> """</tt> </tt> <a name="L45"></a><tt class="py-lineno"> 45</tt> <tt class="py-line"> <tt id="link-7" class="py-name"><a title="Bio.DocSQL.Query.cursor Bio.DocSQL.QuerySingle.cursor" class="py-name" href="#" onclick="return doclink('link-7', 'cursor', 'link-2');">cursor</a></tt><tt class="py-op">.</tt><tt id="link-8" class="py-name"><a title="BioSQL.BioSeqDatabase.Adaptor.execute BioSQL.DBUtils.Generic_dbutils.execute BioSQL.DBUtils.Sqlite_dbutils.execute" class="py-name" href="#" onclick="return doclink('link-8', 'execute', 'link-3');">execute</a></tt><tt class="py-op">(</tt><tt class="py-name">sql</tt><tt class="py-op">.</tt><tt class="py-name">replace</tt><tt class="py-op">(</tt><tt class="py-string">"%s"</tt><tt class="py-op">,</tt> <tt class="py-string">"?"</tt><tt class="py-op">)</tt><tt class="py-op">,</tt> <tt class="py-name">args</tt> <tt class="py-keyword">or</tt> <tt class="py-op">(</tt><tt class="py-op">)</tt><tt class="py-op">)</tt> </tt> </div></div><a name="L46"></a><tt class="py-lineno"> 46</tt> <tt class="py-line"> </tt> <a name="L47"></a><tt class="py-lineno"> 47</tt> <tt class="py-line"><tt id="link-9" class="py-name"><a title="BioSQL.DBUtils._dbutils" class="py-name" href="#" onclick="return doclink('link-9', '_dbutils', 'link-0');">_dbutils</a></tt><tt class="py-op">[</tt><tt class="py-string">"sqlite3"</tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt id="link-10" class="py-name" targets="Class BioSQL.DBUtils.Sqlite_dbutils=BioSQL.DBUtils.Sqlite_dbutils-class.html"><a title="BioSQL.DBUtils.Sqlite_dbutils" class="py-name" href="#" onclick="return doclink('link-10', 'Sqlite_dbutils', 'link-10');">Sqlite_dbutils</a></tt> </tt> <a name="L48"></a><tt class="py-lineno"> 48</tt> <tt class="py-line"> </tt> <a name="L49"></a><tt class="py-lineno"> 49</tt> <tt class="py-line"> </tt> <a name="Mysql_dbutils"></a><div id="Mysql_dbutils-def"><a name="L50"></a><tt class="py-lineno"> 50</tt> <a class="py-toggle" href="#" id="Mysql_dbutils-toggle" onclick="return toggle('Mysql_dbutils');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="BioSQL.DBUtils.Mysql_dbutils-class.html">Mysql_dbutils</a><tt class="py-op">(</tt><tt class="py-base-class">Generic_dbutils</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt> </div><div id="Mysql_dbutils-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="Mysql_dbutils-expanded"><a name="L51"></a><tt class="py-lineno"> 51</tt> <tt class="py-line"> <tt class="py-docstring">"""Custom database utilities for MySQL."""</tt> </tt> <a name="Mysql_dbutils.last_id"></a><div id="Mysql_dbutils.last_id-def"><a name="L52"></a><tt class="py-lineno"> 52</tt> <a class="py-toggle" href="#" id="Mysql_dbutils.last_id-toggle" onclick="return toggle('Mysql_dbutils.last_id');">-</a><tt class="py-line"> <tt class="py-keyword">def</tt> <a class="py-def-name" href="BioSQL.DBUtils.Mysql_dbutils-class.html#last_id">last_id</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">cursor</tt><tt class="py-op">,</tt> <tt class="py-param">table</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt> </div><div id="Mysql_dbutils.last_id-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="Mysql_dbutils.last_id-expanded"><a name="L53"></a><tt class="py-lineno"> 53</tt> <tt class="py-line"> <tt class="py-keyword">try</tt><tt class="py-op">:</tt> </tt> <a name="L54"></a><tt class="py-lineno"> 54</tt> <tt class="py-line"> <tt class="py-comment">#This worked on older versions of MySQL</tt> </tt> <a name="L55"></a><tt class="py-lineno"> 55</tt> <tt class="py-line"> <tt class="py-keyword">return</tt> <tt id="link-11" class="py-name"><a title="Bio.DocSQL.Query.cursor Bio.DocSQL.QuerySingle.cursor" class="py-name" href="#" onclick="return doclink('link-11', 'cursor', 'link-2');">cursor</a></tt><tt class="py-op">.</tt><tt class="py-name">insert_id</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt> <a name="L56"></a><tt class="py-lineno"> 56</tt> <tt class="py-line"> <tt class="py-keyword">except</tt> <tt class="py-name">AttributeError</tt><tt class="py-op">:</tt> </tt> <a name="L57"></a><tt class="py-lineno"> 57</tt> <tt class="py-line"> <tt class="py-comment">#See bug 2390</tt> </tt> <a name="L58"></a><tt class="py-lineno"> 58</tt> <tt class="py-line"> <tt class="py-comment">#Google suggests this is the new way,</tt> </tt> <a name="L59"></a><tt class="py-lineno"> 59</tt> <tt class="py-line"> <tt class="py-comment">#same fix also suggested by Eric Gibert:</tt> </tt> <a name="L60"></a><tt class="py-lineno"> 60</tt> <tt class="py-line"> <tt class="py-keyword">return</tt> <tt id="link-12" class="py-name"><a title="Bio.DocSQL.Query.cursor Bio.DocSQL.QuerySingle.cursor" class="py-name" href="#" onclick="return doclink('link-12', 'cursor', 'link-2');">cursor</a></tt><tt class="py-op">.</tt><tt class="py-name">lastrowid</tt> </tt> </div></div><a name="L61"></a><tt class="py-lineno"> 61</tt> <tt class="py-line"> </tt> <a name="L62"></a><tt class="py-lineno"> 62</tt> <tt class="py-line"><tt id="link-13" class="py-name"><a title="BioSQL.DBUtils._dbutils" class="py-name" href="#" onclick="return doclink('link-13', '_dbutils', 'link-0');">_dbutils</a></tt><tt class="py-op">[</tt><tt class="py-string">"MySQLdb"</tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt id="link-14" class="py-name" targets="Class BioSQL.DBUtils.Mysql_dbutils=BioSQL.DBUtils.Mysql_dbutils-class.html"><a title="BioSQL.DBUtils.Mysql_dbutils" class="py-name" href="#" onclick="return doclink('link-14', 'Mysql_dbutils', 'link-14');">Mysql_dbutils</a></tt> </tt> <a name="L63"></a><tt class="py-lineno"> 63</tt> <tt class="py-line"> </tt> <a name="L64"></a><tt class="py-lineno"> 64</tt> <tt class="py-line"> </tt> <a name="_PostgreSQL_dbutils"></a><div id="_PostgreSQL_dbutils-def"><a name="L65"></a><tt class="py-lineno"> 65</tt> <a class="py-toggle" href="#" id="_PostgreSQL_dbutils-toggle" onclick="return toggle('_PostgreSQL_dbutils');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="BioSQL.DBUtils._PostgreSQL_dbutils-class.html">_PostgreSQL_dbutils</a><tt class="py-op">(</tt><tt class="py-base-class">Generic_dbutils</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt> </div><div id="_PostgreSQL_dbutils-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="_PostgreSQL_dbutils-expanded"><a name="L66"></a><tt class="py-lineno"> 66</tt> <tt class="py-line"> <tt class="py-docstring">"""Base class for any PostgreSQL adaptor."""</tt> </tt> <a name="_PostgreSQL_dbutils.next_id"></a><div id="_PostgreSQL_dbutils.next_id-def"><a name="L67"></a><tt class="py-lineno"> 67</tt> <a class="py-toggle" href="#" id="_PostgreSQL_dbutils.next_id-toggle" onclick="return toggle('_PostgreSQL_dbutils.next_id');">-</a><tt class="py-line"> <tt class="py-keyword">def</tt> <a class="py-def-name" href="BioSQL.DBUtils._PostgreSQL_dbutils-class.html#next_id">next_id</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">cursor</tt><tt class="py-op">,</tt> <tt class="py-param">table</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt> </div><div id="_PostgreSQL_dbutils.next_id-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="_PostgreSQL_dbutils.next_id-expanded"><a name="L68"></a><tt class="py-lineno"> 68</tt> <tt class="py-line"> <tt class="py-name">table</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-15" class="py-name"><a title="BioSQL.DBUtils.Generic_dbutils.tname" class="py-name" href="#" onclick="return doclink('link-15', 'tname', 'link-1');">tname</a></tt><tt class="py-op">(</tt><tt class="py-name">table</tt><tt class="py-op">)</tt> </tt> <a name="L69"></a><tt class="py-lineno"> 69</tt> <tt class="py-line"> <tt class="py-name">sql</tt> <tt class="py-op">=</tt> <tt class="py-string">r"select nextval('%s_pk_seq')"</tt> <tt class="py-op">%</tt> <tt class="py-name">table</tt> </tt> <a name="L70"></a><tt class="py-lineno"> 70</tt> <tt class="py-line"> <tt id="link-16" class="py-name"><a title="Bio.DocSQL.Query.cursor Bio.DocSQL.QuerySingle.cursor" class="py-name" href="#" onclick="return doclink('link-16', 'cursor', 'link-2');">cursor</a></tt><tt class="py-op">.</tt><tt id="link-17" class="py-name"><a title="BioSQL.BioSeqDatabase.Adaptor.execute BioSQL.DBUtils.Generic_dbutils.execute BioSQL.DBUtils.Sqlite_dbutils.execute" class="py-name" href="#" onclick="return doclink('link-17', 'execute', 'link-3');">execute</a></tt><tt class="py-op">(</tt><tt class="py-name">sql</tt><tt class="py-op">)</tt> </tt> <a name="L71"></a><tt class="py-lineno"> 71</tt> <tt class="py-line"> <tt class="py-name">rv</tt> <tt class="py-op">=</tt> <tt id="link-18" class="py-name"><a title="Bio.DocSQL.Query.cursor Bio.DocSQL.QuerySingle.cursor" class="py-name" href="#" onclick="return doclink('link-18', 'cursor', 'link-2');">cursor</a></tt><tt class="py-op">.</tt><tt class="py-name">fetchone</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt> <a name="L72"></a><tt class="py-lineno"> 72</tt> <tt class="py-line"> <tt class="py-keyword">return</tt> <tt class="py-name">rv</tt><tt class="py-op">[</tt><tt class="py-number">0</tt><tt class="py-op">]</tt> </tt> </div><a name="L73"></a><tt class="py-lineno"> 73</tt> <tt class="py-line"> </tt> <a name="_PostgreSQL_dbutils.last_id"></a><div id="_PostgreSQL_dbutils.last_id-def"><a name="L74"></a><tt class="py-lineno"> 74</tt> <a class="py-toggle" href="#" id="_PostgreSQL_dbutils.last_id-toggle" onclick="return toggle('_PostgreSQL_dbutils.last_id');">-</a><tt class="py-line"> <tt class="py-keyword">def</tt> <a class="py-def-name" href="BioSQL.DBUtils._PostgreSQL_dbutils-class.html#last_id">last_id</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">cursor</tt><tt class="py-op">,</tt> <tt class="py-param">table</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt> </div><div id="_PostgreSQL_dbutils.last_id-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="_PostgreSQL_dbutils.last_id-expanded"><a name="L75"></a><tt class="py-lineno"> 75</tt> <tt class="py-line"> <tt class="py-name">table</tt> <tt class="py-op">=</tt> <tt class="py-name">self</tt><tt class="py-op">.</tt><tt id="link-19" class="py-name"><a title="BioSQL.DBUtils.Generic_dbutils.tname" class="py-name" href="#" onclick="return doclink('link-19', 'tname', 'link-1');">tname</a></tt><tt class="py-op">(</tt><tt class="py-name">table</tt><tt class="py-op">)</tt> </tt> <a name="L76"></a><tt class="py-lineno"> 76</tt> <tt class="py-line"> <tt class="py-name">sql</tt> <tt class="py-op">=</tt> <tt class="py-string">r"select currval('%s_pk_seq')"</tt> <tt class="py-op">%</tt> <tt class="py-name">table</tt> </tt> <a name="L77"></a><tt class="py-lineno"> 77</tt> <tt class="py-line"> <tt id="link-20" class="py-name"><a title="Bio.DocSQL.Query.cursor Bio.DocSQL.QuerySingle.cursor" class="py-name" href="#" onclick="return doclink('link-20', 'cursor', 'link-2');">cursor</a></tt><tt class="py-op">.</tt><tt id="link-21" class="py-name"><a title="BioSQL.BioSeqDatabase.Adaptor.execute BioSQL.DBUtils.Generic_dbutils.execute BioSQL.DBUtils.Sqlite_dbutils.execute" class="py-name" href="#" onclick="return doclink('link-21', 'execute', 'link-3');">execute</a></tt><tt class="py-op">(</tt><tt class="py-name">sql</tt><tt class="py-op">)</tt> </tt> <a name="L78"></a><tt class="py-lineno"> 78</tt> <tt class="py-line"> <tt class="py-name">rv</tt> <tt class="py-op">=</tt> <tt id="link-22" class="py-name"><a title="Bio.DocSQL.Query.cursor Bio.DocSQL.QuerySingle.cursor" class="py-name" href="#" onclick="return doclink('link-22', 'cursor', 'link-2');">cursor</a></tt><tt class="py-op">.</tt><tt class="py-name">fetchone</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt> <a name="L79"></a><tt class="py-lineno"> 79</tt> <tt class="py-line"> <tt class="py-keyword">return</tt> <tt class="py-name">rv</tt><tt class="py-op">[</tt><tt class="py-number">0</tt><tt class="py-op">]</tt> </tt> </div></div><a name="L80"></a><tt class="py-lineno"> 80</tt> <tt class="py-line"> </tt> <a name="Psycopg2_dbutils"></a><div id="Psycopg2_dbutils-def"><a name="L81"></a><tt class="py-lineno"> 81</tt> <a class="py-toggle" href="#" id="Psycopg2_dbutils-toggle" onclick="return toggle('Psycopg2_dbutils');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="BioSQL.DBUtils.Psycopg2_dbutils-class.html">Psycopg2_dbutils</a><tt class="py-op">(</tt><tt class="py-base-class">_PostgreSQL_dbutils</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt> </div><div id="Psycopg2_dbutils-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="Psycopg2_dbutils-expanded"><a name="L82"></a><tt class="py-lineno"> 82</tt> <tt class="py-line"> <tt class="py-docstring">"""Custom database utilities for Psycopg2 (PostgreSQL)."""</tt> </tt> <a name="Psycopg2_dbutils.autocommit"></a><div id="Psycopg2_dbutils.autocommit-def"><a name="L83"></a><tt class="py-lineno"> 83</tt> <a class="py-toggle" href="#" id="Psycopg2_dbutils.autocommit-toggle" onclick="return toggle('Psycopg2_dbutils.autocommit');">-</a><tt class="py-line"> <tt class="py-keyword">def</tt> <a class="py-def-name" href="BioSQL.DBUtils.Psycopg2_dbutils-class.html#autocommit">autocommit</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">conn</tt><tt class="py-op">,</tt> <tt class="py-param">y</tt> <tt class="py-op">=</tt> <tt class="py-name">True</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt> </div><div id="Psycopg2_dbutils.autocommit-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="Psycopg2_dbutils.autocommit-expanded"><a name="L84"></a><tt class="py-lineno"> 84</tt> <tt class="py-line"> <tt class="py-keyword">if</tt> <tt class="py-name">y</tt><tt class="py-op">:</tt> </tt> <a name="L85"></a><tt class="py-lineno"> 85</tt> <tt class="py-line"> <tt class="py-name">conn</tt><tt class="py-op">.</tt><tt class="py-name">set_isolation_level</tt><tt class="py-op">(</tt><tt class="py-number">0</tt><tt class="py-op">)</tt> </tt> <a name="L86"></a><tt class="py-lineno"> 86</tt> <tt class="py-line"> <tt class="py-keyword">else</tt><tt class="py-op">:</tt> </tt> <a name="L87"></a><tt class="py-lineno"> 87</tt> <tt class="py-line"> <tt class="py-name">conn</tt><tt class="py-op">.</tt><tt class="py-name">set_isolation_level</tt><tt class="py-op">(</tt><tt class="py-number">1</tt><tt class="py-op">)</tt> </tt> </div></div><a name="L88"></a><tt class="py-lineno"> 88</tt> <tt class="py-line"> </tt> <a name="L89"></a><tt class="py-lineno"> 89</tt> <tt class="py-line"><tt id="link-23" class="py-name"><a title="BioSQL.DBUtils._dbutils" class="py-name" href="#" onclick="return doclink('link-23', '_dbutils', 'link-0');">_dbutils</a></tt><tt class="py-op">[</tt><tt class="py-string">"psycopg2"</tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt id="link-24" class="py-name" targets="Class BioSQL.DBUtils.Psycopg2_dbutils=BioSQL.DBUtils.Psycopg2_dbutils-class.html"><a title="BioSQL.DBUtils.Psycopg2_dbutils" class="py-name" href="#" onclick="return doclink('link-24', 'Psycopg2_dbutils', 'link-24');">Psycopg2_dbutils</a></tt> </tt> <a name="L90"></a><tt class="py-lineno"> 90</tt> <tt class="py-line"> </tt> <a name="L91"></a><tt class="py-lineno"> 91</tt> <tt class="py-line"> </tt> <a name="Pgdb_dbutils"></a><div id="Pgdb_dbutils-def"><a name="L92"></a><tt class="py-lineno"> 92</tt> <a class="py-toggle" href="#" id="Pgdb_dbutils-toggle" onclick="return toggle('Pgdb_dbutils');">-</a><tt class="py-line"><tt class="py-keyword">class</tt> <a class="py-def-name" href="BioSQL.DBUtils.Pgdb_dbutils-class.html">Pgdb_dbutils</a><tt class="py-op">(</tt><tt class="py-base-class">_PostgreSQL_dbutils</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt> </div><div id="Pgdb_dbutils-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="Pgdb_dbutils-expanded"><a name="L93"></a><tt class="py-lineno"> 93</tt> <tt class="py-line"> <tt class="py-docstring">"""Custom database utilities for Pgdb (aka PyGreSQL, for PostgreSQL)."""</tt> </tt> <a name="Pgdb_dbutils.autocommit"></a><div id="Pgdb_dbutils.autocommit-def"><a name="L94"></a><tt class="py-lineno"> 94</tt> <a class="py-toggle" href="#" id="Pgdb_dbutils.autocommit-toggle" onclick="return toggle('Pgdb_dbutils.autocommit');">-</a><tt class="py-line"> <tt class="py-keyword">def</tt> <a class="py-def-name" href="BioSQL.DBUtils.Pgdb_dbutils-class.html#autocommit">autocommit</a><tt class="py-op">(</tt><tt class="py-param">self</tt><tt class="py-op">,</tt> <tt class="py-param">conn</tt><tt class="py-op">,</tt> <tt class="py-param">y</tt> <tt class="py-op">=</tt> <tt class="py-name">True</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt> </div><div id="Pgdb_dbutils.autocommit-collapsed" style="display:none;" pad="+++" indent="++++++++"></div><div id="Pgdb_dbutils.autocommit-expanded"><a name="L95"></a><tt class="py-lineno"> 95</tt> <tt class="py-line"> <tt class="py-keyword">raise</tt> <tt class="py-name">NotImplementedError</tt><tt class="py-op">(</tt><tt class="py-string">"pgdb does not support this!"</tt><tt class="py-op">)</tt> </tt> </div></div><a name="L96"></a><tt class="py-lineno"> 96</tt> <tt class="py-line"> </tt> <a name="L97"></a><tt class="py-lineno"> 97</tt> <tt class="py-line"><tt id="link-25" class="py-name"><a title="BioSQL.DBUtils._dbutils" class="py-name" href="#" onclick="return doclink('link-25', '_dbutils', 'link-0');">_dbutils</a></tt><tt class="py-op">[</tt><tt class="py-string">"pgdb"</tt><tt class="py-op">]</tt> <tt class="py-op">=</tt> <tt id="link-26" class="py-name" targets="Class BioSQL.DBUtils.Pgdb_dbutils=BioSQL.DBUtils.Pgdb_dbutils-class.html"><a title="BioSQL.DBUtils.Pgdb_dbutils" class="py-name" href="#" onclick="return doclink('link-26', 'Pgdb_dbutils', 'link-26');">Pgdb_dbutils</a></tt> </tt> <a name="L98"></a><tt class="py-lineno"> 98</tt> <tt class="py-line"> </tt> <a name="L99"></a><tt class="py-lineno"> 99</tt> <tt class="py-line"> </tt> <a name="get_dbutils"></a><div id="get_dbutils-def"><a name="L100"></a><tt class="py-lineno">100</tt> <a class="py-toggle" href="#" id="get_dbutils-toggle" onclick="return toggle('get_dbutils');">-</a><tt class="py-line"><tt class="py-keyword">def</tt> <a class="py-def-name" href="BioSQL.DBUtils-module.html#get_dbutils">get_dbutils</a><tt class="py-op">(</tt><tt class="py-param">module_name</tt><tt class="py-op">)</tt><tt class="py-op">:</tt> </tt> </div><div id="get_dbutils-collapsed" style="display:none;" pad="+++" indent="++++"></div><div id="get_dbutils-expanded"><a name="L101"></a><tt class="py-lineno">101</tt> <tt class="py-line"> <tt class="py-keyword">try</tt><tt class="py-op">:</tt> </tt> <a name="L102"></a><tt class="py-lineno">102</tt> <tt class="py-line"> <tt class="py-keyword">return</tt> <tt id="link-27" class="py-name"><a title="BioSQL.DBUtils._dbutils" class="py-name" href="#" onclick="return doclink('link-27', '_dbutils', 'link-0');">_dbutils</a></tt><tt class="py-op">[</tt><tt class="py-name">module_name</tt><tt class="py-op">]</tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt> <a name="L103"></a><tt class="py-lineno">103</tt> <tt class="py-line"> <tt class="py-keyword">except</tt> <tt class="py-name">KeyError</tt><tt class="py-op">:</tt> </tt> <a name="L104"></a><tt class="py-lineno">104</tt> <tt class="py-line"> <tt class="py-keyword">return</tt> <tt id="link-28" class="py-name" targets="Class BioSQL.DBUtils.Generic_dbutils=BioSQL.DBUtils.Generic_dbutils-class.html"><a title="BioSQL.DBUtils.Generic_dbutils" class="py-name" href="#" onclick="return doclink('link-28', 'Generic_dbutils', 'link-28');">Generic_dbutils</a></tt><tt class="py-op">(</tt><tt class="py-op">)</tt> </tt> </div><a name="L105"></a><tt class="py-lineno">105</tt> <tt class="py-line"> </tt><script type="text/javascript"> <!-- expandto(location.href); // --> </script> </pre> <br /> <!-- ==================== NAVIGATION BAR ==================== --> <table class="navbar" border="0" width="100%" cellpadding="0" bgcolor="#a0c0ff" cellspacing="0"> <tr valign="middle"> <!-- Tree link --> <th> <a href="module-tree.html">Trees</a> </th> <!-- Index link --> <th> <a href="identifier-index.html">Indices</a> </th> <!-- Help link --> <th> <a href="help.html">Help</a> </th> <th class="navbar" width="100%"></th> </tr> </table> <table border="0" cellpadding="0" cellspacing="0" width="100%%"> <tr> <td align="left" class="footer"> Generated by Epydoc 3.0.1 on Thu Aug 18 18:22:23 2011 </td> <td align="right" class="footer"> <a target="mainFrame" href="http://epydoc.sourceforge.net" >http://epydoc.sourceforge.net</a> </td> </tr> </table> <script type="text/javascript"> <!-- // Private objects are initially displayed (because if // javascript is turned off then we want them to be // visible); but by default, we want to hide them. So hide // them unless we have a cookie that says to show them. checkCookie(); // --> </script> </body> </html>