Changes

0.2.0 (2023-06-11)
^^^^^^^^^^^^^^^^^^

• Bump minimal SQLAlchemy version to 1.3 Bump minimal SQLAlchemy version to 1.3 #815

• Remove deprecated Pool.get remove deprecated Pool.get #706

• | Partially ported PyMySQL#304 <https://github.com/PyMySQL/PyMySQL/pull/304>_ Improper error shown - (2003, "Can't connect to MySQL server on 'localhost'") #792
  | aiomysql now reraises the original exception during connect() if it's not IOError, OSError or asyncio.TimeoutError.
  | This was previously always raised as OperationalError.

• Fix debug log level with sha256_password authentication Fix log exception #863

• Modernized code with pyupgrade <https://github.com/asottile/pyupgrade>_ to Python 3.7+ syntax Modernize code with pyupgrade --py37-plus #930

• Removed tests for EoL MariaDB versions 10.3, 10.7 and 10.8, added tests for MariaDB 10.9, 10.10, 10.11 Test only and all supported MariaDB versions #932

0.1.1 (2022-05-08)
^^^^^^^^^^^^^^^^^^

• Fix SSL connection handshake charset not respecting client configuration Fix SSL connection handshake charset not respecting client configuration #776

0.1.0 (2022-04-11)
^^^^^^^^^^^^^^^^^^

• Don't send sys.argv[0] as program_name to MySQL server by default Error message by program name too big #620

• Allow running process as anonymous uid Unable to import aiomysql while running as uid without account #587

• Fix timed out MySQL 8.0 connections raising InternalError rather than OperationalError Fix MySQL 8.0 tests, properly close timed out connections #660

• Fix timed out MySQL 8.0 connections being returned from Pool Fix MySQL 8.0 tests, properly close timed out connections #660

• Ensure connections are properly closed before raising an OperationalError when the server connection is lost Fix MySQL 8.0 tests, properly close timed out connections #660

• Ensure connections are properly closed before raising an InternalError when packet sequence numbers are out of sync Fix MySQL 8.0 tests, properly close timed out connections #660

• Unix sockets are now internally considered secure, allowing sha256_password and caching_sha2_password auth methods to be used implement a shortcut for determining secure connections, now supporting unix sockets #695

• Test suite now also tests unix socket connections Add unix socket tests #696

• Fix SSCursor raising InternalError when last result was not fully retrieved Issue with unbuffered cursor #635

• Remove deprecated no_delay argument remove deprecated no_delay argument #702

• Support PyMySQL up to version 1.0.2 add support to pymysql 1.0.2 #643

• Bump minimal PyMySQL version to 1.0.0 bump minimal PyMySQL version to 1.0.0 #713

• Align % formatting in Cursor.executemany() with Cursor.execute(), literal % now need to be doubled in Cursor.executemany() Fix sporadic test failures for test_issue_36 #714

• Fixed unlimited Pool size not working, this is now working as documented by passing maxsize=0 to create_pool Pool.maxsize = 0 does not allow unlimited connections #119

• Added Pool.closed property as present in aiopg pool lose closed property #463

• Fixed SQLAlchemy connection context iterator Fix async iterator protocol in aiomysql.utils._SAConnectionContextManager #410

• Fix error packet handling for SSCursor SSCursor can't close while raise Error #428

• Required python version is now properly documented in python_requires instead of failing on setup.py execution Any way to remove this deprecation warning - python verison: 3.9.0? #731

• Add rsa extras_require depending on PyMySQL[rsa] Add an rsa extra require? #557

• Migrate to PEP 517 build system Migrate to PEP 517 build system #746

• Self-reported __version__ now returns version generated by setuptools-scm during build, otherwise 'unknown' Use setuptools-scm for versioning #748

• Fix SSCursor raising query timeout error on wrong query SSCursor can't close while raise Error #428

0.0.22 (2021-11-14)
^^^^^^^^^^^^^^^^^^^

• Support python 3.10 DeprecationWarning: The loop argument is deprecated since Python 3.8, and scheduled for removal in Python 3.10. #505

0.0.21 (2020-11-26)
^^^^^^^^^^^^^^^^^^^

• Allow to use custom Cursor subclasses Allow to set expand Cursor #374

• Fill Connection class with actual client version import version from __init.py__ #388

• Fix legacy aiter methods Fix legacy __aiter__ methods #403

• Fix & update docs Fix a typo and wrong indention #418 docs/index.rst: Updated tutorial to native coroutines #437

• Ignore pyenv's .python-version file Add .python-version to .gitignore #424

• Replace asyncio.streams.IncompleteReadError with asyncio.IncompleteReadError Fix: #454 #460 asyncio.streams.IncompleteReadError is removed from python3.8 #454

• Add support for SQLAlchemy default parameters Default value for column doesn`t work #455 The next release plan? #466

• Update dependencies Update dependencies #485

• Support Python 3.7 & 3.8 Support python 3.7 and 3.8 in travis CI #493

0.0.20 (2018-12-19)
^^^^^^^^^^^^^^^^^^^

• Fixed connect_timeout connect_timeout fix #360

• Fixed support for SQLA executemany fix: support executemany #324

• Fix the python 3.7 compatibility fix the python 3.7 compatibility #357

• Fixed reuse connections when StreamReader has an exception Don't reuse connections when StreamReader has an exception #339

• Fixes warning when inserting binary strings Fixes warning when inserting binary strings #326

0.0.19 (2018-07-12)
^^^^^^^^^^^^^^^^^^^

• See v0.0.18

0.0.18 (2018-07-09)
^^^^^^^^^^^^^^^^^^^

• Updated to support latest PyMySQL changes.

• aiomysql now sends client connection info.

• MySQL8+ Support including sha256_password and cached_sha2_password authentication plugins.

• Default max packet length sent to the server is no longer 1.

• Fixes issue where cursor.nextset can hang on query sets that raise errors.

0.0.17 (2018-07-06)
^^^^^^^^^^^^^^^^^^^

• Pinned version of PyMySQL

0.0.16 (2018-06-03)
^^^^^^^^^^^^^^^^^^^

• Added ability to execute precompiled sqlalchemy queries ability to execute precompiled sqlalchemy queries #294 (Thanks @vlanse)

0.0.15 (2018-05-20)
^^^^^^^^^^^^^^^^^^^

• Fixed handling of user-defined types for sqlalchemy Cannot make db -> python value conversion working with custom SA columns #290

• Fix KeyError when server reports unknown collation fix KeyError when server reports unknown collation #289

0.0.14 (2018-04-22)
^^^^^^^^^^^^^^^^^^^

• Fixed SSL connection finalization dupclicate socket #282

0.0.13 (2018-04-19)
^^^^^^^^^^^^^^^^^^^

• Added SSL support SSL Support (plus mysql_clear_password plugin for RDS) #280 (Thanks @terrycain)

• Fixed all in aiomysql/init fix __all__ in aiomysql/__init__ #270 (Thanks @matianjun1)

• Added docker fixtures Docker test fixtures #275 (Thanks @terrycain)

0.0.12 (2018-01-18)
^^^^^^^^^^^^^^^^^^^

• Fixed support for SQLAlchemy 1.2.0

• Fixed argument for cursor.execute in sa engine proper argument for cursor.execute (for sa engine) #239 (Thanks @NotSoSuper)

0.0.11 (2017-12-06)
^^^^^^^^^^^^^^^^^^^

• Fixed README formatting on pypi

0.0.10 (2017-12-06)
^^^^^^^^^^^^^^^^^^^

• Updated regular expressions to be compatible with pymysql Update regular expressions to make up to date with pymysql. #167 (Thanks @AlexLisovoy)

• Added connection recycling in the pool Pool recylce #216

0.0.9 (2016-09-14)
^^^^^^^^^^^^^^^^^^

• Fixed AttributeError in _request_authentication function To avoid AttributeError in function _request_authentication(self) #104 (Thanks @ttlttl)

• Fixed legacy auth 'Connection' object has no attribute 'password' #105

• uvloop added to test suite Add uvloop to the test suite #106

• Fixed bug with unicode in json field Fix json error for field that contains unicode  #107 (Thanks @methane)

0.0.8 (2016-08-24)
^^^^^^^^^^^^^^^^^^

• Default min pool size reduced to 1 Set default minsize for pool to 1 #80 (Thanks @Drizzt1991)

• Update to PyMySQL 0.7.5 Update to pymysql 0.7.x #89

• Fixed connection cancellation in process of executing a query Fixed connection cancellation in process of executing a query #79 (Thanks @Drizzt1991)

0.0.7 (2016-01-27)
^^^^^^^^^^^^^^^^^^

• Fix for multiple results issue, ported from pymysql Proper fix fo multiple results issure ported from pymysql #52

• Fixed useless warning with no_delay option make no_delay=None by default as result get rid of warning #55

• Added async/await support for Engine, SAConnection, Transaction Even more async support #57

• pool.release returns future so we can wait on it in aexit make pool.release return future #60

• Update to PyMySQL 0.6.7

0.0.6 (2015-12-11)
^^^^^^^^^^^^^^^^^^

• Fixed bug with SA rollback (Thanks @khlyestovillarion!)

• Fixed issue with default no_delay option (Thanks @khlyestovillarion!)

0.0.5 (2015-10-28)
^^^^^^^^^^^^^^^^^^

• no_delay option is deprecated and True by default

• Add Cursor.mogrify() method

• Support for "LOAD LOCAL INFILE" query.

• Check connection inside pool, in case of timeout drop it, fixes ERROR:aiohttp.web:Error handling request #25

• Add support of python 3.5 features to pool, connection and cursor

0.0.4 (2015-05-23)
^^^^^^^^^^^^^^^^^^

• Allow to call connection.wait_closed twice.

• Fixed sqlalchemy 1.0.0 support.

• Fix rename Connection.wait_closed() #11: Rename Connection.wait_closed() to .ensure_closed()

• Raise ResourceWarning on non-closed Connection

• Rename Connection.connect to _connect

0.0.3 (2015-03-10)
^^^^^^^^^^^^^^^^^^

• Added support for PyMySQL up to 0.6.6.

• Ported improvements from PyMySQL.

• Added basic documentation.

• Fixed and added more examples.

0.0.2 (2015-02-17)
^^^^^^^^^^^^^^^^^^

• Added MANIFEST.in.

0.0.1 (2015-02-17)
^^^^^^^^^^^^^^^^^^

• Initial release.

• Implemented plain connections: connect, Connection, Cursor.

• Implemented database pools.

• Ported sqlalchemy optional support.