帮助使用asyncpg与PostgreSQL的listen/notify
项目描述
asyncpg-listen
此库简化了与asyncpg一起使用listen/notify的操作
- 处理连接丢失
- 简化了来自多个通道的通知处理
- 为接收通知设置超时
- 根据ListenPolicy允许接收所有通知/仅接收最后一条通知。
import asyncio
import asyncpg
import asyncpg_listen
async def handle_notifications(notification: asyncpg_listen.NotificationOrTimeout) -> None:
print(f"{notification} has been received")
async def main():
listener = asyncpg_listen.NotificationListener(asyncpg_listen.connect_func(user="postgres"))
listener_task = asyncio.create_task(
listener.run(
{"simple": handle_notifications},
policy=asyncpg_listen.ListenPolicy.LAST,
notification_timeout=5
)
)
await asyncio.sleep(1)
connection = await asyncpg.connect(user="postgres")
try:
for i in range(42):
await connection.execute(f"NOTIFY simple, '{i}'")
finally:
await connection.close()
await asyncio.sleep(1)
listener_task.cancel()
asyncio.run(main())
v0.0.7 (2024-09-07)
v0.0.6 (2022-11-02)
v0.0.5 (2022-05-23)
v0.0.4 (2022-01-24)
v0.0.3 (2022-01-23)
v0.0.2 (2021-11-02)
v0.0.1 (2021-10-27)
- 第一个版本
项目详情
关闭
asyncpg-listen-0.0.7.tar.gz的哈希值
算法 | 哈希摘要 | |
---|---|---|
SHA256 | 33d8c6a69bb20139d143fd9e4035a4627ac76fbea4d874529f99fbb33f0596c5 |
|
MD5 | 600866a71fd334acc3a67da3e1d84127 |
|
BLAKE2b-256 | a215092788b04358374dbff42288497f1acf6957aaa63267dda55bfda6d8b4c9 |
关闭
asyncpg_listen-0.0.7-py3-none-any.whl的哈希值
算法 | 哈希摘要 | |
---|---|---|
SHA256 | 6adb7a3394dbedd97ccd51109835cfd8cef6bd3c419387cf2eb8d9816c77361c |
|
MD5 | b5cc56abe0aa7de9140d55470c83ae2c |
|
BLAKE2b-256 | a8efee0e57219a04616d8c133a4602f805edadf64b95ba61f53fea1284948ba8 |