import asyncio
import os
from concurrent.futures import ThreadPoolExecutor

import pytest
import aioodbc


@pytest.fixture
def loop(request):
    old_loop = asyncio.get_event_loop()
    loop = asyncio.new_event_loop()
    asyncio.set_event_loop(None)

    def fin():
        loop.close()
        asyncio.set_event_loop(old_loop)

    request.addfinalizer(fin)
    return loop


@pytest.fixture
def executor(request):
    executor = ThreadPoolExecutor(max_workers=3)

    def fin():
        executor.shutdown()

    request.addfinalizer(fin)
    return executor


sqlite = 'Driver=SQLite;Database=sqlite.db,'
pg = ('Driver=PostgreSQL Unicode;'
      'Server=localhost;Port=5432;'
      'Database=aioodbc;Uid=aioodbc;'
      'Pwd=passwd;')
mysql = ('Driver=MySQL;Server=localhost;'
         'Database=aioodbc;User=root;'
         'Password=')


def pytest_namespace():
    return {'dsn_list': [sqlite, pg],
            'pg': pg, 'sqlite': sqlite, 'mysql': mysql}


@pytest.fixture
def dsn(request):
    conf = os.environ.get('DSN', 'Driver=SQLite;Database=sqlite.db')
    return conf


@pytest.fixture
def conn(request, loop, dsn):
    return _connect(loop, dsn, request.addfinalizer)


@pytest.fixture
def connection_maker(request, dsn):
    def f(loop, **kw):
        return _connect(loop, dsn, request.addfinalizer, **kw)
    return f


@pytest.fixture
def pool_maker(request):
    def f(loop, **kw):
        return _connect_pool(loop, request.addfinalizer, **kw)
    return f


def _connect_pool(loop, finalizer, **kw):
    pool = loop.run_until_complete(aioodbc.create_pool(loop=loop, **kw))

    def fin():
        pool.close()
        loop.run_until_complete(pool.wait_closed())

    finalizer(fin)
    return pool


@pytest.fixture
def pool(request, loop, dsn):
    return _connect_pool(loop, request.addfinalizer, dsn=dsn)


def _connect(loop, dsn, finalizer, **kw):
    conn = loop.run_until_complete(aioodbc.connect(dsn=dsn, loop=loop, **kw))

    def fin():
        loop.run_until_complete(conn.close())

    finalizer(fin)
    return conn


@pytest.mark.tryfirst
def pytest_pycollect_makeitem(collector, name, obj):
    if collector.funcnamefilter(name):
        item = pytest.Function(name, parent=collector)
        if 'run_loop' in item.keywords:
            return list(collector._genfunctions(name, obj))


@pytest.mark.tryfirst
def pytest_pyfunc_call(pyfuncitem):
    """
    Run asyncio marked test functions in an event loop instead of a normal
    function call.
    """
    if 'run_loop' in pyfuncitem.keywords:
        funcargs = pyfuncitem.funcargs
        loop = funcargs['loop']
        testargs = {arg: funcargs[arg]
                    for arg in pyfuncitem._fixtureinfo.argnames}

        if not asyncio.iscoroutinefunction(pyfuncitem.obj):
            func = asyncio.coroutine(pyfuncitem.obj)
        else:
            func = pyfuncitem.obj
        loop.run_until_complete(func(**testargs))
        return True


def pytest_runtest_setup(item):
    if 'run_loop' in item.keywords and 'loop' not in item.fixturenames:
        # inject an event loop fixture for all async tests
        item.fixturenames.append('loop')


@pytest.fixture
def table(request, conn, loop):

    async def go():
        cur = await conn.cursor()

        await cur.execute("CREATE TABLE t1(n INT, v VARCHAR(10));")
        await cur.execute("INSERT INTO t1 VALUES (1, '123.45');")
        await cur.execute("INSERT INTO t1 VALUES (2, 'foo');")
        await conn.commit()
        await cur.close()

    async def drop_table():
        cur = await conn.cursor()
        await cur.execute("DROP TABLE t1;")
        await cur.commit()
        await cur.close()

    def fin():
        loop.run_until_complete(drop_table())

    request.addfinalizer(fin)

    loop.run_until_complete(go())
    return 't1'

@@ -895,16 +895,23 @@
 lite, pg
+, mysql
 %5D,%0A     

add mysql to test suite