no. On Thursday, August 28, 2014 10:26:42 AM UTC+2, Prasad Muley wrote: > > Okay. > I am using 2.3 . I can't upgrade it because Company decided to use 2.3 > only. > Is there anyway to access current task id in 2.3? > > > > On Thu, Aug 28, 2014 at 1:47 PM, Niphlod <nip...@gmail.com <javascript:>> > wrote: > >> what version are you using ?! W2P_TASK is available from 2.4.1. >> >> >> On Thursday, August 28, 2014 9:30:28 AM UTC+2, Prasad Muley wrote: >> >>> Hi Niphlod, >>> I need to get current task's id. I saw your sample scheduler >>> example on niphlod_w2p_scheduler_tests >>> <https://github.com/niphlod/w2p_scheduler_tests/blob/master/models/scheduler.py> >>> I did it in same way but got error. >>> >>> >>> >>> *#models/scheduler.py* >>> def send_mail(to, subject, message, cc=None, bcc=None, >>> attachments=None): >>> """ >>> This module is called by scheduler. >>> mail is queued by scheduler. >>> """ >>> if cc is None: >>> cc = [] >>> if bcc is None: >>> bcc = [] >>> if attachments is None: >>> attachments = [] >>> #sending mail >>> print W2P_TASK >>> result= mail.send(to=to, cc=cc, bcc=bcc, >>> subject=subject, message=message, >>> attachments=attachments) >>> >>> #if not result: >>> # print "FAILED: Task [%d]" % W2P_TASK.id >>> ### update tasks' status >>> >>> >>> from gluon.scheduler import Scheduler >>> mail_scheduler = Scheduler(db, migrate=False) >>> >>> >>> I got following error >>> >>> DEBUG:web2py.scheduler: new task report: FAILED >>> DEBUG:web2py.scheduler: traceback: Traceback (most recent call last): >>> File "/home/prasad/Rootpy/web2py 2.3/gluon/scheduler.py", line 229, in >>> executor >>> result = dumps(_function(*args, **vars)) >>> File "applications/lcm/models/scheduler.py", line 16, in send_mail >>> print W2P_TASK >>> NameError: global name 'W2P_TASK' is not defined >>> >>> >>> >>> if mail.send() fails due to some issue [for eg wrong password, port etc] >>> Still web2py scheduler mark current task as COMPLETED. >>> >>> That's why I want to check mail.send's result. >>> If result is False then I've to update current task's status as Failed. >>> How do I get id of current task? >>> >>> Thanks in advance. >>> >>> >>> On Tue, Aug 26, 2014 at 3:46 PM, Niphlod <nip...@gmail.com> wrote: >>> >>>> I'd strongly advise you to read the section on the book about >>>> migrations and fixing broke migrations. >>>> If you're starting now with the scheduler, please do the following: >>>> - delete all databases/*_scheduler_*.table files >>>> - delete scheduler_worker, scheduler_tasks, scheduler_run table from >>>> your backend MANUALLY >>>> - use Scheduler(db, ...., migrate=True) >>>> - open appadmin >>>> - reset Scheduler(db, ...., migrate=False) >>>> >>>> >>>> On Tuesday, August 26, 2014 11:18:25 AM UTC+2, Prasad Muley wrote: >>>> >>>>> Hi, >>>>> I tried to access db.scheduler_run table but it is giving me >>>>> following error in web2py shell and app admin UI. >>>>> >>>>> *OperationalError: (1054, "Unknown column >>>>> 'scheduler_run.scheduler_task' in 'field list'")* >>>>> >>>>> >>>>> On Tue, Aug 26, 2014 at 1:04 PM, Niphlod <nip...@gmail.com> wrote: >>>>> >>>>>> there's yet a scheduler_task table in the database. Fix migrations >>>>>> in the usual way, or set Scheduler(db,....,migrate=False) to avoid >>>>>> the error. >>>>>> >>>>>> >>>>>> On Tuesday, August 26, 2014 8:58:06 AM UTC+2, Prasad Muley wrote: >>>>>>> >>>>>>> Hi, >>>>>>> I've web2py 2.3 version. I tried to use scheduler for mail >>>>>>> sending. >>>>>>> I got this error while creating a worker for scheduler >>>>>>> >>>>>>> $ python web2py.py -K send_mail_app >>>>>>> >>>>>>> >>>>>>> [12:07:02] >>>>>>> web2py Web Framework >>>>>>> Created by Massimo Di Pierro, Copyright 2007-2014 >>>>>>> Version 2.3.2 (2012-12-17 15:03:30) stable >>>>>>> Database drivers available: SQLite(sqlite2), SQLite(sqlite3), >>>>>>> MySQL(pymysql), MySQL(MySQLdb), PostgreSQL(psycopg2), >>>>>>> PostgreSQL(pg8000), >>>>>>> MSSQL(pyodbc), DB2(pyodbc), Teradata(pyodbc), IMAP(imaplib) >>>>>>> starting single-scheduler for "send_mail_app"... >>>>>>> Traceback (most recent call last): >>>>>>> File "/home/prasad/Rootpy/web2py 2.3/gluon/restricted.py", line >>>>>>> 212, in restricted >>>>>>> exec ccode in environment >>>>>>> File "applications/send_mail_app/models/scheduler.py", line 2, in >>>>>>> <module> >>>>>>> mail_scheduler = Scheduler(db) >>>>>>> File "/home/prasad/Rootpy/web2py 2.3/gluon/scheduler.py", line >>>>>>> 449, in __init__ >>>>>>> self.define_tables(db, migrate=migrate) >>>>>>> File "/home/prasad/Rootpy/web2py 2.3/gluon/scheduler.py", line >>>>>>> 501, in define_tables >>>>>>> migrate=migrate, format='%(task_name)s') >>>>>>> File "/home/prasad/Rootpy/web2py 2.3/gluon/dal.py", line 7186, in >>>>>>> define_table >>>>>>> table = self.lazy_define_table(tablename,*fields,**args) >>>>>>> File "/home/prasad/Rootpy/web2py 2.3/gluon/dal.py", line 7222, in >>>>>>> lazy_define_table >>>>>>> polymodel=polymodel) >>>>>>> File "/home/prasad/Rootpy/web2py 2.3/gluon/dal.py", line 935, in >>>>>>> create_table >>>>>>> self.create_sequence_and_triggers(query,table) >>>>>>> File "/home/prasad/Rootpy/web2py 2.3/gluon/dal.py", line 1694, in >>>>>>> create_sequence_and_triggers >>>>>>> self.execute(query) >>>>>>> File "/home/prasad/Rootpy/web2py 2.3/gluon/dal.py", line 1709, in >>>>>>> execute >>>>>>> return self.log_execute(*a, **b) >>>>>>> File "/home/prasad/Rootpy/web2py 2.3/gluon/dal.py", line 1703, in >>>>>>> log_execute >>>>>>> ret = self.cursor.execute(*a, **b) >>>>>>> File "/usr/local/lib/python2.7/dist-packages/MySQLdb/cursors.py", >>>>>>> line 201, in execute >>>>>>> self.errorhandler(self, exc, value) >>>>>>> File "/usr/local/lib/python2.7/dist-packages/MySQLdb/connections.py", >>>>>>> line 36, in defaulterrorhandler >>>>>>> raise errorclass, errorvalue >>>>>>> OperationalError: (1050, "Table 'scheduler_task' already exists") >>>>>>> >>>>>>> I've followed following instructions. >>>>>>> >>>>>>> *1) Created a file models/scheduler.py* >>>>>>> >>>>>>> #code from scheduler.py file >>>>>>> from gluon.scheduler import Scheduler >>>>>>> mail_scheduler = Scheduler(db) >>>>>>> >>>>>>> >>>>>>> def send_mail(to, subject, message, cc=None, bcc=None, >>>>>>> attachments=None): >>>>>>> """ >>>>>>> This module is called by scheduler. >>>>>>> You can check scheduler_task table and scheduler.task_status >>>>>>> table >>>>>>> """ >>>>>>> if cc is None: >>>>>>> cc = [] >>>>>>> if bcc is None: >>>>>>> bcc = [] >>>>>>> if attachments is None: >>>>>>> attachments = [] >>>>>>> #sending mail >>>>>>> mail.send(to=to, cc=cc, bcc=bcc, >>>>>>> subject=subject, message=message, >>>>>>> attachments=attachments) >>>>>>> >>>>>>> *2) Called send_mail module in an external script.* >>>>>>> (scripts/send_mails.py) >>>>>>> >>>>>>> #extra code here >>>>>>> task = mail_scheduler.queue_task('send_mail', >>>>>>> pvars={'to': email, >>>>>>> 'subject': >>>>>>> subject, >>>>>>> 'message': >>>>>>> html_email}, >>>>>>> >>>>>>> start_time=datetime.datetime.now()) >>>>>>> print task >>>>>>> >>>>>>> >>>>>>> *3) Created a worker and got above error* >>>>>>> >>>>>>> >>>>>>> Am I missing some steps? >>>>>>> >>>>>> -- >>>>>> 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 a topic in >>>>>> the Google Groups "web2py-users" group. >>>>>> To unsubscribe from this topic, visit https://groups.google.com/d/to >>>>>> pic/web2py/gx5o0vAGXQQ/unsubscribe. >>>>>> To unsubscribe from this group and all its topics, send an email to >>>>>> web2py+un...@googlegroups.com. >>>>>> >>>>>> For more options, visit https://groups.google.com/d/optout. >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> Thanks and Regards >>>>> Prasad M. Muley >>>>> Programmer at One Delta Synergies Pvt Ltd. | PICT 2013 >>>>> >>>>> “Pretty much everything on the web uses those two things: *C* and >>>>> *UNIX*,” - Dennis Ritchie >>>>> *http://www.cs.bell-labs.com/who/dmr/* >>>>> <http://www.cs.bell-labs.com/who/dmr/> >>>>> >>>> -- >>>> 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 a topic in the >>>> Google Groups "web2py-users" group. >>>> To unsubscribe from this topic, visit https://groups.google.com/d/ >>>> topic/web2py/gx5o0vAGXQQ/unsubscribe. >>>> To unsubscribe from this group and all its topics, send an email to >>>> web2py+un...@googlegroups.com. >>>> For more options, visit https://groups.google.com/d/optout. >>>> >>> >>> >>> >>> -- >>> Thanks and Regards >>> Prasad M. Muley >>> Programmer at One Delta Synergies Pvt Ltd. | PICT 2013 >>> >>> “Pretty much everything on the web uses those two things: *C* and *UNIX*,” >>> - Dennis Ritchie >>> *http://www.cs.bell-labs.com/who/dmr/* >>> <http://www.cs.bell-labs.com/who/dmr/> >>> >> -- >> 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 a topic in the >> Google Groups "web2py-users" group. >> To unsubscribe from this topic, visit >> https://groups.google.com/d/topic/web2py/gx5o0vAGXQQ/unsubscribe. >> To unsubscribe from this group and all its topics, send an email to >> web2py+un...@googlegroups.com <javascript:>. >> For more options, visit https://groups.google.com/d/optout. >> > > > > -- > Thanks and Regards > Prasad M. Muley > Programmer at One Delta Synergies Pvt Ltd. | PICT 2013 > > “Pretty much everything on the web uses those two things: *C* and *UNIX*,” > - Dennis Ritchie > *http://www.cs.bell-labs.com/who/dmr/* > <http://www.cs.bell-labs.com/who/dmr/> >
-- 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 web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
