Hello, I am trying to run a database query using the web2py scheduler, but
for some reason I can't get the query to commit. I've tested the function
in a controller to see that it works, and I'm pretty sure the scheduler is
running correctly because I have a scheduler_worker with the status of
ACTIVE in my backend.
this is my *scheduler.py* in *models*:
from gluon.scheduler import Scheduler
scheduler = Scheduler(db)
def delete_after_hours():
current_start = now
start = current_start.replace(tzinfo=utc)
rows = db(db.public_uploads.id > 0).select()
for row in rows:
end_time = row.end_time
end = end_time.replace(tzinfo=utc)
if start >= end:
row.delete_record()
scheduler.queue_task(delete_after_hours)
Thanks in advance for any advice.
*cheers
--
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/fb30c355-c3f8-4706-b0f3-cbdef96082e2n%40googlegroups.com.
