<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01//EN" "http://www.w3.org/TR/html4/strict.dtd"> <h1 class="pudge-member-page-heading"> <tt>SQLJoinConditional</tt> </h1> <h4 class="pudge-member-page-subheading"> Conditional JOIN </h4> <p class="pudge-member-parent-link"> <small> The SQLJoinConditional class is accessible via the <a href="module-sqlobject.sqlbuilder.html"> <tt>sqlobject.sqlbuilder</tt> </a> module. </small> </p> <div id="pudge-section-nav"> <ul> <li> <span class="pudge-missing-section-link"> Attributes </span> </li><li> <a href="#methods" class="pudge-section-link"> Methods (38) </a> </li> <li> <a href="sqlobject/sqlbuilder.py.html?f=1013&l=1053#1013" class="pudge-section-link"> Source </a> </li> </ul> </div> <div style="clear: left"></div> <hr> <a name="methods"></a> <h2>Methods</h2> <div class="pudge-member routine "> <a name="__add__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__add__" class="pudge-obj-link">__add__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=109&l=111#109" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__radd__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__radd__" class="pudge-obj-link">__radd__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=111&l=113#111" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__sub__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__sub__" class="pudge-obj-link">__sub__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=113&l=115#113" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__rsub__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__rsub__" class="pudge-obj-link">__rsub__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=115&l=117#115" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__mul__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__mul__" class="pudge-obj-link">__mul__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=117&l=119#117" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__rmul__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__rmul__" class="pudge-obj-link">__rmul__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=119&l=121#119" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__div__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__div__" class="pudge-obj-link">__div__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=121&l=123#121" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__rdiv__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__rdiv__" class="pudge-obj-link">__rdiv__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=123&l=125#123" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__pos__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__pos__" class="pudge-obj-link">__pos__</a>(self)</tt> <a href="sqlobject/sqlbuilder.py.html?f=125&l=127#125" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__neg__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__neg__" class="pudge-obj-link">__neg__</a>(self)</tt> <a href="sqlobject/sqlbuilder.py.html?f=127&l=129#127" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__pow__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__pow__" class="pudge-obj-link">__pow__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=129&l=131#129" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__rpow__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__rpow__" class="pudge-obj-link">__rpow__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=131&l=133#131" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__abs__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__abs__" class="pudge-obj-link">__abs__</a>(self)</tt> <a href="sqlobject/sqlbuilder.py.html?f=133&l=135#133" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__mod__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__mod__" class="pudge-obj-link">__mod__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=135&l=137#135" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__rmod__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__rmod__" class="pudge-obj-link">__rmod__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=137&l=139#137" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__lt__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__lt__" class="pudge-obj-link">__lt__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=140&l=142#140" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__le__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__le__" class="pudge-obj-link">__le__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=142&l=144#142" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__gt__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__gt__" class="pudge-obj-link">__gt__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=144&l=146#144" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__ge__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__ge__" class="pudge-obj-link">__ge__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=146&l=148#146" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__eq__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__eq__" class="pudge-obj-link">__eq__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=148&l=153#148" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__ne__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__ne__" class="pudge-obj-link">__ne__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=153&l=158#153" 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="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__and__" class="pudge-obj-link">__and__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=159&l=161#159" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__rand__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__rand__" class="pudge-obj-link">__rand__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=161&l=163#161" 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="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__or__" class="pudge-obj-link">__or__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=163&l=165#163" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__ror__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__ror__" class="pudge-obj-link">__ror__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=165&l=167#165" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__invert__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__invert__" class="pudge-obj-link">__invert__</a>(self)</tt> <a href="sqlobject/sqlbuilder.py.html?f=167&l=169#167" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__call__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__call__" class="pudge-obj-link">__call__</a>(self, *args)</tt> <a href="sqlobject/sqlbuilder.py.html?f=170&l=172#170" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__cmp__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__cmp__" class="pudge-obj-link">__cmp__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=183&l=185#183" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__rcmp__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__rcmp__" class="pudge-obj-link">__rcmp__</a>(self, other)</tt> <a href="sqlobject/sqlbuilder.py.html?f=185&l=187#185" 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="class-sqlobject.sqlbuilder.SQLJoinConditional.html#startswith" class="pudge-obj-link">startswith</a>(self, s)</tt> <a href="sqlobject/sqlbuilder.py.html?f=188&l=190#188" 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="class-sqlobject.sqlbuilder.SQLJoinConditional.html#endswith" class="pudge-obj-link">endswith</a>(self, s)</tt> <a href="sqlobject/sqlbuilder.py.html?f=190&l=192#190" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="contains"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#contains" class="pudge-obj-link">contains</a>(self, s)</tt> <a href="sqlobject/sqlbuilder.py.html?f=192&l=194#192" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="components"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#components" class="pudge-obj-link">components</a>(self)</tt> <a href="sqlobject/sqlbuilder.py.html?f=195&l=197#195" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="tablesUsed"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#tablesUsed" class="pudge-obj-link">tablesUsed</a>(self, db)</tt> <a href="sqlobject/sqlbuilder.py.html?f=198&l=200#198" 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="class-sqlobject.sqlbuilder.SQLJoinConditional.html#tablesUsedSet" class="pudge-obj-link">tablesUsedSet</a>(self, db)</tt> <a href="sqlobject/sqlbuilder.py.html?f=200&l=209#200" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="tablesUsedImmediate"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#tablesUsedImmediate" class="pudge-obj-link">tablesUsedImmediate</a>(self)</tt> <a href="sqlobject/sqlbuilder.py.html?f=209&l=211#209" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div><div class="pudge-member routine "> <a name="__init__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__init__" class="pudge-obj-link">__init__</a>(self, table1, table2, op, on_condition=None, using_columns=None)</tt> <a href="sqlobject/sqlbuilder.py.html?f=1015&l=1030#1015" title="View Source">...</a> </h4> <div class="pudge-section rst"> <p class="pudge-member-blurb"> For condition you must give on_condition or using_columns but not both </p> <dl class="docutils"> <dt>on_condition can be a string or SQLExpression, for example</dt> <dd>Table1.q.col1 == Table2.q.col2</dd> <dt>using_columns can be a string or a list of columns, e.g.</dt> <dd>(Table1.q.col1, Table2.q.col2)</dd> </dl> </div> </div><div class="pudge-member routine "> <a name="__sqlrepr__"></a> <h4 class="pudge-member-name"><span class="prefix">f</span> <tt><a href="class-sqlobject.sqlbuilder.SQLJoinConditional.html#__sqlrepr__" class="pudge-obj-link">__sqlrepr__</a>(self, db)</tt> <a href="sqlobject/sqlbuilder.py.html?f=1031&l=1053#1031" title="View Source">...</a> </h4> <div class="pudge-section rst"> </div> </div> <p> <small> See <a href="sqlobject/sqlbuilder.py.html?f=1013&l=1053#1013" title="sqlobject/sqlbuilder.py:1013">the source</a> for more information. </small> </p>