Sure, here is the complete scheduler.py file:
My main DB is db, the DB with the scheduler tables is db_sc.
# -*- coding: utf-8 -*-
def e_db():
today = datetime.datetime.today()
file_name = '%s_%s_%s_%s_%s:%s.csv' % (request.application, today.day,
today.month, today.year, today.hour, today.minute)
file_url = '%s/static/z_backup/csv/%s' % (request.folder, file_name)
db.export_to_csv_file(open(file_url, 'wb'))
subject = 'Backup CSV %s' % request.application
message = 'Il backup CSV di %s è stato salvato in %s.' %
(request.application, file_url)
'''email_sent = mail.send(
to = 'm...@domain.com',
subject = subject,
reply_to = 'm...@domain.com',
message = message)'''
db.commit()
def sitemap_txt_auto():
import os
from gluon.myregex import regex_expose
# Statics URLs
exclusions =
['make_slugs','get_fabbisogno','e_db','get_cart','get_product_cart','test_query','carrellon','ordine_verifican','order_sendn','brands',
'cart_qty', 'cart_weight', 'carrello', 'ordine_verifica',
'ordine_modifica_indirizzo', 'order_send', 'e_deb', 'fuzz',
'googleaf365ee20ab65216', 'insert_product_enquiry',
'insert_service_enquiry', 'prodotto', 'attivita_fattoria_didattica',
'test', 'edit', 'user','unsubscribe','sitemap_txt','download', 'call',
'data', 'upload', 'browse', 'delete']
ctldir = os.path.join(request.folder,"controllers")
ctls=os.listdir(ctldir)
if 'appadmin.py' in ctls: ctls.remove('appadmin.py')
if 'manage.py' in ctls: ctls.remove('manage.py')
if 'admin.py' in ctls: ctls.remove('admin.py')
if 'prod.py' in ctls: ctls.remove('prod.py')
if 'default.py.1' in ctls: ctls.remove('default.py.1')
sitemap='https://www.sitedomain.com'
for ctl in ctls:
if ctl.endswith(".bak") == False:
filename = os.path.join(ctldir,ctl)
data = open(filename, 'r').read()
functions = regex_expose.findall(data)
for f in functions:
if not any(f in s for s in exclusions): # if function is
not in exclustions
sitemap += '\r\n'
sitemap += 'https://www.sitedomain.com/%s' % (f)
# Dynamic URLs
# News
news = db(db.news.on_line == True).select(db.news.ALL)
for item in news:
sitemap += '\r\n'
sitemap += 'https://www.sitedomain.com/news?id=%s' % (str(item.id))
# Products
products = db(db.products.on_line == True).select(db.products.ALL)
for item in products:
sitemap += '\r\n'
sitemap += 'https://www.sitedomain.com/prodotti?product_id=' +
(str(item.id)) + '&product_slug=' + item.product_slug
# Categories
sitemap += '\r\n'
sitemap += 'https://www.sitedomain.com /prodotti?category_id=0'
categories = db().select(db.products_categories.ALL)
for item in categories:
sitemap += '\r\n'
sitemap += 'https://www. sitedomain.com /prodotti?category_id=%s' %
(str(item.id))
# Servizi
services = db().select(db.services.ALL)
for item in services:
sitemap += '\r\n'
sitemap +=
'https://www.sitedomain.com/attivita_fattoria_didattica?id=%s' %
(str(item.id))
file = open('%s/static/sitemap.txt' %request.folder, 'w')
file.write(sitemap)
file.close()
file = open('%s/static/sitemaps/sitemap.txt' %request.folder, 'w')
file.write(sitemap)
file.close()
"""email_sent = mail.send(
to = 'm...@domain.com',
subject = 'Sitemap',
reply_to = 'm...@domain.com',
message = 'La sitemap è stata generata con
successo.')"""
db.commit()
from gluon.scheduler import Scheduler
Scheduler(db_sc,dict(e_db=e_db, sitemap_txt_auto=sitemap_txt_auto))
Il giorno giovedì 12 novembre 2020 alle 10:58:48 UTC+1 snide...@gmail.com
ha scritto:
>
>
> On Wednesday, November 11, 2020 at 11:17:21 PM UTC-8, Gaël Princivalle
> wrote:
>>
>> Running it without nohup I can see this error. How can I debug that?
>> This app was running first on Web2py 2.14.16 and now it runs on the
>> 2.20.4 version.
>>
>> ~/apps/web2py_folder2/env/bin/python
>> ~/apps/web2py_folder2/web2py/web2py.py -K myapp2
>>
>> Traceback (most recent call last): File
>> "apps/web2py_folder2/web2py/web2py.py", line 41, in <module> import
>> gluon.widget File "/home/user/apps/web2py_folder2/web2py/gluon/widget.py",
>> line 27, in <module> from gluon.shell import die, run, test File
>> "/home/user/apps/web2py_folder2/web2py/gluon/shell.py", line 285
>> exec(read_pyc(pycfile), _env) SyntaxError: unqualified exec is not allowed
>> in function 'run' it contains a nested function with free variables
>>
>>>
>>>>>
> I'm guessing you have something different in how you've defined the
> scheduler routines, since it works for one case and not the other. That
> doesn't mean the web2py code doesn't have a problem, but it does mean the
> problem isn't in the path of the working case.
>
> Can you show some of your models/scheduler.py code?
>
> /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 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.
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/4d70fafa-4d87-4f9c-98a7-786e8800d711n%40googlegroups.com.
