aiopgPython 的 PostgreSQL 异步驱动
aiopg 是一个使用 asyncio (PEP-3156/tulip) 框架开发的用来访问 PostgreSQL 数据库的 Python 开发库,封装了基于 Psycopg 数据库驱动程序的异步特性。
示例代码:
import asyncio
from aiopg.pool import create_pool
dsn = 'dbname=jetty user=nick password=1234 host=localhost port=5432'
@asyncio.coroutine
def test_select():
pool = yield from create_pool(dsn)
with (yield from pool) as conn:
cur = yield from conn.cursor()
yield from cur.execute('SELECT 1')
ret = yield from cur.fetchone()
assert ret == (1,), ret
asyncio.get_event_loop().run_until_complete(test_select())评论
