async def METHOD_NAME(request):
    conn = await aiopg.connect(dsn())
    cur = await conn.METHOD_NAME()
    # we use a finalizer instead of yield, because Python 3.5 throws a syntax error, even if the test doesn't run
    def rollback():
        cur.raw.execute("ROLLBACK")
        cur.close()
        conn.close()
    request.addfinalizer(rollback)
    await cur.execute(
        "BEGIN;"
        "CREATE TABLE test(id int, name VARCHAR(5) NOT NULL);"
        "INSERT INTO test VALUES (1, 'one'), (2, 'two'), (3, 'three');"
    )
    return cur