On Thursday, March 3, 2016 at 11:57:46 AM UTC-8, Dave S wrote: > > > > On Thursday, March 3, 2016 at 10:37:30 AM UTC-8, Mohit Jain wrote: >> >> Hello, >> I would like to know how can one delete rows from a web2py table >> where if a specific field (a timestamp) is older than 24hours? I would like >> this process to keep running in the background in fixed time-intervals >> (every 5 minutes or so) and delete entries from the table where this field >> is older than 24hours from the current time. I know using the Scheduler is >> probably the correct way to go about it but I'm unable to figure out the >> exact code to be written (the documentation has too many options and hence >> a bit confusing). Looking for code samples! :) >> >> > Pretty simple. You need a model file, say models/scheduler.py > > import datetime > > def cleantable(): > print "cleantable cleaning the table at %s" % (request.utc_now) > backthen = datetime.strptime(request.utc_now) - datetime.timedelta(h=24) > return backthen.isoformat() # stdout and the return value will be > in the scheduler_run table, up to the limit in size > > ts = scheduler.task_status(db.scheduler_task.task_name == 'cleantable') > if ts.status not in ["QUEUED", "RUNNING"] : > scheduler.queue_task( "cleantable", start_time = ttime, period = 300, > repeats=0) > > > > If you want a user event to trigger your task, move the queue_task call > to a controller. > > The task_queue call could also be done from a -S shell prompt. And you run the scheduler with a -K command line option (or -K -X)
> The limit on stdout contents seems to be 128K > <URL:https://groups.google.com/d/topic/web2py/PunI6ffg9xk/discussion> > /dps -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- 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/d/optout.
