How do I get list of field objects in a table in web2py?

Question

How do I get a list of all the field objects (e.g. gluon.dal.Field) in a table? The following

db.customer.fields

just returns a list of strings which are the field names.

score 6 · Accepted Answer · answered Oct 30 '13 at 12:39

6

field_objects = [f for f in db.customer]

answered Oct 30 '13 at 12:39

Anthony

25,466
3
28
57

Oh I see it implements `__iter__` with this functionality, good to know. – User Oct 30 '13 at 21:36

score 1 · Answer 2 · answered Oct 30 '13 at 06:39

Okay I see that fields are defined as attributes of the table class (gluon.dal.Table). The table class has a __getitem__ method defined which allows indexing by attribute name (as python allows).

Therefore I can get a list of field objects by using a list comprehension:

[db.customer[fieldname] for fieldname in db.customer.fields]

How do I get list of field objects in a table in web2py?

2 Answers2