Can't access scheduler_task table ['DAL' object has no attribute 'scheduler_task']

[Marty Jones]

I'm defining some functions in the modules folder that need to access and insert rows into the db. in the controller, I define "current.db = db" then in the module I import the db as seen below.

I define the function below and attempt to import it and queue it up using Scheduler, but receive "'DAL' object has no attribute 'scheduler_task'". What am I missing?

#!/usr/bin/env python

# -*- coding: utf-8 -*-

from gluon import *

from gluon import current

def insert_task():

    db = current.db

    db.scheduler_task.insert(status = 'QUEUED',

                             application_name = 'my_application/default',

                             task_name = 'download',

                             group_name = 'scrape',

                             function_name = 'download',

                             args = '[]',

                             vars = '{}',

                             enabled = True,

                             start_time = request.now,

                             timeout = 500,

                             )

[Dave S]

Have you instantiated the scheduler elsewhere?  I don't think the tables exist until the first time you do, and it's not worth the effort to create your own table def and try to get all the fields to match.

/dps

 

[Marty Jones]

I seem to have resolved it by switching "db = current.db" to "db = current.globalenv['db']"

[Niphlod]

why don't you use queue_task() ?

[Marty Jones]

how would I import the scheduler into a module to do that?

[Niphlod]

how did you "import" the database ? referencing a "current"... same applies to the scheduler