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.
