I am stuck with a similar situation here.
I have the models/scheduler.py
from gluon.scheduler import Scheduler
def auto_insert():
try:
db.UserLogs(user_name='temp',user_email='[email protected]',activity='checking
scheduler')
return 'inserted'
except:
return 'failed'
scheduler = Scheduler(db, dict(auto_insert=auto_insert))
And I run the scheduler tasks as
[taship@taship web2py]$ python web2py.py -K taportaltest
web2py Web Framework
Created by Massimo Di Pierro, Copyright 2007-2016
Version 2.9.11-stable+timestamp.2014.09.15.23.35.11
Database drivers available: SQLite(sqlite3), MySQL(pymysql),
PostgreSQL(pg8000), MSSQL(pyodbc), DB2(pyodbc), Teradata(pyodbc),
Ingres(pyodbc), IMAP(imaplib)
starting single-scheduler for "taportaltest"...
Then I use the appadmin to start the background tasks.
Application Name:
Task Name:
Group Name:
Status: QUEUEDRUNNINGCOMPLETEDFAILEDTIMEOUTSTOPPEDEXPIRED
Function Name: auto_insert
Uuid:
Args:
Vars:
Enabled:
Start Time:
Next Run Time:
Stop Time:
Repeats: 0=unlimited
Retry Failed: -1=unlimited
Period: seconds
Prevent Drift: Cron-like start_times between runs
Timeout: seconds
Sync Output: update output every n sec: 0=never
Times Run:
Times Failed:
Last Run Time:
Assigned Worker Name:
and things seem to be fine...
scheduler_run.id
<http://localhost:8001/taportaltest/appadmin/select/db?orderby=scheduler_run.id>
scheduler_run.task_id
<http://localhost:8001/taportaltest/appadmin/select/db?orderby=scheduler_run.task_id>
scheduler_run.status
<http://localhost:8001/taportaltest/appadmin/select/db?orderby=scheduler_run.status>
scheduler_run.start_time
<http://localhost:8001/taportaltest/appadmin/select/db?orderby=scheduler_run.start_time>
scheduler_run.stop_time
<http://localhost:8001/taportaltest/appadmin/select/db?orderby=scheduler_run.stop_time>
scheduler_run.run_output
<http://localhost:8001/taportaltest/appadmin/select/db?orderby=scheduler_run.run_output>
scheduler_run.run_result
<http://localhost:8001/taportaltest/appadmin/select/db?orderby=scheduler_run.run_result>
scheduler_run.traceback
<http://localhost:8001/taportaltest/appadmin/select/db?orderby=scheduler_run.traceback>
scheduler_run.worker_name
<http://localhost:8001/taportaltest/appadmin/select/db?orderby=scheduler_run.worker_name>
6 <http://localhost:8001/taportaltest/appadmin/update/db/scheduler_run/6>
auto-insert
<http://localhost:8001/taportaltest/appadmin/update/db/scheduler_task/2>
COMPLETED 2016-05-28 16:18:47 2016-05-28 16:18:47 "inserted" None
taship.iiit.a...
7 <http://localhost:8001/taportaltest/appadmin/update/db/scheduler_run/7>
auto-insert
<http://localhost:8001/taportaltest/appadmin/update/db/scheduler_task/2>
COMPLETED 2016-05-28 16:19:06 2016-05-28 16:19:07 "inserted" None
taship.iiit.a...
8 <http://localhost:8001/taportaltest/appadmin/update/db/scheduler_run/8>
auto-insert
<http://localhost:8001/taportaltest/appadmin/update/db/scheduler_task/2>
COMPLETED 2016-05-28 16:19:22 2016-05-28 16:19:22 "inserted" None
taship.iiit.a...
9 <http://localhost:8001/taportaltest/appadmin/update/db/scheduler_run/9>
auto-insert
<http://localhost:8001/taportaltest/appadmin/update/db/scheduler_task/2>
COMPLETED 2016-05-28 16:19:38 2016-05-28 16:19:40 "inserted" None
taship.iiit.a...
10 <http://localhost:8001/taportaltest/appadmin/update/db/scheduler_run/10>
auto-insert
<http://localhost:8001/taportaltest/appadmin/update/db/scheduler_task/2>
COMPLETED 2016-05-28 16:19:55 2016-05-28 16:19:56 "inserted" None
But the database (db.UserLogs) is not being updated :/
What am I missing here? Do I need to specifically import the database
classes into scheduler.py?
Regards,
Mohit
On Thursday, February 25, 2016 at 1:41:04 PM UTC+5:30, Niphlod wrote:
>
> if anyone wants to familiarize with the scheduler, I always recommend
> https://github.com/niphlod/w2p_scheduler_tests
> <https://www.google.com/url?q=https%3A%2F%2Fgithub.com%2Fniphlod%2Fw2p_scheduler_tests&sa=D&sntz=1&usg=AFQjCNEmvCBDd7yA9iLv9ZtUdQkrJ5QMvQ>
>
--
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.
