This is a collection of tips extracted in part by reading the Web2py code.

gluon.dal

DAL

DB Adapters

Table

Get DAL object given a Table object (in table):

table._db

Get names of fields in a table:

table.fields()

Get Field objects from a table (field name in fieldname):

table[fieldname]

Read out the whole table:

table._db().select(table.ALL)

Clear the table (caution, requires foreign key constraints turned off):

table.truncate()

Field

Environment

Custom Import

Form accepts

Validation