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)