Can I just remove the added line in sqlhtml.py in the web2py 1.91.6?
Is it safe to do so?
I have crud.update form where I have some field that are boolean type that
are set to writable false then I use a .represent= for them...
Ex.:
db.table1.valid.represent=\
lambda value: value==True and T('valid').capitalize() or T('not
valid').capitalize()
They got caught by the if and remove from the update form on submit as far
as I understand.
Richard
On Wed, Feb 2, 2011 at 9:10 AM, Richard Vézina
<ml.richard.vez...@gmail.com>wrote:
> True
>
> Richard
>
>
> On Wed, Feb 2, 2011 at 12:20 AM, Marin Pranjic <marin.pran...@gmail.com>wrote:
>
>> ### this happens because FROM has no knowledge of
>> writable
>> ### and thinks that a missing boolean field is a None
>> if self.table[fieldname].type == 'boolean' and
>> self.vars[fieldname]==None:
>> del self.vars[fieldname]
>>
>> these are in red
>>
>> On Wed, Feb 2, 2011 at 12:19 AM, Massimo Di Pierro <
>> massimo.dipie...@gmail.com> wrote:
>>
>>> Which ones are in red?
>>>
>>> On Feb 1, 1:13 pm, Richard Vézina <ml.richard.vez...@gmail.com> wrote:
>>> > Hello,
>>> >
>>> > If I change erase those line (in red) in /gluon/sqlhtml.py
>>> >
>>> > if not self.ignore_rw and not self.table[fieldname].writable:
>>> > ### this happens because FROM has no knowledge of
>>> writable
>>> > ### and thinks that a missing boolean field is a None
>>> > if self.table[fieldname].type == 'boolean' and
>>> > self.vars[fieldname]==None:
>>> > del self.vars[fieldname]
>>> > continue
>>> >
>>> > It solves the problem... But I don't have clue of what the impacts are
>>> on
>>> > web2py.
>>> >
>>> > I use Postgres as backend...
>>> >
>>> > I will try to write a demo app to reproduce de problem...
>>> >
>>> > Richard
>>> >
>>> > On Tue, Feb 1, 2011 at 12:49 PM, Richard Vézina <
>>> ml.richard.vez...@gmail.com
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>> > > wrote:
>>> > > Hello,
>>> >
>>> > > I am not sure where it comes from the problem I face, but for sure it
>>> comes
>>> > > from 1.91.6 because I dont have the probleme with the exact same app
>>> under
>>> > > 1.88.2.
>>> >
>>> > > 1.
>>> > > 2.
>>> > > 3.
>>> > > 4.
>>> > > 5.
>>> > > 6.
>>> > > 7.
>>> > > 8.
>>> > > 9.
>>> > > 10.
>>> > > 11.
>>> > > 12.
>>> > > 13.
>>> > > 14.
>>> >
>>> > > Traceback (most recent call last):
>>> >
>>> > > File "/home/www-data/web2py/gluon/restricted.py", line 188, in
>>> restricted
>>> >
>>> > > exec ccode in environment
>>> >
>>> > > File "/home/www-data/web2py/applications/init/controllers/test.py",
>>> line 855, in <module>
>>> >
>>> > > File "/home/www-data/web2py/gluon/globals.py", line 95, in <lambda>
>>> >
>>> > > self._caller = lambda f: f()
>>> >
>>> > > File "/home/www-data/web2py/gluon/tools.py", line 2297, in f
>>> >
>>> > > return action(*a, **b)
>>> >
>>> > > File "/home/www-data/web2py/applications/init/controllers/test.py",
>>> line 410, in update
>>> >
>>> > > if form.accepts(request.vars, session):
>>> >
>>> > > File "/home/www-data/web2py/gluon/sqlhtml.py", line 1091, in
>>> accepts
>>> >
>>> > > if self.table[fieldname].type == 'boolean' and
>>> self.vars[fieldname]==None:
>>> > > KeyError: 'valid'
>>> >
>>> > > I have a field name "valid" in my models... May be it conflict with
>>> the new
>>> > > DAL??
>>> >
>>> > > Thanks
>>> >
>>> > > Richard
>>>
>>
>>
>
