sqlobject :: sresults :: SelectResults :: Class SelectResults

Class SelectResults

object --+
         |
        SelectResults

Nested Classes
	IterationClass

Instance Methods

__getitem__(self, value)

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

__iter__(self)

__repr__(self)
repr(x)

__str__(self)
str(x)

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 0x12f99b0>)
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)

queryForSelect(self)

reversed(self)

sum(self, attribute)

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

Properties
	throughTo
Inherited from `object`: `__class__`

Method Details

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 0x12f99b0>)

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.

Property Details

throughTo

Get Method:: unreachable.throughTo(self)