errata. form=crud.update(db.table,onaccept=crud.archive)
info is here: http://web2py.com/examples/static/epydoc/web2py.gluon.tools.Crud-class.html#archive On Jun 9, 11:58 pm, mdipierro <[email protected]> wrote: > Mind that you can also do > > form=crud.update(db.table,onaccept=auth.archive) > > It will create a secret table (which can be exposed) will all > revisions for the edited records. Look into examples in the docstring > or in the web based shell type > > help(auth.archive) > > On Jun 9, 11:53 pm, Christopher Steel <[email protected]> wrote: > > > Hi Jean Guy, > > > Are you talking about record auditing??? > > > You could do that with something like this: > > > # This sets a variable for user_id which is used frequently > > # it must be set after db.py or in db.py but after auth tables have > > been defined > > # and before the table referring to it. > > > user_id = auth.user.id if auth.user else 0 > > > db.define_table('application', > > Field('title'), > > Field('body', 'text'), > > Field('created_on', 'datetime', default=request.now), > > Field('created_by', db.auth_user, default=user_id)) > > > db.application.title.requires = [IS_NOT_EMPTY(), IS_NOT_IN_DB(db, > > 'application.title')] > > db.application.body.requires = IS_NOT_EMPTY() > > db.application.created_by.readable = False > > db.application.created_by.writable = False > > db.application.created_on.readable = False > > db.application.created_on.writable = False > > > If you are allowing editing you could copy the original record and > > create a new one. > > > web2pyslices has a nice example. > > > Cheers, > > > Chris > > > On Jun 8, 6:29 pm, Jean Guy <[email protected]> wrote: > > > > Could it be a good practice to implement electronic signature of the > > > database records like this : > > > > db.define_table('atable', > > > SQLField('var1'), > > > SQLField('var2',default=db(db.auth_user.id > > > ==auth.user_id).select(db.auth_user.initials).first().initials)) > > > > It needs that the user be authentified otherwise the app won't work, but > > > as > > > long as the user as to be authentified for doing accessing the database, > > > it > > > should be ok... > > > > What do you think? > > > > My goal is to have each records signed (stamped with users initials > > > actually) at the database level. > > > > Thanks. > > > > Jonhy
