I've traced right now to the exception and I get KeyError: 'name'
This is referring to the definition in db.py of the compute function
compute=lambda r:r['name'].lower()),
I've removed both notnull=True & required=True from:
Field('name', 'string', length=128, notnull=True, required=True),
but I still get the exception thrown.
I then remove all notnull and required and tested again... same
exception thrown.
however, as I said, if I include a name parameter in update_record all
is well. I think this provides a value for the compute formula to use.
I added this compute version recently and I think this is what's
tripping gae.
On Feb 3, 8:44 pm, mdipierro <[email protected]> wrote:
> Now the see this I understand the problem better. In this line:
>
> Field('mDate', 'datetime', required=True)
>
> required=True is not the same as requires=IS_NOT_EMPTY() and it is not
> the same as notnull=True.
>
> required=True means you cannot do insert without providing a value for
> this field and that is exactly what you tell me the problem is.
>
> On Feb 3, 12:22 pm, Carl <[email protected]> wrote:
>
>
>
> > db.define_table('team',
> > Field('name', 'string', length=128, notnull=True,
> > required=True),
> > Field('name_lower', compute=lambda r:r['name'].lower()),
> > Field('owner_user_id', db.auth_user, required=True,
> > requires=IS_IN_DB(db,db.auth_user.id,'%(id)s')),
> > Field('credit_quota', 'integer', notnull=True,
> > required=True),
> > Field('live', 'boolean', notnull=True,
> > required='True', default='True'),
> > Field('cDate', 'datetime', required=True),
> > Field('mDate', 'datetime', required=True))
>
> > Did you mean to refer to mDate rather than name (because it is
> > name_lower that is 'compute') ?
>
> > On 3 February 2010 17:06, mdipierro <[email protected]> wrote:
>
> > > Can you show us the model and attributes of db.team.
> > > I suspect db.team.mDate is missing a writable=False, readable=False
> > > which you need since it is a computed field.
>
> > > On Feb 3, 10:59 am, Carl <[email protected]> wrote:
> > >> MainThread - pid4460_seq4
> > >> update [gql.py:696]
> > >> update_record [sql.py:3232]
> > >> <lambda> [sql.py:3109]
> > >> update [subscription.py:65]
> > >> update_team [default.py:call:68]
> > >> serve_jsonrpc [tools.py:2560]
> > >> __call__ [tools.py:2646]
> > >> call [default.py:call:594]
> > >> <lambda> [globals.py:96]
> > >> <module> [default.py:call:764]
> > >> restricted [restricted.py:173]
> > >> run_controller_in [compileapp.py:426]
> > >> serve_controller [main.py:193]
> > >> wsgibase [main.py:478]
> > >> wsgiapp [gaehandler.py:71]
> > >> newfun [gaehandler.py:51]
> > >> run [handlers.py:92]
> > >> main [gaehandler.py:85]
> > >> ExecuteOrImportScript [dev_appserver.py:2187]
> > >> ExecuteCGI [dev_appserver.py:2289]
> > >> Dispatch [dev_appserver.py:2379]
> > >> Dispatch [dev_appserver.py:515]
> > >> _Dispatch [dev_appserver.py:3120]
> > >> _HandleRequest [dev_appserver.py:3177]
> > >> do_POST [dev_appserver.py:3069]
> > >> handle_one_request [BaseHTTPServer.py:310]
> > >> handle [BaseHTTPServer.py:316]
> > >> __init__ [SocketServer.py:522]
> > >> __init__ [dev_appserver.py:3057]
> > >> finish_request [SocketServer.py:254]
> > >> process_request [SocketServer.py:241]
> > >> handle_request [SocketServer.py:222]
> > >> serve_forever [SocketServer.py:201]
> > >> main [dev_appserver_main.py:402]
> > >> <module> [dev_appserver_main.py:417]
> > >> run_file [dev_appserver.py:63]
> > >> <module> [dev_appserver.py:67]
> > >> run [pydevd.py:780]
> > >> <module> [pydevd.py:953]
>
> > >> #from a function in default.py
> > >> (id, name, quota, users, usage) = team.update(auth.user.id, id, name)
> > >> # Line68
>
> > >> # from subscription.py.
> > >> def update(self, ownerId, teamId, name):
> > >> q = (self.db.team.owner_user_id == ownerId) \
> > >> & (self.db.team.id == teamId)
> > >> rows = self.db(q).select(self.db.team.ALL)
>
> > >> if rows:
> > >> rows[0].update_record(#name=name, # note I've commented
> > >> out this parameter to reproduce behavior
> > >> credit_quota=quota,
> > >> mDate=now) # *** Line 65 ***
>
> > >> On Feb 3, 3:51 pm, mdipierro <[email protected]> wrote:
>
> > >> > what is the traceback?
>
> > >> > On Feb 3, 6:59 am, Carl <[email protected]> wrote:
>
> > >> > > Given:
> > >> > > - a define_table() with a field as "compute=lambda r:r['name'].lower
> > >> > > ()"
> > >> > > - that I call update_record() on a row returned from a select.
>
> > >> > > when I test on dev_appserver I need to include name as a parameter to
> > >> > > update_record() otherwise an exception is thrown by Set.update(self,
> > >> > > **update_fields) in gql.py (line 696)
>
> > >> > > I post this for the record for anyone using GAE and update_record()
> > >> > > rather than a call to action.
>
> > >> > > I'm using Web2py 1.74.6
>
> > > --
> > > You received this message because you are subscribed to the Google Groups
> > > "web2py-users" group.
> > > To post to this group, send email to [email protected].
> > > To unsubscribe from this group, send email to
> > > [email protected].
> > > For more options, visit this group
> > > athttp://groups.google.com/group/web2py?hl=en.
--
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en.
