(Note: there's a thread from last year on this subject, but for some
reason it's only providing links to reply to author and not to the
group)
The following model code is working correctly except that the
generated SQLFORM has INPUT elements instead of select elements even
though I've specifed an IS_IN_DB() requirement both as arguments to
SQLField() and separately as a field.requires() statement. The
validations work as expected for all fields in all tables, it's just
the SELECT element that's missing.
The SQLFORM code is just
form = SQLFORM(db.config)
and the view is
{{=form}}
Here's the model code (db.py)
def configfields():
""" Here we define all the fields the user is expected to fill in
during the configuration phase along with the tables that will
be created to store all the allowed values for each field.
Returns {table:(field,type), ...}
"""
d = {
'users':('user_name','string'),
'boot':('boot_type','string'),
'ip':('base_device_ip','string'),
'port':('base_device_port','integer'),
}
return d
## The config table records the user, boot, ip, and port used in
## each testing session.
args = []
for tbname,(fname,ftype) in configfields().iteritems():
req = {'requires':IS_IN_DB(db,'%(tbname)s.%(fname)s'%locals())}
args.append(SQLField(fname,ftype,**req))
kwargs = {'migrate':True}
db.define_table('config', *args, **kwargs)
for tbname,(fname,ftype) in configfields().iteritems():
## These tables contain permitted values for the fields in
## the config table.
db.define_table(tbname,SQLField
(fname,ftype,unique=True),migrate=True)
## create validation requirements such that the config table
## field values must be in the corresponding single field
## tables and that values entered in the single field tables
## must not be already present.
table = getattr(db,tbname)
field = getattr(table,fname)
field.requires = [IS_NOT_IN_DB(db,'%s.%s'%(tbname,fname)),
IS_NOT_EMPTY()]
field = getattr(db.config,fname)
field.requires = [IS_IN_DB(db,'%s.%s'%(tbname,fname))]
What am I doing wrong?
Thanks,
Mike
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"web2py Web Framework" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
