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

Class SQLJoinOn

source code

SQLExpression --+        
                |        
          SQLJoin --+    
                    |    
   SQLJoinConditional --+
                        |
                       SQLJoinOn

Conditional JOIN ON

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

Inherited from SQLJoinConditional: __sqlrepr__

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)
(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__