I created like in the book. It's a model. I'm scheduling from the database
administrative interface. 2 days ago worked perfectly! I don't know!
Il 06 feb 2018 9:05 PM, "Dave S" <snidely....@gmail.com> ha scritto:
>
>
> On Tuesday, February 6, 2018 at 7:58:15 AM UTC-8, Andrea Fae' wrote:
>>
>> Hello, days ago I started to use scheduler and all was working very well.
>> I could see db.scheduler_run.task_id lines in the db with all the results
>> and console.
>>
>> Now the scheduler works very well but I don't see nothing in the
>> table db.scheduler_run.task_id. Why? Talk completed without problems...
>>
>
> I don't know. My scheduler_run rows all show a task_id. I have more than
> 2500 runs since switching to 2.15.4 (minimum of 3 runs a day). I had 1900+
> runs under 2.14.6.
>
>
>> This is my routine (from the moment I tried to use AppConfig - now is
>> commented - I noted no lines in the table above...)
>>
>>
> Where does this code live? In a model file, a module, or ??
>
> How do you schedule it?
>
>
>
>> def chiusura_automatica_ticket():
>> esito = False
>> # questa è la data odierna
>> todate = datetime.date.today()
>> # print 'todate = ', todate
>>
>> # carico da appconfig.ini il numero di giorni lavorativi in cui lo
>> scehdulature chiude in automatico le richieste di intervento
>> # mycustom_conf = AppConfig()
>> # questo è il delta in giorni lavorativi indietro
>> # giorni_da_apertura = mycustom_conf.get('custom.auto
>> matic_ticket_closing')
>> giorni_da_apertura = 30
>> print giorni_da_apertura
>>
>> # questa è la data di partenza
>> fromdate = date_by_subtract_business_days(todate,giorni_da_apertura)
>> # print 'fromdate = ',fromdate
>>
>> # seleziono i ticket prima della data "fromdate" che non siano ancora
>> chiusi
>> query = (db.ticket.created_on < fromdate) & (db.ticket.chiuso ==
>> False)
>> db(query).update(chiuso = True, risoluzione = 'CHIUSO
>> AUTOMATICAMENTE')
>> # commit necessaria
>> esito = db.commit()
>> return esito
>>
>
>
> /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 a topic in the
> Google Groups "web2py-users" group.
> To unsubscribe from this topic, visit https://groups.google.com/d/
> topic/web2py/Xjtf3rRBZyU/unsubscribe.
> To unsubscribe from this group and all its topics, send an email to
> web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
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.
