3.2.3. query¶

Last page update: September 22, 2015

TODO

3.2.3.1. introduction¶

TODO

CLIPBOARD:

In a query you can refer itself to the :ref:`primary key <pkey>` of a :ref:`database table <table>`
with the following syntax::

    where='$pkey=:pkey'

**Example**:

>>> db.table('location.province').query(where='$pkey=:pkey',pkey='MI',addPkeyColumn=False).fetch()
[initials=MI,region=LOM,name=Milan,istat_code=013,order=22,total_order=None,valid_vat=None]

3.2.3.2. query methods¶

3.2.3.2.1. count¶

TODO

3.2.3.2.2. fetch¶

TODO

3.2.3.2.3. fetchAsBag¶

TODO

3.2.3.2.4. fetchAsDict¶

TODO

3.2.3.2.5. fetchGrouped¶

TODO

3.2.3.2.6. selection¶

TODO