Class Set

source code

object --+
         |
        Set

a Set represents a set of records in the database,
the records are identified by the query=Query(...) object.
normally the Set is generated by DAL.__call__(Query(...))

given a set, for example
   set = db(db.users.name=='Max')
you can:
   set.update(db.users.name='Massimo')
   set.delete() # all elements in the set
   set.select(orderby=db.users.id, groupby=db.users.name, limitby=(0,10))
and take subsets:
   subset = set(db.users.id<5)