[web2py] is bug? sqlform.factory
when implemented the following code, I notice that the system does not
respect
the length of the field in the database.
if the user enters a name of more than one (1) character the system stores
..
wonder: is this a bug?
to the following model:
auth_user_id = (auth.user and auth.user.id) or None
db.define_table('table_x',
Field('name', 'string', length=1, requires= IS_UPPER()),
Field('auth_user', db.auth_user, default=auth_user_id,
writable=False, Readable=False),
)
using the controller:
def index ():
form = SQLFORM.factory(
Field('name', 'string', length=3, requires=IS_UPPER()),
)
if form.accepts (request.vars):
db(db.table_x.auth_user==auth_user_id).update(name=request.vars.name)
return dict (form = form)
--
Re: [web2py] is bug? sqlform.factory
IS it SQLITE?
Sqlite dos not implements ALTER TABLE for column properties, if you created
the model with n length and so changed it later, sqlite does not respect
this.
It is a sqlite problem.
*if another database, so can be a dal problem
On Mon, Jan 21, 2013 at 11:43 AM, www.diazluis.com
diazluis2...@gmail.comwrote:
when implemented the following code, I notice that the system does not
respect
the length of the field in the database.
if the user enters a name of more than one (1) character the system stores
..
wonder: is this a bug?
to the following model:
auth_user_id = (auth.user and auth.user.id) or None
db.define_table('table_x',
Field('name', 'string', length=1, requires= IS_UPPER()),
Field('auth_user', db.auth_user, default=auth_user_id,
writable=False, Readable=False),
)
using the controller:
def index ():
form = SQLFORM.factory(
Field('name', 'string', length=3, requires=IS_UPPER()),
)
if form.accepts (request.vars):
db(db.table_x.auth_user==auth_user_id).update(name=
request.vars.name)
return dict (form = form)
--
--
Re: [web2py] Re: Bug? SQLFORM.factory and SQLFORM differ in handling of hidden form fields
Done: http://code.google.com/p/web2py/issues/detail?id=162
http://code.google.com/p/web2py/issues/detail?id=162Thanks!
On Tue, Jan 18, 2011 at 4:29 PM, Massimo Di Pierro
massimo.dipie...@gmail.com wrote:
This is a bug. Would you please post your bug report email on
googlecode? I will fix it asap.
On Jan 18, 12:23 pm, Nathan VanHoudnos nathan...@gmail.com wrote:
Hi,
A minimal example:
likertRightAnswer = ['Yes', 'No', 'Impossible to tell']
form = SQLFORM.factory(
Field('rightAnswer',
widget=horizontal_radios,
requires=IS_IN_SET(likertRightAnswer,
error_message=T('Please choose a
response.'))),
hidden={'timestart':request.now.strftime('%Y-%m-%d %H:%M:%S')}
)
In this case, BEAUTIFY(request.post_vars) will include, timestart and
rightAnswer, but BEAUTIFY(form.vars) will only include rightAnswer.
If we instead setup the appropriate db as db.ratings, and then do:
likertRightAnswer = ['Yes', 'No', 'Impossible to tell']
form = SQLFORM(db.ratings,
hidden={'timestart':request.now.strftime('%Y-%m-%d %H:%M:%S')}
)
In this case, both BEAUTIFY(request.post_vars) and BEAUTIFY(form.vars)
will
both include timestart and rightAnswer.
The second behavior is more expected at least to me.
Right now, I'm using request.post_vars.timestart to access the value
after
the form.accepts call, but this feels like I'm hacking something
together.
And it essentially circumvents the security feature discussed in this
thread:
http://groups.google.com/group/web2py/browse_thread/thread/ab21d9d216...
So is this a bug? Or should I be doing something different? (My
application
creates a bunch of little temporary forms and I don't want to bloat
the data-store with them.)
Cheers,
--
Nathan VanHoudnos
|- Statistics Public Policy PhD student
|- Program for Interdisciplinary Education Research (PIER) Fellowship
|- Carnegie Mellon University
|-http://www.andrew.cmu.edu/user/nmv
Neglect of mathematics works injury to all knowledge,
since he who is ignorant of it cannot know the other
sciences or the things of this world. -- Roger Bacon
--
Nathan VanHoudnos
|- Statistics Public Policy PhD student
|- Program for Interdisciplinary Education Research (PIER) Fellowship
|- Carnegie Mellon University
|- http://www.andrew.cmu.edu/user/nmv
Neglect of mathematics works injury to all knowledge,
since he who is ignorant of it cannot know the other
sciences or the things of this world. -- Roger Bacon
[web2py] Re: Bug? SQLFORM.factory and SQLFORM differ in handling of hidden form fields
This is a bug. Would you please post your bug report email on
googlecode? I will fix it asap.
On Jan 18, 12:23 pm, Nathan VanHoudnos nathan...@gmail.com wrote:
Hi,
A minimal example:
likertRightAnswer = ['Yes', 'No', 'Impossible to tell']
form = SQLFORM.factory(
Field('rightAnswer',
widget=horizontal_radios,
requires=IS_IN_SET(likertRightAnswer,
error_message=T('Please choose a
response.'))),
hidden={'timestart':request.now.strftime('%Y-%m-%d %H:%M:%S')}
)
In this case, BEAUTIFY(request.post_vars) will include, timestart and
rightAnswer, but BEAUTIFY(form.vars) will only include rightAnswer.
If we instead setup the appropriate db as db.ratings, and then do:
likertRightAnswer = ['Yes', 'No', 'Impossible to tell']
form = SQLFORM(db.ratings,
hidden={'timestart':request.now.strftime('%Y-%m-%d %H:%M:%S')}
)
In this case, both BEAUTIFY(request.post_vars) and BEAUTIFY(form.vars) will
both include timestart and rightAnswer.
The second behavior is more expected at least to me.
Right now, I'm using request.post_vars.timestart to access the value after
the form.accepts call, but this feels like I'm hacking something together.
And it essentially circumvents the security feature discussed in this
thread:
http://groups.google.com/group/web2py/browse_thread/thread/ab21d9d216...
So is this a bug? Or should I be doing something different? (My application
creates a bunch of little temporary forms and I don't want to bloat
the data-store with them.)
Cheers,
--
Nathan VanHoudnos
|- Statistics Public Policy PhD student
|- Program for Interdisciplinary Education Research (PIER) Fellowship
|- Carnegie Mellon University
|-http://www.andrew.cmu.edu/user/nmv
Neglect of mathematics works injury to all knowledge,
since he who is ignorant of it cannot know the other
sciences or the things of this world. -- Roger Bacon
