wsatools.DbConnect.DbSession.LeftJoin

Class LeftJoin

Defines a database left outer join between two tables. Use as the table argument value in DbSession.query() type methods or when initialising an SelectSQL object.

Instance Methods

[hide private]

__init__(self, tables, attributes)
Defines an SQL left outer join between given tables on given attributes.

source code

_setSQL(self, tables, predicates)
Sets the FROM and WHERE SQL statement member variables for this join.

source code

Inherited from Join: __str__

Inherited from Join (private): _parseInput

Inherited from object: __delattr__, __format__, __getattribute__, __hash__, __new__, __reduce__, __reduce_ex__, __repr__, __setattr__, __sizeof__, __subclasshook__

Properties

[hide private]

Inherited from object: __class__

init(self, tables, attributes)
(Constructor)

source code

Defines an SQL left outer join between given tables on given attributes.

Parameters:

tables (sequence(str) or sequence(tuple)) - Pair of tables to be left-joined on same attribute set. Either just supply table names, or a tuple containing table name and alias, e.g. ["Multiframe", "ProgrammeFrame"] or [("Multiframe", "M1"), ("Multiframe", "M2")].
attributes (sequence(str) or str) - Unique attribute set on which to join. If a single join column is required then just a string will do.

Overrides: object.__init__

_setSQL(self, tables, predicates)

source code

Sets the FROM and WHERE SQL statement member variables for this join.

Overrides: Join._setSQL

Class LeftJoin

__init__(self, tables, attributes) (Constructor)

_setSQL(self, tables, predicates)

init(self, tables, attributes)
(Constructor)