IS_IN_SET_OR validator

[DenesL]

Any use for the following validator?
Note 1: IS_NULL_OR would be special case where theset=[""]
Note 2: it can still generate a dropdown with all the values from
self.options() plus self.other.options()
Note 3: gluon/sqlhtml.py modification also required
Note 4: more specific error message handling can be applied to
IS_NULL_OR

class IS_IN_SET_OR(object):
def __init__(self, other, theset=[], labels=None,
error_message='value not in set'):
self.other=other
self.theset=[str(i) for i in theset]
self.labels=labels
self.error_message=error_message
def set_self_id(self,id):
if hasattr(self.other,'set_self_id'):
self.other.set_self_id(id)
def __call__(self,value):
if value in self.theset:
return(value,None)
v,e=self.other(value)
if e:
return(v,'%s and %s'%(self.error_message,e))
else:
return(v,self.error_message)
def formatter(self,value):
if hasattr(self.other,'formatter'):
return self.other.formatter(value)
return value
def options(self):
if self.labels:
return [(k,self.labels[i]) for i,k in
enumerate(self.theset)]
else:
return [(k,k) for k in self.theset]

[mdipierro]

Thank you Denes. We need to build a repository of these. for now, ould
you write an AlterEgo page?

Massimo

[DenesL]

But gluon/sqlhtml.py has to be modified for it to work, if you are
going to include it in web2py I can do the mod. No point on writing an
alterego if it can not be used.

[Massimo Di Pierro]

Sorry, misread point 3. Could you send me a patch so that I can read
the modification?

Massimo

[DenesL]

ASAP

[DenesL]

The sqlhtml.py mod is easy but then if IS_IN_SET_OR is used in
combination with IS_IN_DB it blows up in function sql_represent of
sql.py, whereas IS_NULL_OR has no problem.
Hmmmm....

[Massimo Di Pierro]

The ql.py should be completely transparent to validators,
sql_represent in particular.

Validators are called only by FORM extended by SQLFORM sqlhtml.py.
The issue may be that IS_NULL_OR exposes options(self). In your case
that is more complex because you have two sets and you have to merge
them.

[DenesL]

Oops, there was an invalid value in the test set.
I am sending you the patch files.

[DenesL]

Massimo, did you receive the patch files?

[mdipierro]

Can you please resend. I am not sure.

[DenesL]

Files resent, did you get them?.