Automatically handle parallel queries with an async `Lock` about aiomysql HOT 4 OPEN

Hi,
the simplest solution for this that would require no code changes is to just acquire() a connection from the pool for each task.
By providing appropriate minsize and maxsize values the pool will automatically take care of creating the necessary amount of connections and it will not return on acquire() until a connection is available.

from aiomysql.

I don't think this is solution will work if need to work within the same connection transaction, which is my requirement.
On our server, we use a connection per request where each connection is also a transaction we can rollback if the request fails (due to an exception or other error).

from aiomysql.

Indeed, transactions will get lost with that.

from aiomysql.

Any progress on this? An asyncio.Lock is an elegant solution that is easy to implement. I'm willing to contribute a PR if necessary, I just want to make sure it will get quickly reviewed if I spend the time on this.

from aiomysql.