I know, I was searching to make sure I can log delete event before... But thanks for the invitation, I do...
Richard On Tue, Apr 23, 2013 at 3:54 PM, Derek <[email protected]> wrote: > Be sure to put stuff like this that you want to share on > http://www.web2pyslices.com <http://www.web2pyslices.com/home>. Searching > the group for neat tricks is not something people generally do. > > > On Tuesday, April 23, 2013 6:21:33 AM UTC-7, Richard wrote: > >> Of course, what could be done, make a variable container and differt the >> insert? >> >> For my usage as far as I can see a db insert on each request is not the >> bottle neck... >> >> But I understand for a bigger project it could be not praticable... >> >> Thanks >> >> Richard >> >> >> On Tue, Apr 23, 2013 at 8:50 AM, Anthony <[email protected]> wrote: >> >>> I suppose because it does a db insert on every request. >>> >>> >>> On Tuesday, April 23, 2013 8:26:53 AM UTC-4, Richard wrote: >>> >>>> Guruyaya, could you explain why, to you, this basic simple usage stats >>>> is unefficiant. >>>> >>>> Thanks >>>> >>>> Richard >>>> >>>> >>>> On Tue, Apr 23, 2013 at 12:26 AM, guruyaya <[email protected]> wrote: >>>> >>>>> The idea seems extremly unefficiant. Wouldn't it make more sense to >>>>> build it from logs, on a seperate machine? >>>>> >>>>> >>>>> On Tuesday, April 23, 2013 1:08:02 AM UTC+3, Richard wrote: >>>>>> >>>>>> Hello, >>>>>> >>>>>> I want to share this little snippet : >>>>>> >>>>>> # MODEL >>>>>> >>>>>> # Statistics of utilisation >>>>>> db.define_table('usage_**statist****ics', >>>>>> Field('time_stamp','datetime', default=request.now), >>>>>> Field('client_ip','string', default=request.client), >>>>>> Field('user_id', 'reference auth_user', default=auth.user and >>>>>> auth.user.id), >>>>>> Field('request_controller','**st****ring', >>>>>> default=request.controller), >>>>>> Field('request_function','**stri****ng', >>>>>> default=request.function), >>>>>> Field('request_extension','**str****ing', >>>>>> default=request.extension), >>>>>> Field('request_ajax','string', default=request.ajax), >>>>>> Field('request_args','string', default=request.args), >>>>>> Field('request_vars','string', default=request.vars), >>>>>> Field('request_view','string', default=request.view), >>>>>> Field('request_http_user_**agent****','string', >>>>>> default=request.env.http_user_******agent), >>>>>> Field('request_language','**stri****ng', >>>>>> default=request.env.http_**accep****t_language), >>>>>> Field('description', 'text'), >>>>>> migrate=False, >>>>>> ) >>>>>> >>>>>> # CONTROLLER >>>>>> >>>>>> def select(): >>>>>> """ >>>>>> Display log event into usage_statistics table. >>>>>> """ >>>>>> db.usage_statistics.id.**readabl****e = False >>>>>> table = SQLFORM.grid(db.usage_**statisti****cs, >>>>>> orderby=~db.usage_statistics.**t****ime_stamp, ui='jquery-ui', >>>>>> formstyle = 'divs',) >>>>>> return dict(table=table) >>>>>> >>>>>> # VIEWS >>>>>> >>>>>> # Just put these two lines in ALL your views or only the views you >>>>>> want to log and you can log what your users do!! >>>>>> >>>>>> {{db.usage_statistics.insert()******}} >>>>>> {{db.commit()}} >>>>>> >>>>>> *Only thing I didn't figured out yet is what the best way to log >>>>>> delete event... I thought about that :* >>>>>> >>>>>> # Not tested and pseudo code >>>>>> def myeventlogcall(form) >>>>>> if form.delete: >>>>>> db.usage_statistics.insert() >>>>>> db.commit() >>>>>> >>>>>> def update_functions(): >>>>>> ... >>>>>> form.process(ondelete=myevent******logcall) >>>>>> ... >>>>>> >>>>>> But, it makes things complicated if case there is already ondelete in >>>>>> an update_function... >>>>>> >>>>>> Any suggestion is welcome. >>>>>> >>>>>> Thanks >>>>>> >>>>>> Richard >>>>>> >>>>>> -- >>>>> >>>>> --- >>>>> 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+un...@**googlegroups.com. >>>>> >>>>> For more options, visit >>>>> https://groups.google.com/**grou**ps/opt_out<https://groups.google.com/groups/opt_out> >>>>> . >>>>> >>>>> >>>>> >>>> >>>> -- >>> >>> --- >>> 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+un...@**googlegroups.com. >>> For more options, visit >>> https://groups.google.com/**groups/opt_out<https://groups.google.com/groups/opt_out> >>> . >>> >>> >>> >> >> -- > > --- > 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 [email protected]. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- --- 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 [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
