how about this?
def apply_rules(form):
if does not pass your criteria:
form.errors[somefield] = 'some message'
form = SQLFORM(db.workers_skills).process(onvalidation=apply_rules)
On Saturday, 21 January 2017 02:42:42 UTC-6, Yebach wrote:
>
> Hello
>
> I have to make a validator on my SQLFORM that checks 4 fields
>
> my table is
>
>
> db.define_table('workers_skills',
> Field('ws_organisation', type ='integer'),
> Field('ws_worker', 'reference workers', label = T('Worker')),
> Field('ws_skill', 'reference skills', label = T('Skill')),
> Field('ws_priority', type ='integer', label = T('Priority')),
> Field ('ws_status', type= 'integer', label = T('Status'),
> widget = SQLFORM.widgets.options.widget, default = 1),
> migrate = settings.migrate)
>
>
> The check is on fields ws_organisation, ws_worker, ws_skill and ws_priority
>
> So a worker cannot have the same ws_priority value for two different
> skills.
>
> this are the validators already set
>
> db.workers_skills.ws_priority.requires =
> [IS_NOT_EMPTY(error_message=T('Missing priority level')),
> IS_INT_IN_RANGE(1,
> 100000,error_message=T('Priority cannot be 0 or larger then 100000!'))
>
>
> db.workers_skills.ws_worker.requires = IS_IN_DB(
> db((db.workers.w_organisation == org)
> & (db.workers.w_status < 100)),
> db.workers.id, '%(w_nick_name)s -
> %(w_last_name)s %(w_first_name)s', zero=T('Select worker'))
>
> #preprečmo da bi ble podvojene vrednosti isti delavc isti skill pa da je
> dropdown mani sk_name glede na organizacijo
> db.workers_skills.ws_skill.requires = IS_IN_DB(db((db.skills.sk_organisation
> == org) &
> (db.skills.sk_status <
> 100)), db.skills.id, '%(sk_name)s',
> zero=T('Select skill'),
>
> _and=IS_NOT_IN_DB(db(db.workers_skills.ws_worker == request.vars.ws_worker),
>
> 'workers_skills.ws_skill'))
>
>
> What would be the most elegant way to solve this?
>
> thank you
>
--
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.
