I would like to generate a dropdown list dynamically according to the
records of a table, which refers to other tables. But it seems that lambda
doesn't work with OPTION helper.
For instance, I defined four tables, t_country, t_state, t_city, and
t_birthplace. Table t_birthplace refers to those three tables, and I want
the birthplace to be shown as "country, state, city".
The following is my code.
In model:
db.define_table('t_country',
Field('f_name'))
db.define_table('t_state',
Field('f_name'))
db.define_table('t_city',
Field('f_name'))
db.define_table('t_birthplace',
Field('f_country','reference t_country'),
Field('f_state','reference t_state'),
Field('f_city','reference t_city'),
format=lambda r: '%s %s %s' % (db(db.t_country.id == r.
f_country).select().first().f_name,
db(db.t_state.id == r.f_state
).select().first().f_name,
db(db.t_city.id == r.f_city).
select().first().f_name))
In controller:
def index():
db.t_country.insert(f_name='US')
db.t_state.insert(f_name='CA')
db.t_city.insert(f_name='San Mateo')
db.t_birthplace.insert(f_country=1,f_state=1,f_city=1)
rows_birthplace = db(db.t_birthplace).select()
# db.t_birthplace._format = '%(f_country)s'
opts_birthplace = [OPTION(db.t_birthplace._format % row, _value=row.id)
for row in rows_birthplace]
form = FORM(SELECT(_name='sel_birthplace', *opts_birthplace))
return dict(form=form)
In view:
{{extend 'layout.html'}}
{{=form}}
I got error while running the above code:
opts_birthplace = [OPTION(db.t_birthplace._format % row, _value=row.id) for
row in rows_birthplace]
TypeError: unsupported operand type(s) for %: 'function' and 'Row'
But if I redefine the format, uncomment "db.t_birthplace._format =
'%(f_country)s'" in controller, then the error is gone, the dropbox is
generated, but the representation of the option is not what I wanted, it
just shows 1, the id of f_country which refers to table t_country.
How can I get the dropdown list that shows the name nicely like "US, CA,
San Mateo"?
Your suggestion is highly appreciated!
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
