aiopg


Nameaiopg JSON
Version 1.4.0 PyPI version JSON
download
home_pagehttps://aiopg.readthedocs.io
SummaryPostgres integration with asyncio.
upload_time2022-10-26 09:31:49
maintainerAndrew Svetlov <andrew.svetlov@gmail.com>, Alexey Firsov <virmir49@gmail.com>, Alexey Popravka <alexey.popravka@horsedevel.com>, Yury Pliner <yury.pliner@gmail.com>
docs_urlNone
authorAndrew Svetlov
requires_python>=3.7
licenseBSD
keywords
VCS
bugtrack_url
requirements No requirements were recorded.
Travis-CI No Travis.
coveralls test coverage
            aiopg
=====
.. image:: https://github.com/aio-libs/aiopg/workflows/CI/badge.svg
   :target: https://github.com/aio-libs/aiopg/actions?query=workflow%3ACI
.. image:: https://codecov.io/gh/aio-libs/aiopg/branch/master/graph/badge.svg
   :target: https://codecov.io/gh/aio-libs/aiopg
.. image:: https://badges.gitter.im/Join%20Chat.svg
    :target: https://gitter.im/aio-libs/Lobby
    :alt: Chat on Gitter

**aiopg** is a library for accessing a PostgreSQL_ database
from the asyncio_ (PEP-3156/tulip) framework. It wraps
asynchronous features of the Psycopg database driver.

Example
-------

.. code:: python

    import asyncio
    import aiopg

    dsn = 'dbname=aiopg user=aiopg password=passwd host=127.0.0.1'

    async def go():
        pool = await aiopg.create_pool(dsn)
        async with pool.acquire() as conn:
            async with conn.cursor() as cur:
                await cur.execute("SELECT 1")
                ret = []
                async for row in cur:
                    ret.append(row)
                assert ret == [(1,)]

    loop = asyncio.get_event_loop()
    loop.run_until_complete(go())


Example of SQLAlchemy optional integration
------------------------------------------

.. code:: python

   import asyncio
   from aiopg.sa import create_engine
   import sqlalchemy as sa

   metadata = sa.MetaData()

   tbl = sa.Table('tbl', metadata,
       sa.Column('id', sa.Integer, primary_key=True),
       sa.Column('val', sa.String(255)))

   async def create_table(engine):
       async with engine.acquire() as conn:
           await conn.execute('DROP TABLE IF EXISTS tbl')
           await conn.execute('''CREATE TABLE tbl (
                                     id serial PRIMARY KEY,
                                     val varchar(255))''')

   async def go():
       async with create_engine(user='aiopg',
                                database='aiopg',
                                host='127.0.0.1',
                                password='passwd') as engine:

           async with engine.acquire() as conn:
               await conn.execute(tbl.insert().values(val='abc'))

               async for row in conn.execute(tbl.select()):
                   print(row.id, row.val)

   loop = asyncio.get_event_loop()
   loop.run_until_complete(go())

.. _PostgreSQL: http://www.postgresql.org/
.. _asyncio: https://docs.python.org/3/library/asyncio.html

Please use::

   $ make test

for executing the project's unittests.
See https://aiopg.readthedocs.io/en/stable/contributing.html for details
on how to set up your environment to run the tests.

Changelog
---------

1.4.0 (2022-10-26)
^^^^^^^^^^^^^^^^^^

* Add python 3.11 and drop python 3.6 support` #892 <https://github.com/aio-libs/aiopg/pull/892>`_


1.3.5 (2022-09-25)
^^^^^^^^^^^^^^^^^^

* Fix pool size limit check for unlimited pools `#888 <https://github.com/aio-libs/aiopg/pull/888>`_


1.3.4 (2022-06-30)
^^^^^^^^^^^^^^^^^^


1.3.4b3 (2022-06-29)
^^^^^^^^^^^^^^^^^^^^


1.3.4b2 (2022-06-29)
^^^^^^^^^^^^^^^^^^^^


1.3.4b1 (2022-06-29)
^^^^^^^^^^^^^^^^^^^^

* Fix compatibility with SA 1.4.38 `#891 <https://github.com/aio-libs/aiopg/pull/891>`_
* Add py.typed marker `#878 <https://github.com/aio-libs/aiopg/pull/878>`_


1.3.3 (2021-11-01)
^^^^^^^^^^^^^^^^^^

* Support async-timeout 4.0+


1.3.2 (2021-10-07)
^^^^^^^^^^^^^^^^^^


1.3.2b2 (2021-10-07)
^^^^^^^^^^^^^^^^^^^^

* Respect use_labels for select statement `#882 <https://github.com/aio-libs/aiopg/pull/882>`_


1.3.2b1 (2021-07-11)
^^^^^^^^^^^^^^^^^^^^

* Fix compatibility with SQLAlchemy >= 1.4 `#870 <https://github.com/aio-libs/aiopg/pull/870>`_


1.3.1 (2021-07-08)
^^^^^^^^^^^^^^^^^^


1.3.1b2 (2021-07-06)
^^^^^^^^^^^^^^^^^^^^

* Suppress "Future exception was never retrieved" `#862 <https://github.com/aio-libs/aiopg/pull/862>`_


1.3.1b1 (2021-07-05)
^^^^^^^^^^^^^^^^^^^^

* Fix ClosableQueue.get on cancellation, close it on Connection.close `#859 <https://github.com/aio-libs/aiopg/pull/859>`_


1.3.0 (2021-06-30)
^^^^^^^^^^^^^^^^^^


1.3.0b4 (2021-06-28)
^^^^^^^^^^^^^^^^^^^^

* Fix "Unable to detect disconnect when using NOTIFY/LISTEN" `#559 <https://github.com/aio-libs/aiopg/pull/559>`_


1.3.0b3 (2021-04-03)
^^^^^^^^^^^^^^^^^^^^

* Reformat using black `#814 <https://github.com/aio-libs/aiopg/pull/814>`_


1.3.0b2 (2021-04-02)
^^^^^^^^^^^^^^^^^^^^

* Type annotations `#813 <https://github.com/aio-libs/aiopg/pull/813>`_


1.3.0b1 (2021-03-30)
^^^^^^^^^^^^^^^^^^^^

* Raise ResourceClosedError if we try to open a cursor on a closed SAConnection `#811 <https://github.com/aio-libs/aiopg/pull/811>`_


1.3.0b0 (2021-03-25)
^^^^^^^^^^^^^^^^^^^^

* Fix compatibility with SA 1.4 for IN statement `#806 <https://github.com/aio-libs/aiopg/pull/806>`_


1.2.1 (2021-03-23)
^^^^^^^^^^^^^^^^^^

* Pop loop in connection init due to backward compatibility `#808 <https://github.com/aio-libs/aiopg/pull/808>`_


1.2.0b4 (2021-03-23)
^^^^^^^^^^^^^^^^^^^^

* Set max supported sqlalchemy version `#805 <https://github.com/aio-libs/aiopg/pull/805>`_


1.2.0b3 (2021-03-22)
^^^^^^^^^^^^^^^^^^^^

* Don't run ROLLBACK when the connection is closed `#778 <https://github.com/aio-libs/aiopg/pull/778>`_

* Multiple cursors support `#801 <https://github.com/aio-libs/aiopg/pull/801>`_


1.2.0b2 (2020-12-21)
^^^^^^^^^^^^^^^^^^^^

* Fix IsolationLevel.read_committed and introduce IsolationLevel.default `#770 <https://github.com/aio-libs/aiopg/pull/770>`_

* Fix python 3.8 warnings in tests `#771 <https://github.com/aio-libs/aiopg/pull/771>`_


1.2.0b1 (2020-12-16)
^^^^^^^^^^^^^^^^^^^^

* Deprecate blocking connection.cancel() method `#570 <https://github.com/aio-libs/aiopg/pull/570>`_


1.2.0b0 (2020-12-15)
^^^^^^^^^^^^^^^^^^^^

* Implement timeout on acquiring connection from pool `#766 <https://github.com/aio-libs/aiopg/pull/766>`_


1.1.0 (2020-12-10)
^^^^^^^^^^^^^^^^^^


1.1.0b2 (2020-12-09)
^^^^^^^^^^^^^^^^^^^^

* Added missing slots to context managers `#763 <https://github.com/aio-libs/aiopg/pull/763>`_


1.1.0b1 (2020-12-07)
^^^^^^^^^^^^^^^^^^^^

* Fix on_connect multiple call on acquire `#552 <https://github.com/aio-libs/aiopg/pull/552>`_

* Fix python 3.8 warnings `#622 <https://github.com/aio-libs/aiopg/pull/642>`_

* Bump minimum psycopg version to 2.8.4 `#754 <https://github.com/aio-libs/aiopg/pull/754>`_

* Fix Engine.release method to release connection in any way `#756 <https://github.com/aio-libs/aiopg/pull/756>`_


1.0.0 (2019-09-20)
^^^^^^^^^^^^^^^^^^

* Removal of an asynchronous call in favor of issues # 550

* Big editing of documentation and minor bugs #534


0.16.0 (2019-01-25)
^^^^^^^^^^^^^^^^^^^

* Fix select priority name `#525 <https://github.com/aio-libs/aiopg/issues/525>`_

* Rename `psycopg2` to `psycopg2-binary` to fix deprecation warning `#507 <https://github.com/aio-libs/aiopg/issues/507>`_

* Fix `#189 <https://github.com/aio-libs/aiopg/issues/189>`_ hstore when using ReadDictCursor `#512 <https://github.com/aio-libs/aiopg/issues/512>`_

* close cannot be used while an asynchronous query is underway `#452 <https://github.com/aio-libs/aiopg/issues/452>`_

* sqlalchemy adapter trx begin allow transaction_mode `#498 <https://github.com/aio-libs/aiopg/issues/498>`_


0.15.0 (2018-08-14)
^^^^^^^^^^^^^^^^^^^

* Support Python 3.7 `#437 <https://github.com/aio-libs/aiopg/issues/437>`_


0.14.0 (2018-05-10)
^^^^^^^^^^^^^^^^^^^

* Add ``get_dialect`` func to have ability to pass ``json_serializer`` `#451 <https://github.com/aio-libs/aiopg/issues/451>`_


0.13.2 (2018-01-03)
^^^^^^^^^^^^^^^^^^^

* Fixed compatibility with SQLAlchemy 1.2.0 `#412 <https://github.com/aio-libs/aiopg/issues/412>`_

* Added support for transaction isolation levels `#219 <https://github.com/aio-libs/aiopg/issues/219>`_


0.13.1 (2017-09-10)
^^^^^^^^^^^^^^^^^^^

* Added connection poll recycling logic `#373 <https://github.com/aio-libs/aiopg/issues/373>`_


0.13.0 (2016-12-02)
^^^^^^^^^^^^^^^^^^^

* Add `async with` support to `.begin_nested()` `#208 <https://github.com/aio-libs/aiopg/issues/208>`_

* Fix connection.cancel() `#212 <https://github.com/aio-libs/aiopg/issues/212>`_ `#223 <https://github.com/aio-libs/aiopg/issues/223>`_

* Raise informative error on unexpected connection closing `#191 <https://github.com/aio-libs/aiopg/issues/191>`_

* Added support for python types columns issues `#217 <https://github.com/aio-libs/aiopg/issues/217>`_

* Added support for default values in SA table issues `#206 <https://github.com/aio-libs/aiopg/issues/206>`_


0.12.0 (2016-10-09)
^^^^^^^^^^^^^^^^^^^

* Add an on_connect callback parameter to pool `#141 <https://github.com/aio-libs/aiopg/issues/141>`_

* Fixed connection to work under both windows and posix based systems `#142 <https://github.com/aio-libs/aiopg/issues/142>`_


0.11.0 (2016-09-12)
^^^^^^^^^^^^^^^^^^^

* Immediately remove callbacks from a closed file descriptor `#139 <https://github.com/aio-libs/aiopg/issues/139>`_

* Drop Python 3.3 support


0.10.0 (2016-07-16)
^^^^^^^^^^^^^^^^^^^

* Refactor tests to use dockerized Postgres server `#107 <https://github.com/aio-libs/aiopg/issues/107>`_

* Reduce default pool minsize to 1 `#106 <https://github.com/aio-libs/aiopg/issues/106>`_

* Explicitly enumerate packages in setup.py `#85 <https://github.com/aio-libs/aiopg/issues/85>`_

* Remove expired connections from pool on acquire `#116 <https://github.com/aio-libs/aiopg/issues/116>`_

* Don't crash when Connection is GC'ed `#124 <https://github.com/aio-libs/aiopg/issues/124>`_

* Use loop.create_future() if available


0.9.2 (2016-01-31)
^^^^^^^^^^^^^^^^^^

* Make pool.release return asyncio.Future, so we can wait on it in
  `__aexit__` `#102 <https://github.com/aio-libs/aiopg/issues/102>`_

* Add support for uuid type `#103 <https://github.com/aio-libs/aiopg/issues/103>`_


0.9.1 (2016-01-17)
^^^^^^^^^^^^^^^^^^

* Documentation update `#101 <https://github.com/aio-libs/aiopg/issues/101>`_


0.9.0 (2016-01-14)
^^^^^^^^^^^^^^^^^^

* Add async context managers for transactions `#91 <https://github.com/aio-libs/aiopg/issues/91>`_

* Support async iterator in ResultProxy `#92 <https://github.com/aio-libs/aiopg/issues/92>`_

* Add async with for engine `#90 <https://github.com/aio-libs/aiopg/issues/90>`_


0.8.0 (2015-12-31)
^^^^^^^^^^^^^^^^^^

* Add PostgreSQL notification support `#58 <https://github.com/aio-libs/aiopg/issues/58>`_

* Support pools with unlimited size `#59 <https://github.com/aio-libs/aiopg/issues/59>`_

* Cancel current DB operation on asyncio timeout `#66 <https://github.com/aio-libs/aiopg/issues/66>`_

* Add async with support for Pool, Connection, Cursor `#88 <https://github.com/aio-libs/aiopg/issues/88>`_


0.7.0 (2015-04-22)
^^^^^^^^^^^^^^^^^^

* Get rid of resource leak on connection failure.

* Report ResourceWarning on non-closed connections.

* Deprecate iteration protocol support in cursor and ResultProxy.

* Release sa connection to pool on `connection.close()`.


0.6.0 (2015-02-03)
^^^^^^^^^^^^^^^^^^

* Accept dict, list, tuple, named and positional parameters in
  `SAConnection.execute()`


0.5.2 (2014-12-08)
^^^^^^^^^^^^^^^^^^

* Minor release, fixes a bug that leaves connection in broken state
  after `cursor.execute()` failure.


0.5.1 (2014-10-31)
^^^^^^^^^^^^^^^^^^

* Fix a bug for processing transactions in line.


0.5.0 (2014-10-31)
^^^^^^^^^^^^^^^^^^

* Add .terminate() to Pool and Engine

* Reimplement connection pool (now pool size cannot be greater than pool.maxsize)

* Add .close() and .wait_closed() to Pool and Engine

* Add minsize, maxsize, size and freesize properties to sa.Engine

* Support *echo* parameter for logging executed SQL commands

* Connection.close() is not a coroutine (but we keep backward compatibility).


0.4.1 (2014-10-02)
^^^^^^^^^^^^^^^^^^

* make cursor iterable

* update docs


0.4.0 (2014-10-02)
^^^^^^^^^^^^^^^^^^

* add timeouts for database operations.

* Autoregister psycopg2 support for json data type.

* Support JSON in aiopg.sa

* Support ARRAY in aiopg.sa

* Autoregister hstore support if present in connected DB

* Support HSTORE in aiopg.sa


0.3.2 (2014-07-07)
^^^^^^^^^^^^^^^^^^

* change signature to cursor.execute(operation, parameters=None) to
  follow psycopg2 convention.


0.3.1 (2014-07-04)
^^^^^^^^^^^^^^^^^^

* Forward arguments to cursor constructor for pooled connections.


0.3.0 (2014-06-22)
^^^^^^^^^^^^^^^^^^

* Allow executing SQLAlchemy DDL statements.

* Fix bug with race conditions on acquiring/releasing connections from pool.


0.2.3 (2014-06-12)
^^^^^^^^^^^^^^^^^^

* Fix bug in connection pool.


0.2.2 (2014-06-07)
^^^^^^^^^^^^^^^^^^

* Fix bug with passing parameters into SAConnection.execute when
  executing raw SQL expression.


0.2.1 (2014-05-08)
^^^^^^^^^^^^^^^^^^

* Close connection with invalid transaction status on returning to pool.


0.2.0 (2014-05-04)
^^^^^^^^^^^^^^^^^^

* Implemented optional support for sqlalchemy functional sql layer.


0.1.0 (2014-04-06)
^^^^^^^^^^^^^^^^^^

* Implemented plain connections: connect, Connection, Cursor.

* Implemented database pools: create_pool and Pool.


            

Raw data

            {
    "_id": null,
    "home_page": "https://aiopg.readthedocs.io",
    "name": "aiopg",
    "maintainer": "Andrew Svetlov <andrew.svetlov@gmail.com>, Alexey Firsov <virmir49@gmail.com>, Alexey Popravka <alexey.popravka@horsedevel.com>, Yury Pliner <yury.pliner@gmail.com>",
    "docs_url": null,
    "requires_python": ">=3.7",
    "maintainer_email": "virmir49@gmail.com",
    "keywords": "",
    "author": "Andrew Svetlov",
    "author_email": "andrew.svetlov@gmail.com",
    "download_url": "https://files.pythonhosted.org/packages/b0/0a/aba75a9ffcb1704b98c39986344230eaa70c40ac28e5ca635df231db912f/aiopg-1.4.0.tar.gz",
    "platform": "macOS",
    "description": "aiopg\n=====\n.. image:: https://github.com/aio-libs/aiopg/workflows/CI/badge.svg\n   :target: https://github.com/aio-libs/aiopg/actions?query=workflow%3ACI\n.. image:: https://codecov.io/gh/aio-libs/aiopg/branch/master/graph/badge.svg\n   :target: https://codecov.io/gh/aio-libs/aiopg\n.. image:: https://badges.gitter.im/Join%20Chat.svg\n    :target: https://gitter.im/aio-libs/Lobby\n    :alt: Chat on Gitter\n\n**aiopg** is a library for accessing a PostgreSQL_ database\nfrom the asyncio_ (PEP-3156/tulip) framework. It wraps\nasynchronous features of the Psycopg database driver.\n\nExample\n-------\n\n.. code:: python\n\n    import asyncio\n    import aiopg\n\n    dsn = 'dbname=aiopg user=aiopg password=passwd host=127.0.0.1'\n\n    async def go():\n        pool = await aiopg.create_pool(dsn)\n        async with pool.acquire() as conn:\n            async with conn.cursor() as cur:\n                await cur.execute(\"SELECT 1\")\n                ret = []\n                async for row in cur:\n                    ret.append(row)\n                assert ret == [(1,)]\n\n    loop = asyncio.get_event_loop()\n    loop.run_until_complete(go())\n\n\nExample of SQLAlchemy optional integration\n------------------------------------------\n\n.. code:: python\n\n   import asyncio\n   from aiopg.sa import create_engine\n   import sqlalchemy as sa\n\n   metadata = sa.MetaData()\n\n   tbl = sa.Table('tbl', metadata,\n       sa.Column('id', sa.Integer, primary_key=True),\n       sa.Column('val', sa.String(255)))\n\n   async def create_table(engine):\n       async with engine.acquire() as conn:\n           await conn.execute('DROP TABLE IF EXISTS tbl')\n           await conn.execute('''CREATE TABLE tbl (\n                                     id serial PRIMARY KEY,\n                                     val varchar(255))''')\n\n   async def go():\n       async with create_engine(user='aiopg',\n                                database='aiopg',\n                                host='127.0.0.1',\n                                password='passwd') as engine:\n\n           async with engine.acquire() as conn:\n               await conn.execute(tbl.insert().values(val='abc'))\n\n               async for row in conn.execute(tbl.select()):\n                   print(row.id, row.val)\n\n   loop = asyncio.get_event_loop()\n   loop.run_until_complete(go())\n\n.. _PostgreSQL: http://www.postgresql.org/\n.. _asyncio: https://docs.python.org/3/library/asyncio.html\n\nPlease use::\n\n   $ make test\n\nfor executing the project's unittests.\nSee https://aiopg.readthedocs.io/en/stable/contributing.html for details\non how to set up your environment to run the tests.\n\nChangelog\n---------\n\n1.4.0 (2022-10-26)\n^^^^^^^^^^^^^^^^^^\n\n* Add python 3.11 and drop python 3.6 support` #892 <https://github.com/aio-libs/aiopg/pull/892>`_\n\n\n1.3.5 (2022-09-25)\n^^^^^^^^^^^^^^^^^^\n\n* Fix pool size limit check for unlimited pools `#888 <https://github.com/aio-libs/aiopg/pull/888>`_\n\n\n1.3.4 (2022-06-30)\n^^^^^^^^^^^^^^^^^^\n\n\n1.3.4b3 (2022-06-29)\n^^^^^^^^^^^^^^^^^^^^\n\n\n1.3.4b2 (2022-06-29)\n^^^^^^^^^^^^^^^^^^^^\n\n\n1.3.4b1 (2022-06-29)\n^^^^^^^^^^^^^^^^^^^^\n\n* Fix compatibility with SA 1.4.38 `#891 <https://github.com/aio-libs/aiopg/pull/891>`_\n* Add py.typed marker `#878 <https://github.com/aio-libs/aiopg/pull/878>`_\n\n\n1.3.3 (2021-11-01)\n^^^^^^^^^^^^^^^^^^\n\n* Support async-timeout 4.0+\n\n\n1.3.2 (2021-10-07)\n^^^^^^^^^^^^^^^^^^\n\n\n1.3.2b2 (2021-10-07)\n^^^^^^^^^^^^^^^^^^^^\n\n* Respect use_labels for select statement `#882 <https://github.com/aio-libs/aiopg/pull/882>`_\n\n\n1.3.2b1 (2021-07-11)\n^^^^^^^^^^^^^^^^^^^^\n\n* Fix compatibility with SQLAlchemy >= 1.4 `#870 <https://github.com/aio-libs/aiopg/pull/870>`_\n\n\n1.3.1 (2021-07-08)\n^^^^^^^^^^^^^^^^^^\n\n\n1.3.1b2 (2021-07-06)\n^^^^^^^^^^^^^^^^^^^^\n\n* Suppress \"Future exception was never retrieved\" `#862 <https://github.com/aio-libs/aiopg/pull/862>`_\n\n\n1.3.1b1 (2021-07-05)\n^^^^^^^^^^^^^^^^^^^^\n\n* Fix ClosableQueue.get on cancellation, close it on Connection.close `#859 <https://github.com/aio-libs/aiopg/pull/859>`_\n\n\n1.3.0 (2021-06-30)\n^^^^^^^^^^^^^^^^^^\n\n\n1.3.0b4 (2021-06-28)\n^^^^^^^^^^^^^^^^^^^^\n\n* Fix \"Unable to detect disconnect when using NOTIFY/LISTEN\" `#559 <https://github.com/aio-libs/aiopg/pull/559>`_\n\n\n1.3.0b3 (2021-04-03)\n^^^^^^^^^^^^^^^^^^^^\n\n* Reformat using black `#814 <https://github.com/aio-libs/aiopg/pull/814>`_\n\n\n1.3.0b2 (2021-04-02)\n^^^^^^^^^^^^^^^^^^^^\n\n* Type annotations `#813 <https://github.com/aio-libs/aiopg/pull/813>`_\n\n\n1.3.0b1 (2021-03-30)\n^^^^^^^^^^^^^^^^^^^^\n\n* Raise ResourceClosedError if we try to open a cursor on a closed SAConnection `#811 <https://github.com/aio-libs/aiopg/pull/811>`_\n\n\n1.3.0b0 (2021-03-25)\n^^^^^^^^^^^^^^^^^^^^\n\n* Fix compatibility with SA 1.4 for IN statement `#806 <https://github.com/aio-libs/aiopg/pull/806>`_\n\n\n1.2.1 (2021-03-23)\n^^^^^^^^^^^^^^^^^^\n\n* Pop loop in connection init due to backward compatibility `#808 <https://github.com/aio-libs/aiopg/pull/808>`_\n\n\n1.2.0b4 (2021-03-23)\n^^^^^^^^^^^^^^^^^^^^\n\n* Set max supported sqlalchemy version `#805 <https://github.com/aio-libs/aiopg/pull/805>`_\n\n\n1.2.0b3 (2021-03-22)\n^^^^^^^^^^^^^^^^^^^^\n\n* Don't run ROLLBACK when the connection is closed `#778 <https://github.com/aio-libs/aiopg/pull/778>`_\n\n* Multiple cursors support `#801 <https://github.com/aio-libs/aiopg/pull/801>`_\n\n\n1.2.0b2 (2020-12-21)\n^^^^^^^^^^^^^^^^^^^^\n\n* Fix IsolationLevel.read_committed and introduce IsolationLevel.default `#770 <https://github.com/aio-libs/aiopg/pull/770>`_\n\n* Fix python 3.8 warnings in tests `#771 <https://github.com/aio-libs/aiopg/pull/771>`_\n\n\n1.2.0b1 (2020-12-16)\n^^^^^^^^^^^^^^^^^^^^\n\n* Deprecate blocking connection.cancel() method `#570 <https://github.com/aio-libs/aiopg/pull/570>`_\n\n\n1.2.0b0 (2020-12-15)\n^^^^^^^^^^^^^^^^^^^^\n\n* Implement timeout on acquiring connection from pool `#766 <https://github.com/aio-libs/aiopg/pull/766>`_\n\n\n1.1.0 (2020-12-10)\n^^^^^^^^^^^^^^^^^^\n\n\n1.1.0b2 (2020-12-09)\n^^^^^^^^^^^^^^^^^^^^\n\n* Added missing slots to context managers `#763 <https://github.com/aio-libs/aiopg/pull/763>`_\n\n\n1.1.0b1 (2020-12-07)\n^^^^^^^^^^^^^^^^^^^^\n\n* Fix on_connect multiple call on acquire `#552 <https://github.com/aio-libs/aiopg/pull/552>`_\n\n* Fix python 3.8 warnings `#622 <https://github.com/aio-libs/aiopg/pull/642>`_\n\n* Bump minimum psycopg version to 2.8.4 `#754 <https://github.com/aio-libs/aiopg/pull/754>`_\n\n* Fix Engine.release method to release connection in any way `#756 <https://github.com/aio-libs/aiopg/pull/756>`_\n\n\n1.0.0 (2019-09-20)\n^^^^^^^^^^^^^^^^^^\n\n* Removal of an asynchronous call in favor of issues # 550\n\n* Big editing of documentation and minor bugs #534\n\n\n0.16.0 (2019-01-25)\n^^^^^^^^^^^^^^^^^^^\n\n* Fix select priority name `#525 <https://github.com/aio-libs/aiopg/issues/525>`_\n\n* Rename `psycopg2` to `psycopg2-binary` to fix deprecation warning `#507 <https://github.com/aio-libs/aiopg/issues/507>`_\n\n* Fix `#189 <https://github.com/aio-libs/aiopg/issues/189>`_ hstore when using ReadDictCursor `#512 <https://github.com/aio-libs/aiopg/issues/512>`_\n\n* close cannot be used while an asynchronous query is underway `#452 <https://github.com/aio-libs/aiopg/issues/452>`_\n\n* sqlalchemy adapter trx begin allow transaction_mode `#498 <https://github.com/aio-libs/aiopg/issues/498>`_\n\n\n0.15.0 (2018-08-14)\n^^^^^^^^^^^^^^^^^^^\n\n* Support Python 3.7 `#437 <https://github.com/aio-libs/aiopg/issues/437>`_\n\n\n0.14.0 (2018-05-10)\n^^^^^^^^^^^^^^^^^^^\n\n* Add ``get_dialect`` func to have ability to pass ``json_serializer`` `#451 <https://github.com/aio-libs/aiopg/issues/451>`_\n\n\n0.13.2 (2018-01-03)\n^^^^^^^^^^^^^^^^^^^\n\n* Fixed compatibility with SQLAlchemy 1.2.0 `#412 <https://github.com/aio-libs/aiopg/issues/412>`_\n\n* Added support for transaction isolation levels `#219 <https://github.com/aio-libs/aiopg/issues/219>`_\n\n\n0.13.1 (2017-09-10)\n^^^^^^^^^^^^^^^^^^^\n\n* Added connection poll recycling logic `#373 <https://github.com/aio-libs/aiopg/issues/373>`_\n\n\n0.13.0 (2016-12-02)\n^^^^^^^^^^^^^^^^^^^\n\n* Add `async with` support to `.begin_nested()` `#208 <https://github.com/aio-libs/aiopg/issues/208>`_\n\n* Fix connection.cancel() `#212 <https://github.com/aio-libs/aiopg/issues/212>`_ `#223 <https://github.com/aio-libs/aiopg/issues/223>`_\n\n* Raise informative error on unexpected connection closing `#191 <https://github.com/aio-libs/aiopg/issues/191>`_\n\n* Added support for python types columns issues `#217 <https://github.com/aio-libs/aiopg/issues/217>`_\n\n* Added support for default values in SA table issues `#206 <https://github.com/aio-libs/aiopg/issues/206>`_\n\n\n0.12.0 (2016-10-09)\n^^^^^^^^^^^^^^^^^^^\n\n* Add an on_connect callback parameter to pool `#141 <https://github.com/aio-libs/aiopg/issues/141>`_\n\n* Fixed connection to work under both windows and posix based systems `#142 <https://github.com/aio-libs/aiopg/issues/142>`_\n\n\n0.11.0 (2016-09-12)\n^^^^^^^^^^^^^^^^^^^\n\n* Immediately remove callbacks from a closed file descriptor `#139 <https://github.com/aio-libs/aiopg/issues/139>`_\n\n* Drop Python 3.3 support\n\n\n0.10.0 (2016-07-16)\n^^^^^^^^^^^^^^^^^^^\n\n* Refactor tests to use dockerized Postgres server `#107 <https://github.com/aio-libs/aiopg/issues/107>`_\n\n* Reduce default pool minsize to 1 `#106 <https://github.com/aio-libs/aiopg/issues/106>`_\n\n* Explicitly enumerate packages in setup.py `#85 <https://github.com/aio-libs/aiopg/issues/85>`_\n\n* Remove expired connections from pool on acquire `#116 <https://github.com/aio-libs/aiopg/issues/116>`_\n\n* Don't crash when Connection is GC'ed `#124 <https://github.com/aio-libs/aiopg/issues/124>`_\n\n* Use loop.create_future() if available\n\n\n0.9.2 (2016-01-31)\n^^^^^^^^^^^^^^^^^^\n\n* Make pool.release return asyncio.Future, so we can wait on it in\n  `__aexit__` `#102 <https://github.com/aio-libs/aiopg/issues/102>`_\n\n* Add support for uuid type `#103 <https://github.com/aio-libs/aiopg/issues/103>`_\n\n\n0.9.1 (2016-01-17)\n^^^^^^^^^^^^^^^^^^\n\n* Documentation update `#101 <https://github.com/aio-libs/aiopg/issues/101>`_\n\n\n0.9.0 (2016-01-14)\n^^^^^^^^^^^^^^^^^^\n\n* Add async context managers for transactions `#91 <https://github.com/aio-libs/aiopg/issues/91>`_\n\n* Support async iterator in ResultProxy `#92 <https://github.com/aio-libs/aiopg/issues/92>`_\n\n* Add async with for engine `#90 <https://github.com/aio-libs/aiopg/issues/90>`_\n\n\n0.8.0 (2015-12-31)\n^^^^^^^^^^^^^^^^^^\n\n* Add PostgreSQL notification support `#58 <https://github.com/aio-libs/aiopg/issues/58>`_\n\n* Support pools with unlimited size `#59 <https://github.com/aio-libs/aiopg/issues/59>`_\n\n* Cancel current DB operation on asyncio timeout `#66 <https://github.com/aio-libs/aiopg/issues/66>`_\n\n* Add async with support for Pool, Connection, Cursor `#88 <https://github.com/aio-libs/aiopg/issues/88>`_\n\n\n0.7.0 (2015-04-22)\n^^^^^^^^^^^^^^^^^^\n\n* Get rid of resource leak on connection failure.\n\n* Report ResourceWarning on non-closed connections.\n\n* Deprecate iteration protocol support in cursor and ResultProxy.\n\n* Release sa connection to pool on `connection.close()`.\n\n\n0.6.0 (2015-02-03)\n^^^^^^^^^^^^^^^^^^\n\n* Accept dict, list, tuple, named and positional parameters in\n  `SAConnection.execute()`\n\n\n0.5.2 (2014-12-08)\n^^^^^^^^^^^^^^^^^^\n\n* Minor release, fixes a bug that leaves connection in broken state\n  after `cursor.execute()` failure.\n\n\n0.5.1 (2014-10-31)\n^^^^^^^^^^^^^^^^^^\n\n* Fix a bug for processing transactions in line.\n\n\n0.5.0 (2014-10-31)\n^^^^^^^^^^^^^^^^^^\n\n* Add .terminate() to Pool and Engine\n\n* Reimplement connection pool (now pool size cannot be greater than pool.maxsize)\n\n* Add .close() and .wait_closed() to Pool and Engine\n\n* Add minsize, maxsize, size and freesize properties to sa.Engine\n\n* Support *echo* parameter for logging executed SQL commands\n\n* Connection.close() is not a coroutine (but we keep backward compatibility).\n\n\n0.4.1 (2014-10-02)\n^^^^^^^^^^^^^^^^^^\n\n* make cursor iterable\n\n* update docs\n\n\n0.4.0 (2014-10-02)\n^^^^^^^^^^^^^^^^^^\n\n* add timeouts for database operations.\n\n* Autoregister psycopg2 support for json data type.\n\n* Support JSON in aiopg.sa\n\n* Support ARRAY in aiopg.sa\n\n* Autoregister hstore support if present in connected DB\n\n* Support HSTORE in aiopg.sa\n\n\n0.3.2 (2014-07-07)\n^^^^^^^^^^^^^^^^^^\n\n* change signature to cursor.execute(operation, parameters=None) to\n  follow psycopg2 convention.\n\n\n0.3.1 (2014-07-04)\n^^^^^^^^^^^^^^^^^^\n\n* Forward arguments to cursor constructor for pooled connections.\n\n\n0.3.0 (2014-06-22)\n^^^^^^^^^^^^^^^^^^\n\n* Allow executing SQLAlchemy DDL statements.\n\n* Fix bug with race conditions on acquiring/releasing connections from pool.\n\n\n0.2.3 (2014-06-12)\n^^^^^^^^^^^^^^^^^^\n\n* Fix bug in connection pool.\n\n\n0.2.2 (2014-06-07)\n^^^^^^^^^^^^^^^^^^\n\n* Fix bug with passing parameters into SAConnection.execute when\n  executing raw SQL expression.\n\n\n0.2.1 (2014-05-08)\n^^^^^^^^^^^^^^^^^^\n\n* Close connection with invalid transaction status on returning to pool.\n\n\n0.2.0 (2014-05-04)\n^^^^^^^^^^^^^^^^^^\n\n* Implemented optional support for sqlalchemy functional sql layer.\n\n\n0.1.0 (2014-04-06)\n^^^^^^^^^^^^^^^^^^\n\n* Implemented plain connections: connect, Connection, Cursor.\n\n* Implemented database pools: create_pool and Pool.\n\n",
    "bugtrack_url": null,
    "license": "BSD",
    "summary": "Postgres integration with asyncio.",
    "version": "1.4.0",
    "project_urls": {
        "CI: GA": "https://github.com/aio-libs/aiopg/actions?query=workflow%3ACI",
        "Chat: Gitter": "https://gitter.im/aio-libs/Lobby",
        "Coverage: codecov": "https://codecov.io/gh/aio-libs/aiopg",
        "Docs: RTD": "https://aiopg.readthedocs.io",
        "Download": "https://pypi.python.org/pypi/aiopg",
        "GitHub: issues": "https://github.com/aio-libs/aiopg/issues",
        "GitHub: repo": "https://github.com/aio-libs/aiopg",
        "Homepage": "https://aiopg.readthedocs.io"
    },
    "split_keywords": [],
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "9b2fab8690bf995171b9a8b60b98a2ca91d4108a42422abf10bf622397437d26",
                "md5": "85542887312a8467e19a900643aec0ba",
                "sha256": "aea46e8aff30b039cfa818e6db4752c97656e893fc75e5a5dc57355a9e9dedbd"
            },
            "downloads": -1,
            "filename": "aiopg-1.4.0-py3-none-any.whl",
            "has_sig": false,
            "md5_digest": "85542887312a8467e19a900643aec0ba",
            "packagetype": "bdist_wheel",
            "python_version": "py3",
            "requires_python": ">=3.7",
            "size": 34770,
            "upload_time": "2022-10-26T09:31:48",
            "upload_time_iso_8601": "2022-10-26T09:31:48.019743Z",
            "url": "https://files.pythonhosted.org/packages/9b/2f/ab8690bf995171b9a8b60b98a2ca91d4108a42422abf10bf622397437d26/aiopg-1.4.0-py3-none-any.whl",
            "yanked": false,
            "yanked_reason": null
        },
        {
            "comment_text": "",
            "digests": {
                "blake2b_256": "b00aaba75a9ffcb1704b98c39986344230eaa70c40ac28e5ca635df231db912f",
                "md5": "4081ea5cd45d766cb21244953a26f477",
                "sha256": "116253bef86b4d954116716d181e9a0294037f266718b2e1c9766af995639d71"
            },
            "downloads": -1,
            "filename": "aiopg-1.4.0.tar.gz",
            "has_sig": false,
            "md5_digest": "4081ea5cd45d766cb21244953a26f477",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": ">=3.7",
            "size": 35593,
            "upload_time": "2022-10-26T09:31:49",
            "upload_time_iso_8601": "2022-10-26T09:31:49.478981Z",
            "url": "https://files.pythonhosted.org/packages/b0/0a/aba75a9ffcb1704b98c39986344230eaa70c40ac28e5ca635df231db912f/aiopg-1.4.0.tar.gz",
            "yanked": false,
            "yanked_reason": null
        }
    ],
    "upload_time": "2022-10-26 09:31:49",
    "github": true,
    "gitlab": false,
    "bitbucket": false,
    "codeberg": false,
    "github_user": "aio-libs",
    "github_project": "aiopg",
    "travis_ci": false,
    "coveralls": true,
    "github_actions": true,
    "requirements": [],
    "lcname": "aiopg"
}
        
Elapsed time: 0.14908s