field.requires = [IS_IN_DB(db,'%s.%s'%(tbname,fname))]
no select
field.requires = IS_IN_DB(db,'%s.%s'%(tbname,fname))
select
On Jul 2, 9:46 am, MikeEllis <michael.f.el...@gmail.com> wrote:
> (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 web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
