Because I'm lazy. In some of my code I do this:
# Set all fields as not editable for field in db.contact.fields: db.contact[field].writable = False # Enable the specific fields that will be editable in the form db.contact.first_name.writable = True db.contact.last_name.writable = True I can then set which fields are writable based on different access levels. Obviously I just need to exclude the 'id' field where I set writable to False. But, this is where it came from. -Jim On Thursday, September 10, 2015 at 10:07:22 AM UTC-5, Niphlod wrote: > > uhm. why the id should be set to not writable ? it is not writable by > default because it's an identity ..... > > On Thursday, September 10, 2015 at 4:54:35 PM UTC+2, Jim S wrote: >> >> I just fixed an issue I was having - it used to work so much be a newer >> version of web2py that introduced it (I think, cannot confirm that it >> worked on earlier version) >> >> I have a table with record versioning active. I'm updating it via >> SQLFORM.grid but before the SQLFORM.grid call I was making the 'id' field >> non-writable. db.contact.id.writable = False >> >> With that in place I'm getting this traceback... >> >> Traceback (most recent call last): >> File "C:\dev\web2py\gluon\restricted.py", line 227, in restricted >> exec ccode in environment >> File "C:/dev/web2py/applications/connect/controllers/contacts.py" >> <http://127.0.0.1:8000/admin/default/edit/connect/controllers/contacts.py>, >> line 892, in <module> >> File "C:\dev\web2py\gluon\globals.py", line 412, in <lambda> >> self._caller = lambda f: f() >> File "C:\dev\web2py\gluon\tools.py", line 3775, in f >> return action(*a, **b) >> File "C:/dev/web2py/applications/connect/controllers/contacts.py" >> <http://127.0.0.1:8000/admin/default/edit/connect/controllers/contacts.py>, >> line 231, in index >> paginate=15, maxtextlength=45, formstyle=my_formstyle, ui=grid_ui) >> File "C:\dev\web2py\gluon\sqlhtml.py", line 2308, in grid >> next=referrer) >> File "C:\dev\web2py\gluon\html.py", line 2301, in process >> self.validate(**kwargs) >> File "C:\dev\web2py\gluon\html.py", line 2238, in validate >> if self.accepts(**kwargs): >> File "C:\dev\web2py\gluon\sqlhtml.py", line 1709, in accepts >> self.id_field_name]).update(**fields) >> File "C:\dev\web2py\gluon\packages\dal\pydal\objects.py", line 2045, in >> update >> if any(f(self,update_fields) for f in table._before_update): >> File "C:\dev\web2py\gluon\packages\dal\pydal\objects.py", line 2045, in >> <genexpr> >> if any(f(self,update_fields) for f in table._before_update): >> File "C:\dev\web2py\gluon\packages\dal\pydal\objects.py", line 415, in >> <lambda> >> archive_record(qset, fs, db[an], cn)) >> File "C:\dev\web2py\gluon\packages\dal\pydal\helpers\methods.py", line 91, >> in archive_record >> if fields[k] != v: >> KeyError: 'id' >> >> >> With the 'id' field writable I do not get the traceback. >> >> Version 2.12.3-stable+timestamp.2015.08.18.19.14.07 >> >> Should this be reported as a bug or is it just me having issues? >> >> -- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
