aioodbc 0.0.1

ODBC driver for asyncio.

aioodbc is Python module that makes possible accessing ODBC databases with asyncio. It is rely on awesome pyodbc library, preserve same look and feel.

Basic Example

aioodbc based on pyodbc , and provides same api, you just need to use yield from conn.f() or await conn.f() instead of just call conn.f() for every method.

Properties are unchanged, so conn.prop is correct as well as conn.prop = val.

import asyncio
import aioodbc


loop = asyncio.get_event_loop()


@asyncio.coroutine
def test_example():
    dsn = 'Driver=SQLite;Database=sqlite.db'
    conn = yield from aioodbc.connect(dsn=dsn, loop=loop)

    cur = yield from conn.cursor()
    yield from cur.execute("SELECT 42;")
    r = yield from cur.fetchall()
    print(r)
    yield from cur.close()
    yield from conn.close()

loop.run_until_complete(test_example())

Connection Pool

Connection pooling ported from aiopg and rely on PEP492 features:

import asyncio
import aioodbc


loop = asyncio.get_event_loop()


async def test_pool():
    dsn = 'Driver=SQLite;Database=sqlite.db'
    pool = await aioodbc.create_pool(dsn=dsn, loop=loop)

    async with (await pool) as conn:
        cur = await conn.cursor()
        await cur.execute("SELECT 42;")
        r = await cur.fetchall()
        print(r)
        await cur.close()
        await conn.close()
    pool.close()
    await pool.wait_closed()

loop.run_until_complete(test_example())

Installation

pip3 install git+https://github.com/jettify/aioodbc.git

In Linux environment pyodbc (hence aioodbc) requires unixODBC library. You can use standard one from your distro like:

$ sudo apt-get install unixodbc
$ sudo apt-get install unixodbc-dev

Other SQL Drivers

• aiopg - asyncio client for PostgreSQL

• aiomysql - asyncio client form MySQL

Requirements

• Python 3.3+

• asyncio or Python 3.4+

• pyodbc

Changes