<!doctype html> <html xmlns="http://www.w3.org/1999/xhtml" lang="en"> <head> <meta http-equiv="X-UA-Compatible" content="IE=Edge" /> <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> <title>sqlobject.dbconnection module — SQLObject 3.7.0 documentation</title> <link rel="stylesheet" href="../_static/bizstyle.css" type="text/css" /> <link rel="stylesheet" href="../_static/pygments.css" type="text/css" /> <script type="text/javascript" src="../_static/documentation_options.js"></script> <script type="text/javascript" src="../_static/jquery.js"></script> <script type="text/javascript" src="../_static/underscore.js"></script> <script type="text/javascript" src="../_static/doctools.js"></script> <script type="text/javascript" src="../_static/bizstyle.js"></script> <link rel="index" title="Index" href="../genindex.html" /> <link rel="search" title="Search" href="../search.html" /> <meta name="viewport" content="width=device-width,initial-scale=1.0"> <!--[if lt IE 9]> <script type="text/javascript" src="_static/css3-mediaqueries.js"></script> <![endif]--> </head><body> <div class="related" role="navigation" aria-label="related navigation"> <h3>Navigation</h3> <ul> <li class="right" style="margin-right: 10px"> <a href="../genindex.html" title="General Index" accesskey="I">index</a></li> <li class="right" > <a href="../py-modindex.html" title="Python Module Index" >modules</a> |</li> <li class="nav-item nav-item-0"><a href="../index.html">SQLObject 3.7.0 documentation</a> »</li> </ul> </div> <div class="sphinxsidebar" role="navigation" aria-label="main navigation"> <div class="sphinxsidebarwrapper"> <div role="note" aria-label="source link"> <h3>This Page</h3> <ul class="this-page-menu"> <li><a href="../_sources/api/sqlobject.dbconnection.rst.txt" rel="nofollow">Show Source</a></li> </ul> </div> <div id="searchbox" style="display: none" role="search"> <h3>Quick search</h3> <div class="searchformwrapper"> <form class="search" action="../search.html" method="get"> <input type="text" name="q" /> <input type="submit" value="Go" /> <input type="hidden" name="check_keywords" value="yes" /> <input type="hidden" name="area" value="default" /> </form> </div> </div> <script type="text/javascript">$('#searchbox').show(0);</script> </div> </div> <div class="document"> <div class="documentwrapper"> <div class="bodywrapper"> <div class="body" role="main"> <div class="section" id="module-sqlobject.dbconnection"> <span id="sqlobject-dbconnection-module"></span><h1>sqlobject.dbconnection module<a class="headerlink" href="#module-sqlobject.dbconnection" title="Permalink to this headline">¶</a></h1> <dl class="class"> <dt id="sqlobject.dbconnection.Boolean"> <em class="property">class </em><code class="descclassname">sqlobject.dbconnection.</code><code class="descname">Boolean</code><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#Boolean"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.Boolean" title="Permalink to this definition">¶</a></dt> <dd><p>Bases: <code class="xref py py-class docutils literal notranslate"><span class="pre">object</span></code></p> <p>A bool class that also understands some special string keywords</p> <p>Understands: yes/no, true/false, on/off, 1/0, case ignored.</p> </dd></dl> <dl class="class"> <dt id="sqlobject.dbconnection.ConnMethodWrapper"> <em class="property">class </em><code class="descclassname">sqlobject.dbconnection.</code><code class="descname">ConnMethodWrapper</code><span class="sig-paren">(</span><em>method</em>, <em>connection</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#ConnMethodWrapper"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.ConnMethodWrapper" title="Permalink to this definition">¶</a></dt> <dd><p>Bases: <code class="xref py py-class docutils literal notranslate"><span class="pre">object</span></code></p> </dd></dl> <dl class="class"> <dt id="sqlobject.dbconnection.ConnWrapper"> <em class="property">class </em><code class="descclassname">sqlobject.dbconnection.</code><code class="descname">ConnWrapper</code><span class="sig-paren">(</span><em>soClass</em>, <em>connection</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#ConnWrapper"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.ConnWrapper" title="Permalink to this definition">¶</a></dt> <dd><p>Bases: <code class="xref py py-class docutils literal notranslate"><span class="pre">object</span></code></p> <p>This represents a SQLObject class that is bound to a specific connection (instances have a connection instance variable, but classes are global, so this is binds the connection variable lazily when a class method is accessed)</p> </dd></dl> <dl class="class"> <dt id="sqlobject.dbconnection.ConnectionHub"> <em class="property">class </em><code class="descclassname">sqlobject.dbconnection.</code><code class="descname">ConnectionHub</code><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#ConnectionHub"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.ConnectionHub" title="Permalink to this definition">¶</a></dt> <dd><p>Bases: <code class="xref py py-class docutils literal notranslate"><span class="pre">object</span></code></p> <p>This object serves as a hub for connections, so that you can pass in a ConnectionHub to a SQLObject subclass as though it was a connection, but actually bind a real database connection later. You can also bind connections on a per-thread basis.</p> <p>You must hang onto the original ConnectionHub instance, as you cannot retrieve it again from the class or instance.</p> <p>To use the hub, do something like:</p> <div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">hub</span> <span class="o">=</span> <span class="n">ConnectionHub</span><span class="p">()</span> <span class="k">class</span> <span class="nc">MyClass</span><span class="p">(</span><span class="n">SQLObject</span><span class="p">):</span> <span class="n">_connection</span> <span class="o">=</span> <span class="n">hub</span> <span class="n">hub</span><span class="o">.</span><span class="n">threadConnection</span> <span class="o">=</span> <span class="n">connectionFromURI</span><span class="p">(</span><span class="s1">'...'</span><span class="p">)</span> </pre></div> </div> <dl class="method"> <dt id="sqlobject.dbconnection.ConnectionHub.doInTransaction"> <code class="descname">doInTransaction</code><span class="sig-paren">(</span><em>func</em>, <em>*args</em>, <em>**kw</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#ConnectionHub.doInTransaction"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.ConnectionHub.doInTransaction" title="Permalink to this definition">¶</a></dt> <dd><p>This routine can be used to run a function in a transaction, rolling the transaction back if any exception is raised from that function, and committing otherwise.</p> <p>Use like:</p> <div class="highlight-default notranslate"><div class="highlight"><pre><span></span><span class="n">sqlhub</span><span class="o">.</span><span class="n">doInTransaction</span><span class="p">(</span><span class="n">process_request</span><span class="p">,</span> <span class="n">os</span><span class="o">.</span><span class="n">environ</span><span class="p">)</span> </pre></div> </div> <p>This will run <code class="docutils literal notranslate"><span class="pre">process_request(os.environ)</span></code>. The return value will be preserved.</p> </dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.ConnectionHub.getConnection"> <code class="descname">getConnection</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#ConnectionHub.getConnection"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.ConnectionHub.getConnection" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="attribute"> <dt id="sqlobject.dbconnection.ConnectionHub.threadConnection"> <code class="descname">threadConnection</code><a class="headerlink" href="#sqlobject.dbconnection.ConnectionHub.threadConnection" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> </dd></dl> <dl class="class"> <dt id="sqlobject.dbconnection.ConnectionURIOpener"> <em class="property">class </em><code class="descclassname">sqlobject.dbconnection.</code><code class="descname">ConnectionURIOpener</code><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#ConnectionURIOpener"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.ConnectionURIOpener" title="Permalink to this definition">¶</a></dt> <dd><p>Bases: <code class="xref py py-class docutils literal notranslate"><span class="pre">object</span></code></p> <dl class="method"> <dt id="sqlobject.dbconnection.ConnectionURIOpener.connectionForURI"> <code class="descname">connectionForURI</code><span class="sig-paren">(</span><em>uri</em>, <em>oldUri=False</em>, <em>**args</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#ConnectionURIOpener.connectionForURI"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.ConnectionURIOpener.connectionForURI" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.ConnectionURIOpener.dbConnectionForScheme"> <code class="descname">dbConnectionForScheme</code><span class="sig-paren">(</span><em>scheme</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#ConnectionURIOpener.dbConnectionForScheme"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.ConnectionURIOpener.dbConnectionForScheme" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.ConnectionURIOpener.registerConnection"> <code class="descname">registerConnection</code><span class="sig-paren">(</span><em>schemes</em>, <em>builder</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#ConnectionURIOpener.registerConnection"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.ConnectionURIOpener.registerConnection" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.ConnectionURIOpener.registerConnectionInstance"> <code class="descname">registerConnectionInstance</code><span class="sig-paren">(</span><em>inst</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#ConnectionURIOpener.registerConnectionInstance"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.ConnectionURIOpener.registerConnectionInstance" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> </dd></dl> <dl class="class"> <dt id="sqlobject.dbconnection.ConsoleWriter"> <em class="property">class </em><code class="descclassname">sqlobject.dbconnection.</code><code class="descname">ConsoleWriter</code><span class="sig-paren">(</span><em>connection</em>, <em>loglevel</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#ConsoleWriter"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.ConsoleWriter" title="Permalink to this definition">¶</a></dt> <dd><dl class="method"> <dt id="sqlobject.dbconnection.ConsoleWriter.write"> <code class="descname">write</code><span class="sig-paren">(</span><em>text</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#ConsoleWriter.write"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.ConsoleWriter.write" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> </dd></dl> <dl class="class"> <dt id="sqlobject.dbconnection.DBAPI"> <em class="property">class </em><code class="descclassname">sqlobject.dbconnection.</code><code class="descname">DBAPI</code><span class="sig-paren">(</span><em>**kw</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI" title="Permalink to this definition">¶</a></dt> <dd><p>Bases: <a class="reference internal" href="#sqlobject.dbconnection.DBConnection" title="sqlobject.dbconnection.DBConnection"><code class="xref py py-class docutils literal notranslate"><span class="pre">sqlobject.dbconnection.DBConnection</span></code></a></p> <p>Subclass must define a <cite>makeConnection()</cite> method, which returns a newly-created connection object.</p> <p><code class="docutils literal notranslate"><span class="pre">queryInsertID</span></code> must also be defined.</p> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.accumulateSelect"> <code class="descname">accumulateSelect</code><span class="sig-paren">(</span><em>select</em>, <em>*expressions</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.accumulateSelect"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.accumulateSelect" title="Permalink to this definition">¶</a></dt> <dd><p>Apply an accumulate function(s) (SUM, COUNT, MIN, AVG, MAX, etc…) to the select object.</p> </dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.clearTable"> <code class="descname">clearTable</code><span class="sig-paren">(</span><em>tableName</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.clearTable"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.clearTable" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.close"> <code class="descname">close</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.close"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.close" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.createBinary"> <code class="descname">createBinary</code><span class="sig-paren">(</span><em>value</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.createBinary"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.createBinary" title="Permalink to this definition">¶</a></dt> <dd><p>Create a binary object wrapper for the given database.</p> </dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.createColumn"> <code class="descname">createColumn</code><span class="sig-paren">(</span><em>soClass</em>, <em>col</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.createColumn"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.createColumn" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.createColumns"> <code class="descname">createColumns</code><span class="sig-paren">(</span><em>soClass</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.createColumns"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.createColumns" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.createEmptyDatabase"> <code class="descname">createEmptyDatabase</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.createEmptyDatabase"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.createEmptyDatabase" title="Permalink to this definition">¶</a></dt> <dd><p>Create an empty database.</p> </dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.createIndexSQL"> <code class="descname">createIndexSQL</code><span class="sig-paren">(</span><em>soClass</em>, <em>index</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.createIndexSQL"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.createIndexSQL" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.createReferenceConstraint"> <code class="descname">createReferenceConstraint</code><span class="sig-paren">(</span><em>soClass</em>, <em>col</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.createReferenceConstraint"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.createReferenceConstraint" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.createReferenceConstraints"> <code class="descname">createReferenceConstraints</code><span class="sig-paren">(</span><em>soClass</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.createReferenceConstraints"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.createReferenceConstraints" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.createSQL"> <code class="descname">createSQL</code><span class="sig-paren">(</span><em>soClass</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.createSQL"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.createSQL" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.createTable"> <code class="descname">createTable</code><span class="sig-paren">(</span><em>soClass</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.createTable"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.createTable" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.createTableSQL"> <code class="descname">createTableSQL</code><span class="sig-paren">(</span><em>soClass</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.createTableSQL"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.createTableSQL" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="attribute"> <dt id="sqlobject.dbconnection.DBAPI.dbName"> <code class="descname">dbName</code><em class="property"> = None</em><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.dbName" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.dropTable"> <code class="descname">dropTable</code><span class="sig-paren">(</span><em>tableName</em>, <em>cascade=False</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.dropTable"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.dropTable" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.getConnection"> <code class="descname">getConnection</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.getConnection"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.getConnection" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.iterSelect"> <code class="descname">iterSelect</code><span class="sig-paren">(</span><em>select</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.iterSelect"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.iterSelect" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.make_odbc_conn_str"> <code class="descname">make_odbc_conn_str</code><span class="sig-paren">(</span><em>odb_source</em>, <em>db</em>, <em>host=None</em>, <em>port=None</em>, <em>user=None</em>, <em>password=None</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.make_odbc_conn_str"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.make_odbc_conn_str" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.printDebug"> <code class="descname">printDebug</code><span class="sig-paren">(</span><em>conn</em>, <em>s</em>, <em>name</em>, <em>type='query'</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.printDebug"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.printDebug" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.query"> <code class="descname">query</code><span class="sig-paren">(</span><em>s</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.query"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.query" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.queryAll"> <code class="descname">queryAll</code><span class="sig-paren">(</span><em>s</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.queryAll"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.queryAll" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.queryAllDescription"> <code class="descname">queryAllDescription</code><span class="sig-paren">(</span><em>s</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.queryAllDescription"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.queryAllDescription" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.queryForSelect"> <code class="descname">queryForSelect</code><span class="sig-paren">(</span><em>select</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.queryForSelect"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.queryForSelect" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.queryInsertID"> <code class="descname">queryInsertID</code><span class="sig-paren">(</span><em>soInstance</em>, <em>id</em>, <em>names</em>, <em>values</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.queryInsertID"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.queryInsertID" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.queryOne"> <code class="descname">queryOne</code><span class="sig-paren">(</span><em>s</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.queryOne"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.queryOne" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.releaseConnection"> <code class="descname">releaseConnection</code><span class="sig-paren">(</span><em>conn</em>, <em>explicit=False</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.releaseConnection"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.releaseConnection" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.sqlrepr"> <code class="descname">sqlrepr</code><span class="sig-paren">(</span><em>v</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.sqlrepr"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.sqlrepr" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBAPI.transaction"> <code class="descname">transaction</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBAPI.transaction"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBAPI.transaction" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> </dd></dl> <dl class="class"> <dt id="sqlobject.dbconnection.DBConnection"> <em class="property">class </em><code class="descclassname">sqlobject.dbconnection.</code><code class="descname">DBConnection</code><span class="sig-paren">(</span><em>name=None</em>, <em>debug=False</em>, <em>debugOutput=False</em>, <em>cache=True</em>, <em>style=None</em>, <em>autoCommit=True</em>, <em>debugThreading=False</em>, <em>registry=None</em>, <em>logger=None</em>, <em>loglevel=None</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBConnection"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBConnection" title="Permalink to this definition">¶</a></dt> <dd><dl class="classmethod"> <dt id="sqlobject.dbconnection.DBConnection.connectionFromOldURI"> <em class="property">classmethod </em><code class="descname">connectionFromOldURI</code><span class="sig-paren">(</span><em>uri</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBConnection.connectionFromOldURI"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBConnection.connectionFromOldURI" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="classmethod"> <dt id="sqlobject.dbconnection.DBConnection.connectionFromURI"> <em class="property">classmethod </em><code class="descname">connectionFromURI</code><span class="sig-paren">(</span><em>uri</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBConnection.connectionFromURI"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBConnection.connectionFromURI" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBConnection.expireAll"> <code class="descname">expireAll</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBConnection.expireAll"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBConnection.expireAll" title="Permalink to this definition">¶</a></dt> <dd><p>Expire all instances of objects for this connection.</p> </dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBConnection.oldUri"> <code class="descname">oldUri</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBConnection.oldUri"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBConnection.oldUri" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBConnection.soClassAdded"> <code class="descname">soClassAdded</code><span class="sig-paren">(</span><em>soClass</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBConnection.soClassAdded"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBConnection.soClassAdded" title="Permalink to this definition">¶</a></dt> <dd><p>This is called for each new class; we use this opportunity to create an instance method that is bound to the class and this connection.</p> </dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.DBConnection.uri"> <code class="descname">uri</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#DBConnection.uri"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.DBConnection.uri" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> </dd></dl> <dl class="class"> <dt id="sqlobject.dbconnection.Iteration"> <em class="property">class </em><code class="descclassname">sqlobject.dbconnection.</code><code class="descname">Iteration</code><span class="sig-paren">(</span><em>dbconn</em>, <em>rawconn</em>, <em>select</em>, <em>keepConnection=False</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#Iteration"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.Iteration" title="Permalink to this definition">¶</a></dt> <dd><p>Bases: <code class="xref py py-class docutils literal notranslate"><span class="pre">object</span></code></p> <dl class="method"> <dt id="sqlobject.dbconnection.Iteration.next"> <code class="descname">next</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#Iteration.next"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.Iteration.next" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> </dd></dl> <dl class="class"> <dt id="sqlobject.dbconnection.LogWriter"> <em class="property">class </em><code class="descclassname">sqlobject.dbconnection.</code><code class="descname">LogWriter</code><span class="sig-paren">(</span><em>connection</em>, <em>logger</em>, <em>loglevel</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#LogWriter"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.LogWriter" title="Permalink to this definition">¶</a></dt> <dd><dl class="method"> <dt id="sqlobject.dbconnection.LogWriter.write"> <code class="descname">write</code><span class="sig-paren">(</span><em>text</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#LogWriter.write"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.LogWriter.write" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> </dd></dl> <dl class="class"> <dt id="sqlobject.dbconnection.Transaction"> <em class="property">class </em><code class="descclassname">sqlobject.dbconnection.</code><code class="descname">Transaction</code><span class="sig-paren">(</span><em>dbConnection</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#Transaction"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.Transaction" title="Permalink to this definition">¶</a></dt> <dd><p>Bases: <code class="xref py py-class docutils literal notranslate"><span class="pre">object</span></code></p> <dl class="method"> <dt id="sqlobject.dbconnection.Transaction.assertActive"> <code class="descname">assertActive</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#Transaction.assertActive"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.Transaction.assertActive" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.Transaction.begin"> <code class="descname">begin</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#Transaction.begin"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.Transaction.begin" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.Transaction.close"> <code class="descname">close</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#Transaction.close"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.Transaction.close" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.Transaction.commit"> <code class="descname">commit</code><span class="sig-paren">(</span><em>close=False</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#Transaction.commit"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.Transaction.commit" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.Transaction.iterSelect"> <code class="descname">iterSelect</code><span class="sig-paren">(</span><em>select</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#Transaction.iterSelect"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.Transaction.iterSelect" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.Transaction.query"> <code class="descname">query</code><span class="sig-paren">(</span><em>s</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#Transaction.query"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.Transaction.query" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.Transaction.queryAll"> <code class="descname">queryAll</code><span class="sig-paren">(</span><em>s</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#Transaction.queryAll"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.Transaction.queryAll" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.Transaction.queryInsertID"> <code class="descname">queryInsertID</code><span class="sig-paren">(</span><em>soInstance</em>, <em>id</em>, <em>names</em>, <em>values</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#Transaction.queryInsertID"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.Transaction.queryInsertID" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.Transaction.queryOne"> <code class="descname">queryOne</code><span class="sig-paren">(</span><em>s</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#Transaction.queryOne"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.Transaction.queryOne" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> <dl class="method"> <dt id="sqlobject.dbconnection.Transaction.rollback"> <code class="descname">rollback</code><span class="sig-paren">(</span><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#Transaction.rollback"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.Transaction.rollback" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> </dd></dl> <dl class="function"> <dt id="sqlobject.dbconnection.makeDebugWriter"> <code class="descclassname">sqlobject.dbconnection.</code><code class="descname">makeDebugWriter</code><span class="sig-paren">(</span><em>connection</em>, <em>loggerName</em>, <em>loglevel</em><span class="sig-paren">)</span><a class="reference internal" href="../_modules/sqlobject/dbconnection.html#makeDebugWriter"><span class="viewcode-link">[source]</span></a><a class="headerlink" href="#sqlobject.dbconnection.makeDebugWriter" title="Permalink to this definition">¶</a></dt> <dd></dd></dl> </div> </div> </div> </div> <div class="clearer"></div> </div> <div class="related" role="navigation" aria-label="related navigation"> <h3>Navigation</h3> <ul> <li class="right" style="margin-right: 10px"> <a href="../genindex.html" title="General Index" >index</a></li> <li class="right" > <a href="../py-modindex.html" title="Python Module Index" >modules</a> |</li> <li class="nav-item nav-item-0"><a href="../index.html">SQLObject 3.7.0 documentation</a> »</li> </ul> </div> <div class="footer" role="contentinfo"> © Copyright 2004-2018, Ian Bicking and contributors. Created using <a href="http://sphinx-doc.org/">Sphinx</a> 1.7.4. </div> </body> </html>