blob: 3f6f95fd452890fa4c2354e8043af282c8579af1 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
|
"""
Example demonstrating use of the asynchronous scheduler with persistence via MySQL or
MariaDB in a simple asyncio app.
Requires the "mysql" service to be running.
To install prerequisites: pip install sqlalchemy asyncmy
To run: python async_postgres.py
It should print a line on the console on a one-second interval.
"""
from __future__ import annotations
from asyncio import run
from datetime import datetime
from sqlalchemy.ext.asyncio import create_async_engine
from apscheduler.datastores.async_sqlalchemy import AsyncSQLAlchemyDataStore
from apscheduler.schedulers.async_ import AsyncScheduler
from apscheduler.triggers.interval import IntervalTrigger
def tick():
print("Hello, the time is", datetime.now())
async def main():
engine = create_async_engine(
"mysql+asyncmy://root:secret@localhost/testdb?charset=utf8mb4"
)
data_store = AsyncSQLAlchemyDataStore(engine)
async with AsyncScheduler(data_store) as scheduler:
await scheduler.add_schedule(tick, IntervalTrigger(seconds=1), id="tick")
await scheduler.wait_until_stopped()
run(main())
|