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()
}}}

Load table from a Rows object (e.g. as obtained by reading out the table as above) or from a list of dicts:
{{{
table.truncate()
for row in rows:
    if isinstance(row, Row):
        row = row.as_dict()
    table.insert(**row)
}}}
=== Field ===

== Environment ==
=== Custom Import ===

== Form accepts ==
=== Validation ===