Package install :: Package MoSTBioDat :: Package DataBase :: Package Query :: Package SQLBuilder :: Module sqlbuilder :: Class SQLJoinConditional
[hide private]
[frames] | no frames]

Class SQLJoinConditional

source code

SQLExpression --+    
                |    
          SQLJoin --+
                    |
                   SQLJoinConditional
Known Subclasses:

Conditional JOIN

Instance Methods [hide private]
 
__init__(self, table1, table2, op, on_condition=None, using_columns=None)
For condition you must give on_condition or using_columns but not both
source code
 
__sqlrepr__(self, db) source code

Inherited from SQLExpression: __abs__, __add__, __and__, __call__, __cmp__, __div__, __eq__, __ge__, __gt__, __invert__, __le__, __lt__, __mod__, __mul__, __ne__, __neg__, __or__, __pos__, __pow__, __radd__, __rand__, __rcmp__, __rdiv__, __repr__, __rmod__, __rmul__, __ror__, __rpow__, __rsub__, __str__, __sub__, components, contains, endswith, startswith, tablesUsed, tablesUsedDict, tablesUsedImmediate

Method Details [hide private]

__init__(self, table1, table2, op, on_condition=None, using_columns=None)
(Constructor)

source code 
For condition you must give on_condition or using_columns but not both

on_condition can be a string or SQLExpression, for example
    Table1.q.col1 == Table2.q.col2
using_columns can be a string or a list of columns, e.g.
    (Table1.q.col1, Table2.q.col2)

Overrides: SQLJoin.__init__

__sqlrepr__(self, db)

source code 
Overrides: SQLJoin.__sqlrepr__