Flask-DBPacemaker 1.2.0

Hook db connection when you're running a long term sleep crawler assignment.

Flask Database Pacemaker

python_requires>=3.6 Flask>=1.0.2 Flask-APScheduler>=1.11.0 Flask-SQLAlchemy>=2.3.2

- How to use

1. Set confing.py

DB_PACEMAKER_SWITCH is required MODELS_PATH_LIST is required POKE_DB_INTERVAL default value has _has been set as one hour.

# for DBPacemaker - 透過定時排程請求DB，保持連線
DB_PACEMAKER_SWITCH = True if os.environ['ENVIRONMENT'] == 'develop' else False
MODELS_PATH_LIST = ['spyder_common.models']
POKE_DB_INTERVAL = 60 * 60

2. Import package at app.py

from flask_dbpacemaker import DBPacemaker

• Append this after you declared config and app

DBPacemaker.run(app, db=db, config=config)

• If you got a exist scheduler, you have to add it like this.

DBPacemaker.run(app, db=db, config=config, display=True, secheduler=secheduler)

Note: The job permanent trigger is 'interval'.

Cheers! 🎉