`SQLJoinConditional`

Conditional JOIN

The SQLJoinConditional class is accessible via the sqlobject.sqlbuilder module.

Attributes
Methods (38)
Source

Methods

f `add(self, other)` ...

f `radd(self, other)` ...

f `sub(self, other)` ...

f `rsub(self, other)` ...

f `mul(self, other)` ...

f `rmul(self, other)` ...

f `div(self, other)` ...

f `rdiv(self, other)` ...

f `pos(self)` ...

f `neg(self)` ...

f `pow(self, other)` ...

f `rpow(self, other)` ...

f `abs(self)` ...

f `mod(self, other)` ...

f `rmod(self, other)` ...

f `lt(self, other)` ...

f `le(self, other)` ...

f `gt(self, other)` ...

f `ge(self, other)` ...

f `eq(self, other)` ...

f `ne(self, other)` ...

f `and(self, other)` ...

f `rand(self, other)` ...

f `or(self, other)` ...

f `ror(self, other)` ...

f `invert(self)` ...

f `call(self, *args)` ...

f `cmp(self, other)` ...

f `rcmp(self, other)` ...

f `startswith(self, s)` ...

f `endswith(self, s)` ...

f `contains(self, s)` ...

f `components(self)` ...

f `tablesUsed(self, db)` ...

f `tablesUsedSet(self, db)` ...

f `tablesUsedImmediate(self)` ...

f `init(self, table1, table2, op, on_condition=None, using_columns=None)` ...

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)

f `sqlrepr(self, db)` ...

See the source for more information.