Package CHEM :: Package Common :: Module Model :: Class SQLQuery

Class SQLQuery

Helper class to dynamically build a SQL statement. Unlike just appending to a string, allows for addition of select, from, where, etc. clauses in any order, then generate them in normal order at the end.

Instance Methods

[hide private]

__init__(self)

addSelect(self, aSelect)

addFrom(self, aFrom)

addWhere(self, aWhere)

addWhereEqual(self, field, param)

addWhereLike(self, field, param)

addWhereOp(self, field, op, param)

addWhereIn(self, field, paramList)

addGroupBy(self, aGroupBy)

addHaving(self, aHaving)

addOrderBy(self, aOrderBy, dir=None)

setLimit(self, limit)

setOffset(self, offset)

addParam(self, aParam)

getParams(self)

__str__(self)