web2py - sqlform.grid oncreate,delete,update

create your on sqlform.grid action triggers

 # coding: utf8  
 import datetime  
 def log_update(formval):  
   strdate=datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")  
   action_log = "usuario %s atualizou o registro %s em %s" % (session.uid,str(formval.vars.id),strdate)  
   dbsec.log_security.insert(action_log=action_log,intranet=session.email,action_desc="update",action_url_from=request.env.path_info)  
 def log_create(formval):  
   strdate=datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")  
   action_log = "usuario %s criou o registro %s em %s" % (session.uid,str(formval.vars.id),strdate)  
   dbsec.log_security.insert(action_log=action_log,intranet=session.email,action_desc="create",action_url_from=request.env.path_info)  
 def log_delete(table,record_id):  
   strdate=datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")  
   action_log = "usuario %s deletou o registro %s da tabela %s em %s" % (session.uid,record_id,table,strdate)  
   dbsec.log_security.insert(action_log=action_log,intranet=session.email,action_desc="delete",action_url_from=request.env.path_info)  

 query_f = (db.table)  
   fields = [db.table.id,db.table.comments]  
   datasource = SQLFORM.grid(query=query_f,fields=fields,orderby=[db.table.id],  
     user_signature=False,create=False,details=False,editable=False,deletable=True,oncreate=log_create,onupdate=log_update,ondelete=log_delete)