# `SelectResults`

The SelectResults class is accessible via the `sqlobject.sresults` module.

## Attributes

#### a `throughTo`

    <property object at 0x937f89c>

## 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 at 0x92dd1ac>)` ...

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.