Home
Trees
Indices
Help
Package CHEM
::
Package Common
::
Module Model
:: Class SQLQuery
[
hide private
]
[
frames
] |
no frames
]
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
)
Home
Trees
Indices
Help
Generated by Epydoc 3.0beta1 on Thu Nov 8 17:49:28 2007
http://epydoc.sourceforge.net