sqlobject :: sresults :: SelectResults :: Class SelectResults

Class SelectResults

object --+
         |
        SelectResults

Nested Classes

[hide private]

IterationClass

Instance Methods

[hide private]

__getitem__(self, value)

__init__(self, sourceClass, clause, clauseTables=None, **ops)
x.__init__(...) initializes x; see x.__class__.__doc__ for signature

__iter__(self)

__nonzero__(self)

__repr__(self)
repr(x)

__str__(self)
str(x)

_getConnection(self)

_mungeOrderBy(self, orderBy)

accumulate(self, *expressions)
Use accumulate expression(s) to select result using another SQL select through current connection.

accumulateMany(self, *attributes)
Making the expressions for count/sum/min/max/avg of a given select result attributes.

accumulateOne(self, func_name, attribute)
Making the sum/min/max/avg of a given select result attribute.

avg(self, attribute)

clone(self, **newOps)

connection(self, conn)

count(self)
Counting elements of current select results

distinct(self)

filter(self, filter_clause)

getOne(self, default=<class sqlobject.sqlbuilder.NoDefault at 0x9af140c>)
If a query is expected to only return a single value, using ``.getOne()`` will return just that value.

lazyColumns(self, value)

lazyIter(self)
Returns an iterator that will lazily pull rows out of the database and return SQLObject instances

limit(self, limit)

max(self, attribute)

min(self, attribute)

newClause(self, new_clause)

orderBy(self, orderBy)

reversed(self)

sum(self, attribute)

Inherited from object: __delattr__, __getattribute__, __hash__, __new__, __reduce__, __reduce_ex__, __setattr__

Properties

[hide private]

Inherited from object: __class__

Method Details

[hide private]

init(self, sourceClass, clause, clauseTables=None, **ops)
(Constructor)

x.__init__(...) initializes x; see x.__class__.__doc__ for signature

Overrides: object.__init__: (inherited documentation)

repr(self)
(Representation operator)

repr(x)

Overrides: object.__repr__: (inherited documentation)

str(self)
(Informal representation operator)

str(x)

Overrides: object.__str__: (inherited documentation)

accumulate(self, *expressions)

Use accumulate expression(s) to select result using another SQL select through current connection. Return the accumulate result

accumulateMany(self, *attributes)

Making the expressions for count/sum/min/max/avg of a given select result attributes. `attributes` must be a list/tuple of pairs (func_name, attribute); `attribute` can be a column name (like 'a_column') or a dot-q attribute (like Table.q.aColumn)

accumulateOne(self, func_name, attribute)

Making the sum/min/max/avg of a given select result attribute. `attribute` can be a column name (like 'a_column') or a dot-q attribute (like Table.q.aColumn)

getOne(self, default=<class sqlobject.sqlbuilder.NoDefault at 0x9af140c>)

If a query is expected to only return a single value, using ``.getOne()`` will return just that value.

If not results are found, ``SQLObjectNotFound`` will be raised, unless you pass in a default value (like ``.getOne(None)``).

If more than one result is returned, ``SQLObjectIntegrityError`` will be raised.

Class SelectResults

__init__(self, sourceClass, clause, clauseTables=None, **ops) (Constructor)

__repr__(self) (Representation operator)

__str__(self) (Informal representation operator)

accumulate(self, *expressions)

accumulateMany(self, *attributes)

accumulateOne(self, func_name, attribute)

getOne(self, default=<class sqlobject.sqlbuilder.NoDefault at 0x9af140c>)

init(self, sourceClass, clause, clauseTables=None, **ops)
(Constructor)

repr(self)
(Representation operator)

str(self)
(Informal representation operator)