I can see if I create a new app in Webpy 2.20.4 that the db file have this:
if configuration.get('scheduler.enabled'):
from gluon.scheduler import Scheduler
scheduler = Scheduler(db,
heartbeat=configuration.get('scheduler.heartbeat'))
In my db.py file I don't have that, the scheduler is called at the end of
the scheduler.py file and that's all.
How can I adapt my db.py file to that?
In my db.py file I have the connection strin of the db database (main
tables) and the db_sc database (scheduler database):
db = DAL('postgres://myuser:mypassword@localhost:5432/postg_db',
check_reserved=['all'], pool_size=1, entity_quoting=True, bigint_id=True,
migrate=False, fake_migrate_all=False)
db_sc = DAL('postgres://myuser:mypassword@localhost:5432/postg_db_sc',
check_reserved=['all'], pool_size=1, entity_quoting=True, bigint_id=True,
migrate=False, fake_migrate_all=False)
Thanks in advance for your help.
Il giorno giovedì 12 novembre 2020 alle 11:52:32 UTC+1 Gaël Princivalle ha
scritto:
> 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 = '[email protected]',
> subject = subject,
> reply_to = '[email protected]',
> 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 = '[email protected]',
> subject = 'Sitemap',
> reply_to = '[email protected]',
> 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 [email protected]
> 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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/web2py/1f4b4428-8bd4-450d-b2c6-5c121cd58ff8n%40googlegroups.com.
