Package gluon :: Module dal :: Class Query

Class Query

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}

Class Query

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

__repr__(self) (Representation operator)

__str__(self) (Informal representation operator)

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

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

repr(self)
(Representation operator)

str(self)
(Informal representation operator)