Hi Massimo, it's not about winning - I prefer learning...
On Sun, Jun 14, 2009 at 11:14 PM, mdipierro<mdipie...@cs.depaul.edu> wrote: > > OK. you win. > > On Jun 14, 3:54 pm, Hans Donner <hans.don...@pobox.com> wrote: >> then how to recognise what value was submitted? >> >> On 14 jun, 22:53, mdipierro <mdipie...@cs.depaul.edu> wrote: >> >> > I would then just handle this manual in onvalidate, no need for the >> > hidden file. >> >> > On Jun 14, 5:51 am, Hans Donner <hans.don...@pobox.com> wrote: >> >> > > If I have multiple users running the same function, one of the users >> > > should get an error that the year he has been submitting is already >> > > existing and I do not want that what he inserts is the year following >> > > the one he has been submitting. >> > > (and I'm on GAE, so no uniquess checking there on db level) >> >> > > On Sun, Jun 14, 2009 at 12:41 PM, mdipierro<mdipie...@cs.depaul.edu> >> > > wrote: >> >> > > > I am pretty sure that if you omit this line: >> >> > > > form.append(INPUT(_type='hidden', _value=newyear, _name >> > > > ='newyear')) >> >> > > > the field still goes in db because of "default" thus no need for >> > > > validation. >> >> > > > Massimo >> >> > > > On Jun 14, 2:26 am, Hans Donner <hans.don...@pobox.com> wrote: >> > > >> I think there is, but currently I've came up with: >> >> > > >> def year(): >> > > >> # too many - fail >> > > >> if len(request.args) > 1: >> > > >> redirect(URL(r=request,args=[])) >> >> > > >> # init >> > > >> table = db.year_year >> > > >> app_settings = AppSettings() >> > > >> arg0 = None >> > > >> if len(request.args) == 1: >> > > >> arg0 = request.args[0] >> >> > > >> if arg0 == 'add': >> >> > > >> def update_settings(form): >> > > >> requested = form.request_vars.newyear >> > > >> if not app_settings['min_year']: >> > > >> requested = form.vars.year >> > > >> app_settings['min_year'] = requested >> > > >> app_settings['max_year'] = requested >> > > >> app_settings.commit() >> >> > > >> def onvalidate_addyear(form): >> > > >> if app_settings['max_year']: >> > > >> next = str(int(app_settings['max_year']) + 1) >> > > >> requested = form.request_vars.newyear >> > > >> if next and requested != next: >> > > >> if requested <= next: >> > > >> session.flash = \ >> > > >> "The year %s has already been added" % >> > > >> requested >> > > >> else: >> > > >> session.flash = \ >> > > >> "The year %s does not follow %s" % >> > > >> (requested, next) >> > > >> redirect(URL(r=request, args=['add'])) >> > > >> form.vars.year = requested >> >> > > >> default = dict( >> > > >> table = table, >> > > >> onaccept = update_settings, >> > > >> onvalidation = onvalidate_addyear >> > > >> ) >> >> > > >> if app_settings['min_year'] == None: >> > > >> # no years yet - need to add first >> > > >> form = crud.create(**default) >> > > >> return dict(form = form) >> > > >> else: >> > > >> newyear = int(app_settings['max_year']) + 1 >> > > >> table.year.writeable = False >> > > >> table.year.default = newyear >> > > >> form = crud.create(**default) >> > > >> # add field to hold value for input >> > > >> form.append(INPUT(_type='hidden', _value=newyear, _name = >> > > >> 'newyear')) >> > > >> return dict(form = form) >> >> > > >> # no add >> > > >> rows = db().select(table.ALL) >> > > >> all_years = extract_field(rows, 'year') >> >> > > >> if arg0 and int(arg0) and \ >> > > >> arg0 >= app_settings['min_year'] and arg0 <= >> > > >> app_settings['max_year']: >> > > >> form = crud.read(table, rows[all_years.index(arg0)]) >> > > >> return dict(form = form) >> > > >> elif arg0: >> > > >> redirect(URL(r=request,args=[])) >> >> > > >> return dict(app = app_settings.row, years = all_years) >> >> > > >> On Sun, Jun 14, 2009 at 2:16 AM, mdipierro<mdipie...@cs.depaul.edu> >> > > >> wrote: >> >> > > >> > can you post an example? I am sure there is a better way. >> >> > > >> > Massimo >> >> > > >> > On Jun 13, 3:28 pm, Hans Donner <hans.don...@pobox.com> wrote: >> > > >> >> the model has some more fields, entered by the user. This filed is >> > > >> >> prepopulated by the server. >> > > >> >> On submitting the prepopluated value may be not valid any more, but >> > > >> >> may not be updated by the server >> > > >> >> (is considered part of the user submitted fileds). >> >> > > >> >> Currently worked around it by adding a hidden field with the data >> > > >> >> and >> > > >> >> supplying an onvalidation. >> >> > > >> >> On Sat, Jun 13, 2009 at 6:31 PM, >> > > >> >> mdipierro<mdipie...@cs.depaul.edu> wrote: >> >> > > >> >> > I do not understand. If the fields are marked readonly (as in >> > > >> >> > db.table.field.readonly=True) the field is not submitted from the >> > > >> >> > client to the server with the form. The form is populated >> > > >> >> > serverside. >> >> > > >> >> > Massimo >> >> > > >> >> > On Jun 13, 10:38 am, Hans Donner <hans.don...@pobox.com> wrote: >> > > >> >> >> Well, depends what you call 'inserted by the visitor'. In this >> > > >> >> >> case >> > > >> >> >> I'm prepopulating the form, some fields are not editable, but >> > > >> >> >> the user >> > > >> >> >> should submit these values as well. >> > > >> >> >> Guess I have to use onvalidate then to make sure all is ok. >> >> > > >> >> >> The second remark in my original posting: the 'unique' should >> > > >> >> >> somehow >> > > >> >> >> be supported by DAL, or warnings should be submitted that it is >> > > >> >> >> unsupported. >> >> > > >> >> >> On Sat, Jun 13, 2009 at 4:39 PM, >> > > >> >> >> mdipierro<mdipie...@cs.depaul.edu> wrote: >> >> > > >> >> >> > back to the original question. Should they validate? If they >> > > >> >> >> > are >> > > >> >> >> > readonly it means they are not inserted by the visitor. We >> > > >> >> >> > only >> > > >> >> >> > validate visitor provided input. >> >> > > >> >> >> > Massimo >> >> > > >> >> >> > On Jun 13, 9:02 am, Hans Donner <hans.don...@pobox.com> wrote: >> > > >> >> >> >> sorry, should be db.table.field.default = '' >> >> > > >> >> >> >> On Sat, Jun 13, 2009 at 3:54 PM, >> > > >> >> >> >> mdipierro<mdipie...@cs.depaul.edu> wrote: >> >> > > >> >> >> >> > I am not what you mean by: >> >> > > >> >> >> >> > db.table.field = 'some invalid value for the requires[]' >> >> > > >> >> >> >> > It seems to be redefining the field. It should give an >> > > >> >> >> >> > error. >> >> > > >> >> >> >> > On Jun 13, 8:28 am, Hans Donner <hans.don...@pobox.com> >> > > >> >> >> >> > wrote: >> > > >> >> >> >> >> db.define_table( >> > > >> >> >> >> >> 'test', >> > > >> >> >> >> >> SQLField('unique', 'string', unique = True, >> > > >> >> >> >> >> requires = IS_NOT_IN_DB(db, 'test.unique')), >> > > >> >> >> >> >> ) >> >> > > >> >> >> >> >> def pseudo(): >> > > >> >> >> >> >> db.table.field.writable = False >> > > >> >> >> >> >> db.table.field = 'some invalid value for the >> > > >> >> >> >> >> requires[]' >> > > >> >> >> >> >> form = crud.create(db.table) >> >> > > >> >> >> >> >> the form doesn't run the validators for the non-writable >> > > >> >> >> >> >> field, and >> > > >> >> >> >> >> when you are on GAE the uniqueness is not enforced on db >> > > >> >> >> >> >> level (and >> > > >> >> >> >> >> DAL does not make up for this). >> >> > > >> >> >> >> >> When I have the following: >> > > >> >> >> >> >> def pseudo(): >> > > >> >> >> >> >> db.table.field = 'some invalid value for the >> > > >> >> >> >> >> requires[]' >> > > >> >> >> >> >> form = crud.create(db.table) >> > > >> >> >> >> >> form.custom.widget.jaar.update(**dict(_disabled = >> > > >> >> >> >> >> True)) >> >> > > >> >> >> >> >> the value is non-editable by the user, it is validated >> > > >> >> >> >> >> but the value is removed > > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---