Home       Trees       Indices       Help   
web2py Web Framework
Package gluon :: Module dal :: Class Query
[hide private]
[frames] | no frames]

Class Query

source code

object --+
         |
        Query

a query object necessary to define a set. it can be stored or can be passed to DAL.__call__() to obtain a Set

Example:

   query = db.users.name=='Max'
   set = db(query)
   records = set.select()
Instance Methods [hide private]
 
__init__(self, db, op, first=None, second=None, ignore_common_filters=False, **optional_args)
x.__init__(...) initializes x; see help(type(x)) for signature		 source code
 
__repr__(self)
repr(x)		 source code
 
__str__(self)
str(x)		 source code
 
__and__(self, other) source code
 
__rand__(self, other) source code
 
__or__(self, other) source code
 
__ror__(self, other) source code
 
__invert__(self) source code
 
__eq__(self, other) source code
 
__ne__(self, other) source code
 
case(self, t=1, f=0) source code
 
as_dict(self, flat=False, sanitize=True)
Experimental stuff		 source code
 
as_xml(self, sanitize=True) source code
 
as_json(self, sanitize=True) source code

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

Properties [hide private]

Inherited from object: __class__

Method Details [hide private]

__init__(self, db, op, first=None, second=None, ignore_common_filters=False, **optional_args)
(Constructor)

source code 

x.__init__(...) initializes x; see help(type(x)) for signature

Overrides: object.__init__
(inherited documentation)

__repr__(self)
(Representation operator)

source code 

repr(x)

Overrides: object.__repr__
(inherited documentation)

__str__(self)
(Informal representation operator)

source code 

str(x)

Overrides: object.__str__
(inherited documentation)

as_dict(self, flat=False, sanitize=True)

source code  
Experimental stuff

This allows to return a plain dictionary with the basic
query representation. Can be used with json/xml services
for client-side db I/O

Example:
>>> q = db.auth_user.id != 0
>>> q.as_dict(flat=True)
{"op": "NE", "first":{"tablename": "auth_user",
                      "fieldname": "id"},
             "second":0}

   Home       Trees       Indices       Help   
web2py Web Framework
Generated by Epydoc 3.0.1 on Sun Mar 16 02:36:13 2014 http://epydoc.sourceforge.net