<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd">
<h1 class="pudge-member-page-heading">
<tt>sqlbuilder</tt>
</h1>
<p class="pudge-member-parent-link">
<small>
The sqlbuilder module is accessible via the
<a href="module-sqlobject.html">
<tt>sqlobject</tt>
</a> module.
</small>
</p>
<div id="pudge-section-nav">
<ul>
<li>
<a href="#attributes" class="pudge-section-link">
Attributes (7)
</a>
</li><li>
<a href="#functions" class="pudge-section-link">
Functions (58)
</a>
</li><li>
<a href="#classes" class="pudge-section-link">
Classes (42)
</a>
</li><li>
<span class="pudge-missing-section-link">
Modules
</span>
</li>
<li>
<a href="module-sqlobject.sqlbuilder-index.html" class="pudge-section-link">
Index
</a>
</li>
<li>
<a href="sqlobject/sqlbuilder.py.html" class="pudge-section-link">
Source
</a>
</li>
</ul>
</div>
<div style="clear: left"></div>
<div class="rst pudge-module-doc">
<p>Builds SQL expressions from normal Python expressions.</p>
<div class="section" id="disclaimer">
<h1>Disclaimer</h1>
<p>This program is free software; you can redistribute it and/or modify
it under the terms of the GNU Lesser General Public License as
published by the Free Software Foundation; either version 2.1 of the
License, or (at your option any later version.</p>
<p>This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.</p>
<p>You should have received a copy of the GNU Lesser General Public
License along with this program; if not, write to the Free Software
Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301,
USA.</p>
</div>
<div class="section" id="instructions">
<h1>Instructions</h1>
<p>To begin a SQL expression, you must use some sort of SQL object -- a
field, table, or SQL statement (<tt class="docutils literal">SELECT</tt>, <tt class="docutils literal">INSERT</tt>, etc.) You can
then use normal operators, with the exception of:
<cite>and</cite>
,
<cite>or</cite>
,
<cite>not</cite>
,
and
<cite>in</cite>
. You can use the
<a href="module-sqlobject.sqlbuilder.html#AND" class="obj-link routine" title="sqlobject.sqlbuilder.AND - ">
<tt>AND</tt></a>
,
<a href="module-sqlobject.sqlbuilder.html#OR" class="obj-link routine" title="sqlobject.sqlbuilder.OR - ">
<tt>OR</tt></a>
,
<a href="module-sqlobject.sqlbuilder.html#NOT" class="obj-link routine" title="sqlobject.sqlbuilder.NOT - ">
<tt>NOT</tt></a>
, and
<a href="module-sqlobject.sqlbuilder.html#IN" class="obj-link routine" title="sqlobject.sqlbuilder.IN - ">
<tt>IN</tt></a>
functions
instead, or you can also use
<cite>&</cite>
,
<cite>|</cite>
, and
<cite>~</cite>
for
<cite>and</cite>
,
<cite>or</cite>
, and
<cite>not</cite>
respectively (however -- the precidence for these operators
doesn't work as you would want, so you must use many parenthesis).</p>
<p>To create a sql field, table, or constant/function, use the namespaces
<a href="module-sqlobject.sqlbuilder.html#table" class="obj-link attribute" title="sqlobject.sqlbuilder.table - ">
<tt>table</tt></a>
,
<a href="module-sqlobject.sqlbuilder.html#const" class="obj-link attribute" title="sqlobject.sqlbuilder.const - ">
<tt>const</tt></a>
, and
<a href="module-sqlobject.sqlbuilder.html#func" class="obj-link attribute" title="sqlobject.sqlbuilder.func - ">
<tt>func</tt></a>
. For instance, <tt class="docutils literal">table.address</tt> refers
to the <tt class="docutils literal">address</tt> table, and <tt class="docutils literal">table.address.state</tt> refers to the
<tt class="docutils literal">state</tt> field in the address table. <tt class="docutils literal">const.NULL</tt> is the <tt class="docutils literal">NULL</tt>
SQL constant, and <tt class="docutils literal">func.NOW()</tt> is the <tt class="docutils literal">NOW()</tt> function call
(
<a href="module-sqlobject.sqlbuilder.html#const" class="obj-link attribute" title="sqlobject.sqlbuilder.const - ">
<tt>const</tt></a>
and
<a href="module-sqlobject.sqlbuilder.html#func" class="obj-link attribute" title="sqlobject.sqlbuilder.func - ">
<tt>func</tt></a>
are actually identicle, but the two names are
provided for clarity). Once you create this object, expressions
formed with it will produce SQL statements.</p>
<p>The <tt class="docutils literal">sqlrepr(obj)</tt> function gets the SQL representation of these
objects, as well as the proper SQL representation of basic Python
types (None==NULL).</p>
<p>There are a number of DB-specific SQL features that this does not
implement. There are a bunch of normal ANSI features also not present.</p>
<p>See the bottom of this module for some examples, and run it (i.e.
<tt class="docutils literal">python sql.py</tt>) to see the results of those examples.</p>
</div>
</div>
<hr>
<a name="attributes"></a>
<h2>Attributes</h2>
<div class="pudge-member name">
<a name="const"></a>
<h4 class="pudge-member-name"><span class="prefix">a</span>
<tt><a href="module-sqlobject.sqlbuilder.html#const" class="pudge-obj-link">const</a></tt></h4>
<div class="pudge-section rst">
<pre><sqlobject.sqlbuilder.ConstantSpace instance at 0xb5131ac></pre>
</div>
</div><div class="pudge-member name">
<a name="table"></a>
<h4 class="pudge-member-name"><span class="prefix">a</span>
<tt><a href="module-sqlobject.sqlbuilder.html#table" class="pudge-obj-link">table</a></tt></h4>
<div class="pudge-section rst">
<pre><sqlobject.sqlbuilder.TableSpace instance at 0xb51318c></pre>
</div>
</div><div class="pudge-member name">
<a name="SQLTrueClause"></a>
<h4 class="pudge-member-name"><span class="prefix">a</span>
<tt><a href="module-sqlobject.sqlbuilder.html#SQLTrueClause" class="pudge-obj-link">SQLTrueClause</a></tt></h4>
<div class="pudge-section rst">
<pre>1 = 1</pre>
</div>
</div><div class="pudge-member name">
<a name="func"></a>
<h4 class="pudge-member-name"><span class="prefix">a</span>
<tt><a href="module-sqlobject.sqlbuilder.html#func" class="pudge-obj-link">func</a></tt></h4>
<div class="pudge-section rst">
<pre><sqlobject.sqlbuilder.ConstantSpace instance at 0xb5131ac></pre>
</div>
</div><div class="pudge-member name">
<a name="operatorMap"></a>
<h4 class="pudge-member-name"><span class="prefix">a</span>
<tt><a href="module-sqlobject.sqlbuilder.html#operatorMap" class="pudge-obj-link">operatorMap</a></tt></h4>
<div class="pudge-section rst">
<pre>{'!=': <built-in function ne>,
'*': <built-in function mul>,
'+': <built-in function add>,
'-': <built-in function sub>,
'/': <built-in function div>,
'<': <built-in function lt>,
'<=': <built-in function le>,
'=': <built-in function eq>,
'>': <built-in function gt>,
'>=': <built-in function ge>,
'IN': <built-in function contains>,
'IS': <built-in function eq>}</pre>
</div>
</div><div class="pudge-member name">
<a name="safeSQLRE"></a>
<h4 class="pudge-member-name"><span class="prefix">a</span>
<tt><a href="module-sqlobject.sqlbuilder.html#safeSQLRE" class="pudge-obj-link">safeSQLRE</a></tt></h4>
<div class="pudge-section rst">
<pre><_sre.SRE_Pattern object at 0xb361660></pre>
</div>
</div><div class="pudge-member name">
<a name="__package__"></a>
<h4 class="pudge-member-name"><span class="prefix">a</span>
<tt><a href="module-sqlobject.sqlbuilder.html#__package__" class="pudge-obj-link">__package__</a></tt></h4>
<div class="pudge-section rst">
<pre>'sqlobject'</pre>
</div>
</div>
<a name="functions"></a>
<h2>Functions</h2>
<div class="pudge-member routine ">
<a name="sqlIdentifier"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#sqlIdentifier" class="pudge-obj-link">sqlIdentifier</a>(obj)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=87&l=90#87" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="execute"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#execute" class="pudge-obj-link">execute</a>(expr, executor)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=92&l=97#92" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="SQLExprConverter"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#SQLExprConverter" class="pudge-obj-link">SQLExprConverter</a>(value, db)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=216&l=218#216" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="tablesUsedSet"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#tablesUsedSet" class="pudge-obj-link">tablesUsedSet</a>(obj, db)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=221&l=226#221" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="dictToList"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#dictToList" class="pudge-obj-link">dictToList</a>(template, dict)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=745&l=752#745" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="AND"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#AND" class="pudge-obj-link">AND</a>(*ops)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=822&l=831#822" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="OR"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#OR" class="pudge-obj-link">OR</a>(*ops)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=832&l=841#832" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="NOT"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#NOT" class="pudge-obj-link">NOT</a>(op)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=842&l=844#842" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="IN"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#IN" class="pudge-obj-link">IN</a>(item, list)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=848&l=858#848" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="NOTIN"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#NOTIN" class="pudge-obj-link">NOTIN</a>(item, list)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=859&l=864#859" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="STARTSWITH"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#STARTSWITH" class="pudge-obj-link">STARTSWITH</a>(expr, pattern)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=865&l=867#865" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="ENDSWITH"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#ENDSWITH" class="pudge-obj-link">ENDSWITH</a>(expr, pattern)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=868&l=870#868" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="CONTAINSSTRING"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#CONTAINSSTRING" class="pudge-obj-link">CONTAINSSTRING</a>(expr, pattern)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=871&l=873#871" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="ISNULL"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#ISNULL" class="pudge-obj-link">ISNULL</a>(expr)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=874&l=876#874" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="ISNOTNULL"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#ISNOTNULL" class="pudge-obj-link">ISNOTNULL</a>(expr)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=877&l=879#877" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="JOIN"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#JOIN" class="pudge-obj-link">JOIN</a>(table1, table2)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=962&l=964#962" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="INNERJOIN"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#INNERJOIN" class="pudge-obj-link">INNERJOIN</a>(table1, table2)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=965&l=967#965" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="CROSSJOIN"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#CROSSJOIN" class="pudge-obj-link">CROSSJOIN</a>(table1, table2)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=968&l=970#968" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="STRAIGHTJOIN"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#STRAIGHTJOIN" class="pudge-obj-link">STRAIGHTJOIN</a>(table1, table2)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=971&l=973#971" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="LEFTJOIN"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#LEFTJOIN" class="pudge-obj-link">LEFTJOIN</a>(table1, table2)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=974&l=976#974" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="LEFTOUTERJOIN"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#LEFTOUTERJOIN" class="pudge-obj-link">LEFTOUTERJOIN</a>(table1, table2)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=977&l=979#977" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="NATURALJOIN"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#NATURALJOIN" class="pudge-obj-link">NATURALJOIN</a>(table1, table2)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=980&l=982#980" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="NATURALLEFTJOIN"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#NATURALLEFTJOIN" class="pudge-obj-link">NATURALLEFTJOIN</a>(table1, table2)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=983&l=985#983" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="NATURALLEFTOUTERJOIN"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#NATURALLEFTOUTERJOIN" class="pudge-obj-link">NATURALLEFTOUTERJOIN</a>(table1, table2)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=986&l=988#986" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="RIGHTJOIN"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#RIGHTJOIN" class="pudge-obj-link">RIGHTJOIN</a>(table1, table2)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=989&l=991#989" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="RIGHTOUTERJOIN"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#RIGHTOUTERJOIN" class="pudge-obj-link">RIGHTOUTERJOIN</a>(table1, table2)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=992&l=994#992" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="NATURALRIGHTJOIN"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#NATURALRIGHTJOIN" class="pudge-obj-link">NATURALRIGHTJOIN</a>(table1, table2)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=995&l=997#995" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="NATURALRIGHTOUTERJOIN"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#NATURALRIGHTOUTERJOIN" class="pudge-obj-link">NATURALRIGHTOUTERJOIN</a>(table1, table2)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=998&l=1000#998" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="FULLJOIN"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#FULLJOIN" class="pudge-obj-link">FULLJOIN</a>(table1, table2)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1001&l=1003#1001" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="FULLOUTERJOIN"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#FULLOUTERJOIN" class="pudge-obj-link">FULLOUTERJOIN</a>(table1, table2)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1004&l=1006#1004" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="NATURALFULLJOIN"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#NATURALFULLJOIN" class="pudge-obj-link">NATURALFULLJOIN</a>(table1, table2)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1007&l=1009#1007" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="NATURALFULLOUTERJOIN"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#NATURALFULLOUTERJOIN" class="pudge-obj-link">NATURALFULLOUTERJOIN</a>(table1, table2)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1010&l=1012#1010" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="INNERJOINConditional"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#INNERJOINConditional" class="pudge-obj-link">INNERJOINConditional</a>(table1, table2, on_condition=None, using_columns=None)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1056&l=1058#1056" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="LEFTJOINConditional"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#LEFTJOINConditional" class="pudge-obj-link">LEFTJOINConditional</a>(table1, table2, on_condition=None, using_columns=None)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1059&l=1061#1059" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="LEFTOUTERJOINConditional"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#LEFTOUTERJOINConditional" class="pudge-obj-link">LEFTOUTERJOINConditional</a>(table1, table2, on_condition=None, using_columns=None)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1062&l=1064#1062" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="RIGHTJOINConditional"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#RIGHTJOINConditional" class="pudge-obj-link">RIGHTJOINConditional</a>(table1, table2, on_condition=None, using_columns=None)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1065&l=1067#1065" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="RIGHTOUTERJOINConditional"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#RIGHTOUTERJOINConditional" class="pudge-obj-link">RIGHTOUTERJOINConditional</a>(table1, table2, on_condition=None, using_columns=None)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1068&l=1070#1068" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="FULLJOINConditional"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#FULLJOINConditional" class="pudge-obj-link">FULLJOINConditional</a>(table1, table2, on_condition=None, using_columns=None)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1071&l=1073#1071" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="FULLOUTERJOINConditional"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#FULLOUTERJOINConditional" class="pudge-obj-link">FULLOUTERJOINConditional</a>(table1, table2, on_condition=None, using_columns=None)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1074&l=1076#1074" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="INNERJOINOn"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#INNERJOINOn" class="pudge-obj-link">INNERJOINOn</a>(table1, table2, on_condition)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1091&l=1093#1091" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="LEFTJOINOn"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#LEFTJOINOn" class="pudge-obj-link">LEFTJOINOn</a>(table1, table2, on_condition)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1094&l=1096#1094" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="LEFTOUTERJOINOn"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#LEFTOUTERJOINOn" class="pudge-obj-link">LEFTOUTERJOINOn</a>(table1, table2, on_condition)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1097&l=1099#1097" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="RIGHTJOINOn"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#RIGHTJOINOn" class="pudge-obj-link">RIGHTJOINOn</a>(table1, table2, on_condition)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1100&l=1102#1100" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="RIGHTOUTERJOINOn"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#RIGHTOUTERJOINOn" class="pudge-obj-link">RIGHTOUTERJOINOn</a>(table1, table2, on_condition)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1103&l=1105#1103" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="FULLJOINOn"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#FULLJOINOn" class="pudge-obj-link">FULLJOINOn</a>(table1, table2, on_condition)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1106&l=1108#1106" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="FULLOUTERJOINOn"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#FULLOUTERJOINOn" class="pudge-obj-link">FULLOUTERJOINOn</a>(table1, table2, on_condition)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1109&l=1111#1109" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="INNERJOINUsing"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#INNERJOINUsing" class="pudge-obj-link">INNERJOINUsing</a>(table1, table2, using_columns)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1112&l=1114#1112" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="LEFTJOINUsing"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#LEFTJOINUsing" class="pudge-obj-link">LEFTJOINUsing</a>(table1, table2, using_columns)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1115&l=1117#1115" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="LEFTOUTERJOINUsing"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#LEFTOUTERJOINUsing" class="pudge-obj-link">LEFTOUTERJOINUsing</a>(table1, table2, using_columns)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1118&l=1120#1118" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="RIGHTJOINUsing"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#RIGHTJOINUsing" class="pudge-obj-link">RIGHTJOINUsing</a>(table1, table2, using_columns)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1121&l=1123#1121" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="RIGHTOUTERJOINUsing"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#RIGHTOUTERJOINUsing" class="pudge-obj-link">RIGHTOUTERJOINUsing</a>(table1, table2, using_columns)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1124&l=1126#1124" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="FULLJOINUsing"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#FULLJOINUsing" class="pudge-obj-link">FULLJOINUsing</a>(table1, table2, using_columns)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1127&l=1129#1127" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="FULLOUTERJOINUsing"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#FULLOUTERJOINUsing" class="pudge-obj-link">FULLOUTERJOINUsing</a>(table1, table2, using_columns)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1130&l=1132#1130" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="EXISTS"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#EXISTS" class="pudge-obj-link">EXISTS</a>(subquery)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1224&l=1226#1224" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="NOTEXISTS"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#NOTEXISTS" class="pudge-obj-link">NOTEXISTS</a>(subquery)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1227&l=1229#1227" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="SOME"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#SOME" class="pudge-obj-link">SOME</a>(subquery)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1230&l=1232#1230" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="ANY"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#ANY" class="pudge-obj-link">ANY</a>(subquery)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1233&l=1235#1233" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member routine ">
<a name="ALL"></a>
<h4 class="pudge-member-name"><span class="prefix">f</span>
<tt><a href="module-sqlobject.sqlbuilder.html#ALL" class="pudge-obj-link">ALL</a>(subquery)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1236&l=1238#1236" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div>
<a name="classes"></a>
<h2>Classes</h2>
<div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.VersionError.html" class="pudge-obj-link">VersionError</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=74&l=76#74" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.VersionError.html#members">
10 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.NoDefault.html" class="pudge-obj-link">NoDefault</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=76&l=78#76" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.SQLObjectState.html" class="pudge-obj-link">SQLObjectState</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=80&l=84#80" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.SQLObjectState.html#members">
4 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.SQLExpression.html" class="pudge-obj-link">SQLExpression</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=108&l=211#108" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.SQLExpression.html#members">
36 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.SQLOp.html" class="pudge-obj-link">SQLOp</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=242&l=267#242" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.SQLOp.html#members">
39 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.SQLModulo.html" class="pudge-obj-link">SQLModulo</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=268&l=277#268" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.SQLModulo.html#members">
39 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.SQLCall.html" class="pudge-obj-link">SQLCall</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=281&l=291#281" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.SQLCall.html#members">
39 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.SQLPrefix.html" class="pudge-obj-link">SQLPrefix</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=294&l=310#294" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.SQLPrefix.html#members">
39 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.SQLConstant.html" class="pudge-obj-link">SQLConstant</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=313&l=320#313" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.SQLConstant.html#members">
39 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.SQLTrueClauseClass.html" class="pudge-obj-link">SQLTrueClauseClass</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=323&l=328#323" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.SQLTrueClauseClass.html#members">
38 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.Field.html" class="pudge-obj-link">Field</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=337&l=347#337" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.Field.html#members">
39 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.SQLObjectField.html" class="pudge-obj-link">SQLObjectField</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=348&l=378#348" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.SQLObjectField.html#members">
39 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.Table.html" class="pudge-obj-link">Table</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=382&l=395#382" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.Table.html#members">
40 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.SQLObjectTable.html" class="pudge-obj-link">SQLObjectTable</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=396&l=426#396" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.SQLObjectTable.html#members">
40 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.SQLObjectTableWithJoins.html" class="pudge-obj-link">SQLObjectTableWithJoins</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=427&l=450#427" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.SQLObjectTableWithJoins.html#members">
40 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.TableSpace.html" class="pudge-obj-link">TableSpace</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=451&l=458#451" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.TableSpace.html#members">
1 member</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.ConstantSpace.html" class="pudge-obj-link">ConstantSpace</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=459&l=464#459" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.AliasField.html" class="pudge-obj-link">AliasField</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=470&l=484#470" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.AliasField.html#members">
39 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.AliasTable.html" class="pudge-obj-link">AliasTable</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=485&l=522#485" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.AliasTable.html#members">
41 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.Alias.html" class="pudge-obj-link">Alias</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=523&l=532#523" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.Alias.html#members">
38 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.Union.html" class="pudge-obj-link">Union</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=534&l=551#534" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.Union.html#members">
38 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.Select.html" class="pudge-obj-link">Select</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=556&l=705#556" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.Select.html#members">
48 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.Insert.html" class="pudge-obj-link">Insert</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=708&l=742#708" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.Insert.html#members">
38 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.Update.html" class="pudge-obj-link">Update</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=753&l=782#753" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.Update.html#members">
39 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.Delete.html" class="pudge-obj-link">Delete</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=785&l=799#785" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="pudge-member-blurb">
To be safe, this will signal an error if there is no where clause,
unless you pass in where=None to the constructor.
</p>
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.Delete.html#members">
38 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.Replace.html" class="pudge-obj-link">Replace</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=802&l=805#802" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.Replace.html#members">
39 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.DESC.html" class="pudge-obj-link">DESC</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=812&l=821#812" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.DESC.html#members">
38 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.ColumnAS.html" class="pudge-obj-link">ColumnAS</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=880&l=888#880" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="pudge-member-blurb">
Just like SQLOp('AS', expr, name) except without the parentheses
</p>
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.ColumnAS.html#members">
39 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.SQLJoin.html" class="pudge-obj-link">SQLJoin</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=940&l=959#940" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.SQLJoin.html#members">
38 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html" class="pudge-obj-link">SQLJoinConditional</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1013&l=1053#1013" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="pudge-member-blurb">
Conditional JOIN
</p>
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#members">
38 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.SQLJoinOn.html" class="pudge-obj-link">SQLJoinOn</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1077&l=1081#1077" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="pudge-member-blurb">
Conditional JOIN ON
</p>
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.SQLJoinOn.html#members">
38 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.SQLJoinUsing.html" class="pudge-obj-link">SQLJoinUsing</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1084&l=1088#1084" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="pudge-member-blurb">
Conditional JOIN USING
</p>
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.SQLJoinUsing.html#members">
38 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.OuterField.html" class="pudge-obj-link">OuterField</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1138&l=1141#1138" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.OuterField.html#members">
39 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.OuterTable.html" class="pudge-obj-link">OuterTable</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1142&l=1144#1142" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.OuterTable.html#members">
40 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.Outer.html" class="pudge-obj-link">Outer</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1145&l=1148#1145" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.Outer.html#members">
1 member</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.LIKE.html" class="pudge-obj-link">LIKE</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1150&l=1177#1150" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.LIKE.html#members">
40 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.RLIKE.html" class="pudge-obj-link">RLIKE</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1178&l=1199#1178" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.RLIKE.html#members">
41 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.INSubquery.html" class="pudge-obj-link">INSubquery</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1201&l=1211#1201" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.INSubquery.html#members">
39 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.NOTINSubquery.html" class="pudge-obj-link">NOTINSubquery</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1212&l=1214#1212" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.NOTINSubquery.html#members">
39 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.Subquery.html" class="pudge-obj-link">Subquery</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1216&l=1223#1216" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.Subquery.html#members">
38 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.ImportProxyField.html" class="pudge-obj-link">ImportProxyField</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1241&l=1244#1241" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.ImportProxyField.html#members">
39 members</a>.
</p>
</div>
</div><div class="pudge-member class ">
<h4 class="pudge-member-name"><span class="prefix">C</span>
<tt>
<a href="class-sqlobject.sqlbuilder.ImportProxy.html" class="pudge-obj-link">ImportProxy</a>(...)</tt>
<a href="sqlobject/sqlbuilder.py.html?f=1245&l=1264#1245" class="pudge-member-view-source" title="View Source">...</a>
</h4>
<div class="pudge-section rst">
<p class="pudge-member-blurb">
Class to be used in column definitions that rely on other tables that might
not yet be in a classregistry.
</p>
<p class="note">
This class contains <a href="class-sqlobject.sqlbuilder.ImportProxy.html#members">
39 members</a>.
</p>
</div>
</div>
<p>
<small>
See
<a href="sqlobject/sqlbuilder.py.html" title="sqlobject/sqlbuilder.py:0">the source</a>
for more information.
</small>
</p>
distrib
>
Mageia
>
6
>
x86_64
>
media
>
core-release
>
by-pkgid
>
7100f2b58690d0bf43c8eb8cfe1232ce
>
files
>
1161
