SelectResults


Attributes

a throughTo

<property object>

Methods

f __sizeof__(...) ...

__sizeof__() -> int size of object in memory, in bytes

f __format__(...) ...

default object formatter

f __subclasshook__(...) ...

Abstract classes can override this to customize issubclass().

This is invoked early on by abc.ABCMeta.__subclasscheck__(). It should return True, False or NotImplemented. If it returns NotImplemented, the normal algorithm is used. Otherwise, it overrides the normal algorithm (and the outcome is cached).

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

f queryForSelect(self) ...

f clone(self, **newOps) ...

f orderBy(self, orderBy) ...

f connection(self, conn) ...

f limit(self, limit) ...

f lazyColumns(self, value) ...

f reversed(self) ...

f distinct(self) ...

f newClause(self, new_clause) ...

f filter(self, filter_clause) ...

f __getitem__(self, value) ...

f __iter__(self) ...

f lazyIter(self) ...

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

f accumulate(self, *expressions) ...

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

f count(self) ...

Counting elements of current select results

f 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)

f 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)

f sum(self, attribute) ...

f min(self, attribute) ...

f avg(self, attribute) ...

f max(self, attribute) ...

f getOne(self, default=<class sqlobject.sqlbuilder.NoDefault>) ...

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.

See the source for more information.